About this course
Our SQL for data analytics course is the perfect choice for Data Analysts, Data Engineers, and Data Scientists who want to take their SQL skills to next level. This course will take you from basics of SQL syntax to advanced techniques for data manipulation, data analysis and complex problem solving. Kick start your career with mastering the most in demand data skill called SQL.
Course Highlights :
Comments (0)
01 Installation of SQL server client, Introduction to SQL and DDL
1 Parts
01 Installation of SQL server client, Introduction to SQL and DDL
860 MB
02 ALTER commands, Constraints , Delete and Update
1 Parts
02 ALTER commands, Constraints , Delete and Update
913 MB
03 Select and Where
1 Parts
03 Select and Where
833 MB
04 SQL Filters Continue and Aggregation
1 Parts
04 SQL Filters Continue and Aggregation
860 MB
05 Data Aggregation Continue + SQL Joins
1 Parts
05 Data Aggregation Continue + SQL Joins
821 MB
06 SQL functions - date and string functions, case when
1 Parts
06 SQL functions - date and string functions, case when
765 MB
07 Set operations - Union, union all, minus, intersect
1 Parts
07 Set operations - Union, union all, minus, intersect
876 MB
08 SQL Interview Questions
1 Parts
08 SQL Interview Questions
992 MB
09 Sub Queries and CTEs
1 Parts
09 Sub Queries and CTEs
807 MB
10 Window Analytical functions - RANK, ROW_NUMBER, LEAD, LAG etc
1 Parts
10 Window Analytical functions - RANK, ROW_NUMBER, LEAD, LAG etc
892 MB
11 Aggregation with window functions
1 Parts
11 Aggregation with window functions
821 MB
12 Procedures and functions
1 Parts
12 Procedures and functions
802 MB
13 Advanced insert, update, exists and not exists
1 Parts
13 Advanced insert, update, exists and not exists
758 MB
14 SQL performance - Index and query optimization techniques
1 Parts
14 SQL performance - Index and query optimization techniques
806 MB
15 Introduction to Tableau and path ahead
1 Parts
15 Introduction to Tableau and path ahead
705 MB
16. SQL case study Project.1
1 Parts
16. SQL case study Project.1
1016 MB
18 Doubt Session Videos
1 Parts
18 Doubt Session Videos
573 MB
0
0 Reviews
.png)
