Advanced SQL Bootcamp

Take your SQL skills to the next level with our Advanced SQL Bootcamp

4.26 (1052 reviews)
Udemy
platform
English
language
Data Science
category
instructor
8,812
students
10.5 hours
content
Aug 2022
last update
$89.99
regular price

What you will 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

Description

Welcome to the best online course to take your SQL skills to the next level!

This course is designed to take you from basic SQL knowledge to a SQL Developer Professional. 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 that is stored in a SQL database effectively.

SQL is a critical skill for the modern workforce and we've created an online course specifically designed to take your current SQL knowledge to an advanced level. We'll begin the course with a deep dive into understanding how to construct subqueries and common table expressions, afterwards we'll move on to discussing window functions and advanced Join operations. Then you'll learn about the power of sets, including set operations and grouping sets. We will continue by learning about larger scope topics such as schema structures, table relationships, table inheritance, and views. We'll also teach you how to create easy to call stored procedures and automatic triggers across your database. After each section we will test your skills with a set of exercise questions.

In this course, you'll learn everything you need to be an expert SQL developer, we cover the topics that other basics courses don't! In this course you'll 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

  • and much more!

Not only does this course come with great technical learning content, but we also provide support in our Q&A Forums inside the course as well as access to our exclusive student community discord server where you can connect with other students. All of this material comes with a 30-day money back guarantee , so you can try the course completely risk free.

Enroll today and we'll see you inside the course!


Content

Introduction

Course FAQs
Course Introduction
Course Curriculum
Database Set-up

Subqueries and CTEs

Subqueries Overview
Subqueries in FROM Statements
Common Table Expressions
Subqueries for Comparisons
IN and NOT IN Statements
ANY and ALL statements
EXISTS clause in Subqueries
Recursive CTEs
Subqueries - Exercises
Subqueries - Exercise Solutions

Window Functions

Window Functions Overview
OVER, PARTITION and ORDER BY
WINDOW and Window Functions
Window Functions Exercise
Window Functions Exercise - Solutions

Advanced JOIN Operations

Self-Joins
Cross-Join
Full Join
USING Keyword and Natural JOINs
Advanced JOINs Exercise
Advanced JOINs Exercise Solutions

Set Operations

UNION
INTERSECT
EXCEPT
Set Operations - Exercise
Set Operations - Exercise Solutions

Grouping Sets

Grouping Sets Overview
CUBE
ROLLUP
Grouping Sets Exercises
Grouping Sets - Exercise Solutions

Schema Structures and Table Relationships

Information Schema
COMMENT
Adding and Dropping Constraints
Adding and Dropping Foreign Keys
Schema Structure Exercises
Schema Structure - Exercise Solutions

Transactions

Transactions Overview
UPDATE and SET
Beginning and Ending Transactions
SAVEPOINT
Database Locks
Transactions Exercises
Transactions Exercise - Solutions

Table Inheritance and Partioning

Range Partitioning
List Partitioning
Hash Partitioning
Table Inheritance
Table Partitioning Exercises
Table Partitioning Exercises - Solutions

Views

Creating Views
Modifying and Deleting Views
Updatable Views
Materialized Views
Recursive Views
Views Exercise
Views Exercise - Solutions

SQL Functions

Creating Functions
Modifying Functions
Functions Exercises
Functions Exercise - Solutions

Stored Procedures

Creating Stored Procedures
Modifying Stored Procedures
Stored Procedures Exercise
Stored Procedures Exercise - Solutions

Triggers

Creating Triggers
Enabling and Disabling Triggers
Modifying and Dropping Triggers
Triggers Exercises
Triggers Exercises - Solutions

Useful Methods and Tools

EXPLAIN and EXPLAIN ANALYZE
Dropping Data with TRUNCATE
Exporting and Importing Data with COPY
Array and Array Functions
JSON and JSON Functions
Modules and Extensions
Useful Methods and Tools Exercises
Useful Methods and Tools Exercises - Solutions

Screenshots

Advanced SQL Bootcamp - Screenshot_01Advanced SQL Bootcamp - Screenshot_02Advanced SQL Bootcamp - Screenshot_03Advanced SQL Bootcamp - Screenshot_04

Reviews

Donny
May 21, 2023
Doing a very poor job at showing and explaining what he's doing. He tends to jump right into whatever he's everything. Not taking into account that no one at his level is watching this course.
Ciaran
May 21, 2023
Good explanations given as usual, however this database is way too complicated and expansive. it has 2 partitions, so when i want to select the column "encounters", i have to type general_hospital.encounters. Column names are too large and a simple calculations look like - avg(surgical_discharge_date - surgical_admission_date). On the past course, we used the DVD_Rental, which was a lot more appropriate, as you could understand the point of the query and took an interest. In this one, the vastness of the database and the field names are soo boring and uninteresting, that it is taking away from the learning, to the point i don't understand or care what the lecture is trying to achieve, whereas the DVD Rental was actually interesting. Jose's Tone in describing each action has taken a downward trajectory, so not as engaging.. That aside, it is well explained and thorough enough. Where the last course was an A+, is one, so far is maybe B-
Ekta
May 5, 2023
Its good , Only thing i have encountered issue with Binary Path setup which isn't mentioned but it got resolved .
Sam
May 3, 2023
The previous course (or any other beginner SQL course) is definitely recommended before doing this one, as there is a step up in terms of material and exercises. The exercise format took a little while to get used to, there are no hints or support (there are of course answers/solutions afterwards, to check your knowledge). You get provided with 3-4 questions that you have to solve, after each chapter and that's it. It is expected that you familiarise yourself with the tables and table structure on your own - either by looking through the tables and running some basic queries or asking your SQL tool to make a hierarchy table. There is no hand-holding here. The course gets much easier towards the 50% mark, as by this time, you have seen the tables quite often and have a sense of where data is in each table and on which primary keys they can be joined together. Once you get used to this, however, it's actually quite empowering. This is exactly how questions come to me at work (the people requesting data often have no idea which tables the data is in - nor do they provide hints or clues as to where the data is or what method you should use to extract the data). It definitely feels great once you find the answer / data you need. I would say, if you stick with this course and do the exercises as intended, you will learn more that in other courses where you are provided tips/hints and more support - as these often become a crutch without you realising it. Personally, I also found that some of the information could have been presented in better ways. I find it very helpful to visualise what each SQL function does - especially for things like joins - so more diagrams would have been great. However, just like in real life, when I thought the material could have been explained further or if I had questions that weren't answered, Google and Stack Overflow provided the additional context I needed. It's also worth mentioning that this course deals exclusively with medical data. If that isn't your thing, then you might not like it. The course instructor is very knowledgable in this domain. Personally, I found it refreshing to experience a different domain than what I'm used to. Ultimately, after this course, I definitely have felt an improvement in my SQL skills and my confidence using SQL at work.
Dawid
May 3, 2023
When I received notification about the fact that Jose Portilla released another SQL course with advanced topics I immediately bought the course. I had great experiences from his SQL bootcamp so I was expecting something on the similar level. But unfortunately, I'm a little disappointed. First of all, as it was already mentioned in another reviews Jose is not a teacher in this course and the course itself doesn't represent the standard that I would personally associated with Jose Portilla brand. While the course indeed covers some advanced topics, the examples are very rushed and they don't really make much sense. But the biggest disappointment was with exercises... It would be much much better to present the solution (the table with the results that we need to retrieve from the database) instead of just asking us to create something and doing it in a very vague and indirect way. In most cases it was very problematic for me to actually do exercises and it wasn't because of the fact that I didn't understand the topic but I just didn't get what I was asked to do. Many times I had to come up with my own way of practicing the concepts presented in the course because exercises were useless. And it's really disappointing because as I mentioned before I was expecting similar form to the one in Jose Portilla SQL bootcamp. Hopefully, this course will be revamped.
Christopher
May 1, 2023
delivery instructor is NOT Jose, and so far the introductory setup course was not well explained. I will update this as I progress through the materiel.
Samad
April 19, 2023
The Instructor is good but I would suggest he gives more tasking examples using the tables in the database instead of just giving simple examples. Also, he was tutoring as if everyone was familiar with the tables in the database, he should carry people along more next time and let them familiarize themselves with the tables as the course goes on. Lastly, I was a bit unhappy when I realized the instructor was not Jose Portilla, he should have just told us a new person would anchor the course and not lied that he was going to be the one.
Viktoria
April 18, 2023
I’m not satisfied with this course because the teacher is not explaining that carefully that I think it’s okay, because here are some difficult things to understand. In my previous course my teacher was Jose Portilla and he was great.
Jorge
April 12, 2023
This is one of the most disappointing courses I've ever taken. Everything is in chaos as he types what he thinks instead of being methodical. I need to learn SQL elements and queries, but this is definitely not the most effective approach to achieving it. I wouldn't recommend it to anybody. It's a shame I pay for this.
Sivan
April 10, 2023
I just finished Jose's SQL bootcamp and loved his style of teaching and his execelent explantions. Unfortunately, Jose isn't teaching this course, and though Ben (The teacher) isn't bad, he definitely needs to improve. The course and Ben's explanations severely lacking in intro. I stopped in the middle of section 2 and bought a differnt SQL course.
Rupesh
March 27, 2023
I think, he has to explain the database first and relationship between tables used for practical purpose. Then start teaching the advanced topics. Definitely this course will be helpful from SQL perspective. But it can be better in explanation way.
Oleg
March 27, 2023
First of all-delivery instructor is NOT Jose. The course structured as expected, but level of details is SIGNIFICANTLY lower. The code is not explained section by section, the code block is just read out as if it’s self explanatory, which was not for me obviously, because if it was - I would NOT buy it. There is only one example- hospital, which instructor knows really well, but guess what? I not only know this side of life but also don’t like it in general. Jose was always putting very different examples from multiple fields and this one feels poor. Exercises are very scarce, and many are quite artificial and don’t always make sense, at least to me. I did learn quite a bit from the course but it is far from expectations from Jose Portilla brand…
Pablo
March 19, 2023
very difficult to follow. Dataset is complex and becomes a typing lesson vs sql learning. After reading reviews below 4 stars, I understand their frustration. wouldve been nice if same dataset was used form sql bootcamp.
David
March 17, 2023
It would be great to see the original tables of general_hospital in a diagram before every demonstration. Some visual representation of "what the query is supposed to do"
J
February 27, 2023
Not as good as the Complete SQL Bootcamp in my opinion although still good to know which areas are advanced.

Charts

Price

Advanced SQL Bootcamp - Price chart

Rating

Advanced SQL Bootcamp - Ratings chart

Enrollment distribution

Advanced SQL Bootcamp - Distribution chart

Related Topics

4829662
udemy ID
8/12/2022
course created date
8/28/2022
course indexed date
Bot
course submited by