4 Weeks Only SQL Server Training Course in Phoenixville

Mon Jan 25 2021 at 08:30 pm to 10:30 pm

IT Training Center | Phoenixville

Tech Training Solutions
Publisher/HostTech Training Solutions
4 Weeks Only SQL Server Training Course in Phoenixville
Advertisement
4 Weeks Only SQL Server Training is being delivered from January 25, 2021 - February 17, 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.

4 Weeks Only SQL Server Training is being delivered from January 25, 2021 - February 17, 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


4 Weeks Only SQL Server Training Course Schedule
  • January 25, 2021 - February 17, 2021 US Pacific time
  • 4 Weeks | 2 hours on Mondays, 2 hours on Wednesdays every week US Pacific time
  • 5:30 PM - 7:30 PM US Pacific time each of those days
  • Please click here to add your location and check your local date and time for first session to be held on January 25, 2021 at 5:30 PM 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

  • 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

Advertisement

Event Venue & Nearby Stays

IT Training Center, Tech Training Solutions, Phoenixville, United States

Tickets

USD 450.00 to USD 525.00

Sharing is Caring: