
About this Training
Syllabus
About this Course
This training lets you get familiar with table creation and design, managing indexes, and retrieving details about the database execution plans. This course also focuses on the creation of views, and TSQL programming units such as Stored Procedures, Functions, and Triggers. Other common aspects of database development, such as concurrency and XML management are also covered in this course.
In this course, each module is reinforced with structured hands-on exercises.
Audience Profile
This course is mainly intended for Database Administrators, Database Developers, Business Intelligence professionals, QA professionals, Data Analysts, and other roles responsible for developing SQL Server Databases.
- Data Types
- Working with Schemas
- Creating and Altering Tables
- Partitioning Data
- Compressing Data
- Understanding the role of Constraints in RDBMS
- Implementing Primary Key, NOT NULL, Unique, Check and Foreign Key
- Core Indexing Concepts
- Managing Indexes
- Working with Execution Plans
- Introduction to Views
- Creating and Managing Views
- Performance Considerations
- Introduction to Stored Procedures
- Working With Stored Procedures
- Implementing Parameterized Stored Procedures
- Overview of Functions
- Designing and Implementing Scalar Functions
- Designing and Implementing Table-Valued Functions
- Implementation Considerations for Functions
- Alternatives to Functions
- Designing DML triggers
- Designing DML triggers