16 Hours Virtual LIVE Online SQL Training Course

16 Hours SQL Training course for Beginners is Instructor-led and guided and is being delivered March 15, 2022 - April 7, 2022 US Pacific Time for 16 hours over 4 week, 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 Training Course Schedule

·      March 15, 2022 - April 7, 2022 US Pacific time

·      16 Hours | 2 Hours on Tuesdays , 2 Hours on Thursdays every week US Pacific time

·      8:30 AM - 10:30 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 March15, 2022 at 8:30 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 Outline

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 Function Creating, Altering and Dropping

·      Types Of User Defined Functions

·      Scalar Functions

·      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 Exception Handling

·      Adding and removing User Defined Error Messages to And from SQL Error Messages List

·      Exceptions Manual

·      Table Valued Functions Inline Table Valued Functions

·      Multi Statement Table Valued Functions Permissions on User Defined Functions

·      Triggers Stored 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

Fee : $399

Registration: 16 Hours SQL Training course for Beginners