Home Training MySQL Database Training

Questions:Ask|Latest

MySQL Database Training
Posted on: March 25, 2008 By Deepak Kumar

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