space
Search Courses  in 

Just fill this form to get COURSE FEE details from BEST Training Institutes Instantly !

 

My City

 

I need details for

 

My Name

My Mobile Number

My Email ID

Purpose

Tell us your expectation...

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

Unix Academy Delhi Training

High Technologies Solutions - Delhi,Noida,Gurgaon

Embedded Technosolutions Mumbai

SHRISTI TECHNOLOGY LABS

GRRAS Institute Ahmedabad Jaipur Pune

Sun Infosystems Surat

Indian Institute of Technocrafts, Kolkata

IIHT Vadapalani Chennai

HITS computer Education chennai

IICT Chrompet - SAP Training in ChennaiPMP Training in India

IIHT Bangalore

RIA Institute of Technology Bangalore

Best Oracle PHP Java Training chennaiCareer Innovation Technologies Velachery

Dallas Technologies Bangalore

JITS Training

Mazenet SolutionAMEKS Infotech Ekkattuthangal, Chennai

HB Services Adyar Training InstituteITBMS chennai Best Training Institute

vgit kilpauke learning, e-publishing, technical writting courses

7 Eleven Arthashastra Chennai

Core Mind Technologies Chennai

Systems Domain Bangalore

Peridot Systems Chennai

Training course fee & Discounts

 

 

   DMCA.com Protection Status