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 SharePoint 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
Event Venue & Nearby Stays
IT Training Center, Tech Training Solutions, Berkeley, United States
USD 450.00 to USD 525.00