Database Management
Training
Provided by Online Training Directory
This course features coverage of the important aspects of the relational PC-based database model including coverage of SQL. A highly useful methodology for designing databases is presented and illustrated through a variety of examples. This course is designed for anyone interested in gaining familiarity with database management.
Someone taking this course should have some experience using a computer in a windows environment. No programming experience is required However some experience using Microsoft Access is recomended. There are two database case examples that are used throughout the course to illustrate database design concepts.
You will need to purchase a book. Information about the book will be given upon contacting the instructor.
The course is 10 weeks and is self-paced. An instructor is available to answer questions about your database projects.
This course provides you with hands-on experience using Microsoft Access 2002. There are several database projects that stimulate hands-on learning and research. All course work and time frames for completion will need to be met according to the guidelines stated for this course. The following computer system requirements are recommended. Windows XP, CD-ROM drive, 50 MB of free hard-disk space, Microsoft Access 2002, and Internet access. The book uses Microsoft Access 2002 to illustrate its examples.
You may be able to use Microsoft Access 2000 for this course.
|
|
||||||||||
Database Management
Outcomes
The student will learn the process of database design and about the functions that a PC-based database management system can provide. Upon completion of this course the student should be able to produce database designs for future database applications.
Assessment
You will send some of your PC-database projects to your instructor for review. There will be some short written assignments to complete. You are expected to complete the database projects and written assignments on time.
Week 1
Week 2
Week 3
Week 4
Week 5
Week 6
Week 7
Week 8
Week 9
Week 10
Look at introduction to the field of database management. Examine two case studies that will be used for many of the database examples in this course. Study the basic terminology and concepts of databases and database management systems.
Learn about data definition and manipulation aspects of the database relational model. Apply a method to retrieve data from databases called Query-By-Example (QBE). Describe the shorthand representation of the structure of a relational database and illustrate this technique by representing the database for a case study.
Learn about the Structured Query Language (SQL) language. Use SQL to define table data and manipulate it. Use computed fields in SQL and learn how to sort data and use built-in functions and nested queries.
Learn about the relational database model. Use indexes to improve database performance. Learn integrity rules and examine ways to change the structure of a database. Use the system catalog found in many relational DBM?s to provide database users with information about the structure of a database.
Examine Database design and the database normalization process. Learn about the normalization process which enables you to identify the existence of potential database problems and the processes for making corrections.
Apply the process of determining tables (relations) and columns (attributes) that will make up the database. Learn about entity-relationship diagrams and their role in database design. Explore special issues related to database design, including survey forms and their use in database design and how to obtain important information from exiting documents.
Examine the functions that a Database Management System performs in managing a database. These functions include; update and retrieve data, provide catalog services, recover data, provide security services, provide data integrity features, support data independence, support data replications, and provide utility services.
Learn about the responsibilities of a database administrator (DBA) in managing a database. Focus on the role of DBA in a PC environment and about formulating and enforcing important polices with respect to the database.
Examine several database management topics, most of which are applicable to relational systems. Topics include the centralized approach to processing data, distributed approach to processing data, object-oriented systems which treat data as objects and include the actions that operate on these objects, and the impact of the Web on database access.
Finish database projects and database case studies.
Contact Hours: 40
The student will learn the process of database design and about the functions that a PC-based database management system can provide. Upon completion of this course the student should be able to produce database designs for future database applications.
Assessment
You will send some of your PC-database projects to your instructor for review. There will be some short written assignments to complete. You are expected to complete the database projects and written assignments on time.
Week 1
Week 2
Week 3
Week 4
Week 5
Week 6
Week 7
Week 8
Week 9
Week 10
Look at introduction to the field of database management. Examine two case studies that will be used for many of the database examples in this course. Study the basic terminology and concepts of databases and database management systems.
Learn about data definition and manipulation aspects of the database relational model. Apply a method to retrieve data from databases called Query-By-Example (QBE). Describe the shorthand representation of the structure of a relational database and illustrate this technique by representing the database for a case study.
Learn about the Structured Query Language (SQL) language. Use SQL to define table data and manipulate it. Use computed fields in SQL and learn how to sort data and use built-in functions and nested queries.
Learn about the relational database model. Use indexes to improve database performance. Learn integrity rules and examine ways to change the structure of a database. Use the system catalog found in many relational DBM?s to provide database users with information about the structure of a database.
Examine Database design and the database normalization process. Learn about the normalization process which enables you to identify the existence of potential database problems and the processes for making corrections.
Apply the process of determining tables (relations) and columns (attributes) that will make up the database. Learn about entity-relationship diagrams and their role in database design. Explore special issues related to database design, including survey forms and their use in database design and how to obtain important information from exiting documents.
Examine the functions that a Database Management System performs in managing a database. These functions include; update and retrieve data, provide catalog services, recover data, provide security services, provide data integrity features, support data independence, support data replications, and provide utility services.
Learn about the responsibilities of a database administrator (DBA) in managing a database. Focus on the role of DBA in a PC environment and about formulating and enforcing important polices with respect to the database.
Examine several database management topics, most of which are applicable to relational systems. Topics include the centralized approach to processing data, distributed approach to processing data, object-oriented systems which treat data as objects and include the actions that operate on these objects, and the impact of the Web on database access.
Finish database projects and database case studies.
Contact Hours: 40
About The Training Provider: Online Training Directory
Online Training Directory - Workforce and Continuing Ed online courses are offered at basic, intermediate and advanced levels. Going beyond basic training provides a deeper and more educationally rewarding learning experience, especially for students who wish to advance careers or initiate new ones. For the general lifelong learner we continue to offer "fun to learn" single, stand-alone courses.
We look forward to...
