Course Summary

Course Title: Microsoft SQL Server Program (SQL Server, T-SQL & Reporting Services)
Course Duration: 6 Weeks of Training
Training Materials: All attendees would receive
  • Training presentation of each session,
  • Source Code for examples covered.
Training Format: This course is delivered as a highly interactive session, with extensive live examples. This course is delivered in two modes:
  • Class Room,
  • Online using Web and Audio Conferencing.
What will you learn?
In this training, attendees learn :
  • RDBMS & XML
  • SQL Server Database
  • Programming SQL Sever Database
  • Administering SQL Server Database
  • Designing SQL Server Solutions
  • Modeling Business Requirements
  • SQL Server Reporting Solutions
Attendees also learn:
  • Resume' Preparation Guidelines and Tips
  • Interview Preparation Guidelines and Tips
Who should attend?
Following professionals should plan on joining:
  • Anyone who is developing applications usinng MS SQL Server
  • Architects designing MS SQL Database solutions
  • Project Managers managing projects with SQL Server
  • Someone who is looking to switch to MS SQL Server Administration or Programming
  • Someone who is preparing for MS SQL Server Certification
What will be covered?

RDBMS & XML
  1. Introduction to RDBMS
  2. Normalization
  3. Data Integrity
  4. Codd’s Rules
  5. XML
  6. Modeling a Database at logical level

SQL Server Database
  1. Architecture
  2. Administration Tools
  3. Maintaining Indexes
  4. Security and Disaster recovery
  5. Replication

Programming SQL Sever Database
  1. Transact-SQL
  2. Data Types & Tables
  3. Data Integrity
  4. Views, Stored Procedures & User defined functions
  5. Triggers, Transactions & Locks
  6. Optimizing and Analyzing
Lab - Transact-SQL Project

Administering SQL Server Database
  1. Standard controls
  2. Menus, Data-bound Controls
  3. Dialog boxes & Forms Inheritance
  4. Printing & Reporting
  5. Deployment & Security

Designing SQL Server Solutions
  1. Connecting to Data Sources
  2. Selecting SQL Server Solutions
  3. Designing Data Modeling Strategy
  4. Designing Transaction Strategy
  5. Notification Services Solutions
  6. Advanced Query and XML Solutions

Mid Term Exam

Modeling Business Requirements
  1. Creating a Conceptual Model
  2. Trimming the Conceptual Schema
  3. Uniqueness constraints & Role constraints
  4. Logical Derivations & Entity Subtypes
  5. Relational Logical Model

SQL Server Reporting Solutions
  1. Introduction
  2. Basic Reports
  3. Manipulating Datasets
  4. Programming reporting services

Final Project & Exam

Resume Preparation Tips
  1. Resume Review
  2. Resume Preparation Tips
  3. Sample Resumes

Interview Preparation
  1. Interview Preparation Tips
  2. Sample Interview Questions
  3. Tips & Guidelines for Effective Interview?

We are committed to the Quality. Quality comes first for any services we provide.
Read Testimonials from our previous Trainees, to see it yourself.

Register Now

You can register using one of many options below:

Online Registration: Click Here to Register!

To Register By Phone:
Call (510) 244 3953, (925) 248 2249

To Register By Email:
Email contact@sansatechnology.com

Check Training Calendar at the Training Page


Have you got any questions?

Call us now - Our expert Customer Service Professionals will help you choose the right course.
Contact us today!


Discounts

Visit our Discounts Page to learn how you can save even more.