The SQL Primer Masterclass
- Description
- Curriculum
- FAQ
- Reviews
Welcome to The SQL Primer Masterclass. SQL skill is the most in-demand skillset required for someone who is working with data or is interested in starting a professional career in Data & Analytics field.
First question an interviewer ask is “what is your SQL level?”. In ‘The SQL Primer’ course we’ll take you from the basics to advanced concepts, ensuring you gain a deep understanding of SQL. Our goal in this course is to help improve your SQL knowledge, expose you to real life example to help you understand how to apply SQL knowledge in various scenarios. We have lots of exercises and quizzes to help you learn and get interview ready.
Starting with an introduction to SQL and BigQuery, you will learn about the basic structure of SQL, how to write queries, and essential syntax. As you progress, you’ll discover the various SQL commands, data types, and functions that help manipulate and retrieve data efficiently.
Understand the important topics like Joins, Subqueries, Common Table Expressions (CTEs), Window Functions, Nested and Repeated Structures, and Data Build Tool (dbt) with ease. Additionally, we cover string functions and SQL operators that can enhance your data manipulation capabilities.
You’ll also learn best practices for SQL, providing you the know-how to write clean, efficient, and effective code.
By the end of the course, you’ll be well-equipped to handle any SQL-related task and make data-driven decisions confidently. Ideal for beginners and those looking to refresh their knowledge, ‘SQL Primer’ is your ticket to mastering the language of data.”
Who this course is for:
- Data Scientist, Data Engineer, Data Analyst, BI Analysts, Analytics Engineers
- Anyone working with data and want’t to improve SQL skill
- For data professionals who wants to get a refresher on SQL
- Students or recent graduates who are looking to get a job in a Data field
- Anyone who is interested in Analytics or BI Career Path
-
4BigQuery SetupVideo lesson
-
5ResourcesVideo lesson
Please note that course slides are not provided due to license and copyright materials. If you'd like to reuse any content from this course please contact instructor for licensing requirements.
-
6Setting up Dataset & TableVideo lesson
-
7dbt SetupVideo lesson
-
39DDL-DML-Exercise 1Video lesson
-
40DDL-DML-Exercise 2Video lesson
-
41DDL-DML-Exercise 3Video lesson
-
42DDL-DML-Exercise 4Video lesson
-
43DDL-DML-Exercise 5Video lesson
-
44DDL-DML-Exercise 6Video lesson
-
45DDL-DML-Exercise 7Video lesson
-
46DDL-DML-Exercise 8Video lesson
-
47DDL-DML-Exercise 9Video lesson
-
48DDL-DML-Exercise 10Video lesson
-
49DDL-DML-Exercise 11Video lesson
-
50SUMVideo lesson
-
51COUNTVideo lesson
-
52COUNTIFVideo lesson
-
53AVGVideo lesson
-
54MIN-MAXVideo lesson
-
55Aggregate-Exercise 1Video lesson
-
56Aggregate-Exercise 2Video lesson
-
57Aggregate-Exercise 3Video lesson
-
58Aggregate-Exercise 4Video lesson
-
59Aggregate-Exercise 5Video lesson
-
60Aggregate-Exercise 6Video lesson
-
61Aggregate-Exercise 7Video lesson
-
62Aggregate-Exercise 8Video lesson
-
63Aggregate-Exercise 9Video lesson
-
64Aggregate-Exercise 10Video lesson
-
65Aggregate-Exercise 11Video lesson
-
66Aggregate-Exercise 12Video lesson
-
67CONCATVideo lesson
-
68REPLACEVideo lesson
-
69LOWERVideo lesson
-
70UPPERVideo lesson
-
71NORMALIZEVideo lesson
-
72SPLITVideo lesson
-
73LEFT-RIGHTVideo lesson
-
74TRIMVideo lesson
-
75String-Exercise 1Video lesson
-
76String-Exercise 2Video lesson
-
77String-Exercise 3Video lesson
-
78String-Exercise 4Video lesson
-
79String-Exercise 5Video lesson
-
80String-Exercise 6Video lesson
-
81String-Exercise 7Video lesson
-
82String-Exercise 8Video lesson
-
83String-Exercise 9Video lesson
-
84String-Exercise 10Video lesson
-
85String-Exercise 11Video lesson
External Links May Contain Affiliate Links read more