0% completed

All LessonsFree Lessons (6)

Introduction

Introduction Relational vs Non-Relational MySQL History & Architecture

Basic SQL

Exploring MySQL Create Database Data Types Create Table ... continue Temporary Table Collations & Character Sets Inserting Data Querying Data LIKE Operator Combining Conditions ORDER BY LIMIT Deleting Data TRUNCATE Updating Data Primary Key and Indexes ... continued Alterations Alter Index More on Alter Alias DISTINCT Aggregate Methods GROUP BY HAVING

Joins

Types of Joins Self Inner Join Inner Join Union Left and Right Joins Natural Join

Nested Queries

Nested Scalar Queries Nested Column Queries Nested Row Queries EXISTS Operator Correlated Queries

Multi Table Operations

Multi-Table Delete Multi-Table Update SELECT and INSERT REPLACE

Views

Creating a View Updating a View With Check Option Local & Cascaded Check Drop, Show, & Rename Views

Stored Procedures

What are Stored Procedures?Create, Delete, and Alter a Stored Procedure Variables Parameters Conditional Statements Iterative Statements Cursors Error Handling SIGNAL and RESIGNAL Stored Functions

Triggers

What are Triggers?Create and Delete a Trigger INSERT Triggers UPDATE Triggers DELETE Triggers Multiple Triggers

Miscellaneous

Transaction EXPLAIN Foreign Keys

Practice & Prep

Solution Practice Set 1

Solution Practice Set 2

Solution Practice Set 3

Solution Practice Set 4

Solution Practice Set 5

Solution Practice Set 6

Epilogue

An Introductory Guide to SQL/

...

/

Quiz 1

Quiz 1

Quiz yourself on basic queries and commands, including DELETE, LIMIT, and DATE in MySQL.

We'll cover the following...

Question # 1

1.

Which query/queries will print the version of MySQL?

A.

SELECT NOW();

B.

SELECT VERSION();

C.

SHOW VARIABLES LIKE "%version%";

D.

B and C

1 / 1