MySQL Querying Fundamentals

Course Description:

The MySQL Querying Fundamentals class teaches students the fundamentals of how to write MySQL statements and perform simple queries of a database. Students will learn the core skills needed to access and manipulate data from MySQL databases. This course covers MySQL version 8.0.

Topics covered in the course include:

• Connect to the MySQL Server database and execute a simple query.
• Include a search condition in a simple query
• Use various functions to perform calculations on data
• Organize the data obtained from a query before it is displayed on-screen
• Retrieve data from multiple tables

Target Student:

Prerequisites:

Some familiarity with database terminology and structure will be helpful to students in this course.

Section 1: How to retrieve data from a single table
An introduction to the SELECT statement
Coding the SELECT clause
Coding the WHERE clause
Coding the ORDER BY clause
Coding the LIMIT clause

Section 2: 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
Coding summary queries
Working with aggregate functions
How to group and summarize data
Coding aggregate window functions

Section 3: Coding subqueries
An introduction to 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 4: Working with data types
The data types
How to convert data

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

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