MSSQL Server DBA Course Syllabus
Course Syllabus
Download SyllabusIntroducing SQL Server :
- Overview Of The SQL Server Suite Of Products
- Fundamentals Of The Relational Database Engine
- Benefits Of The Business Intelligence Stack
SQL Server Components And Tools
- SQL Server Agent And Management Studio
- Integration Services
- Analysis Services
- Reporting Services
- Data Quality Services
- Master Data Services
Building The Database
- Constructing A Relational Database
- Choosing Optimal File Size And Growth Parameters
- Working With Database Schemas
Defining Tables
- Specifying Appropriate Datatypes
- Indexing Tables With Management Studio
- Adding, Modifying Or Removing Columns
Safeguarding Data With Constraints:
- Enforcing Uniqueness Through Primary Key Constraints
- Validating Conditions With Check Constraints
- Protecting Relationships With Foreign Keys
Leveraging Server Programmability
- Retrieving Data With Transact-SQL
- Employing Query Designer To Construct Select Statements
- Analyzing Data For Aggregate Functions
- Retrieving Data As An XML Document
Modifying Data With SQL Commands
- Inserting New Rows Into Tables
- Updating Targeted Data
- Deleting Specific Rows
- Developing Programming Constructs
- Creating Stored Procedures For Productivity
- Writing User-Defined Functions To Simplify Queries
- Deploying Triggers To Capture Change Events
Administering SQL Server Databases
- Executing The Maintenance Plan Wizard
- Defragmenting Data And Checking Database Integrity
- Improving Performance By Rebuilding Indexes
Automating Administrative Tasks
- Scheduling Repeating Jobs
- Implementing A Backup Strategy
