English | MP4 | AVC 1920×1080 | AAC 48KHz 2ch | 4h 55m | 2.03 GB
Learn SQL, the most popular language for storing, querying and analyzing the data that powers today’s applications! In this course, you’ll learn to retrieve data with SELECT, use JOIN to tie tables together, create and update data, and use efficient queries to get the data fast. This SQL course is for professional developers who want to understand for persisting data in a server-side application with a relational database.
Table of Contents
Foundations of Relational Databases
1 Welcome & Tech Check
2 Relational Algebra & Codds Relational Model
Retrieving Data
3 Using the Command Line & Simple SELECT queries
4 LIMIT and ORDER Solution
5 Project Overview
6 SELECTing Columns Exercise
7 SELECTing Columns Solution
8 Filtering via WHERE clauses
9 Filtering via WHERE Exercise
10 Filtering via WHERE Solution
11 LIMITing and ORDERing the result set
12 LIMIT and ORDER Exercise
Querying Across Tables
13 Relationships & Joins
14 JOIN Exercise
15 JOIN Solution
16 Aggregate Functions and GROUP BY
17 Aggregate Functions and GROUP BY Exercise
18 Aggregate Functions and GROUP BY Solution
Creating, Updating, and Deleting
19 Creating & Deleting Records
20 Creating & Deleting Records Exercise
21 Creating & Deleting Records Solution
22 Transactions & Isolation
23 Transactions Exercise
24 Transactions Solution
25 Updating Records
26 Updating Records Exercise
27 Updating Records Solution
The Schema Evolves
28 Migrations
29 Indices
30 Add Indices Exercise
31 Add Indices Solution
32 Column Constraints
33 Column Constraints Exercise
34 Column Constraints Solution
Wrapping Up SQL Fundamentals
35 Wrap Up and Q&A
Resolve the captcha to access the links!