MySQL
This course provides students with a comprehensive overview of MySQL. Students will be able to install, run, tune, create and use databases. Basics of database applications will also be covered so that the student will have the tools to create database backed websites. MySQL is an open source relational database that is free for most users
Our Course Content
Relational Database Basics
- Tables
- Rows
- Columns
- Relationships
- Datatypes
- Primary Keys
- Foreign Keys
- Relational Database Management System
Popular Databases
- Commercial Databases
- Popular Open Source Databases
- Valid Object References
SQL Statements
- Database Manipulation Language (DML)
- Database Definition Language (DDL)
- Database Control Language (DCL)
Introduction to the Northwind Database
- Some Basics
- Comments
- Whitespace and Semi-colons
- Case Sensitivity
Sorting Records
-
- Sorting By a Single Column
- Sorting By Multiple Columns
- Sorting By Column Position
- Ascending and Descending Sorts
- Sorting Results
The WHERE Clause and Operator Symbols
- Checking for Equality
- Checking for Inequality
- Checking for Greater or Less Than
- Checking for NULL
- WHERE and ORDER BY
WHERE Clause and Operator Words
- The BETWEEN Operator
- The IN Operator
- The LIKE Operator
- The NOT Operator
Checking Multiple Conditions
- AND
- OR
- Order of Evaluation
Advanced SELECTs
Calculated Fields
- Concatenation
- Mathematical Calculations
- Aliases
Aggregate Functions and Grouping
- Aggregate Functions
- Grouping Data
- Selecting Distinct Records
Built-in Data Manipulation Functions
-
- Common Math Functions
- Common String Functions
- Common Date Functions
- Data Manipulation Functions
Subqueries, Joins and Unions
- Subqueries
- Subqueries
- Joins
- Table Aliases
- Multi-table Joins
- Using Joins
- Outer Joins
- Unions
- UNION ALL
- UNION Rules
- Working with Unions
Inserting, Updating and Deleting Records
- INSERT
- Inserting Records
- UPDATE
- DELETE
- Updating and Deleting Records
Views
- Creating Views
- Dropping Views
- Benefits of Views
- Creating a View
Stored Procedures
- Creating Stored Procedures
- Dropping Stored Procedures
- Creating a Stored Procedure
- Benefits of Stored Procedures