*Due to the Coronavirus, as a precautionary measure, we are going to hold this event as a virtual technology event.

16 Hours SQL Server Training is being delivered from May 26, 2020 - June 18, 2020 for 16 hours over 4 weeks, 8 sessions, 2 sessions per week, 2 hours per session.

• All Published Ticket Prices are in US Dollars
• The course will be taught in English language

16 Hours SQL Server Training Schedule

• May 26, 2020 - June 18, 2020 US Pacific time
• 16 Hours | 2 Hours on Tuesdays, 2 Hours on Thursdays every week US Pacific time,
• 9:00 AM - 11:00 AM US Pacific time each of those days
• Please click here to add your city name and check your local date and time for the first session to be held on May 26, 2020 at 9:00 AM US Pacific Time.

Features and Benefits

• 16 Hours, 8 sessions, 4 weeks of total Instructor-led and guided training
• Training material, instructor handouts and access to useful resources on the cloud provided
• Practical Hands-on Lab exercises provided
• Actual code and scripts provided
• Real-life Scenarios

Prerequisites

Anyone who is interested in learning SQL and SQL Server.

Course Objectives

• To learn basic Database Concepts.
• To design a database using E-R Modelling.
• To learn the concept of Normalization.
• To understand different components of SQL Server and to learn how to use Management Studio.
• To learn different SQL Statements like DDL, DML, DQL, DCL, and TCL.
• To create Databases, tables, and views.
• To perform Insert, Update, Delete on database tables.
• To gain a complete understanding of writing the simple and complex queries using simple select statements, aggregate functions, and different types of join.
• To develop an ability to write scripts using T-SQL
• To gain a complete understanding of developing Stored Procedures, User Defined Functions, triggers, Index, and Cursor.

Course Curriculum

1. Introduction to DBMS

• File Management System And Its Drawbacks
• Database Management System (DBMS) and Data Models
• Physical Data Models
• Logical Data Models
• Hierarchical Data Model (HDBMS)Network Data Model (NDBMS)Relational Data Model (RDBMS)Object Data Model (ODBMS)Object Relational Data Model (ORDBMS)Conceptual Data ModelsEntity – Relationship (E-R) Model

2. Introduction to SQL Server

• Advantages and Drawbacks Of SQL Server Compared To Oracle And DB2
• 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

3. TSQL (Transact-Structured Query Language)

1) 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

2) 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

3) Data Query Language (DQL)

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

4) 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)

5) Top n Clause

6) Set Operators

• Union
• Intersect
• Except

7) Joins

• Inner Join
• Equi Join
• Natural Join
• Non-Equi Join
• Self Join
• Outer Join
• Left Outer Join
• Right Outer Join
• Full Outer Join
• Cross Join

8) 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

9) Indexes

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

10) Security

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

11) Views

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

12) Transaction Management

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

13) T-SQL 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

14) Cursors

• Working With Cursors
• Types Of Cursors
• Forward_Only and Scroll Cursors
• Static, Dynamic and Keyset Cursors
• Local and Global Cursors

15) Stored Sub Programs

• Advantages Of Stored Sub Programs compared to Independent SQL Statements
• Creating , Altering and Dropping
• Optional Parameters
• Input and Output Parameters
• Permissions on Stored Procedures
• User Defined FunctionCreating, Altering and Dropping
• Types Of User Defined Functions
• Scalar Functions
• Purpose of TriggersDifferences Between Stored Procedures and User Defined Functions and Triggers
• Creating, Altering and Dropping TriggersMagic Tables
• Instead Of TriggersException HandlingException Handling
• Adding and removing User Defined Error Messages To And From SQL Error Messages List
• Exceptions Manual
• Table Valued FunctionsInline Table Valued Functions
• Multi Statement Table Valued FunctionsPermissions On User Defined Functions
• TriggersStored Procedures

16) CLR Integration

• What is CLR Integration and The Steps For Implementing It
• A Simple Example With CLR Integration

17) Working With XML Data Type

18) Backup and Restore Of Database

19) Attach and Detach of Database

20) Normalization