Home Training MySQL Database Training



MySQL Database Training
Posted on: March 25, 2008 at 12:00 AM
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 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

     

Related Tags for MySQL Database Training:
sqlmysqlcdatabasetabledataobjectreportsoutputgettrainingportreportaisimplecreatetabifwithtoinibasemodifyportseitputuseiminmodasmouttrjesrepoasehowobjobjectivemodicoursesatmyivmpleartrtssimssthababljepleplobjectiveso


More Tutorials from this section

Ask Questions?    Discuss: MySQL Database Training  

Post your Comment


Your Name (*) :
Your Email :
Subject (*):
Your Comment (*):
  Reload Image
 
 

Ask Questions?

If you are facing any programming issue, such as compilation errors or not able to find the code you are looking for.

Ask your questions, our development team will try to give answers to your questions.