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