Register Now for for Next Session start on 14th Jan 2023

Microsoft SQL Server

Intermediat level
36 hrs duration

What you'll learn

  • Creating Database and tables
  • CRUD Operation on data
  • Making perfomance Database
  • Implementation and mentenace of database

Microsoft SQL Server and T-SQL Query

Microsoft SQL Server is a powerful relational database management system (RDBMS) designed for storing and retrieving data. It provides a secure and scalable platform for managing databases, offering advanced features for performance optimization and data integrity.

Transact-SQL (T-SQL) is the query language used in SQL Server, allowing users to interact with the database by writing queries for tasks such as data retrieval, modification, and administration. T-SQL extends the SQL language with additional programming constructs, making it a versatile tool for developing complex database applications and stored procedures. With its comprehensive capabilities, Microsoft SQL Server is widely used in enterprise environments for data management and analysis.

  • The Basic Architecture of SQL Server
  • SQL Server Editions and Versions
  • Getting Started with SQL Server Management Studio
  • Introducing T-SQL
  • T-SQL Command
    • Data Definition Language
    • Data Modification Language (DML)
  • T-SQL Syntax
  • Introduction to Bank database
  • Process mechanism for online banking
  • Creating bank database (T-SQL)
  • Designing Tables
  • Working with Schemas
  • Creating and Altering Tables
  • Inserting Data into Tables
  • Viewing Data
  • Update and Delete Data in a table
  • Lab :
    • Designing and Implementing different tables
    • Insert/Update/Delete in previously created tables.
  • Enforcing Data Integrity
  • Implementing Domain Integrity
  • Implementing Entity and Referential Integrity
  • Core Indexing Concepts
  • Single Column and Composite Indexes
  • SQL Server Table Structures
  • Working with Clustered Indexes
  • Lab :
    • Create integrity and constraints.
    • Testing the constraints
    • Creating Tables with Clustered Indexes
    • Inserting data in the tables
    • Improving Performance through Nonclustered Indexes
  • Sorting Data in different previously created tables
  • Filtering Data with a WHERE Clause
  • Filtering with the TOP and OFFSET-FETCH Options
  • Working with Unknown and Missing Values
  • Lab : Sorting and Filtering Data with previously created tables
  • Understanding Joins
  • Querying with Inner Joins in Customer and Transaction tables
  • Querying with Outer Joins
  • Querying with Cross Joins and Self Joins
  • Lab : Querying Multiple Tables in Transaction tables
Load more ...