|
This course introduces users to SQL Server and how to use it to create, manage, and access database information.
Objectives:
After completing this course, students will be able to:
- Explain the basic features of SQL Server
- Describe the major functions of SQL and T-SQL
- Describe the security features and roles of SQL Server
- Perform database queries with isql
- Manage database tables
- Update and maintain databases
Topics:
- SQL Server Overview
- SQL Server Functions
- SQL Server Features
- T-SQL and Database Integrity
- Triggers, Partitions, and Security
- Using isql and Performing Queries
- Viewing, Managing, and Creating Tables
- Maintaining Databases
|