{"id":67827,"date":"2020-10-12T12:31:52","date_gmt":"2020-10-12T12:31:52","guid":{"rendered":"https:\/\/www.fita.in\/?p=67827"},"modified":"2023-10-09T12:45:09","modified_gmt":"2023-10-09T12:45:09","slug":"sql-for-data-science-for-beginners","status":"publish","type":"post","link":"https:\/\/www.fita.in\/sql-for-data-science-for-beginners\/","title":{"rendered":"SQL For Data Science: For Beginners"},"content":{"rendered":"

Data has become the fuel for the organizations to strategize and formulate the entire models as per trending patterns and requirements. Databases are where these data reside, but working with them requires a programming language.<\/p>\r\n

SQL or Structured Query Language is a primary language for working with databases. It is used widely for data analysis or data science, it is a must to know the language for driving, reports, manipulation, or analysis of a dataset.<\/p>\r\n

With SQL you can update, add or delete records from the database.The top Relational Database Management Systems(RDBMS) such as PostgreSQL, MySql, SQLite, MariaDB, Oracle<\/a> are based on the SQL.<\/p>\r\n

This blog is your way to go for analyzing simple datasets using SQL.<\/p>\r\nHere is what we will discuss step by step in this blog,\r\n

\r\n
\r\n\r\n<\/i> Basics Of SQL\r\n
\r\n
<\/i> Create Table<\/div>\r\n
<\/i> Insert into Table<\/div>\r\n
<\/i> Updating rows in Table<\/div>\r\n
<\/i> Deleting rows from Table<\/div>\r\n
<\/i> Counting records.<\/div>\r\n
<\/i> Deleting Table<\/div>\r\n<\/div>\r\n<\/div>\r\n<\/div>\r\n
\r\n
\r\n\r\n<\/i> Advanced SQL\r\n
\r\n
<\/i> Functions for aggregation<\/div>\r\n
<\/i> Finding extreme values<\/div>\r\n
<\/i> Slicing the data<\/div>\r\n
<\/i> Limiting the data<\/div>\r\n
<\/i> Filtering the data<\/div>\r\n
<\/i> Grouping the data<\/div>\r\n<\/div>\r\n<\/div>\r\n<\/div>\r\nLet us now learn the Sql starting with the Basics Of SQL…\r\n

Basic Of SQL<\/strong><\/h3>\r\nCreating Database<\/strong>\r\n\r\nA SQL Database is a godown for storing structured data. Here is how you would create a database in MySQL.\r\n
\r\n
\r\n
-- syntax for creating a database<\/p>\r\n
<\/p>\r\n
CREATE DATABASE <databasename><\/p>\r\n
USE <databasename><\/p>\r\n<\/code><\/pre>\r\n<\/div>\r\nHere the CREATE DATABASE command creates the database with the database name and the USE command will activate the database with the database name followed.\r\n
\r\n
\r\n
-- Example for creating a database<\/p>\r\n
<\/p>\r\n
CREATE DATABASE FITA<\/p>\r\n
USE FITA<\/p>\r\n<\/code><\/pre>\r\n<\/div>\r\nAfter creating the database let us now see how to create a table in the database.\r\n\r\nCreating Tables<\/strong>\r\n\r\nThe data in databases are stored in Tables with attributes and the type of data. A database can have more than one table. creating tables is just as creating a database\r\n
\r\n
\r\n
-- syntax for creating a table<\/p>\r\n
<\/p>\r\n
CREATE TABLE <tablename><\/p>\r\n
(<\/p>\r\n
variable1 datatype 1,<\/p>\r\n
variable 2 datatype 2,<\/p>\r\n
variable n datatype n,<\/p>\r\n
..<\/p>\r\n
);<\/p>\r\n<\/code><\/pre>\r\n<\/div>\r\n
Here the CREATE TABLE will create a table with a table name. The variables here are the name of the attributes, which will be the columns of the table.SQL data can have numeric, character or string Date and Time, Binary, and Boolean data type. A semicolon indicates the termination.<\/p>\r\n\r\n
\r\n
\r\n
-- Example for creating a table<\/p>\r\n
<\/p>\r\n
CREATE TABLE Students<\/p>\r\n
(<\/p>\r\n
roll number INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,<\/p>\r\n
student_name TEXT,<\/p>\r\n
marks INTEGER,<\/p>\r\n
grade VARCHAR,<\/p>\r\n
passed BOOLEAN<\/p>\r\n
);<\/p>\r\n<\/code><\/pre>\r\n<\/div>\r\n
Here the roll number is of type integer and the primary key is for identifying records with this unique value. There could be only one primary key for a record.<\/p>\r\n
AUTOINCREMENT is used to increment the value automatically, that is you won\u2019t need to pass the value for the roll number and it will be automatically set.<\/p>\r\n
After creating the tables in the database let us now see how to insert rows in the table.<\/p>\r\n\r\n
Insert into table<\/strong><\/h3>\r\nTo insert a record into the table you will need to specify all the values with the respective data type in the table.\r\n
\r\n
\r\n
-- Syntax for inserting a record<\/p>\r\n
<\/p>\r\n
INSERT INTO TABLE <tablename> VALUES<\/p>\r\n
(<\/p>\r\n
value 1,<\/p>\r\n
value 2,<\/p>\r\n
..<\/p>\r\n
value n<\/p>\r\n
);<\/p>\r\n<\/code><\/pre>\r\n<\/div>\r\n
\r\n
<\/i> Add 5 students marks, name grade, and whether passed to the Student\u2019s table.\r\n\r\n<\/div>\r\n<\/div>\r\n
\r\n
\r\nINSERT INTO Students VALUES (NULL,\u201cAtufa\u201d,70,\u201dB\u201d,true);\r\n\r\nINSERT INTO Students VALUES (NULL,\u201cPuja\u201d,85,\u201dA\u201d,true);\r\n\r\nINSERT INTO Students VALUES (NULL,\u201cJane\u201d,50,\u201dB\u201d,true);\r\n\r\nINSERT INTO Students VALUES (NULL,\u201cRosy\u201d,45,\u201dC\u201d,true);\r\n\r\nINSERT INTO Students VALUES (NULL,\u201cHarry\u201d,20,\u201dF\u201d,false);\r\n<\/code><\/pre>\r\n<\/div>\r\nNotice that we didn’t pass the roll number because it has been set to AUTO_INCREMENT.\r\n\r\nNote that these commands need not to be written in capital letters on different lines necessarily, this is just to distinguish the SQL commands from the values.\r\n\r\nAfter inserting rows in the database let us now see how to retrieve data from the table in the database.\r\n
Retrieving data<\/strong><\/h3>\r\n
\r\n
<\/i> Retrieve all the records from the table.<\/div>\r\n<\/div>\r\n
\r\n
-- Example for selecting all the records\r\n\r\n \r\n\r\nSELECT * FROM Students<\/code><\/pre>\r\n<\/div>\r\n\r\nHere the SELECT command is for retrieving data, and * for all the records.\r\n\r\nOutput for the above query<\/strong>\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n
roll_number<\/strong><\/td>\r\nstudent_name<\/strong><\/td>\r\nmarks<\/strong><\/td>\r\ngrade<\/strong><\/td>\r\npassed<\/strong><\/td>\r\n<\/tr>\r\n
1<\/td>\r\nAtufa<\/td>\r\n70<\/td>\r\nB<\/td>\r\n1<\/td>\r\n<\/tr>\r\n
2<\/td>\r\nPuja<\/td>\r\n85<\/td>\r\nA<\/td>\r\n1<\/td>\r\n<\/tr>\r\n
3<\/td>\r\nJane<\/td>\r\n50<\/td>\r\nB<\/td>\r\n1<\/td>\r\n<\/tr>\r\n
4<\/td>\r\nRosy<\/td>\r\n45<\/td>\r\nC<\/td>\r\n1<\/td>\r\n<\/tr>\r\n
5<\/td>\r\nHarry<\/td>\r\n20<\/td>\r\nF<\/td>\r\n0<\/td>\r\n<\/tr>\r\n<\/tbody>\r\n<\/table>\r\n
\r\n
<\/i> Selecting specific attributes<\/div>\r\n<\/div>\r\nTo select records from the specific columns of the table\r\n
\r\n
<\/i> Retrieve all the names and whether passed condition of the students from the table.<\/div>\r\n<\/div>\r\n
\r\n
--\u00a0Example for selecting records for specific attributes\r\n\r\n \r\n\r\nSELECT student_name, passed FROM STUDENTS;<\/code><\/pre>\r\n<\/div>\r\nOutput for the above query<\/strong>\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n
student_name<\/strong><\/td>\r\npassed<\/strong><\/td>\r\n<\/tr>\r\n
Puja<\/td>\r\n1<\/td>\r\n<\/tr>\r\n
Jane<\/td>\r\n1<\/td>\r\n<\/tr>\r\n
Rosy<\/td>\r\n1<\/td>\r\n<\/tr>\r\n
Harry<\/td>\r\n0<\/td>\r\n<\/tr>\r\n<\/tbody>\r\n<\/table>\r\nHere the 0 represents false value or failed and 1 represents true value or passed.\r\n
\r\n
<\/i> Selecting specific records<\/div>\r\n<\/div>\r\nTo select specific rows from the table with a condition using WHERE command.\r\n
\r\n
<\/i> Retrieve all the records of the students who got B grade.<\/div>\r\n<\/div>\r\n
\r\n
SELECT * FROM Students WHERE grade == \u2018B\u2019;<\/code><\/pre>\r\n<\/div>\r\nOutput for the above query<\/strong>\r\n\r\n\r\n\r\n\r\n\r\n
roll_number<\/strong><\/td>\r\nstudent_name<\/strong><\/td>\r\nmarks<\/strong><\/td>\r\ngrade<\/strong><\/td>\r\npassed<\/strong><\/td>\r\n<\/tr>\r\n
1<\/td>\r\nAtufa<\/td>\r\n70<\/td>\r\nB<\/td>\r\n1<\/td>\r\n<\/tr>\r\n
3<\/td>\r\nJane<\/td>\r\n50<\/td>\r\nB<\/td>\r\n1<\/td>\r\n<\/tr>\r\n<\/tbody>\r\n<\/table>\r\nOr to select specific records from specific columns with a condition using the WHERE command. Here is an exercise\r\n
\r\n
<\/i> Retrieve all the names of the students who achieved A grade.<\/div>\r\n<\/div>\r\n
\r\n
SELECT student_name FROM Students WHERE grade == \u2018A\u2019;<\/code><\/pre>\r\n<\/div>\r\nOutput for the above query<\/strong>\r\n\r\n\r\n\r\n\r\n
student_name<\/strong><\/td>\r\n<\/tr>\r\n
Puja<\/td>\r\n<\/tr>\r\n<\/tbody>\r\n<\/table>\r\nLet\u2019s do one more,\r\n
\r\n
<\/i> Select all the names of the students who have passed or achieved more than 35 marks.<\/div>\r\n<\/div>\r\n
\r\n
SELECT student_name FROM Students WHERE marks>=35;<\/code><\/pre>\r\n<\/div>\r\nOutput for the above query<\/strong>\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n
student_name<\/strong><\/td>\r\n<\/tr>\r\n
Atufa<\/td>\r\n<\/tr>\r\n
Puja<\/td>\r\n<\/tr>\r\n
Jane<\/td>\r\n<\/tr>\r\n
Rosy<\/td>\r\n<\/tr>\r\n<\/tbody>\r\n<\/table>\r\nNow let’s do one more powerful query\r\n
\r\n
<\/i> Retrieve all the records of the passed students ordered by their grades.<\/div>\r\n<\/div>\r\n
\r\n
SELECT * FROM Students WHERE marks>=35 ORDER BY grade;<\/code><\/pre>\r\n<\/div>\r\nHere the ORDER BY will arrange the records based on the attribute passed, or in this case by grades.\r\n
\r\nOutput for the above query<\/strong>\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n
roll_number<\/strong><\/td>\r\nstudent_name<\/strong><\/td>\r\nmarks<\/strong><\/td>\r\ngrade<\/strong><\/td>\r\npassed<\/strong><\/td>\r\n<\/tr>\r\n
2<\/td>\r\nPuja<\/td>\r\n85<\/td>\r\nA<\/td>\r\n1<\/td>\r\n<\/tr>\r\n
1<\/td>\r\nAtufa<\/td>\r\n70<\/td>\r\nB<\/td>\r\n1<\/td>\r\n<\/tr>\r\n
3<\/td>\r\nJane<\/td>\r\n50<\/td>\r\nB<\/td>\r\n1<\/td>\r\n<\/tr>\r\n
4<\/td>\r\nRosy<\/td>\r\n45<\/td>\r\nC<\/td>\r\n1<\/td>\r\n<\/tr>\r\n<\/tbody>\r\n<\/table>\r\nYou can also pass an optional command ASC or DSC for ascending or descending order to the query. By default, it is set to ASC.\r\n\r\nAfter retrieving the data from the database let us now see how to update the records from the table in the database.\r\n
Updating records from Table<\/h3>\r\nTo update records from the table you will simply need to use the UPDATE and SET command. Here are some examples\r\n
\r\n
<\/i> Update the grades for marks greater than or equal to 70 to \u2018B\u2019.<\/div>\r\n<\/div>\r\n
\r\n
UPDATE Students SET grade = 'A' WHERE marks>=70;\r\n\r\nSELECT marks, grade FROM Students;<\/code><\/pre>\r\n<\/div>\r\nOutput for the above query<\/strong>\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n
marks<\/strong><\/td>\r\ngrade<\/strong><\/td>\r\n<\/tr>\r\n
70<\/td>\r\nA<\/td>\r\n<\/tr>\r\n
85<\/td>\r\nA<\/td>\r\n<\/tr>\r\n
50<\/td>\r\nB<\/td>\r\n<\/tr>\r\n
45<\/td>\r\nC<\/td>\r\n<\/tr>\r\n
20<\/td>\r\nF<\/td>\r\n<\/tr>\r\n<\/tbody>\r\n<\/table>\r\n
Check out this complete\u00a0Online Data Science Course<\/a> by FITA<\/a>, which includes Supervised, Unsupervised machine learning algorithms, Data Analysis Manipulation and visualization, reinforcement testing, hypothesis testing,<\/em> and much more to make an industry required data scientist at an affordable price, which includes certification, support with career guidance assistance \u00a0with an active placement cell,to make you an industry required certified data scientist.<\/p>\r\nAfter learning to update the records from the database let us now see how to count the records from the table in the database.\r\n\r\nCounting records\r\n\r\nThe count() function can be used to count. Here are some examples\r\n
\r\n
<\/i> Count the number of records in the table<\/div>\r\n<\/div>\r\n
\r\n
SELECT COUNT(*) FROM Students; -- outputs 5<\/code><\/pre>\r\n<\/div>\r\n
\r\n
<\/i> Count the number of students passed<\/div>\r\n<\/div>\r\n
\r\n
SELECT COUNT(*) FROM Students WHERE marks>=35; -- outputs 4<\/code><\/pre>\r\n<\/div>\r\nAfter learning to count the records from the database let us now see how to delete the records from the table in the database.\r\n\r\nDeleting records from Table.\r\n\r\nDELETE can be used to delete any record or row from the table. Here are some exercises.\r\n
\r\n
<\/i> delete all the records of the failed students.<\/div>\r\n<\/div>\r\n
\r\n
DELETE FROM Students WHERE grade == 'F';\r\n\r\nSELECT * FROM Students;<\/code><\/pre>\r\n<\/div>\r\nOutput for the above query<\/strong>\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n
roll_number<\/strong><\/td>\r\nstudent_name<\/strong><\/td>\r\nmarks<\/strong><\/td>\r\ngrade<\/strong><\/td>\r\npassed<\/strong><\/td>\r\n<\/tr>\r\n
1<\/td>\r\nAtufa<\/td>\r\n70<\/td>\r\nA<\/td>\r\n1<\/td>\r\n<\/tr>\r\n
2<\/td>\r\nPuja<\/td>\r\n85<\/td>\r\nA<\/td>\r\n1<\/td>\r\n<\/tr>\r\n
3<\/td>\r\nJane<\/td>\r\n50<\/td>\r\nB<\/td>\r\n1<\/td>\r\n<\/tr>\r\n
4<\/td>\r\nRosy<\/td>\r\n45<\/td>\r\nC<\/td>\r\n1<\/td>\r\n<\/tr>\r\n<\/tbody>\r\n<\/table>\r\n
\r\n
<\/i> We are starting a new academic year with new students so delete all the records from the table.<\/div>\r\n<\/div>\r\n
\r\n
DELETE FROM Students;<\/code><\/pre>\r\n<\/div>\r\nThis will delete all the records of the table without its attributes.\r\n\r\nThe last task in the basics of SQL is to delete the table.\r\n
Deleting Table<\/h3>\r\nTo delete a table from the database using the DROP command with the table name.\r\n
\r\n
<\/i> We are closing the school and starting a new business due to lockdown, and don’t need the students\u2019 table anymore.<\/div>\r\n<\/div>\r\nHere is the command to delete the table for students.\r\n
\r\n
DROP TABLE Students;<\/code><\/pre>\r\n<\/div>\r\n
ADVANCED SQL QUERIES<\/h3>\r\nLet us now check some of the advanced sql queries, for summing, filtering, and limiting the data.\r\n\r\nAggregation Functions in SQL<\/strong>\r\n\r\nHere we will use the Students tables with the previous 5 records.\r\n
\r\n
<\/i> SUM() function.<\/div>\r\n
<\/i> Calculate the SUM() of the marks of students and hence calculate the average.<\/div>\r\n<\/div>\r\n
\r\n
SELECT SUM(marks) FROM Students; -- outputs 270<\/code><\/pre>\r\n<\/div>\r\nNow the average can be calculated by dividing this value(270) by 5 which results in 54.\r\n\r\nYou can also use the WHERE here to add specific records.\r\n
\r\n
<\/i> AVG() function<\/div>\r\n<\/div>\r\nWe had used the SUM() function before and divided it by the number of rows to calculate the average. This can be automated with the AVG() function.\r\n
\r\n
<\/i> Calculate the average marks for the passed students<\/div>\r\n<\/div>\r\n
\r\n
ECT AVG(marks) FROM Students WHERE marks>=35; -- outputs 62.5SEL<\/code><\/pre>\r\n<\/div>\r\nYou can also calculate the standard deviation of a column using the STDDEV() function, to calculate the difference between actual and the mean value.\r\n
\r\n
<\/i> MIN() and MAX() function<\/div>\r\n<\/div>\r\nThese functions return the highest and the lowest value of the specified column.\r\n
\r\n
<\/i> Find the maximum marks of the student with the grade \u2018B\u2019.<\/div>\r\n<\/div>\r\n
\r\n
SELECT student_name,MAX(marks) FROM Students WHERE grade =='B';<\/code><\/pre>\r\n<\/div>\r\nOutput for the above query<\/strong>\r\n\r\n\r\n\r\n\r\n
student_name<\/strong><\/td>\r\nmax(marks)<\/strong><\/td>\r\n<\/tr>\r\n
Jane<\/td>\r\n50<\/td>\r\n<\/tr>\r\n<\/tbody>\r\n<\/table>\r\n
Check out this\u00a0SQL Training in Chennai<\/a>. FITA provides a complete SQL course that covers all the beginning and the advanced queries of SQL.<\/p>\r\n
Additionally it covers all the elements of ANSI SQL, Data Definition Language (DDL) and Data Manipulation Language (DML) using both SQL Server and Oracle, with an active placement cell,to make a certified Database Professional.<\/p>\r\n
After learning the aggregate functions of SQL, for summing up the data, finding the minimum or maximum value from the data or the average let us now learn to filter the records from the database.<\/p>\r\n\r\n
Filtering the data<\/h3>\r\nFilters in SQL include WHERE, ORDER BY, BETWEEN, LIKE, GROUP BY, HAVING.\r\n\r\nWe have already covered ORDER BY and WHERE. Let\u2019s take a look at others.\r\n
\r\n
<\/i> GROUP BY<\/div>\r\n<\/div>\r\nThis statement usually works with aggregate functions (MAX, MIN, SUM, COUNT, AVG) to create sets of the same values. Here is an example\r\n
\r\n
SELECT COUNT(marks), grade FROM Students GROUP BY grade;<\/code><\/pre>\r\n<\/div>\r\nOutput for the above query<\/strong>\r\n\r\n\r\n\r\n\r\n\r\n\r\n
count(marks)<\/strong><\/td>\r\ngrade<\/strong><\/td>\r\n<\/tr>\r\n
2<\/td>\r\nA<\/td>\r\n<\/tr>\r\n
1<\/td>\r\nB<\/td>\r\n<\/tr>\r\n
1<\/td>\r\nC<\/td>\r\n<\/tr>\r\n<\/tbody>\r\n<\/table>\r\n
\r\n
<\/i> LIKE<\/div>\r\n<\/div>\r\nLIKE is like a regex that matches the passed statement among the specified records. Here is an example\r\n
\r\n
SELECT * FROM Students WHERE student_name LIKE '%Harry';<\/code><\/pre>\r\n<\/div>\r\nIt would be more efficient to use this statement if the table had full names of the students stored.\r\n
\r\n
<\/i> BETWEEN<\/div>\r\n<\/div>\r\nBETWEEN is used to retrieve records from a specific range. Here is an example of retrieving student names and their grades between the marks 50 to 75.\r\n
\r\n
SELECT student_name, grade FROM Students WHERE marks BETWEEN 50 AND 75;<\/code><\/pre>\r\n<\/div>\r\nOutput for the above query<\/strong>\r\n\r\n\r\n\r\n\r\n\r\n
student_name<\/strong><\/td>\r\ngrade<\/strong><\/td>\r\n<\/tr>\r\n
Atufa<\/td>\r\nA<\/td>\r\n<\/tr>\r\n
Jane<\/td>\r\nB<\/td>\r\n<\/tr>\r\n<\/tbody>\r\n<\/table>\r\n
\r\n
<\/i> HAVING<\/div>\r\n<\/div>\r\nHAVING is just like WHERE but used with aggregate functions, since using WHERE with aggregate functions results in an error.\r\n
\r\n
<\/i> Retrieve the number of students passed (marks greater than 35) with their grades.<\/div>\r\n<\/div>\r\nIf you try to do it like this,\r\n
\r\n
SELECT grade, COUNT(*) FROM Students GROUP BY grade WHERE marks>35;<\/code><\/pre>\r\n<\/div>\r\nIt will result in a syntax error near \u2018WHERE\u2019.So instead of using WHERE here use HAVING.\r\n
\r\n
SELECT grade, COUNT(*) FROM Students GROUP BY grade HAVING marks>35;<\/code><\/pre>\r\n<\/div>\r\nOutput for the above query<\/strong>\r\n\r\n\r\n\r\n\r\n\r\n\r\n
grade<\/strong><\/td>\r\ncount(*)<\/strong><\/td>\r\n<\/tr>\r\n
A<\/td>\r\n2<\/td>\r\n<\/tr>\r\n
B<\/td>\r\n1<\/td>\r\n<\/tr>\r\n
C<\/td>\r\n1<\/td>\r\n<\/tr>\r\n<\/tbody>\r\n<\/table>\r\nOther filters include AND, OR, NOT, IN, ANY, ALL, EXISTS, UNION, and JOINS (OUTER JOIN, INNER JOIN, LEFT JOIN, RIGHT JOIN, FULL JOIN, and SELF JOIN).\r\n\r\nAfter learning the queries for filtering the records from the database, for selecting records based on conditions, let us now learn to limiting the records from the database.\r\n
Limiting the data<\/h3>\r\n
\r\n
<\/i> Let\u2019s say you have a database with millions of records, but you just want a glance at the first three, you can do this with the LIMIT clause.<\/div>\r\n<\/div>\r\n
\r\n
SELECT * FROM Students LIMIT 3;<\/code><\/pre>\r\n<\/div>\r\nWhich will give you the first three records in the Students table.\r\n
\r\n
<\/i> Now you need those 3 records from the 3rd roll number, you can do this with the OFFSET clause.<\/div>\r\n<\/div>\r\n
\r\n
SELECT * FROM Students LIMIT 3 OFFSET 2;<\/code><\/pre>\r\n<\/div>\r\nOutput for the above query<\/strong>\r\n\r\n\r\n\r\n\r\n\r\n
roll_number<\/strong><\/td>\r\nstudent_name<\/strong><\/td>\r\nmarks<\/strong><\/td>\r\ngrade<\/strong><\/td>\r\npassed<\/strong><\/td>\r\n<\/tr>\r\n
3<\/td>\r\nJane<\/td>\r\n50<\/td>\r\nB<\/td>\r\n1<\/td>\r\n<\/tr>\r\n
4<\/td>\r\nRosy<\/td>\r\n45<\/td>\r\nC<\/td>\r\n1<\/td>\r\n<\/tr>\r\n<\/tbody>\r\n<\/table>\r\n
This was a quick start tutorial for SQL and its implementations. To get the in depth knowledge of Python along with its various applications and real-time projects, you can enroll in\u00a0Python Course in Chennai <\/a>or Python Training in Bangalore<\/a>\u00a0or enroll for a Data science course at Chennai<\/a> or Data science course in Bangalore<\/a> or in virtual classes for these courses, which includes Supervised, Unsupervised machine learning<\/a> algorithms, Data Analysis Manipulation and visualization, reinforcement testing, hypothesis testing\u00a0<\/em>and much more with an active placement cell, to make an industry required data scientist at an affordable price, which includes certification, support with career guidance assistance to make you an industry required certified python developer and a certified data scientist.<\/p>\r\n
FITA\u2019s courses training is delivered by professional experts who have worked in the software development and testing industry for a minimum of 10+ years, and have experience of working with different software frameworks and software testing designs.<\/p>","protected":false},"excerpt":{"rendered":"Data has become the fuel for the organizations to strategize and formulate the entire models as per trending patterns and requirements. Databases are where these data reside, but working with them requires a programming language. SQL or Structured Query Language is a primary language for working with databases. It is used widely for data analysis […]","protected":false},"author":1,"featured_media":89116,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[1198,2411],"tags":[],"class_list":["post-67827","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-data-science","category-sql"],"acf":[],"yoast_head":"\nSQL For Data Science: For Beginners | SQL Data Analytics | FITA Academy<\/title>\n<meta name=\"description\" content=\"Data has become the fuel for the organizations to strategize and formulate the entire models as per trending patterns and requirements. Databases are where these data reside, but working with them requires a programming language.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.fita.in\/sql-for-data-science-for-beginners\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"SQL For Data Science: For Beginners | SQL Data Analytics | FITA Academy\" \/>\n<meta property=\"og:description\" content=\"Data has become the fuel for the organizations to strategize and formulate the entire models as per trending patterns and requirements. Databases are where these data reside, but working with them requires a programming language.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.fita.in\/sql-for-data-science-for-beginners\/\" \/>\n<meta property=\"og:site_name\" content=\"FITA Academy\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/fitaAcademy\" \/>\n<meta property=\"article:published_time\" content=\"2020-10-12T12:31:52+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2023-10-09T12:45:09+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.fita.in\/wp-content\/uploads\/2020\/10\/sql-for-data-science.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"800\" \/>\n\t<meta property=\"og:image:height\" content=\"400\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"admin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@fitaacademy\" \/>\n<meta name=\"twitter:site\" content=\"@fitaacademy\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"admin\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"10 minutes\" \/>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"SQL For Data Science: For Beginners | SQL Data Analytics | FITA Academy","description":"Data has become the fuel for the organizations to strategize and formulate the entire models as per trending patterns and requirements. Databases are where these data reside, but working with them requires a programming language.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.fita.in\/sql-for-data-science-for-beginners\/","og_locale":"en_US","og_type":"article","og_title":"SQL For Data Science: For Beginners | SQL Data Analytics | FITA Academy","og_description":"Data has become the fuel for the organizations to strategize and formulate the entire models as per trending patterns and requirements. Databases are where these data reside, but working with them requires a programming language.","og_url":"https:\/\/www.fita.in\/sql-for-data-science-for-beginners\/","og_site_name":"FITA Academy","article_publisher":"https:\/\/www.facebook.com\/fitaAcademy","article_published_time":"2020-10-12T12:31:52+00:00","article_modified_time":"2023-10-09T12:45:09+00:00","og_image":[{"width":800,"height":400,"url":"https:\/\/www.fita.in\/wp-content\/uploads\/2020\/10\/sql-for-data-science.jpg","type":"image\/jpeg"}],"author":"admin","twitter_card":"summary_large_image","twitter_creator":"@fitaacademy","twitter_site":"@fitaacademy","twitter_misc":{"Written by":"admin","Est. reading time":"10 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.fita.in\/sql-for-data-science-for-beginners\/#article","isPartOf":{"@id":"https:\/\/www.fita.in\/sql-for-data-science-for-beginners\/"},"author":{"name":"admin","@id":"https:\/\/www.fita.in\/#\/schema\/person\/bb54ebe12aae8299727b8582c44347fb"},"headline":"SQL For Data Science: For Beginners","datePublished":"2020-10-12T12:31:52+00:00","dateModified":"2023-10-09T12:45:09+00:00","mainEntityOfPage":{"@id":"https:\/\/www.fita.in\/sql-for-data-science-for-beginners\/"},"wordCount":1924,"publisher":{"@id":"https:\/\/www.fita.in\/#organization"},"image":{"@id":"https:\/\/www.fita.in\/sql-for-data-science-for-beginners\/#primaryimage"},"thumbnailUrl":"https:\/\/www.fita.in\/wp-content\/uploads\/2020\/10\/sql-for-data-science.jpg","articleSection":["Data Science","SQL"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/www.fita.in\/sql-for-data-science-for-beginners\/","url":"https:\/\/www.fita.in\/sql-for-data-science-for-beginners\/","name":"SQL For Data Science: For Beginners | SQL Data Analytics | FITA Academy","isPartOf":{"@id":"https:\/\/www.fita.in\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.fita.in\/sql-for-data-science-for-beginners\/#primaryimage"},"image":{"@id":"https:\/\/www.fita.in\/sql-for-data-science-for-beginners\/#primaryimage"},"thumbnailUrl":"https:\/\/www.fita.in\/wp-content\/uploads\/2020\/10\/sql-for-data-science.jpg","datePublished":"2020-10-12T12:31:52+00:00","dateModified":"2023-10-09T12:45:09+00:00","description":"Data has become the fuel for the organizations to strategize and formulate the entire models as per trending patterns and requirements. Databases are where these data reside, but working with them requires a programming language.","breadcrumb":{"@id":"https:\/\/www.fita.in\/sql-for-data-science-for-beginners\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.fita.in\/sql-for-data-science-for-beginners\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.fita.in\/sql-for-data-science-for-beginners\/#primaryimage","url":"https:\/\/www.fita.in\/wp-content\/uploads\/2020\/10\/sql-for-data-science.jpg","contentUrl":"https:\/\/www.fita.in\/wp-content\/uploads\/2020\/10\/sql-for-data-science.jpg","width":800,"height":400},{"@type":"BreadcrumbList","@id":"https:\/\/www.fita.in\/sql-for-data-science-for-beginners\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.fita.in\/"},{"@type":"ListItem","position":2,"name":"SQL For Data Science: For Beginners"}]},{"@type":"WebSite","@id":"https:\/\/www.fita.in\/#website","url":"https:\/\/www.fita.in\/","name":"FITA Academy","description":"","publisher":{"@id":"https:\/\/www.fita.in\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.fita.in\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.fita.in\/#organization","name":"FITA Academy","url":"https:\/\/www.fita.in\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.fita.in\/#\/schema\/logo\/image\/","url":"https:\/\/www.fita.in\/wp-content\/uploads\/2019\/07\/site-logo-2.png","contentUrl":"https:\/\/www.fita.in\/wp-content\/uploads\/2019\/07\/site-logo-2.png","width":206,"height":100,"caption":"FITA Academy"},"image":{"@id":"https:\/\/www.fita.in\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/fitaAcademy","https:\/\/x.com\/fitaacademy","https:\/\/www.instagram.com\/fita_Academy\/","https:\/\/www.linkedin.com\/company\/9223636\/admin\/","https:\/\/www.youtube.com\/channel\/UCIbVc86kI5Jnq4Ez_8_hhIg?view_as=subscriber"]},{"@type":"Person","@id":"https:\/\/www.fita.in\/#\/schema\/person\/bb54ebe12aae8299727b8582c44347fb","name":"admin","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/1eb033f2b18b94065fabbcf6c8d8766b4ce3e554fea0cd7e183a04d46a52a42c?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/1eb033f2b18b94065fabbcf6c8d8766b4ce3e554fea0cd7e183a04d46a52a42c?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/1eb033f2b18b94065fabbcf6c8d8766b4ce3e554fea0cd7e183a04d46a52a42c?s=96&d=mm&r=g","caption":"admin"}}]}},"_links":{"self":[{"href":"https:\/\/www.fita.in\/wp-json\/wp\/v2\/posts\/67827","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.fita.in\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.fita.in\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.fita.in\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.fita.in\/wp-json\/wp\/v2\/comments?post=67827"}],"version-history":[{"count":9,"href":"https:\/\/www.fita.in\/wp-json\/wp\/v2\/posts\/67827\/revisions"}],"predecessor-version":[{"id":94648,"href":"https:\/\/www.fita.in\/wp-json\/wp\/v2\/posts\/67827\/revisions\/94648"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.fita.in\/wp-json\/wp\/v2\/media\/89116"}],"wp:attachment":[{"href":"https:\/\/www.fita.in\/wp-json\/wp\/v2\/media?parent=67827"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.fita.in\/wp-json\/wp\/v2\/categories?post=67827"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.fita.in\/wp-json\/wp\/v2\/tags?post=67827"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}