Narrowing Down Select Statements | StackSkills

Autoplay
Autocomplete

Previous Lesson Complete and Continue

MySQL and SQL for Beginners

Getting Started

Introducing MySQL (7:14)
Installing MySQL and the Workbench (6:21)
Using the Command Line (7:10)
Creating Tables (9:30)
Multiple Columns, int and Data Types (4:48)
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:48)
Exclusive Or (7:47)
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:12)
Time, Date and Year (11:23)
Timestamp and Datetime (8:54)
Enumerations (6:46)
Brackets and Conditions Revisited (9:47)
Data Types Exercises (5:33)
Data Types Solutions to Exercises (8:27)

Aggregate Functions and Grouping

The distinct keyword (6:22)
Counting Distinct Values (6:12)
Aggregate Functions (5:10)
Arithmetic in MySQL (3:51)
The Health Survey Dataset (5:54)
Group By (9:49)
Having: Restricting Groups By Aggregate Functions (7:00)
Exercises 3 (7:57)
Solutions 3 (8:18)

Foreign Keys and Multiple Tables

Naming Columns and Tables (6:13)
Foreign Keys (11:57)
ER Diagrams (8:17)
Joins and Cartesian Products (10:20)
Inner Joins (5:47)
Left and Right Outer Joins (7:50)
Joins on Multiple Tables (5:38)
Querying Chains of Tables (4:39)
One to Many and One to One (4:48)
Many to Many (13:26)
Joining Tables to Themselves (13:21)
Restrict Foreign Keys (12:03)
Cascade Foreign Keys (14:17)
Exercises 4 (5:02)
Solutions 4 (12:05)

Combining Queries

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

Altering Schemas

Adding Columns (4:34)
Adding Foreign Keys (8:22)
Adding Indexes (5:39)
Indexes on Multiple Columns (4:12)

Users and Privileges

Creating Users (8:35)
Granting Privileges (9:19)

Views

Creating a Simple View (8:14)
View Algorithms (11:00)
With Check Option (7:14)

Locks and Transactions

Exclusive Table Locks (10:02)
Shared Table Locks (4:32)
Using Variables (6:38)
Setting Variables with Selects (7:10)
A Select-Update Example (9:29)
Fixing Select-Updates with Table Locks (6:43)
ACID (5:32)
A Simple Transaction (11:08)
Start Transaction (4:33)
InnoDB Row Locking and Isolation (6:59)
ACID Isolation Levels (9:40)
Serializable and Row vs Table Locking (12:11)
Demonstrating the Other Isolation Levels (9:54)
Rolling Back to Savepoints (7:58)
The Account Transfer Problem (8:37)
Select for Update (12:49)
Lock in Share Mode (8:31)

MySQL Functions

String Functions (14:07)
Dates, Intervals and Queries (8:29)
Date Diff and Dayname (4:50)
Str_To_Date and Date_Format (11:30)
Control Flow Functions (10:02)
Casting (6:25)
Functions Exercises (5:24)
Functions Solution (15:53)

Stored Procedures

Introducing Stored Procedures (2:40)
Changing the Delimiter (3:07)
Hello World (7:08)
Editing Stored Procedures (5:36)
Setting the Definer (7:23)
Procedure Permissions (6:53)
Passing Parameters (5:11)
Multiple Parameters (4:19)
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:37)
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:46)
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:37)

Final Exercise

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

Appendix

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

Narrowing Down Select Statements

Complete and Continue

Discussion

0 comments