Advanced SQL Bootcamp
About Course
Free Advanced SQL Bootcamp Course
This Advanced SQL Bootcamp course is designed to take your SQL skills to the next level! After completing this course, you will have a better understanding of how tables and databases work as well as advanced capabilities in querying the information stored in a SQL database effectively.
This course is perfect for individuals with basic SQL knowledge looking to become SQL Developer Professionals. You will learn about:
* Subqueries
* Common Table Expressions
* Window Functions
* Advanced Join Operations
* Set Operations
* Grouping Sets
* Schema Structures and Table Relationships
* Table Transactions
* Views
* Table Inheritance
* Stored Procedures
* Triggers
* Useful Advanced Methods
This course will teach you about advanced SQL concepts, including how to construct subqueries and common table expressions, window functions, and advanced join operations. You’ll learn about the power of sets, including set operations and grouping sets, as well as larger scope topics such as schema structures, table relationships, table inheritance, and views. You will also learn how to create easy-to-call stored procedures and automatic triggers across your database.
This course comes with great technical learning content, Q&A Forums inside the course, and access to our exclusive student community discord server.
**Get started today, this course is completely free!**
This course is available on platforms such as Udemy, Udacity, Coursera, MasterClass, NearPeer, and more!
Course Content
Introduction
-
A Message from the Professor
-
Course Introduction
01:56 -
Course Curriculum
02:25 -
Database Set-up
10:46
Subqueries & CTEs
Window Functions
Advanced JOIN Operations
Set Operations
Grouping Sets
Schema Structures and Table Relationships
Transactions
Table Inheritance and Partioning
Views
SQL Functions
Stored Procedures
Triggers
Useful Methods and Tools
Earn a certificate
Add this certificate to your resume to demonstrate your skills & increase your chances of getting noticed.