off original price!

The coupon code was not applied because it has already been redeemed or expired. Please click on "My Courses" to see if the course is already on your account.

off original price!

The coupon code was not applied because it has already been redeemed or expired. Please click on "My Courses" to see if the course is already on your account.

MySQL and SQL for Beginners

Learn to create and query databases using the free MySQL Server and Workbench

What's Inside

This course teaches you how to work with SQL and MySQL, the free industrial-strength database.

If you're interested in creating software that stores data in a central repository or you want to create dynamic websites, you'll almost certainly want to learn some SQL. This course teaches you everything from basic SQL to complex queries, transactions and stored procedures.

MySQL is one of the most popular databases currently in use in the world; second only to the incredibly secure and scalable Oracle. Probably the majority of websites in the world currently use MySQL to store their data, and learning SQL with MySQL will also make it easy to learn how to work with other databases.

Fortunately you can easily install MySQL on your computer at home -- even a laptop, and get started with this course right away!

Course Curriculum

Getting Started

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

Importing and Exporting Data

Exporting and Importing Data - 7:06
Start
Exporting Using the Command Line - 5:48
Start
Importing Using the Command Line - 4:31
Start

MySQL Operators

Some Test Data - 3:09
Start
Comparison Operators - 12:43
Start
Logical Operators - 12:48
Start
Exclusive Or - 7:47
Start
Exercises Part 1 - 6:19
Start
Solutions Part 1 - 13:44
Start

Update, Order and Limit

Beginning Update Statements - 6:18
Start
Order By - 4:49
Start
Limiting Results - 3:48
Start

MySQL Data Types

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

Aggregate Functions and Grouping

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

Foreign Keys and Multiple Tables

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

Combining Queries

Union and Union All - 10:00
Start
Subqueries with "in" - 7:00
Start
Inline Views - 8:00
Start

Altering Schemas

Adding Columns - 4:34
Start
Adding Foreign Keys - 8:22
Start
Adding Indexes - 5:39
Start
Indexes on Multiple Columns - 4:12
Start

Users and Privileges

Creating Users - 8:35
Start
Granting Privileges - 9:19
Start

Views

Creating a Simple View - 8:14
Start
View Algorithms - 11:00
Start
With Check Option - 7:14
Start

Locks and Transactions

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

MySQL Functions

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

Stored Procedures

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

Triggers

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

User-Defined Functions

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

Visual Design

Designing Databases Visually - 16:37
Start

Final Exercise

Final Exercise - 2:42
Start
Conclusion - 2:24
Start

Appendix

Connecting With Java - 14:29
Start
Retrieving Data with Java - 9:14
Start

off original price!

The coupon code was not applied because it has already been redeemed or expired. Please click on "My Courses" to see if the course is already on your account.

Get started now!

Paid Course Coupon Discount

or pay in installments:

$200

Certificate Available

48176+ Students

136 Lectures

18+ Hours of Video

Lifetime Access

24/7 Support

Instructor Rating

John Purcell

Popular Bundles

StackSkills Unlimited
Evan Kimbrell's Business Launching Bundle
Essential JavaScript Coding Bundle
Ultimate Web Developer Bundle
World Travel Hacker Bundle

off original price!

The coupon code was not applied because it has already been redeemed or expired. Please click on "My Courses" to see if the course is already on your account.

Just In

The 2020 Learn to Code Bundle

Hot Bundle

Master Photoshop & The Entire Creative Cloud

Unlimited Learning

Expand Your Mind with StackSkills Unlimited

Course Categories

MySQL and SQL for Beginners

Learn to create and query databases using the free MySQL Server and Workbench

What's Inside

Course Curriculum

Get started now!

Paid Course Coupon Discount

John Purcell