English | MP4 | AVC 1280×720 | AAC 44KHz 2ch | 82 lectures (10h 41m) | 3.35 GB
Take your SQL skills to the next level with our Advanced SQL Bootcamp
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!
What you’ll 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
Table of Contents
Introduction
1 Course FAQs
2 Course Introduction
3 Course Curriculum
4 Database Set-up
Subqueries and CTEs
5 Subqueries Overview
6 Subqueries in FROM Statements
7 Common Table Expressions
8 Subqueries for Comparisons
9 IN and NOT IN Statements
10 ANY and ALL statements
11 EXISTS clause in Subqueries
12 Recursive CTEs
13 Subqueries – Exercises
14 Subqueries – Exercise Solutions
Window Functions
15 Window Functions Overview
16 OVER, PARTITION and ORDER BY
17 WINDOW and Window Functions
18 Window Functions Exercise
19 Window Functions Exercise – Solutions
Advanced JOIN Operations
20 Self-Joins
21 Cross-Join
22 Full Join
23 USING Keyword and Natural JOINs
24 Advanced JOINs Exercise
25 Advanced JOINs Exercise Solutions
Set Operations
26 UNION
27 INTERSECT
28 EXCEPT
29 Set Operations – Exercise
30 Set Operations – Exercise Solutions
Grouping Sets
31 Grouping Sets Overview
32 CUBE
33 ROLLUP
34 Grouping Sets Exercises
35 Grouping Sets – Exercise Solutions
Schema Structures and Table Relationships
36 Information Schema
37 COMMENT
38 Adding and Dropping Constraints
39 Adding and Dropping Foreign Keys
40 Schema Structure Exercises
41 Schema Structure – Exercise Solutions
Transactions
42 Transactions Overview
43 UPDATE and SET
44 Beginning and Ending Transactions
45 SAVEPOINT
46 Database Locks
47 Transactions Exercises
48 Transactions Exercise – Solutions
Table Inheritance and Partioning
49 Range Partitioning
50 List Partitioning
51 Hash Partitioning
52 Table Inheritance
53 Table Partitioning Exercises
54 Table Partitioning Exercises – Solutions
Views
55 Creating Views
56 Modifying and Deleting Views
57 Updatable Views
58 Materialized Views
59 Recursive Views
60 Views Exercise
61 Views Exercise – Solutions
SQL Functions
62 Creating Functions
63 Modifying Functions
64 Functions Exercises
65 Functions Exercise – Solutions
Stored Procedures
66 Creating Stored Procedures
67 Modifying Stored Procedures
68 Stored Procedures Exercise
69 Stored Procedures Exercise – Solutions
Triggers
70 Creating Triggers
71 Enabling and Disabling Triggers
72 Modifying and Dropping Triggers
73 Triggers Exercises
74 Triggers Exercises – Solutions
Useful Methods and Tools
75 EXPLAIN and EXPLAIN ANALYZE
76 Dropping Data with TRUNCATE
77 Exporting and Importing Data with COPY
78 Array and Array Functions
79 JSON and JSON Functions
80 Modules and Extensions
81 Useful Methods and Tools Exercises
82 Useful Methods and Tools Exercises – Solutions
Resolve the captcha to access the links!