Narrowing Down Select Statements | Cave of Programming

Autoplay
Autocomplete

Previous Lesson Complete and Continue

MySQL and SQL for Beginners

Getting Started

Introducing MySQL (7:14)
Installing MySQL and the Workbench (6:20)
Using the Command Line (7:10)
Creating Tables (9:30)
Multiple Columns, int and Data Types (4:47)
Null Values and Not Null (8:25)
Mysql Storage Engines and Configuration (13:04)
SQL Modes (13:43)
Deleting All the Data in a Table (4:24)
Primary Keys (8:10)
Auto Increment (5:12)
Narrowing Down Select Statements (5:48)

Importing and Exporting Data

Exporting and Importing Data (7:06)
Exporting Using the Command Line (5:48)
Importing Using the Command Line (4:31)

MySQL Operators

Some Test Data (3:09)
Comparison Operators (12:43)
Logical Operators (12:47)
Exclusive Or (7:46)
Exercises Part 1 (6:19)
Solutions Part 1 (13:44)

Update, Order and Limit

Beginning Update Statements (6:18)
Order By (4:49)
Limiting Results (3:48)

MySQL Data Types

MySQL Types (3:14)
Text Types (13:01)
Floating Point Types and Integers (11:30)
Bool (8:48)
Blobs - Binary Data (4:48)
The Bit Type (6:11)
Time, Date and Year (11:23)
Timestamp and Datetime (8:54)
Enumerations (6:45)
Brackets and Conditions Revisited (9:47)
Data Types Exercises (5:35)
Data Types Solutions to Exercises (8:29)

Aggregate Functions and Grouping

The distinct keyword (6:24)
Counting Distinct Values (6:14)
Aggregate Functions (5:12)
Arithmetic in MySQL (3:52)
The Health Survey Dataset (5:56)
Group By (9:50)
Having: Restricting Groups By Aggregate Functions (7:02)
Exercises 3 (7:59)
Solutions 3 (8:20)

Foreign Keys and Multiple Tables

Naming Columns and Tables (6:15)
Foreign Keys (11:59)
ER Diagrams (8:19)
Joins and Cartesian Products (10:22)
Inner Joins (5:49)
Left and Right Outer Joins (7:51)
Joins on Multiple Tables (5:40)
Querying Chains of Tables (4:41)
One to Many and One to One (4:50)
Many to Many (13:28)
Joining Tables to Themselves (13:23)
Restrict Foreign Keys (12:05)
Cascade Foreign Keys (14:19)
Exercises 4 (5:04)
Solutions 4 (12:07)

Combining Queries

Union and Union All (10:02)
Subqueries with "in" (7:02)
Inline Views (8:02)

Altering Schemas

Adding Columns (4:35)
Adding Foreign Keys (8:24)
Adding Indexes (5:40)
Indexes on Multiple Columns (4:14)

Users and Privileges

Creating Users (8:37)
Granting Privileges (9:21)

Views

Creating a Simple View (8:15)
View Algorithms (11:02)
With Check Option (7:16)

Locks and Transactions

Exclusive Table Locks (10:04)
Shared Table Locks (4:34)
Using Variables (6:40)
Setting Variables with Selects (7:10)
A Select-Update Example (9:31)
Fixing Select-Updates with Table Locks (6:45)
ACID (5:34)
A Simple Transaction (11:10)
Start Transaction (4:35)
InnoDB Row Locking and Isolation (7:01)
ACID Isolation Levels (9:42)
Serializable and Row vs Table Locking (12:13)
Demonstrating the Other Isolation Levels (9:55)
Rolling Back to Savepoints (8:00)
The Account Transfer Problem (8:39)
Select for Update (12:49)
Lock in Share Mode (8:33)

MySQL Functions

String Functions (14:09)
Dates, Intervals and Queries (8:29)
Date Diff and Dayname (4:49)
Str_To_Date and Date_Format (11:32)
Control Flow Functions (10:04)
Casting (6:27)
Functions Exercises (5:24)
Functions Solution (15:53)

Stored Procedures

Introducing Stored Procedures (2:41)
Changing the Delimiter (3:08)
Hello World (7:08)
Editing Stored Procedures (5:37)
Setting the Definer (7:25)
Procedure Permissions (6:52)
Passing Parameters (5:11)
Multiple Parameters (4:18)
Select Into Variables (2:44)
Out Parameters (5:52)
Inout Parameters (6:09)
The If Statement (6:10)
Local Variables (6:06)
Implementing Account Withdrawal (7:36)
Transactional Withdrawal (3:26)
Errors and Warnings (3:59)
Error Handlers (6:50)
While Loops (9:57)
Labelled Loops (9:59)
Generating Random Data (7:59)
A Data Generating Procedure (12:24)
Cursors (8:25)
Fetching Cursor Data in a Loop (11:45)
The Case Expression (17:14)
Variable Scope and Multiple Cursors (10:54)
Procedures Exercises (10:26)
Procedures Solutions (14:22)

Triggers

Introducing Triggers (12:46)
Triggers and Validation (7:49)
Triggers and Transactions (15:54)
Triggers Exercise (2:29)
Triggers Exercise Solution (6:29)

User-Defined Functions

Functions vs. Procedures (5:03)
User-Defined Functions (11:37)

Visual Design

Designing Databases Visually (16:36)

Final Exercise

Final Exercise (2:41)
Conclusion (2:24)

Appendix

Connecting With Java (14:29)
Retrieving Data with Java (9:14)

Teach online with

Narrowing Down Select Statements

Discussion

0 comments