SQL Server Online Training
0 STUDENTS ENROLLED
Introduction
SQL Server Training makes you proficient in SQL Server and T-SQL and enhance all features and capabilities of SQL Server and T-SQL. It helps manage and store information in an efficient manner.
Course Content
1.SQL Server Introduction & Installation
- SQL Server 2012 Installation
- Service Accounts & Use, Authentication Modes & Usage, Instance Configurations
- SQL Server Features & Purpose
- Using Management Studio (SSMS)
- Configuration Tools & SQLCMD
- Conventions & Collation
2.SQL Server 2012 Database Design
- SQL Database Architecture
- Database Creation using GUI
- Database Creation using T-SQL scripts
- DB Design using Files and File Groups
- File locations and Size parameters
- Log files and placement
- Database Structure modifications
3.SQL Server Tables & Data
- SQL Server Database Tables
- Table creation using T-SQL Scripts
- Naming Conventions for Columns
- Single Row and Multi-Row Inserts
- Table Aliases
- Column Aliases & Usage
- Table creation using Schemas
- Basic INSERT
- UPDATE
- DELETE
- SELECT queries and Schemas
- Use of WHERE, IN and BETWEEN
- Variants of SELECT statement
- ORDER BY
- GROUPING
- HAVING
- ROWCOUNT and CUBE Functions
4.Data Validations and Constraints Need for Data Integrity
- Table creation using Constraints
- NULL and IDENTITY properties
- UNIQUE KEY Constraint and NOT NULL
- PRIMARY KEY Constraint & Usage
- CHECK and DEFAULT Constraints
- Naming Composite Primary Keys
- Disabling Constraints & Other Options
5.Views and Row Data Security
- Benefits of Views in SQL Database
- Views on Tables and Views
- SCHEMA BINDING and ENCRYPTION
- Issues with Views and ALTER TABLE
- Common System Views and Metadata
- Common Dynamic Management views
- Working with JOINS inside views
6.Indexes and Query Tuning
- Need for Indexes & Usage?
- Indexing Table & View Columns
- Index SCAN and SEEK
- INCLUDED Indexes & Usage
- Materializing Views (storage level)
- Composite Indexed Columns & Keys
- Indexes and Table Constraints
- Primary Keys & Non Clustered Indexes
7.Stored Procedures and Benefits
- Why to use Stored Procedures?
- Types of Stored Procedures
- Use of Variables and parameters
- SCHEMABINDING and ENCRYPTION
- INPUT and OUTPUT parameters
- System level Stored Procedures
- Dynamic SQL and parameterization
8.User Defined Functions and Usage
- Scalar Valued Functions
- Types of Table Valued Functions
- SCHEMABINDING and ENCRYPTION
- System Functions and usage
- Date Functions
- Time Functions
- String and Operational Functions
- ROW_COUNT
- GROUPING Functions
9.Triggers and Cursors – Memory Limitations
- Why to use Triggers?
- DML Triggers and Performance impact
- INSERTED and DELETED memory tables
- Data Audit operations & Sampling
- Database Triggers and Server Triggers
- Bulk Operations with Triggers
10.Cursors – Memory Limitations
- Cursor declaration and Life cycle
- STATIC
- DYNAMIC
- SCROLL Cursors
- FORWARD_ONLY and LOCAL Cursors
- KEYSET Cursors with Complex SPs
11.Transaction Types and Real-world Scenario
- ACID Properties and Scope
- EXPLICIT Transaction types
- IMPLICIT Transactions and options
- AUTOCOMMIT Transaction and usage
- SAVEPOINT and Query Blocking
- Complex SPs with Transactions
- Linked Server and DTC operationsSQL Server Introduction & Installation
- SQL Server 2012 Installation
- Service Accounts & Use, Authentication Modes & Usage, Instance Configurations
- SQL Server Features & Purpose
- Using Management Studio (SSMS)
- Configuration Tools & SQLCMD
- Conventions & Collation
Course Reviews
No Reviews found for this course.
Microsoft Technologies, Other Courses, Popular
SQL Server Online Training
Duration: 30 Hours
0( 0 REVIEWS )
0 STUDENTS
Write a Review