Home About Courses Schedule Services Webinars Contact Search

Introduction to SQL using MySQL

SEE SCHEDULE

Duration: 2 Days

Method: Instructor led, Hands-on workshops

Price: $1125.00

Course Code: MY1200


Audience

This MySQL training course is designed for students new to writing SQL queries using MySQL.

Description

If your organization uses MySQL for report writing as a backend to a database and it will be your job to write SQL queries, then this is the right SQL course for you. You will learn the fundamentals of SQL queries shared by all major databases as well as some of the ways MySQL's variant of SQL differs from other databases. The SQL learned in this course is standard to all modern databases, but MySQL will be used in class and syntax and functionality specific to MySQL will be pointed out.

Objectives

Upon successful completion of this course, the student will be able to:

  • Understand how MySQL works
  • Learn to use SQL to output reports with MySQL
  • Learn to write queries getting data from multiple tables

Prerequisites

None

Topics

  • I. Relational Database Basics
    • Brief History of SQL
    • Relational Databases
    • Tables
      • Rows
      • Columns
      • Relationships
      • Datatypes
      • Primary Keys
      • Foreign Keys
      • Relational Database Management System
    • Popular Databases
      • Commercial Databases
      • Popular Open Source Databases
    • SQL Statements
      • Database Manipulation Language (DML)
      • Database Definition Language (DDL)
      • Database Control Language (DCL)
  • II. Simple SELECTs
    • Introduction to the Northwind Database
    • Some Basics
      • Comments
      • Whitespace and Semi-colons
      • Case Sensitivity
    • SELECTing All Columns in All Rows
    • Exercise: Exploring the Tables
    • SELECTing Specific Columns
    • Exercise: SELECTing Specific Columns
    • Sorting Records
      • Sorting by a Single Column
      • Sorting By Multiple Columns
    • Ascending and Descending Sorts
    • Exercise: Sorting Results
    • The WHERE Clause and Logical Operator Symbols
      • Checking for Equality
      • Checking for Inequality
    • Exercise: Using the WHERE Clause to Check for Equality or Inequality
    • Checking for Greater or Less Than
    • Exercise: Using the WHERE Clause to Check for Greater or Less Than
    • Checking for NULL
    • Exercise: Checking for NULL
    • WHERE and ORDER BY
    • Exercise: Using WHERE and ORDER BY Together
    • Checking Multiple Conditions with Boolean Operators
      • AND
      • OR
      • Order of Evaluation
    • Exercise: Writing SELECTs with Multiple Conditions
    • The WHERE Clause and Logical Operator Keywords
      • The BETWEEN Operator
      • The IN Operator
      • The LIKE Operator
      • The NOT Operator
    • Exercise: More SELECTs with WHERE
  • III. Advanced SELECTs
    • Calculated Fields
      • Concatenation
      • Mathematical Calculations
      • Aliases
    • Exercise: Calculating Fields
    • Aggregate Functions and Grouping
      • Aggregate Functions
      • Grouping Data
    • Exercise: Working with Aggregate Functions
    • Selecting Distinct Records
    • Built-in Data Manipulation Functions
      • Common Math Functions
      • Common String Functions
      • Common Date Functions
    • Exercise: Data Manipulation Functions
  • IV. Subqueries, Joins and Unions
    • Subqueries
    • Exercise: Subqueries
    • Joins
      • Table Aliases
      • Multi-table Joins
    • Exercise: Using Joins
    • Outer Joins
    • Unions
      • UNION ALL
      • UNION Rules
    • Exercise: Working with Unions
  • V. Conditional Processing with CASE
    • Using CASE
    • Exercise: Working with CASE