Subscribe and Access : 5200+ FREE Videos and 21+ Subjects Like CRT, SoftSkills, JAVA, Hadoop, Microsoft .NET, Testing Tools etc..
Batch
Date: Dec
23rd @12:00Noon
Faculty: Mr. Ahmed Shareef (18+ Yrs of Exp,.. & Real Time Expert)
Duration : 40 Days
Venue
:
DURGA SOFTWARE SOLUTIONS,
Flat No : 202,
2nd Floor,
HUDA Maitrivanam,
Ameerpet, Hyderabad - 500038
Ph.No: +91- 9246212143, 80 96 96 96 96
Syllabus:
SQL SERVER 2016
Basics
- Database
- DBMS
- RDBMS
- Oracle and SQL Server
SQL Server Environment
- Introduction to SQL Server
- Types of Servers
- DB Life Cycle
- Editions, Features, Hierarchy of SQL Server
- SQL Server Management Studio Enhancements
- SQL Server Business Intelligence Development Studio (BIDS) / SSDT
SQL Server Database
- Types of database
- Working with user defined databases
SQL Language
- DDL
- DML (INSERT, UPDATE, DELETE, MERGE)
- TCL
- DDL
- DCL
Joins and Sub Queries
- SQL Operators
- Simple Queries
- Built in Functions
- Joins
- Sub-Queries
- Advanced Queries
Data Integrity
- Domain Integrity
- Entity Integrity
- Referential Integrity
- Normalization & Denormalization
Views
- Create View
- Advantage of Views
- Updatable Views
- Non Updatable Views
- Indexed View
Synonyms, Sequences
Introduction to T-SQL
- Anonymous Block
- Stored Block
Introduction to Anonymous block
- Basic Programming
- Exception Handling
- Cursors
Stored block Stored Procedures
- System Stored Procedure
- User Defined Stored Procedures
- Advantages of Procedures
- Passing In/Out Parameters
- Altering Procedure
- Extended Stored Procedures
User Defined Functions
- Scalar UDF
- Inline UDF
- Multi Statement Table UDF
- Table Variables, Temporary Tables
Triggers
- DML Triggers (After | Instead of )
- DDL Triggers
- Magic Tables
- Advantages of Triggers
Transactions and Locks
- Implicit Transactions
- Explicit Transactions
- TCL Commands
- Lock Types
- Isolation Levels
- Dead Locks
- MS-DTC
Indexes
- Clustered Index
- Non Clustered Index
- Creating Index
- Advantages of Indexes
XML Integration
- FOR XML
- OPEN XML
- XML Data Type
Security
- Windows Authentication
- SQL Server Authentication
- Creating, Dropping Login
- Database Permissions
- Introduction to Roles, Schema
Database Maintenance
- Backup Database
- Restore Database
- Deployment of Database
- Generating T-SQL Scripts and Batches
- System Databases and System Tables
SQL Server Agent
Data Transformation Services
