Querying MySQL

Course Description:

The Querying MySQL class is an intensive 3-day course that teaches students the core skills for working with MySQL. Students learn the basics of MySQL use and work their way up to the programming of stored procedures. This course covers MySQL version 8.0

Topics covered in the course include:

• An introduction to relational databases and SQL
• How to use MySQL Workbench and other development tools
• How to retrieve data from a single table
• How to retrieve data from two or more tables
• How to insert, update, and delete data
• How to code summary queries
• How to code subqueries
• How to work with data types
• How to use functions
• How to create databases, tables, and indexes
• How to create views
• Language skills for writing stored programs
• How to use transactions and locking
• How to create stored procedures and functions
• How to code stored procedures

Target Student:

Prerequisites:

Prior experience installing software and programming in any language, such as HTML, is recommended but not require

Section 1: Introducing relational databases and SQL
Introducing client/server systems
Introducing the relational database model
Introducing SQL and SQL-based systems
The SQL statements
Using SQL from an application program

Section 2: Using MySQL Workbench and other development tools
Introducing MySQL Workbench
Using MySQL Workbench to run SQL statements
Using the MySQL Reference Manual
Using the MySQL Command Line Client

Section 3: How to retrieve data from a single table
Introducing the SELECT statement
Coding the SELECT clause
Coding the WHERE clause
Coding the ORDER BY clause
Coding the LIMIT clause

Section 4: How to retrieve data from two or more tables
Working with inner joins
Working with outer joins
Other skills for working with joins
Working with unions

Section 5: How to insert, update, and delete data
How to create test tables
How to insert new rows
How to update existing rows
How to delete existing rows

Section 6: Coding summary queries
Working with aggregate functions
How to group and summarize data
Coding aggregate window functions

Section 7: Coding subqueries
Introducing subqueries
Coding subqueries in the WHERE clause
Using the ALL keyword
Coding subqueries in other clauses
Working with complex queries
Working with common table expressions

Section 8: Working with data types
The data types
How to convert data

Section 9: Using functions
Working with string data
Working with numeric data
Working with date/time data
Other functions you should know about

Section 10: How to create databases, tables, and indexes
Working with databases
Working with tables
Working with indexes
Using MySQL Workbench
Working with character sets and collations
Working with storage engines

Section 11: How to create views
Introducing views
Working with views

Section 12: Language skills for writing stored programs
Introducing stored programs
How to write procedural code

Section 13: Using transactions and locking
Working with transactions
Working with concurrency and locking

Section 14: How to create stored procedures and functions

Section 15: Coding stored procedures
Coding stored functions
Using Workbench with procedures and functions

We offer live-instructor group training classes for your team.

Upskill your team from the comfort of your office or online.

Benefits of Group Training Include:

• Experienced Professional Instructor Trains Your Team
• Content Focused On Your Team's Needs
• Convenient Scheduling and Class Setup
• Significant Per/Student Cost Savings
• Online, On-Site and Blended Options Available

Get A Free Consultation