Database Fundamentals Self-Study Course
Starting dates and places
Description
Database Fundamentals will give the student an overview of Databases and the fundamental concepts of relational database architecture and managementAudience
Course Topics Introduction to Database Systems
- Differentiate between a database and a Database Management System
- Identify the requirements of a good database
- Examine an example of a database system and the elements comprising the database system
- Describe the evolution of database models
- Describe the structure and evolution of database architectures
- Design a database
- Differentiate between data warehousing and Online Transactional Processing
- Describe the features and characteristics of an Oracle relational database management system a…
Frequently asked questions
There are no frequently asked questions yet. If you have any more questions or need help, contact our customer service.
Audience
Course Topics Introduction to Database Systems
- Differentiate between a database and a Database Management System
- Identify the requirements of a good database
- Examine an example of a database system and the elements comprising the database system
- Describe the evolution of database models
- Describe the structure and evolution of database architectures
- Design a database
- Differentiate between data warehousing and Online Transactional Processing
- Describe the features and characteristics of an Oracle relational database management system and Oracle object relational database management system
- Describe relational database concepts and characteristics
- Describe how to outline a relational database schema
- Describe the concept of relational database integrity
- Manage operations in a relational database
- Formulate algebraic operations in a database
- Describe how to use SQL in a relational database
- Discuss and write basic Select SQL statements
- Describe how to insert, update, and delete data
- Outline database transaction processing and the related problems
- Outline how to resolve concurrency problems in a database
- Describe the types and features of locks and describe how to avoid lock contention
- Describe database security and access issues
- Describe Oracle9i database users, how to authenticate them, and their relationship to schemas
- Describe the system and object privileges in an Oracle9i database
Course Objectives
Share your review
Do you have experience with this course? Submit your review and help other people make the right choice. As a thank you for your effort we will donate $1.- to Stichting Edukans.There are no frequently asked questions yet. If you have any more questions or need help, contact our customer service.