Relational Database

Computer Training Center - South Bend
South Bend, Indiana, United States

Course Format: Classroom | E-learning | Virtual Class | Online | On-site | Blended | Self-paced

Course Description:

'' Individuals who already use relational databases, and have a need to design or modify the design of tables to be used in a relational database management system. They know the basics of how to use a relational database, but do not know how to design a database.

Overview: For many new or intermediate database developers, it’s difficult to know where to start when designing a relational database. It’s easy to make the mistake of assuming that the functionality of a database will take shape over time, or the design will fall into place as you build the database. This course covers the steps to effectively plan and design functional, efficient databases.

Topics covered include:
Gathering Information to Plan a Relational Database
Determining Database Purpose
Creating a Preliminary Field List
Determining Fields
Grouping Fields into Tables
Identifying Relationships
Designating Primary Key Fields
Identifying Table Relationships
Normalizing Data
Normalizing to the First Normal Form
Normalizing to the Second Normal Form
Normalizing to the Third Normal Form
Normalizing to the Higher Normal Forms
Ensuring Data Integrity
Ensuring Consistent Data
Preventing Field Data Errors
Determining Queries
Determining Select Queries
Determining Calculations
Determining Action Queries
Improving Query Performance
Testing Queries

Prerequisites: Before taking this course, the student should have a basic understanding of the computer’s operating system. The student should have some familiarity with data tables and basic knowledge of how to create queries in Microsoft Access.
...''

Phone:574.287.1053

School Address:

St. Joseph: 2364 S. Cleveland Ave | St Joseph, MI 49085 | 269.983.3903

South Bend: 2750 Foundation Drive| South Bend, IN 46628 | 574.287.1053


Jobs & Resumes: South Bend
Houses & Roommates: South Bend

Acrobat 7.0
InDesign CS - Level I
InDesign CS - Level II
PageMaker 7.0
Microsoft Publisher 2003
QuarkXPress 6
Lotus Approach ME 9.5
Lotus Notes 6.0 - Database Features
Access 2007
Oracle 10g - Introduction
SQL Fundamentals
Oracle 9i
Oracle 8i - SQL, PL/SQL, and SQL*Plus
Illustrator CS
PageMill 3.0
Photoshop CS
CorelDRAW
ColdFusion MX
HTML

Notice: The course description on this page was captured from the Internet as historical reference or submitted by visitors. It was archived statically and not updated from day to day.
 

Facts: This website holds more than 300,000 training course records worldwide, with hundreds of new postings daily. All services in this website are free!