UMSL logo

Computer Education & Training Center

Relational Database Design

SQL Server Relational Database Design

Our relational database design course will get you started on the design process so that you can maximize the speed and efficiency of your database. Learn the planning strategies that will optimize your database and ensure consistency.

Although SQL Server is used for this course, the principles taught apply to other database systems, including Oracle and Access. Students using other relational database applications could take this course to learn about basic design and implementation.

Introduction to Relational Database Design using SQL Server

(Prerequisite: Introduction to SQL or equivalent experience.) If you are creating a new relational database or want to improve the speed and efficiency of an existing one, this course will guide you through the planning strategies you need to optimize your database. Learn the terminology and basic features of a relational database. Discover important design objectives that ensure consistency, eliminate redundancy, maximize speed, and enforce data integrity and security. Explore the three-schema architecture essential to good design, as well as the design stages in the database life cycle, including conception and planning, translating design into the database structure, and tweaking the database to improve performance. Other topics include choosing the appropriate data types and documenting the database for yourself and coworkers. [Course Outline]
Fee: $399

Two-Day Class Meets 8:30am-4:00pm (13 hours)
Code Dates Location Instructor
E8124 Thurs., Oct. 12 & Fri., Oct. 13West CountyFrank Richey

If you would like to register for a course, call (314) 984-9000 or register online.

Classes are also available in the SQL Language that cover SQL syntax and beginning through advanced commands and queries.

You may also be interested in other SQL Server classes including SQL Server Reporting Services, SQL Server Integration Services, SQL Server Administration, and SQL Programming (Transact-SQL).