This SQL Server training teaches developers all the Transact-SQL skills they need to create database objects like Tables, Views, Stored procedures & Functions and triggers in SQL Server. Gives idea about writing Queries & Sub-queries, working with Joins, etc. As well as database management skills like backup, restore, etc.
SQL Server
By: Professor
Course Content
SQL Server
- Database
- DBMS
- RDBMS
- Oracle and SQL Server
- 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
- Types of database
- Working with user defined databases
- DDL
- DML (INSERT, UPDATE, DELETE, MERGE)
- TCL
- DDL
- DCL
- SQL Operators
- Simple Queries
- Built in Functions
- Joins
- Sub-Queries
- Advanced Queries
- Domain Integrity
- Entity Integrity
- Referential Integrity
- Create View
- Advantage of Views
- Updatable Views
- Non Updatable Views
- Indexed View
- Synonyms, Sequences
- Anonymous Block
- Stored Block
- Basic Programming
- Exception Handling
- Cursors
- System Stored Procedure
- User Defined Stored Procedures
- Advantages of Procedures
- Passing In/Out Parameters
- Altering Procedure
- Extended Stored Procedures
- Scalar UDF
- Inline UDF
- Multi Statement Table UDF
- Table Variables, Temporary Tables
- DML Triggers (After | Instead of )
- DDL Triggers
- Magic Tables
- Advantages of Triggers
- Implicit Transactions
- Explicit Transactions
- TCL Commands
- Lock Types
- Isolation Levels
- Dead Locks
- MS-DTC
- Clustered Index
- Non Clustered Index
- Creating Index
- Advantages of Indexes
- FOR XML
- OPEN XML
- XML Data Type
- Windows Authentication
- SQL Server Authentication
- Creating, Dropping Login
- Database Permissions
- Introduction to Roles, Schema
- Backup Database
- Restore Database
- Deployment of Database
- Generating T-SQL Scripts and Batches
- System Databases and System Tables
- Jobs
- Schedules
Register
Josh Innovations is a leading software training institute providing Software Training, Project Guidance, IT Consulting and Technology Workshops.