MS SQL

Master Program1034 Ratings
  • Live interaction with Industry leadershipIncludes live Master Classes and Ask me anything sessions
  • 100+ hours of live interactive learningLive Online classes by industry experts
  • With real time projectsBuilt on datasets of various scenarios & real time problems
  • ITlearn360 JobAssistGet noticed by the top hiring companies

Learning Path

  • Course 1

    MS SQL Server 2016 Administrator

    Course curriculum

    Module 1: Relational Database Management Systems Concept

    • 1.1  Database and a Relational Database Management System (RDBMS)
    • 1.2   Microsoft SQL Server Platform and Overview
    • 1.3   Database Administrator Role and Responsibilities

    Module 2: Installing Microsoft SQL Server 2016

    • 2.1  Microsoft SQL Server 2016 and Editions?
    • 2.2   Hardware and Software Prerequisites to Install SQL Server 2016
    • 2.3   SQL Server 2016 Components
    • 2.4   Adding Features to an Existing SQL Server 2016
    • 2.5   Microsoft SQL Server 2016 Management Studio Installation

    Module 3: Microsoft SQL Server 2016 Architecture

    • 3.1  SQL Server System and Business (non-system) Databases
    • 3.2   SQL Server Database Structure
    • 3.3   Filegroups and Datafiles of SQL Server
    • 3.4   Transaction Logs and Recovery Models of SQL Server
    • 3.5   SQL Server Instance vs Database
    • 3.6   Client to Server Sets of SQL Server

    Module 4: Creating Database Objects On The Management Studio

    • 4.1  Creating Database
    • 4.2   Using SQL Server Management Studio (SSMS) and Create Table and Index
    • 4.3   SSMS Index Management for Fragmentation Reduction
    • 4.4   SSMS Primary Key and Foreign Key Setup
    • 4.5   SSMS File Grouping

    Module 5: Securing Microsoft SQL Server 2016

    • 5.1  Understand Instance and Database-level Principles
    • 5.2   Roles in Fixed Server of SQL Server
    • 5.3   Creating New User and Mapping with Instance Login
    • 5.4   Database Schemas in SQL Server and User Management
    • 5.5   Grant and Revoking Database Users
    • 5.6   Configuration Manager of SQL Server and Instance Ownership
    • 5.7   Auditing Logins in SQL Server 2016

    Module 6: Session Management on MS SQL Server 2016

    • 6.1  Database Connections vs Sessions
    • 6.2   Monitoring Database Activity
    • 6.3   SSMS Killing Session or Terminals
    • 6.4   SSMS Running Reports
    • 6.5   Autocommit Transactions

    Module 7: Backuping and Recovering from MS SQL Server

    • 7.1  Backup and Recovery Concept and Strategies
    • 7.2   Offline Mode on Database
    • 7.3   Copy Database Wizard (CDW) to Copy Databases
    • 7.4   SIMPLE and FULL Recovery Model for Full Backup
    • 7.5   Backup History Information
    • 7.6   Automating Backups Plan in SQL Server
    • 7.7   Purging Old Backups Plans
    • 7.8   Scheduling Backups From SQL Server Agent
    • 7.9   Database Restore and Recovery Overview
    • 7.10   Full Database Restore and Recovery
    • 7.11   Recovering from SQL Server Transactional Logs
    • 7.12   Using Time Based Recovery Option (STOPAT)

    Module 8: Backup to AZURE (Cloud)

    • 8.1  Creating Azure Account
    • 8.2   Creating Storage Containers in Azure
    • 8.3   Creating SQL Server Credentials and Use for Backup Authentication
    • 8.4   Perform a Full Database Backup to URL
    • 8.5   Delete the Database and Restore it from the URL

    Module 9: Service Packs and Database Upgrades

    • 9.1  SQL Server 2012 Service Pack 3 (SP3) to SQL Server 2012 RTM
    • 9.2   SQL Server 2012 SP3 to SQL Server 2016 RTM

    Module 10: Export and Import from MS SQL Server 2016

    • 10.1  Partial Data Export and Import Using BCP Command Line Tools
    • 10.2   Partial Data/import Through Wizards of GUI Tools

    Module 11: Tuning SQL Server 2016 Performance

    • 11.1  Indexing Concept to Boost Select Performance
    • 11.2   Index Fragmentation and Maintaining to Improve Performance
    • 11.3   Understanding SQL Server Database Statistics and Profiler
    • 11.4   Creating SQL Server Traces and Server-Side Traces
    • 11.5   Using Views to Improve MS SQL Performance
  • Course 2

    T-SQL

    Course curriculum

    Module 1: Basics on MS SQL Server 2016

    • 1.1  This module introduces SQL Server
    • 1.2   the versions of SQL Server
    • 1.3   including cloud versions
    • 1.4   and how to connect to SQL Server using SQL Server Management Studio
    • 1.5   SQL Server Architecture
    • 1.6   Learn SQL Server Management Studio and Tools
    • 1.7   Creating T-SQL Scripts and Managing them

    Module 2: Introduction to T-SQL Querying

    • 2.1  Basics of T-SQL
    • 2.2   Know Sets and Predicate Logic
    • 2.3   Know Logical Order of Operations in SELECT statements
    • 2.4   Write T-SQL Querying and run SELECT Statements
    • 2.5   Run queries that filters data using predicates
    • 2.6   Use ORDER BY to sort data
    • 2.7   -- (Comment) and Slash Star Comment
    • 2.8   CREATE DIAGNOSTICS SESSION
    • 2.9   NULL and UNKNOWN USE
    • 2.10  Backslash and GO

    Module 3: T-SQL Control Flows and Error Handling

    • 3.1  BEGIN...END
    • 3.2   BREAK and CONTINUE
    • 3.3   ELSE (IF...ELSE)
    • 3.4   END (BEGIN...END)
    • 3.5   GOTO
    • 3.6   RETURN
    • 3.7   TRY...CATCH and THROW
    • 3.8   WAITFOR while WHILE

    Module 4: Using CURSORS IN T-SQL

    • 4.1  CLOSE
    • 4.2   DEALLOCATE and DECLARE CURSOR
    • 4.3   FETCH and OPEN

    Module 5: Using Expressions in T-SQL

    • 5.1  Using with CASE Expression
    • 5.2   Using with COALESCE Expression
    • 5.3   Using NULLIF Expression

    Module 6: Using Operators in T-SQL

    • 6.1  Using Unary - Positive and Negative Operators
    • 6.2   Set - EXCEPT and INTERSECT Operators
    • 6.3   Set - UNION Operator
    • 6.4   Using Arithmetic Operators
    • 6.5   Module
    • 6.6   Assignment
    • 6.7   Using Comparisons
    • 6.8   Logical Operators
    • 6.9   Work on Strings

    Module 7: Working in TRANSACTIONS

    • 7.1  Transaction Isolation Levels
    • 7.2   Apply BEGIN DISTRIBUTED TRANSACTION and BEGIN TRANSACTION
    • 7.3   COMMIT TRANSACTION and COMMIT WORK
    • 7.4   ROLLBACK TRANSACTION and ROLLBACK WORK
    • 7.5   SAVE TRANSACTION

    Module 8: Variables in T-SQL

    • 8.1  SET @local_variable
    • 8.2   SELECT @local_variable
    • 8.3   DECLARE @local_variable