| Introduction |
- Overview
- Components
- Architecture
|
| Using Transact-SQL |
- SQL Server programming tools
- Introduction to Transact-SQL
- Transact-SQL syntax elements
- Executing Transact-SQL statements
|
| Designing database |
- Introduction to database design
- Planning SQL Server Database
- Identifying system requirements
- Developing a logical data model
|
| Implementing database and tables |
- Creating and managing database
- Identifying data
- Creating and managing tables
|
| Implementing data integrity |
- Introduction to data
- Implementing Integrity
|
| Managing and manipulating data |
- Importing and exporting data
- Using distributed queries to access external data
- Using cursors to retrieve data
- retrieving XML data
|
| Implementing stored procedures |
- Introduction to stored procedures
- Creating, modifying and deleting stored procedures
- Programming stored procedures
|
| Implementing triggers |
- Introduction to triggers
- Creating and managing triggers
- Programming triggers
|
| Implementing views |
- Introduction to views
- Creating, modifying and deleting views
- Accessing data through views
|
| Designing and administering security |
- Overview of Security
- Designing database security plan
- Database security implementation and administration
|
