| |SQL Server Core Administration Skills
| |
ID: SQCore | Course Length: 5 |  |
|
| | |
Module 0: Application Architecture |
| | | - The Application Tiers: 1, 2 and 3-tiered Applications
- Distributed Applications: Technology and Infrastructure
- Web Applications: Technology and Infrastructure.
- SQL Server Features and Services
|
 |
| | |
Module 1: Database Essentials |
| | | - The Relational Database Management System: SQL Server
- Creating Tables
- Schemas
- Implementing Database Integrity
- Domain Integrity
- Entity Integrity: Primary Keys
- Referential Integrity: Foreign Keys
- Retrieving Table and Constraint Information
|
|
| | |
Module 2: Manipulating Data |
| | | - The Basic Select Statement
- Retrieving Aggregate Values
- Modifying Data
- Selecting From Multiple Tables
- Sub-queries
- Implementing Views
|
|
| | |
Module 3: Tsql Programming |
| | | - Declaring and Using Variables
- Triggers
- String Functions
- Using the XML Data Type
- Using Xquery
- Datetime Functions
- SQL Server Null Value Functions
- Implementing Error Handling
- Creating Functions
- Stored Procedures
|
|
| | |
Module 4: Indexes |
| | | - Index Architecture
- Planning Indexes
- Managing Table Data
- Rebuilding Indexes
- Creating Full Text Indexes
|
|
| | |
Module 5: Jobs and Alerts |
| | | - Scheduling and Using Jobs & Tasks
- Using Job Operators
- Creating Jobs and Tasks Using Management Studio
|
|
| | |
Module 6: Server Security |
| | | - Authorization and Authentication
- SQL Server Security
- Creating Logins
- Creating Users
- Assigning Permissions
|
|
| | |
Module 7: Backup and Recovery |
| | | - SQL Server Logging
- Performing Database Backups
- Recovery
|
|
| | |
Module 8: A Complete System Administration Lab for SQL Server |
| | |
|
|