Sql & advance Sql online training

Unlock the power of data with our expert-led SQL online training programs. Get the most out of your data journey. Our top-rated SQL instructors provide hands-on training to make you a skilled SQL practitioner.

Flexible advanced SQL training designed to fit your schedule. Develop in-demand skills in data science, analytics, and database management.Take your SQL knowledge to the next level with our online training. Master advanced techniques, database administration, and unlock new career opportunities.

SQL Course Content

Duration: 30-35 hrs.

Introduction To SQL Server

• Connecting To Server
  • Server Type
  • Server Name
  • Authentication Modes
    • Sql Server Authentication Mode
    • Windows Authentication Mode
    • Login and Password
    • Sql Server Management Studio and Tools In Management Studio
      • Object Explorer
      • Object Explorer Details
      • Query Editor

TSQL (Transact-Structured Query Language)

Introduction To TSQL

• History and Features of TSQL
• Types Of TSQL Commands
• Data Definition Language (DDL)
• Data Manipulation Language (DML)
• Data Query Language (DQL)
• Data Control Language (DCL)
• Transaction Control Language (TCL)
• Database

• Creating Database
• Altering Database
• Deleting Database
• Constraints
  • Procedural Integrity Constraints
  • Declarative Integrity Constraints
    • Not Null, Unique, Default and Check constraints
    • Primary Key and Referential Integrity or foreign key constraints
    • Data Types In TSQL
    • Table
      • Creating Table
      • Altering Table
      • Deleting Table

Data Manipulation Language

• Insert
• Identity
• Creating A Table From Another Table
• Inserting Rows From One Table To Another
• Update

• Computed Columns
• Delete
  • Truncate
  • Differences Between Delete and Truncate

Data Query Language (DQL)

• Select
• Where clause
• Order By Clause
• Distinct Keyword
• Isnull() function
• Column aliases
• Predicates
• Between … And
• In
• Like
• Is Null

Built In Functions

• Scalar Functions
• Numeric Functions
• Character Functions
• Conversion Functions
• Date Functions
• Aggregate Functions

• Convenient Aggregate Functions
• Statistical Aggregate Functions
• Group By and Having Clauses
• Super Aggregates
• Over(partition by …) Clause
• Ranking Functions
  • Common Table Expressions (CTE)

Top n Clause

Linked Server Concepts

Set Operators

• Union
• Intersect
• Except

Joins

• Inner Join

• Self Join
• Outer Join
  • Left Outer Join
  • Right Outer Join
  • Full Outer Join
  • Cross Join

Sub Queries

• Single Row Sub Queries
• Multi Row Sub Queries
• Any or Some
• ALL
• Nested Sub Queries
• Co-Related Sub Queries

• Exists and Not Exists

Indexes

• Clustered Index
• NonClustered Index
• Create , Alter and Drop Indexes
• Using Indexes

Views

• Purpose Of Views
• Creating , Altering and Dropping Indexes
• Simple and Complex Views
• Encryption and Schema Binding Options in creating views

Transaction Management

• Introduction
• Begin Transaction
• Commit Transaction
• Rollback Transaction
• Save Transaction
• Role Of Log File In Transaction Management
• Implicit Transactions

TSQL Programming

• Drawbacks Of TSQL that leads to TSQL Programming
• Introduction To TSQL Programming
• Control statements In TSQL Programming
• Conditional Control Statements

• If
• Case

• Looping Control Statements
• While

Stored Sub Programs

• Advantages Of Stored Sub Programs compared to Independent SQL Statements
• Stored Procedures
• Creating , Altering and Dropping
• Optional Parameters
• Input and Output Parameters
• Permissions on Stored Procedures
• User Defined Functions
• Creating, Altering and Dropping
• Types Of User Defined Functions

• Scalar Functions
• Table Valued Functions
  • Inline Table Valued Functions
  • Multi Statement Table Valued Functions

• Permissions On User Defined Functions
• Triggers
• Purpose of Triggers
• Differences Between Stored Procedures and User Defined Functions and Triggers
• Creating, Altering and Dropping Triggers
• Magic Tables
• Instead Of Triggers
• Exception Handling
• Implementing Exception Handling
• Adding and removing User Defined Error Messages To And From SQL Server Error Messages List
• Raising Exceptions Manual

Normalization& Denormalization

Real-Time Explanation:

• SQL Server Software Installation (setting of different environments - development, stage and production DB servers)
• Use cases with an explanation for every SQL Server Concept
• Three Minor Project Implementations (Real Time – Education, Bank, Supply domains)
• Process of Requirement Gathering (for Development, Enhancement) and Implementation
• Unit Testing, QA Testing & UAT signoff
• Script Deployment – Dev, Stage & Prod
• SQL Optimisation (with respect to database design, table design, querying, page size, normalization and denormalization, indexes etc.,.)
• Interview Guidance