Relational Database Design A Practical Approach
- Course Categorization:
- Databases
- Course Provider:
- New Horizons Computer Learning Centers
- Learning Method:
- Classroom Learning
Lesson 1: Analyzing Client Requirements
- Analyze Current Data Storage Systems
- Identify New Client Requirements
- Determine the Required Data Fields
- Group Fields into Tables
- Identify Key Fields
Lesson 2: Creating a Preliminary Design
- Create a Preliminary Entity Relationship Diagram
- Apply the First Normal Form
- Apply the Second Normal Form
- Apply the Third Normal Form
- Apply the Higher Normal Forms
- Denormalize Tables
- Incorporate Client Feedback
Lesson 3: Implementing the Database Design
- Translate Business Rules into Constraints
- Create Tables
- Create Indexes
Lesson 4: Generating Reports
- Manipulate Data
- Generate Reports Using Conditions
- Generate Reports from Multiple Tables
- Generate Summary Reports
- Create Views
Lesson 5: Customizing a Database
- Modify Constraints
- Modify Fields
- Modify Tables
- Nashua, NH - May 3, 2012
- Greensboro, NC - May 7, 2012
- Gainesville, FL - June 14, 2012
- Pensacola, FL - June 14, 2012
- Urbandale, IA - June 19, 2012
- Greensboro, NC - June 20, 2012
- Nashua, NH - July 12, 2012
- Urbandale, IA - August 31, 2012
- Nashua, NH - September 5, 2012
- Nashua, NH - November 6, 2012
People Also Registered For
SQL Querying - Level 2 Advanced Querying
In this course, students will work with advanced queries to manipulate and index tables. Students will also create transactions so that you can choose to save or cancel data entry process.
SQL Querying - Level 1 Fundamentals of Querying
In this course, students will compose SQL queries to retrieve desired information from a database.
Related Courses
Relational Database Design A Practical Approach
In this course, students will design and create a relational database.
SQL Querying - Level 1 Fundamentals of Querying
In this course, students will compose SQL queries to retrieve desired information from a database.
SQL Querying - Level 2 Advanced Querying
In this course, students will work with advanced queries to manipulate and index tables. Students will also create transactions so that you can choose to save or cancel data entry process.
10337 Updating Your Microsoft SQL Server 2008 BI Skills to SQL Server 2008 R2
This course focuses on the new features SQL Server 2008 R2 for BI specialists.
50027 Querying and Processing SQL Server Data with SQL Statements
This course concentrates on providing students with the knowledge and skills necessary to exploit the features and functions available in SQL Server.
6158 Updating Your SQL Server® 2005 Skills to SQL Server 2008
This course provides students with the knowledge and skills to upgrade their SQL Server 2005 skills to SQL Server 2008.
2778 Writing Queries Using Microsoft SQL Server 2008 Transact-SQL
This course provides students with the technical skills required to write basic Transact-SQL queries for Microsoft SQL Server 2008.
2793 Implementing and Maintaining Microsoft SQL Server 2005 Reporting Services
This course teaches how to implement a Reporting Services solution in an organization. The course discusses how to use the Reporting Services development tools to create reports, and how to use...
6231 Maintaining a Microsoft SQL Server 2008 R2 Database
This course provides students with the knowledge and skills to maintain a Microsoft SQL Server 2008 R2 database. The course focuses on teaching individuals how to use SQL Server 2008 R2 product...
6232 Implementing a Microsoft SQL Server 2008 R2 Database
This course is intended for Microsoft SQL Server database developers who are responsible for implementing a database on SQL Server 2008 R2. In this course, students learn the skills and best...
