3 hours class duration   6 days a week / as per your convenience

This SQL Server training teaches developers all the Transact-SQL skills they need to create database objects like Tables, Views, Stored procedures & Functions and triggers in SQL Server.  Gives idea about writing Queries & Subqueries, working with Joins, etc. As well as database management skills like backup, restore, etc.

  • Learn Database models  Overview of SQL Server Management Studio and Transact-SQL language.
  • Master writing simple and complex queries that retrieve data from the database.
  • Calculate information across result sets using aggregate queries (sum, min, max, avg, etc.)
  • Insert, update, and delete data, Retrieve data from tables.
  • Joins, Sub-queries, Working with Data Types, Procedure and Functions.
  • Understand the different Views.
  • Working with Triggers.
  • Design a database, Maintain databases, tables, and sequences with SQL statements.
  • Create and manage views.
  • Ensure the integrity of multiple, related database updates by using transactions.
  • Retrieve data using cursor.
  • Manage binary data using BLOBs.

No Prior Experience is presumed.