SQL Server

  • 4.5/5.0
  • 1000+ Enrolled
  • All levels
  • Last updated 1/2025
  • English

Course description

Our SQL Server Training covers everything you need to know about SQL Server. From the basics to advanced concepts, this course includes:

  • Database design and architecture
  • Writing complex SQL queries
  • Data manipulation techniques
  • Performance optimization strategies
  • User management and data security

With our engaging format and hands-on exercises, you will gain real-world experience that prepares you for practical challenges in the field.

Prerequisites :

To get the most out of our SQL Server Online Course Training, we recommend that you have:

  • Basic knowledge of programming concepts.
  • Familiarity with data structures and algorithms.
  • Understanding of basic computer operations.
What you’ll learn

  • File Management System And Its Drawbacks
  • Database Management System (DBMS) and Data Models
  • Conceptual Data Models

  • Advantages and Drawbacks Of SQL Server Compared To Oracle And DB2

  • History and Features of TSQL
  • Altering DatabaseTypes Of TSQL Commands
  • Deleting Database
  • Data Types In TSQL

  • Create
  • Alter
  • Drop
  • Truncate

  • Insert, Update & Delete
  • Differences Between Delete and Truncate
  • MERGE command

  • Select
  • Where clause
  • Predicates
  • Order By Clause
  • Distinct Clause
  • Column aliases
  • Computed columns

  • Numeric Functions
  • Character Functions
  • Conversion Functions
  • Date Functions
  • Special functions
  • Aggregate Functions
  • Ranking Functions

  • Union
  • Intersect
  • Except

  • Inner Join or Equi Join
  • Outer Join
  • Non-Equi Join
  • Self Join
  • Cross Join
  • ANSI joins

  • Single Row Sub Queries
  • Multi Row Sub Queries
  • Derived Tables & CTEs
  • Scalar Subqueries

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

  • SQL Server Authenticated Login
  • Windows Authenticated Login
  • Login Creation
  • User Creation
  • Granting Permissions
  • Revoking Permissions
  • Roles

  • Purpose Of Views
  • Simple and Complex Views
  • Encryption and Schema Binding Options in creating views

  • Non Clustered Index
  • Unique Index
  • Clustered Index

  • Generating sequence numbers using identity with SEED, INCR

  • creating, altering, dropping sequence

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

  • Working With Cursors
  • Types Of Cursors

  • Implementing Exception Handling
  • Adding and removing User Defined Error Messages To And From SQL Server Error Messages List
  • User defined exceptions

  • Advantages Of Stored Sub Programs compared to Independent SQL Statements
  • Stored Procedures
  • User Defined Functions

  • Purpose of Triggers
  • Differences Between Stored Procedures and User Defined Functions and Triggers
  • Creating, Altering and Dropping Triggers
  • Magic Tables
  • Instead Of Triggers

  • Temporary Tables and Global Temporary Tables
  • Table variables
  • Diff b/w temporary tables and table variables
  • Backup and Restore Of Database
  • Exporting & Importing Data
  • Attach and Detach of Database
  • Normalization
Enroll now

Course Information

  • Course Name Looker BI
  • Lectures 30
  • Duration 4h 50m
  • Level Beginner to Expert
  • Course Type Online/Offline
  • Language English
  • Faculty / Exp Keshav / 5yrs
  • Certificate Yes
Enroll a free demo class now

Our Courses