In this program students learn the concepts of relational databases and the powerful SQL programming language. The students also learn to use single row functions to customize output, use conversion functions and conditional expressions and use group functions to report aggregated data. Demonstrations and hands-on practice reinforce the fundamental concepts. Students can also learn to control privileges at the object and system level. Additionally, this program covers creating indexes and constraints, and altering existing schema objects. Students also learn to create and query external tables and use the advanced features of SQL to query and manipulate data within the database.


  • Retrieve row and column data from SELECT statements

  • Create reports of sorted and restricted dat

  • Create reports of aggregated data

  • Run data manipulation statements (DML) to update data in the Oracle Database 11g

  • Run data definition language (DDL) statements to create and manage schema objects

Week-1: Read chapter 1, 2 and 3

  • SQL Server Basics

  •     Client-Server database architecture and SQL Server architecture

  •     Installing MS SQL Server (2008, 2012 or earlier)

  •     Tables, relational databases, SQL and database objects

  •     Design and develop MS SQL Server databases and tables

  •     Referencing objects in SQL Server databases

  •     Obtaining information from database tables

  •     SQL Server security


Week-2: Read chapter 4, 5 and 6 and Complete all exercise of chapter 3 and 4

  • Understanding Tables and Databases

  •     Creating databases manually

  •     Creating databases with database wizard

  •     Defining a maintenance plan wizard

  •     Databases using Transact-SQL

  •     Database manipulation: characteristics and deletions

  •     Working with tables

  • Indexes and Views

  •     The basics of index structures

  •     Creating and working with indexes

  •     Indexes and table architecture

  •     Creating views (including using view manager)

  •     Working with views

  •     Indexed views


Week-3: Read Chapter 7, 8 and Complete all exercise of chapter 6 and 7

  • Database Diagrams, The Query Analyzer and SQL Basics

  •     Working with diagrams

  •     Diagramming for pubs database

  •     Server connectivity and Screen management

  •     Working with queries

  •     SQL essentials (select, create table, insert, delete, update)

  • Stored Procedures, Triggers and Replication

  •     Components of stored procedures

  •     Creating and working with stored procedures/system stored procedures

  •     Components of triggers


Week-4: Read Chapter 9

  • Data Transformation Services (DTS), Back Ups/Restores, Users, Roles, Logins and Analysis Manager

  •     Creating, importing and exporting DTS

  •     Creating, scheduling backups and restores

  •     Authentication types, users, roles, security plans

  •     Configuring DSN, loading analysis manager and working with cubes


Week-5: Read Chapter 10

  •     Creating, scheduling backups and restores

  •     Authentication types, users, roles, security plans

  •     Configuring DSN, loading analysis manager and working with cubes


Week-6: Read Chapter 11

  •     Creating and working with triggers

  •     Replication model and types of replication

  •     Merge replication