Overview

Save Big on Coursera Plus. 7,000+ courses at $160 off. Limited Time Only!

Grab it

Dive into a comprehensive 9-hour video playlist exploring SQL for data science. Learn essential SQL commands, queries, and functions crucial for data analysis. Begin with SQL basics, its importance in data science, and advantages. Progress through database concepts, RDBMS, and SQL processes. Master DDL, DML, DQL, DSL, and TCL commands with practical examples. Explore table creation, data manipulation, and complex querying techniques. Discover how to write efficient queries, use aggregate functions, and implement case statements. Delve into subqueries, joins, and set operations. Gain hands-on experience by installing MySQL and practicing various SQL operations. Ideal for beginners and aspiring data scientists looking to enhance their SQL skills for effective data manipulation and analysis.

Syllabus

What is SQL | use of SQL in data science | SQL topics for data science | advantages of SQL.
SQL for data science Part:02 | DDL | DML | DQL | DSL | TCL | Structure query language | Data Science.
SQL for data science Part:03 | What is Database | What is RDBMS | SQL process | Data Science.
SQL for data science Part:04 | Select, insert, update and delete commands with syntax | Data Science.
SQL for data science Part:05 | Create, alter and describe commands with syntax | Data Science.
SQL for data science Part:06 dml commands|sql for beginners| sql queries| dml commands|sql functions.
SQL for data science Part:07 dcl commands|sql for beginners| sql queries| dml commands|sql functions.
SQL for data science Part:08 tcl commands|sql for beginners| sql queries| dml commands|sql functions.
SQL for data science Part:09 dql commands|sql for beginners| sql queries| dml commands|sql functions.
SQL for data science Part:10 dql commands|sql for beginners| sql queries| dml commands|sql functions.
SQL for data science Part:11 DQL commands|sql for beginners| sql queries| DQL commands|sql functions.
SQL for data science Part:12 dql commands|sql for beginners| sql queries| dql commands|sql functions.
SQL for data science Part:13 procedure for writing correct queries l for beginners | sql queries.
SQL for data science Part:14 procedure for writing correct queries(cont.) l for beginner|sql queries.
How to install MySQL 8.0.26 Server and Workbench latest version on Windows 10 | MySQL Tutorial.
SQL for data science Part:16 Creating a database l for beginner|sql queries.
SQL for data science Part:17 Create, drop and show commands l for beginner|sql queries.
SQL for data science Part:18 Show databases and Creating the table l for beginner|sql queries.
SQL for data science Part:19 Insert and select functions l for beginner|sql queries.
SQL for data science Part:20 condition with select statement l for beginner | sql queries.
SQL for data science Part:21 distinct, all and where clause l for beginner | sql queries.
SQL for data science Part:22 Renaming the table l for beginner | sql queries.
SQL for data science Part:23 order by and putting conditions l sql for beginner | sql queries.
SQL for data science Part:24 group by and putting conditions l sql for beginner | sql queries.
SQL for data science Part:25 More SQL queries l sql for beginner | sql queries.
SQL for data science Part:26 Keys in SQL l sql for beginner | sql queries.
SQL for data science Part:27 Keys in SQL (Part : 2) l sql for beginner | sql queries.
SQL for data science Part:28 Joins in SQL l sql for beginner | sql queries.
SQL for data science Part:29 left and right Joins in SQL l sql for beginner | sql queries.
SQL for data science Part:30 Full Join in SQL l sql for beginner | sql queries.
SQL for data science Part:31 Constarints in SQL l sql for beginner | sql queries.
SQL for data science Part:32 Constarints in SQL (cont.)l sql for beginner | sql queries.
SQL for data science Part:33 Applying different queries in SQL l sql for beginner | sql queries.
SQL for data science Part:34 Aggregate functions in SQL part 01 l sql for beginner | sql queries.
SQL for data science Part:35 Aggregate functions in SQL Part:02 l sql for beginner | sql queries.
SQL for data science Part:36 Case statement in SQL l sql for beginner | sql queries.
SQL for data science Part:37 Sample query on case-switch l sql for beginner | sql queries.
SQL for data science Part:38 Sql correlated subqueries l sql for beginner | sql queries.
SQL for data science Part:39 nested subqueries vs correlated subquerieslsql for beginner|sql queries.
SQL for data science Part:40 correlated delete subqueries l sql for beginner | sql queries.
SQL for data science Part:41 Union Operator l sql for beginner | sql queries.
SQL for data science Part:42 count,sum,avg,min,max | sql for beginner | sql queries.