|
Provided by: Online Training Directory Database Management |
 |
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.
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.
|
|
||||||||
Training
Provided by Online Training Directory
- K asked: What is the cost of this course? Is this course an accredited course?
- M asked: How long is the course, and what is the cost of the course? Do you get a certification?
- K asked: what is tuple relational calculus
- G asked: Please forward me information that I can send to my company to request this training course. Please tell me what you receive upon successfull completion? thank you,
- P asked: database management related to SQL server
- A asked: i am due to start work soon and my job description will involve database management which aim not very familia with please assist.
- A asked: No question for now
- M asked: - Can you offer a comparison between the material covered in these courses - Database Management vs. Database Design Concepts? - Are these Instructor Lead courses? - Do they offer CEU Credit? - Are there any additional Text & Materials required for taking the course and how much do they cost?
- T asked: can you please give me more information about the training you offer?
- R asked: I would like to know if I can gettraining in data base managment online
- L asked: How much is the course and what is the time committment required.
- S asked: what I am suppose to do exactly..???
- asked: Detailed syllabus please
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
About The Training Provider: Online Training Directory
Online Training Directory - JER Online (JER Group, Inc.) lists over 1000 , cost affordable, non-credit Courses and Certificates in its own proprietary online catalog. We are always adding "more courses...all the time " to a growing inventory.
The courses and certificates that comprise JER Online s course catalog are developed by (1) JER Online, (2) a growing number of accredited .edu partners and by (3) corporate...
