Advanced SQL Bootcamp

Wishlist Share
Share Course
Page Link
Share On Social Media
Website Icon

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!

Show More

What Will You Learn?

  • Learn the power of Subqueries in SQL
  • Discover how to use Window Functions and Partitions in SQL
  • Understand advanced JOIN commands in SQL
  • Learn about SQL Set Operations
  • Discover Grouping Sets
  • Building table relationships and schema structures in SQL
  • Use SQL Transactions with Update and Set calls
  • Understand Table Inheritance with SQL
  • Create Views in SQL
  • Learn how to use Stored Procedures
  • Discover how to use Triggers across SQL Tables
  • Understand general useful methods and commands in Advanced SQL

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.

selected template

Student Ratings & Reviews

No Review Yet
No Review Yet

Want to receive push notifications for all major on-site activities?

×