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

MHIITS
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.

1. Introduction to Microsoft SQL Server and T-SQL Query

  • 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

2. Working with Database and Tables

  • 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.

3. Implementing Data Integrity and Indexing

  • 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

4. Sorting and Filtering Data

  • 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

5. Querying Multiple 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 ...