Complete Guide to SQL for Data Engineering: from Beginner to Advanced

Focused View

Deepak Goyal

7:11:33

37 View

01 - Introduction

01 - SQL for data engineering.mp4

00:38

02 - What you should know.mp4

01:41

03 - Using Codespaces.mp4

01:39

02 - 1. SQL Introduction

01 - What is SQL and why learn it.mp4

08:04

02 - Role of SQL in data engineering.mp4

05:53

03 - Setting up the SQL environment Install PostgreSQL.mp4

07:55

04 - Walkthrough PostgreSQL.mp4

07:22

03 - 2. SQL Basics

01 - Introduction to databases and tables.mp4

09:05

02 - SQL syntax and basic queries.mp4

12:11

03 - Selecting and filtering data.mp4

05:18

04 - Sorting data with ORDER BY.mp4

07:48

05 - Combining conditions with AND and OR.mp4

07:26

06 - Challenge Combine filter and ORDER BY.mp4

00:34

07 - Solution Combine filter and ORDER BY.mp4

00:45

04 - 3. Data Manipulation

01 - Introduction to data manipulation.mp4

03:25

02 - Inserting data into tables.mp4

09:51

03 - Updating existing records.mp4

08:14

04 - Deleting records from tables.mp4

08:52

05 - Challenge Delete records.mp4

00:25

06 - Solution Delete records.mp4

00:23

05 - 4. Advanced Data Querying

01 - Introduction to joins.mp4

05:02

02 - Inner join explained.mp4

07:09

03 - Left and right joins explained.mp4

07:18

04 - Full outer joins.mp4

10:41

05 - Using the UNION operator.mp4

09:02

06 - Using the CASE statement for conditional logic.mp4

07:12

07 - Using GROUP BY to aggregate data.mp4

08:52

08 - Common aggregation functions SUM, AVG, COUNT, etc..mp4

06:38

09 - Filtering GROUP BY results with the HAVING clause.mp4

07:52

10 - Challenge Joins.mp4

00:37

11 - Solution Joins.mp4

01:49

06 - 5. SQL Functions

01 - Introduction to SQL functions.mp4

04:30

02 - Using mathematical functions.mp4

04:56

03 - Working with date functions.mp4

09:02

04 - Working with time functions.mp4

07:06

05 - String functions Concatenation and trimming.mp4

05:45

06 - String functions Changing case and extracting substrings.mp4

07:22

07 - Challenge Play with strings.mp4

00:48

08 - Solution Play with strings.mp4

00:50

07 - 6. SQL Analytical Functions

01 - Introduction to analytical functions.mp4

05:31

02 - Using the RANK() function.mp4

07:16

03 - Using the DENSE RANK() function.mp4

04:27

04 - Exploring the ROW NUMBER() function.mp4

06:35

05 - Understanding the LAG() and LEAD() functions.mp4

07:55

06 - Running totals with SUM() OVER().mp4

07:29

07 - Calculating moving averages.mp4

07:33

08 - Challenge Find out the sum.mp4

00:33

09 - Solution Find out the sum.mp4

00:44

08 - 7. Views and Stored Procedures

01 - Introduction to views.mp4

04:10

02 - Creating and using views.mp4

08:02

03 - Introduction to stored procedures.mp4

04:57

04 - Creating and executing stored procedures.mp4

05:44

05 - Challenge Select via view.mp4

00:27

06 - Solution Select via view.mp4

02:00

09 - 8. Indexes and Performance

01 - Introduction to indexes.mp4

04:28

02 - Creating and managing indexes.mp4

06:09

03 - Understanding query performance.mp4

08:12

04 - Basic performance tuning techniques.mp4

07:20

05 - Challenge Indexes.mp4

00:35

06 - Solution Indexes.mp4

00:49

10 - 9. Database Security and User Management

01 - Introduction to database security.mp4

05:55

02 - Understanding users and roles in SQL.mp4

04:41

03 - Creating users and assigning roles.mp4

08:35

04 - Granting and revoking permissions.mp4

09:33

05 - Using roles for permission management.mp4

06:34

06 - Best practices for managing roles and permissions.mp4

07:10

07 - Challenge Create a role.mp4

00:27

08 - Solution Create a role.mp4

01:01

11 - 10. Debugging Common Mistakes and SQL Errors

01 - Understanding SQL syntax errors.mp4

09:43

02 - Logical errors in SQL.mp4

07:35

03 - Debugging NULL values.mp4

06:48

04 - Practical example Debugging real SQL issues.mp4

06:26

12 - 11. ETL Overview

01 - What is ETL and its importance.mp4

06:28

02 - ETL process flow.mp4

05:30

03 - Common ETL tools.mp4

07:23

13 - 12. Real-World Project

01 - Capstone project Insurance claims analysis.mp4

03:04

02 - Capstone project solution Insurance claims analysis.mp4

12:53

14 - Conclusion

01 - Next steps.mp4

00:51

Description

Are you looking to get up and running with SQL as a data engineer, but not sure where to begin? In this course, instructor Deepak Goyal provides a comprehensive overview of SQL specifically targeted at data engineers, from basic queries and analytic tasks to advanced functions and data management.Find out why SQL is one of the most frequently and widely used programming languages for data engineers. Explore fundamental skills in data manipulation, queries, functions, views and stored procedures, indexes and performance, database security, debugging, ETL, and more. The course concludes with a real-world capstone project based on insurance claims analysis.

This course is integrated with GitHub Codespaces, an instant cloud developer environment that offers all the functionality of your favorite IDE without the need for any local machine setup. With GitHub Codespaces, you can get hands-on practice from any machine, at any time-all while using a tool that you'll likely encounter in the workplace. Check out the "Using GitHub Codespaces with this course" video to learn how to get started.

More details

User Reviews

Rating

average 0

Total votes0

Focused display

Data Science

Microsoft SQL

Deepak Goyal

Instructor's Courses

Linkedin Learning

View courses Linkedin Learning

LinkedIn Learning is an American online learning provider. It provides video courses taught by industry experts in software, creative, and business skills. It is a subsidiary of LinkedIn. All the courses on LinkedIn fall into four categories: Business, Creative, Technology and Certifications. It was founded in 1995 by Lynda Weinman as Lynda.com before being acquired by LinkedIn in 2015. Microsoft acquired LinkedIn in December 2016.