microsoft partner logo color
8340  Reviews star_rate star_rate star_rate star_rate star_half

Introduction to SQL Using MySQL

Ascendient Learning's Introduction to SQL using MySQL course is designed for students new to writing SQL queries using MySQL. Note: This class can also be taught using MariaDB. Skills Gained...

Read More
By Request
Contact Us For Pricing
Duration 2 days
Course Code SQL-170
Available Formats Classroom

Overview

Ascendient Learning's Introduction to SQL using MySQL course is designed for students new to writing SQL queries using MySQL.

Note: This class can also be taught using MariaDB.

Skills Gained

  • Understand how MySQL works
  • Learn to use SQL to output reports with MySQL
  • Learn to modify MySQL data with SQL
  • Learn to create a simple MySQL database
  • Learn to create simple work with Views in MySQL
  • Learn to create tables in MySQL

Prerequisites

Experience in basic computer literacy with previous experience with command-line programs and some knowledge of database concepts is required. Some knowledge of data retrieval and reporting would be beneficial.

Course Details

Training Materials

All SQL using MySQL training students receive comprehensive courseware and a related textbook.

Software Requirements

  • Modern version of Windows, macOS, or Linux
  • MySQL version 5, 8, or above (we will provide detailed installation instructions)
  • Local admin privileges
  • Related lab files and database content that the students will extract and install at the start of class

Outline

  • 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
      • Valid Object References
    • SQL Statements
      • Database Manipulation Language (DML)
      • Database Definition Language (DDL)
      • Database Control Language (DCL)
  • Simple SELECTs
    • Introduction to the Northwind Database
    • Some Basics
      • Comments
      • Whitespace and Semi-colons
      • Case Sensitivity
    • SELECTing All Columns in All Rows
    • Exploring the Tables
    • SELECTing Specific Columns
    • SELECTing Specific Columns
    • 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
    • Using the WHERE clause to check for equality or inequality
    • Using the WHERE clause to check for greater or less than
    • Checking for NULL
    • Using WHERE and ORDER BY Together
    • The WHERE Clause and Operator Words
      • The BETWEEN Operator
      • The IN Operator
      • The LIKE Operator
      • The NOT Operator
    • More SELECTs with WHERE
    • Checking Multiple Conditions
      • AND
      • OR
      • Order of Evaluation
    • Writing SELECTs with Multiple Conditions
  • Advanced SELECTs
    • Calculated Fields
      • Concatenation
      • Mathematical Calculations
      • Aliases
    • Calculating Fields
    • Aggregate Functions and Grouping
      • Aggregate Functions
      • Grouping Data
      • Selecting Distinct Records
    • Working with Aggregate Functions
    • 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
  • Conditional Processing with CASE
    • Using CASE
    • Working with CASE
  • Inserting, Updating and Deleting Records
    • INSERT
    • Inserting Records
    • UPDATE
    • DELETE
    • Updating and Deleting Records
  • Creating and Modifying Tables
    • Data Types
    • Creating Tables
      • NULL Values
      • Primary Keys
      • Foreign Keys
    • Creating Tables
    • Adding and Dropping Columns
    • Renaming Tables
      • SQL Server
      • Oracle and MySQL
    • Dropping Tables
  • Views
    • Creating Views InnoDB
    • Dropping Views
    • Benefits of Views
    • Creating a View
  • Conclusion
Read Less

Schedule

Upcoming Course Dates

There are currently no scheduled dates for this course. If you are interested in this course, contact us with the form below.

Contact Information

FAQ

How do I get a Microsoft exam voucher?

Pearson Vue Exam vouchers can be requested and ordered with your course purchase or can be ordered separately by clicking here.

  • Vouchers are non-refundable and non-returnable. Vouchers expire 12 months from the date they are issued unless otherwise specified in the terms and conditions.
  • Voucher expiration dates cannot be extended. The exam must be taken by the expiration date printed on the voucher.

Do Microsoft courses come with post lab access?

Most Microsoft official courses will include post-lab access ranging from 30 to 180 calendar days after instructor led course delivery. A lab training key in class will be provided that can be leveraged to continue connecting to a remote lab environment for the individual course attendee.

Does the course schedule include a Lunchbreak?

Lunch is normally an hour-long after 3-3.5 hours of the class day.

What languages are used to deliver training?

Microsoft courses are conducted in English unless otherwise specified.

Reviews

vary good online learning. instructor is vary good the way he explained every thing.

Easy to work with. Learning material pdfs were able to be printed out in color which was very nice to write on.

ExitCertified was a great. They gave me all the materials and information I needed ahead of time to prepare for the course.

The labs and course material gave me valuable insights into cloud security architecture

I liked the pace of the course. I like that I have more than instance to use the lab.