Overview

This course on SQL for Data Science aims to teach students about different SQL commands, queries, and functions specifically tailored for data science applications. By the end of the course, students will be able to understand the use of SQL in data science, various SQL topics relevant to data science, and the advantages of using SQL in this field. The course covers a wide range of SQL commands such as DDL, DML, DQL, DSL, and TCL, along with teaching how to create, alter, describe, insert, update, and delete data. Students will also learn about database concepts, RDBMS, SQL processes, and different types of SQL commands. The teaching method involves a series of video lectures that explain each concept with practical examples and syntax explanations. This course is designed for beginners in SQL who are interested in applying SQL specifically in the context of data science.

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.