Training Course:Relational DatabaseSchool/Trainer:Computer Training Unit, North Carolina State University
Raleigh, North Carolina, United States
Course Format: Classroom | E-learning | Virtual Class | Online | On-site | Blended | Self-paced
Course Description:
'' Relational Database Design teaches the concepts and guidelines used in designing a relational database. You will gain an understanding of the terminology and principles used in this discipline by working through an example scenario and designing a database. You will use a suggested design process. Working with data in a relational database by using queries is also covered. Here are some of the topics covered in the course: identify and define relational databases terminology, determine tables, fields, key fields and table relationships for a database, and examine common table problems by normalizing a database. This course does not assume any experience in relational database design but you will gain the most from the course if you have had some experience in working with a database of any kind. This course prepares you for designing a relational database from scratch, for working with or modifying a relational database designed by someone else, and for creating queries that will produce accurate results from any relational database.
Suggested Prerequisites: Understanding of the Windows Operating System
Attend and You Will Learn
Lesson 1: INTRODUCTION TO RELATIONAL DATABASES
The basics of relational databases
Reasons for needing "proper" design
Relational database terminology
Planning the database
Database design process
Beginning the design Lesson 2: DESIGNING TABLES
Deciding on tables
Naming tables and fields
Identifying primary key fields
Identifying table relationships
Diagramming relationships
Using foreign keys
Creating intersection tables Lesson 3: DATA NORMALIZATION
Eliminating repeating groups
Incorporating functional dependency in
table design
Eliminating transitive dependencies Lesson 4: ADVANCED DATA NORMALIZATION
Eliminating data entry and data
update problems
Eliminating repeated and
null values
Designing for data maintenance
and growth Lesson 5: DATA INTEGRITY
Enforcing referential integrity
Cascading updates and deletes
Enforcing business rules
Using field properties
Table-level integrity
Finalize and document the database design Lesson 6: QUERYING THE DATABASE
Selecting fields and records
AND and OR conditions
Calculations in queries
Types of table joins
Data editing constraints
Additional types of queries
SQL
Optimizing query performance ...''
Please go to the school's official website for training price and schedule:
http://www.ncsu.edu/
http://www.ncsu.edu/ctu/
Phone:919.515.8163
School Address:
Computer Training Unit
NC State University
McKimmon Center
1101 Gorman Street
Raleigh, NC 27606 USA
Jobs & Resumes: Raleigh
Houses & Roommates: Raleigh
Other training courses offered by Computer Training Unit, North Carolina State University:
Word 2007
Excel Programming
Excel Macros
Excel
Access Application Development
Access Boot Camp
Access Basic Programming
Crystal Reports Level I
Crystal Reports Level II
Microsoft Project
Visio
Acrobat
AutoCAD
Illustrator
InDesign
PageMaker
Photoshop
PowerPoint
Publisher
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.
Tips:
You do not need to register before you can use most of our services. You will get a code for each posting ever made on this website. It is the key for you to remove the posting anytime by yourself. |
|
| 
