SQL with MySQL

Course Number:  501-JC
Recommend Duration: 2 days

Prerequisites:  None

Topics

• MySQL and Relational Database Concepts (quick overview)

• Using MySQL

• GUI Client Tools

• Building a Database (we will create 2 databases)

• Retrieving Data

• Filtering and Sorting Data

• Advanced Filtering

• Scalar Functions

  • Numeric

  • String

  • Dates

• Aggregate Functions

• Joining Tables

• Advanced Joins

• Combining Queries

• Subqueries

• Views

• Stored Procedures

• Triggers

• Using MySQL with EXCEL

• Administration

  • Backups and Recovery

  • Managing Users

  • Server Configuration