MySQL Database Training

MySQL Training Course Objectives * How to use SQL to get output reports with MySQL. * How to modify MySQL data with SQL. * How to create a simple MySQL database Table.

MySQL Database Training

MySQL Database Training 

     

MySQL Training Course Objectives
  • How to use SQL to get output reports with MySQL.
  • How to modify MySQL data with SQL.
  • How to create a simple MySQL database Table.
Eligibility
This course is designed for those having  basic knowledge of computer. 

 

MySQL Training Course Outline

 

  • Relational Database Basics   
  • What is Relational Database?
  • What is Data, Table, Field, Records?
  • Popular Databases
  • SQL Statements
  • Simple SELECT Statement
  • SELECTing All Columns in All Rows
  • Exploring the Tables
  • SELECTing Specific Columns 
  • Sorting Records 
  • The WHERE Clause and Operator Symbols 
  • The WHERE Clause and Operator Words 
  • Checking Multiple Conditions 
  • Writing SELECTs with Multiple Conditions
  • Advanced SELECT Statement
  • Aggregate Functions and Grouping
  • Built-in Data Manipulation Functions
  • Interceptors 
  • Subqueries, Joins, and Unions with MySQL 
  • Subqueries 
  • Joins 
  • Outer Joins  
  • Unions 
  • Inserting, Updating and Deleting Records with MySQL
  • INSERT
  • UPDATE 
  • DELETE
  • Creating and Modifying Tables with MySQL
  • Creating Tables
  • Data types 
  • Altering Tables
  • Renaming Tables
  • Dropping Tables
  • Views and Stored Procedures
  • Creating Views with MySQL
  • Dropping Views 
  • Creating Stored Procedures
  • Benefits of Stored Procedures