Advanced SQL for Data Engineering
About Course
This free Advanced SQL for Data Engineering course from Udemy will help you master advanced database design concepts and sharpen your SQL skills. This course is perfect for anyone who wants to work in data-driven industries.
This course is divided into eight comprehensive sections, starting with an overview of relational databases and setting up your environment. You will learn about SQL syntax, Data Definition Language (DDL), Data Manipulation Language (DML), Data Query Language (DQL), and Data Control Language (DCL).
The course covers topics such as managing and manipulating databases, DateTime, complex data types, and advanced query techniques. You will learn how to use SQL statements like CREATE, ALTER, INSERT, UPDATE, DELETE, MERGE, and DROP. You will also learn about DateTime types, timezones, intervals, ENUMs, Ranges, and nested data.
The course also covers advanced query techniques like OVER, various types of JOINS, CASE, CONCAT, and Recursive Common Table Expressions (CTEs). You will learn how to optimize data structures, data normalization, the STAR schema, and the Snowflake model.
You will also learn about stored procedures, User-Defined Functions (UDFs), temporary tables, materialized views, and transactions. The course concludes with a series of challenging exercises to help you put your new skills to the test.
By the end of this course, you will be able to design, manage, and optimize databases effectively. This course is perfect for both budding and experienced data engineers.
Take this course today and become a SQL expert! This course is completely free. It’s available on Udemy, Udacity, Coursera, MasterClass, NearPeer, and other platforms.
Course Content
setting up the environment and overview of relational database
-
A Message from the Professor
-
Introduction to the course
01:02 -
Setting up the environment
02:59 -
An overview of relational databases
03:24 -
DDL DML
02:59 -
SQL syntax
03:10
Manipulating databases: Mastering essential SQL statements
Timing is everything: managing and manipulating Datatime in SQL
Complex Datatypes: ENUMs, ARRAYs, Ranges, and Nested Data in SQL
Advanced Query Techniques: Exploring OVER, JOINS, CASE and more in SQL
Optimizing Data Structures: The art and science of data normalization in SQL
Performance and Control: Mastering Stored Procedures, Temporary Tables
Practical Tasks
Earn a certificate
Add this certificate to your resume to demonstrate your skills & increase your chances of getting noticed.
Student Ratings & Reviews
