Dec

16 Hours Only SQL Server Training Course in Firenze

by Tech Training Solutions

Actions and Detail Panel

Sales Ended

Event Information

Share this event

Date and Time

Tue, December 22, 2020

4:30 PM – 6:30 PM CET

Add to Calendar

Location

IT Training Center

Tech Training Solutions

Firenze

Italy

View Map View Map

Refund Policy

Contact the organizer to request a refund.

Eventbrite's fee is nonrefundable.

Event description

16 Hours Only SQL Server Training is being delivered from December 22, 2020 - January 14, 2021 US Pacific Time.

About this Event

This event has been UPDATED since it was first published. View the Complete, UPDATED & Detailed SQL Server Training Information here.

16 Hours Only SQL Server Training is being delivered from December 22, 2020 - January 14, 2021 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 Only SQL Server Training Schedule

December 22, 2020 - January 14, 2021 US Pacific time
16 Hours | 2 Hours on Tuesday, 2 Hours on Thursday every week US Pacific time
7:30 AM - 9: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 December 22, 2020 at 7.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 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