021-36990045

Institute of Information Technology

0333-0204496

Course Details

SQL Server: Standardized Query Language

Module 1: Introduction to Basic Database Concepts

  • What is Data, Field, Record and database?
  • Limitations of File Management System.
  • Basic Concepts of DBMS.
  • Exploring Relational DBMS
  • Understanding Client and Server

Module 2: Normalization

  • Normalizing Tables

Module 3: Introduction to SQL Server

  • What is SQL Server Version history and different editions
  • Basic Features Components and Tools
  • Starting and Stopping SQL Server Instances / Services
  • Introduction to Management Studio
  • Types of System Databases in SQL

Module 4: Introduction to SQL

  • Basics of SQL Types of SQL Statements
  • DDL, DML, DQL, DCL and TCL
  • Create Database using Management Studio
  • Datatypes in SQL Server

Module 5: DDL and DML Statements

  • Why write statements in Frontends?
  • Create, Alter and Drop Table
  • Insert, Update and Delete Statement Truncate Statement

Module 6: Working with Queries

  • Understanding Select Statement
  • Usage of Top, Distinct, Null etc...keywords
  • Using String and Arithmetic Expressions
  • Exploring Where Clause with Operators
  • Using Advanced Operators
  • Sorting data using Order By clause
  • Working with basic of Sub Queries

Module 7: Aggregate Functions

  • Using functions in Queries
  • Using predefined functions
  • Count, Sum, Min, Max, Avg Group By and Having Clause
  • Using Group By with Rollup and Cube

Module 8: Joins and Set Operations

  • Introduction to Joins
  • Various types of Join
  • Sub Queries
  • Set Operations using Unions, Intersect and Except

Module 9: Working with Constraints

  • Unique
  • Not NULL
  • Primary Key
  • Foreign Key

Module 10: Implementing Views

  • Introduction & Advantages of Views
  • Creating, Altering, Dropping Views
  • Advance Options while Creating a View
  • SQL Server Catalogue Views

Module 11: Data Control language (DCL)

  • Creating Users & Roles
  • Granting & Revoking of Roles & privileges
  • Managing using Management Studio

Module 12: Working with Indexes

  • Introduction Clustered and Non Clustered Index
  • Creating and Dropping Indexes

Module 13: Writing Transact-SQL (T-SQL)

  • What is T-SQL?
  • Declaring and using Variables
  • Error Handling
  • Using System Functions / Global Variables Using Dynamic SQL

Module 14: Working with Stored Procedures and Functions

  • Introduction to stored procedures
  • Benefits of Stored Procedures
  • Creating, Executing Modifying, Dropping
  • Input–Output and Optional Parameters
  • System defined SP’s and Functions.
  • User defined Functions

Module 15: Implementing Triggers

  • Introduction to triggers
  • Creating, Altering, Dropping triggers
  • for/after/instead of triggers

Module 16: Backup and Restore

  • Generating SQL Script
  • Executing SQL Script
  • Taking database Backup
  • Restoring database using backup
  • Attaching and Detaching of database

Module 17: Advance Features

  • Pivot Table

Module 18: Analyze Performance

  • Basic Session Functionality
  • Implementing Simple Sessions Configuring Session Control
  • Configuring Session Contro

Module 19: A Guide to Moving and Copying Databases

  • Creating a database
  • Creating a database Table
  • CRUD in MySQL
  • Populating a MySQL database
  • Relational database tables
  • Populating the relational table
  • Module 20: Best Practices

    • Structuring a database
    • Using tables
    • Table relationships
    • Common data types