SQL Server

  1. Courses
  2. SQL Server
Prev Next

Course Details

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. It gives idea about writing Queries & Sub-queries, working with Joins and etc.

  • Prerequisite: No Prior Experience is Presumed.
  • Course Duration: 30 Working days, daily 1.30 hours
  • Share
Training Course Objective
  • 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 cursors
  • Manage binary data using BLOBs

Course Content

Introduction To DBMS
  1. File Management System And Its Drawbacks
  2. Database Management System (DBMS) and Data Models
  3. Physical Data Models
  4. Logical Data Models
  5. Hierarchical Data Model (HDBMS)
  6. Network Data Model (NDBMS)
  7. Relational Data Model (RDBMS)
  8. Object Data Model (ODBMS)
  9. Object Relational Data Model (ORDBMS)
  10. Conceptual Data Models
  11. Entity – Relationship (E-R) Model
Introduction To SQL Server
  1. Advantages and Drawbacks Of SQL Server Compared To Oracle And DB2
  2. Connecting To Server
  3. Server Type
  4. Server Name
  5. Authentication Modes
  6. Sql Server Authentication Mode
  7. Windows Authentication Mode
  8. Login and Password
  9. Sql Server Management Studio and Tools In Management Studio
  10. Object Explorer
  11. Object Explorer Details
  12. Query Editor

TSQL (Transact-Structured Query Language)

Introduction To TSQL
  1. History and Features of TSQL
  2. Types Of TSQL Commands
  3. Data Definition Language (DDL)
  4. Data Manipulation Language (DML)
  5. Data Query Language (DQL)
  6. Data Control Language (DCL)
  7. Transaction Control Language (TCL)
  8. Database
  9. Creating Database
  10. Altering Database
  11. Deleting Database
  12. Constrains
  13. Procedural Integrity Constraints
  14. Declarative Integrity Constraints
  15. Not Null, Unique, Default and Check constraints
  16. Primary Key and Referential Integrity or foreign key constraints
  17. Data Types In TSQL
  18. Table
  19. Creating Table
  20. Altering Table
  21. Deleting Table
Data Manipulation Language
  1. Insert
  2. Identity
  3. Creating A Table From Another Table
  4. Inserting Rows From One Table To Another
  5. Update
  6. Computed Columns
  7. Delete
  8. Truncate
  9. Differences Between Delete and Truncate
Data Query Language (DQL)
  1. Select
  2. Where clause
  3. Order By Clause
  4. Distinct Keyword
  5. Isnull() function
  6. Column aliases
  7. Predicates
  8. Between … And
  9. In
  10. Like
  11. Is Nul
Built In Functions
  1. Scalar Functions
  2. Numeric Functions
  3. Character Functions
  4. Conversion Functions
  5. Date Functions
  6. Aggregate Functions
  7. Convenient Aggregate Functions
  8. Statistical Aggregate Functions
  9. Group By and Having Clauses
  10. Super Aggregates
  11. Over(partition by …) Clause
  12. Ranking Functions
  13. Common Table Expressions (CTE)

Top n Clause

Set Operators
    Union
  • Intersect
  • Except
    • Joins
    1. Inner Join
    2. Equi Join
    3. Natural Join
    4. Non-Equi Join
    5. Self Join
    6. Outer Join
    7. Left Outer Join
    8. Right Outer Join
    9. Full Outer Join
    10. Cross Join
    Sub Queries
    1. Single Row Sub Queries
    2. Multi Row Sub Queries
    3. Any or Some
    4. ALL
    5. Nested Sub Querie
    6. Co-Related Sub Queries
    7. Exists and Not Exists
    Indexes
    1. Clustered Index
    2. NonClustered Index
    3. Create , Alter and Drop Indexes
    4. Using Indexes
    Security
    1. Login Creation
    2. SQL Server Authenticated Login
    3. Windows Authenticated Login
    4. User Creation
    5. Granting Permissions
    6. Revoking Permissions
    7. Roles
    Views
    1. Purpose Of Views
    2. Creating , Altering and Dropping Indexes
    3. Simple and Complex Views
    4. Encryption and Schema Binding Options in creating views
    Transaction Management
    1. Introduction
    2. Begin Transaction
    3. Commit Transaction
    4. Rollback Transaction
    5. Save Transaction
    6. Role Of Log File In Transaction Management
    7. Implicit Transactions
    TSQL Programming
    1. Drawbacks Of TSQL that leads to TSQL Programming
    2. Introduction To TSQL Programming
    3. Control statements In TSQL Programming
    4. Conditional Control Statements
    5. If
    6. Case
    7. Looping Control Statements
    8. While
    Cursors
    1. Working With Cursors
    2. Types Of Cursors
    3. Forward_Only and Scroll Cursors
    4. Static, Dynamic and Keyset Cursors
    5. Local and Global Cursors
    Stored Sub Programs
    1. Advantages Of Stored Sub Programs compared to Independent SQL Statements
    2. Stored Procedures
    3. Creating , Altering and Dropping
    4. Optional Parameters
    5. Input and Output Parameters
    6. Permissions on Stored Procedures
    7. User Defined Functions
    8. Creating, Altering and Dropping
    9. Types Of User Defined Functions
    10. Scalar Functions
    11. Table Valued Functions
    12. Inline Table Valued Functions
    13. Multi Statement Table Valued Functions
    14. Permissions On User Defined Functions
    15. Triggers
    16. Purpose of Triggers
    17. Differences Between Stored Procedures and User Defined Functions and Triggers
    18. Creating, Altering and Dropping Triggers
    19. Magic Tables
    20. Instead Of Triggers
    21. Exception Handling
    22. Implementing Exception Handling
    23. Adding and removing User Defined Error Messages To And From SQL Server Error Messages List
    24. Raising Exceptions Manual
    CLR Integration
    1. What is CLR Integration and The Steps For Implementing IT
    2. A Simple Example With CLR Integration
    Working With XML Data Type
    Backup and Restore Of Database
    Attach and Detach of Database
    Normalization

    Other Courses

    Buld your career with Vflag
    AWS

    Amazon Web Services

    Data Science

    Data Science

    DevOps

    DevOps

    Hadoop

    Hadoop

    Python FullStack

    Python FullStack

    SQl Server

    SQl Server/a>