4 WEEKENDS SQL SERVER TRAINING FOR BEGINNERS IS BEING DELIVERED FROM
APRIL 4, 2020 - APRIL 26, 2020 for 16 hours over 4 weekends, 8
sessions, 2 sessions per weekend, 2 hours per session. * All
Published Ticket Prices are in US Dollars * This course will be
taught in English language
4 Weekends SQL Server Training Schedule
* April 4 - April 26, 2020 US Pacific time
* 4 Weekends | Saturday, Sunday US Pacific time every weekend
* 8:30 AM - 10:30 AM US Pacific time each of those days
* Please add your location to find your local date and time for the
1st Session on April 4, 2020 at 8:30 AM US Pacific Time
[https://www.timeanddate.com/worldclock/converter.html?iso=20200404T153000&p1=234]
Features and Benefits
* 4 weekends, 8 sessions, 16 hours of total Instructor led LIVE
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
None
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 Models
*
Entity – 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
*
Introduction
*
Begin 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
*
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
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
culture
art
243
Views
05/04/2020 Last update