Database Fundamentals Self-Study Course

Database Fundamentals Self-Study Course

Oracle University
Logo Oracle University
Provider rating: starstar_borderstar_borderstar_borderstar_border 2 Oracle University has an average rating of 2 (out of 1 reviews)

Need more information? Get more details on the site of the provider.

Starting dates and places

There are no known starting dates for this product.

Description

Database Fundamentals will give the student an overview of Databases and the fundamental concepts of relational database architecture and management
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 a…

Read the complete description

Frequently asked questions

There are no frequently asked questions yet. If you have any more questions or need help, contact our customer service.

Didn't find what you were looking for? See also: Database Management, CompTIA A+ / Network+ / Security+, Oracle, IT Security, and Web Accessibility.

Database Fundamentals will give the student an overview of Databases and the fundamental concepts of relational database architecture and management
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
Relational Databases
  • 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
Database Data Management
  • 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
There are no reviews yet.

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.