SQL Fundamentals LiveLessons

Table of contents

1. SQL Fundamentals Overview
   1. SQL Fundamentals Overview
2. Lesson 1: Introduction to the MySQL Interfaces
   1. Learning Objectives
   2. Introduction to the MySQL Interfaces
3. Lesson 2: Getting Data Out of the Database
   1. Learning Objectives
   2. The SELECT statement
   3. DISTINCT
   4. Ordering the results with ORDER clause
   5. Using the WHERE clause to filter data
   6. Using Subqueries to filter data
4. Lesson 3: Managing Data in the Database
   1. Learning Objectives
   2. UPDATE
   3. INSERT
   4. DELETE
   5. Managing Transactions
5. Lesson 4: Aggregation and Grouping
   1. Learning Objectives
   2. COUNT/SUM/MIN/MAX
   3. GROUP BY
   4. Filtering results using the HAVING clause
6. Lesson 5: Working with Multiple Tables
   1. Learning Objectives
   2. Introduction to the concept of joins
   3. INNER
   4. OUTER
   5. UNION
   6. INTERSECT
   7. MINUS
7. Lesson 6: Working with Tables in the Database
   1. Learning Objectives
   2. CREATE and DROP
   3. ALTER objects in the table objects
   4. Placing indexes on tables for improved performance
   5. Using keys and constraints to control data entered into tables
   6. Working with temporary table objects
8. Lesson 7: Working with Security
   1. Learning Objectives
   2. Introduction of how security in the database is handled
   3. Working with Users
   4. Assigning rights
9. Lesson 8: Advanced SQL programming
   1. Learning Objectives
   2. SQL Functions: String and Numbers
   3. SQL Functions: Date and Time
   4. SQL Functions: Conversions
   5. VIEWS
   6. STORED PROCEDURES
   7. TRIGGERS
   8. CURSORS