Learn Bench


  • This class covers all the basics and will get you on your way, with a solid foundation.
  • This instructor led, hands-on class covers the fundamentals of SQL and relational databases, using MySQL as a teaching tool.

Students who can benefit from this course

  • New or existing users of MySQL, who have little or no previous experience with a relational database management system


  • Basic computer literacy is required
  • Previous experience with any command-line program
  • Knowledge of database concepts


  • Understand the features and benefits of MySQL
  • Be able to install and start the MySQL server
  • Understand the basics of Relational Databases
  • Understand the SQL and MySQL languages
  • Understand Data/Column types with regard to efficient database design
  • Be able to view a database design structure/content
  • Create a database design using an efficient structure
  • Be able to extract basic database information using the SELECT command
  • Be able to troubleshoot syntax and understand typical warnings and errors
  • Be able to delete or modify a database, and table row data
  • Grouping query data with Aggregation
  • Connect data from multiple table rows using JOIN
  • Perform nested sub-queries
  • Use of Simple Functions (String, Date, Numerical)
  • Describe MySQL connectors, their major features and differences
  • Understand MySQL storage engines, transactions and features of the common engines
  • MySQL Architecture
  • Install and Start MySQL
  • Database Basics
  • SQL Language and MySQL
  • Keys
  • Normalization
  • Data Types
  • What is NULL?
  • Database Creation
  • Create a New Database Structure
  • Creating a Database
  • Creating a Table
  • Basic Queries
  • The SELECT Command
  • MySQL Query Browser
  • Troubleshooting
  • Database Maintenance
  • Delete an Entire Database
  • Maintaining Tables
  • Maintaining Columns
  • Indexes and Constraints
  • Data Manipulation
    Delete/Modify Table row Data
  • The INSERT Command
  • The REPLACE Command
  • The UPDATE Statement
  • The DELETE Command
  • Functions
  • Simple Functions
  • Grouping With Functions
  • Joining Tables
  • Combining Multiple Tables
  • Inner Joins
  • Outer Joins
  • Sub queries
  • What is a Sub query?
  • Categories of Sub queries
  • Sub query Types
  • Placing Sub queries
  • Supplementary Information
  • Creating VIEWs
  • Transactions
  • Storage Engines
  • Retrieving Metadata


MAy i help u

Live Chat
We're with you 24/7

latest product