|
This course provides an overview of data modeling with an emphasis on relational database systems, and shows users how to implement a logical design by creating a database in SQL Server 2000.
Objectives:
After completing this course, students will be able to:
- Gather database requirements
- Build a logical data model
- Create and alter databases, files, and filegroups
- View and change database properties and options
Topics:
- Data modeling
- Logical design
- Components of the logical model
- Entity relationships
- Normalization
- Data integrity and constraints
- Physical design considerations
- The SQL Server 2000 software
- System files and tables
- Database files and filegroups
- Creating a database
- Altering a database
- Other database modifications
- Useful functions and stored procedures
|
