Home Training MySQL Database Training
Questions:Ask|Latest


 
 

Share on Google+Share on Google+

MySQL Database Training

Advertisement
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

     

Advertisement

Liked it!  Share this Tutorial


Follow us on Twitter, or add us on Facebook or Google Plus to keep you updated with the recent trends of Java and other open source platforms.

Posted on: March 25, 2008

Ask Questions?    Discuss: MySQL Database Training  

Post your Comment


Your Name (*) :
Your Email :
Subject (*):
Your Comment (*):
  Reload Image
 
 
Comments
DMCA.com