| SQL Server Core Administration Skills |
ID: SQCore | Course Length:5 | Company Name:Choquette Technology Associates Inc.
|
|
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 |
|