SQL Overview and Building the Database Schema

• Create and modify database tables, constraints and indexes
• Modify table contents
• Understand the various types of join, and its uses to retrive data from multiple tables
• Data update and transaction handling
• Apply rows and aggregate functions
• Relational Databases, Data Dictionaries
Building tables with CREATE,Modify and ALTER TABLES
• Add columns, DROP TABLE
• Data Intergrity and Constraints
• Improving performance with Indexes
• Data Manupulation and modifying table Contents

Transactions Development

• Create,modify and querry database tables, constraints and indexes
• Implementation of different types of data retrival from multiple tables
• Data update and transaction handling
• Apply rows and aggregate functions
• SELECT STATEMENTS, Querying tables,Expressions handling and TABLE ORDERING
• Various Types of database functions for Data manupulations
• Performances analysis for enhancement/optimality
• Subqueries and expression in details
• Creating and manupulating Views-Stored
• Building reusable codes
• Introduction to Triggers


Attendees Who Took This training are also encouraged to take the followup courses

• Transact-SQL-Programming (Advance)
• SQL Server Reporting Services
• Developing SQL Queries for SQL Server
• Introduction to Perl Programming
• SQL Server Integration Services for Business Intelligence
• Python Programming Introduction