My SQL training course

My sql is a database management course. Use of MySQL "front-ends", desktop software and web applications that create and manage MySQL databases, build database structures, back up data, inspect status, and work with data records. The official set of MySQL front-end tools, MySQL Workbench is actively developed by Oracle, and is freely available for use.


Prerequisites


Experience in basic computer literacy with previous experience with command-line programs and some knowledge of database concepts is required. Some knowledge of data retrieval and reporting would be beneficial.


My SQL Course content


Relational Database Basics


» Brief History of SQL
» Relational Databases
» Tables
» Rows
» Columns
» Relationships
» Datatypes
» Primary Keys
» Foreign Keys
» Relational Database Management System
» Popular Databases
» Commercial Databases
» Popular Open Source Databases
» Valid Object References
» SQL Statements
» Database Manipulation Language (DML)
» Database Definition Language (DDL)
» Database Control Language (DCL)


Simple SELECTS


» Introduction to the Northwind Database
» Some Basics
» Comments
» Whitespace and Semi-colons
» Case Sensitivity
» SELECTing All Columns in All Rows
» Exploring the Tables
» SELECTing Specific Columns
» Sorting Records
» Sorting By a Single Column
» Sorting By Multiple Columns
» Sorting By Column Position
» Ascending and Descending Sorts
» Sorting Results
» The WHERE Clause and Operator Symbols
» Checking for Equality
» Checking for Inequality
» Checking for Greater or Less Than
» Checking for NULL
» WHERE and ORDER BY
» Using the WHERE clause to check for equality or inequality
» Using the WHERE clause to check for greater or less than
» Checking for NULL
» Using WHERE and ORDER BY Together
» The WHERE Clause and Operator Words
» The BETWEEN Operator
» The IN Operator
» The LIKE Operator
» The NOT Operator
» More SELECTs with WHERE
» Checking Multiple Conditions
» AND
» OR
» Order of Evaluation
» Writing SELECTs with Multiple Conditions


Advanced SELECTs


» Calculated Fields
» Concatenation
» Mathematical Calculations
» Aliases
» Calculating Fields
» Aggregate Functions and Grouping
» Aggregate Functions
» Grouping Data
» Selecting Distinct Records
» Working with Aggregate Functions
» Built-in Data Manipulation Functions
» Common Math Functions
» Common String Functions
» Common Date Functions
» Data Manipulation Functions


Subqueries, Joins and Unions


» Subqueries
» Joins
» Table Aliases
» Multi-table Joins
» Using Joins
» Outer Joins
» Unions
» UNION ALL
» UNION Rule
» Working with Unions


Conditional Processing with CASE


» Using CASE
» Working with CASE


Inserting, Updating and Deleting Records


» INSERT
» Inserting Records
» UPDATE
» DELETE
» Updating and Deleting Records


Creating and Modifying Tables


» Data Types
» Creating Tables
» NULL Values
» Primary Keys
» Foreign Keys
» Creating Tables
» Adding and Dropping Columns
» Renaming Tables
» SQL Server
» Oracle and MySQL
» Dropping Tables


Views


» Creating Views
» Dropping Views
» Benefits of Views
» Creating a View


Stored Procedures


» Creating Stored Procedures
» Dropping Stored Procedures
» Creating a Stored Procedure
» Benefits of Stored Procedures


Below you can find city wise My SQLInstitutes


My SQLtraining institutes in India

My SQLtraining institutes in Chennai

My SQLtraining institutes in Bangalore

My SQLtraining institutes in Mumbai

My SQLtraining institutes in Pune

My SQLtraining institutes in Delhi-NCR

21-08-2013 by Training Support