Oracle

Database Design Foundation

(1Z0-006) / ISBN : 978-1-64459-059-1
Lessons
Lab
TestPrep
Get A Free Trial

Skills You’ll Get

Download Course Outline

1

Introduction to Databases

  • Introduction to Databases
  • What Is a Database?
  • File-Based Databases
  • The Evolution of Databases
  • Relational Databases and Database Management Systems (DBMSs)
  • Origins of Relational Databases
  • Lesson Summary
2

Relational Database Fundamentals

  • Introduction to Relational Databases
  • Multitier Database Architecture
  • Relational Model Terminology
  • Using Tables to Represent Data
  • Characteristics of Relations
  • Data Models
  • Entities and Data Relationships
  • Relational Integrity
  • Database Languages
  • Data Dictionaries
  • Lesson Summary
3

Database Planning

  • Introduction to Database Planning
  • Database Design Life Cycle
  • Database Requirements Document
  • Selecting a DBMS
  • Selecting an Application Interface
  • Lesson Summary
4

Overview of Database Design Methodology

  • Introduction to Database Design Methodology
  • Effects of Poor Database Design Practices
  • Database Design Phases
  • Conceptual Database Design
  • Entity-Relationship (ER) Models
  • Lesson Summary
5

Normalization

  • Introduction to Normalization
  • What Is Normalization?
  • Normal Forms
  • First Normal Form
  • Second Normal Form
  • Third Normal Form
  • Boyce-Codd Normal Form (BCNF)
  • Lesson Summary
6

Logical Database Design

  • Introduction to Logical Database Design
  • Logical Database Design
  • Creating a Logical Data Model
  • Using a Database Definition Language
  • Validating the Logical Data Model
  • Defining Integrity Constraints
  • Creating an Enterprise Data Model
  • Lesson Summary
7

Physical Database Design

  • Introduction to Physical Database Design
  • Physical Database Design
  • Connect to the SQL Database
  • Creating Enterprise Constraints
  • Using Secondary Indexes
  • Denormalization
  • Creating User Views
  • Designing Database Access Rules
  • Lesson Summary
8

Structured Query Language

  • Introduction to Structured Query Language
  • SQL Basics
  • Data Definition Language
  • Data Manipulation Language
  • Retrieving Data from Relations
  • Data Control Language
  • Lesson Summary
9

Relational Algebra

  • Introduction to Relational Algebra
  • Defining Relational Algebra
  • Selection
  • Projection
  • Cartesian Product
  • Union
  • Difference
  • Intersection
  • Joins
  • Lesson Summary
10

Transactions and Database Security

  • Introduction to Database Transactions and Security
  • Transactions
  • Concurrency Control
  • Database Security
  • Lesson Summary
A

Appendix A: Installation of Oracle Database

  • Installing Oracle Database
B

Appendix B: Guide to Use Oracle Database

  • Connecting to Oracle Database
  • Adding an Entry to the tnsnames.ora File

1

Introduction to Databases

  • Understanding DBMS
2

Relational Database Fundamentals

  • Identifying database keys
  • Understanding types of relationships
3

Database Planning

  • Identifying database design lifecycle phases
  • Understanding white box and black box testing
  • Understanding DBMS selection criteria
4

Overview of Database Design Methodology

  • Understanding anomalies
5

Normalization

  • Normalizing the unnormalized model to 1st normal form II
  • Normalizing the 1st normal form to 2nd normal form
  • Normalizing the 2nd normal form to 3rd normal form
  • Normalizing the 3rd normal form to BCNF
6

Physical Database Design

  • Creating a table
  • Deleting check constraints
  • Understanding SQL constraints
  • Creating index
  • Creating views
  • Understanding database privileges
7

Structured Query Language

  • Deleting rows from a table
  • Altering tables
  • Setting default values while creating tables
  • Dropping default values
  • Counting rows of a table
  • Using MIN and AVG keyword
  • Retrieving values of a table using nested queries
  • Using the GROUP BY and HAVING clauses
  • Counting the number of departments from the table
  • Inserting values into a table
  • Inserting values into a table from an existing table
  • Updating values of a table
  •  Using the LIKE operator I
  • Using the LIKE operator II
  • Using the AND operator
  • Using the SELECT operator
  • Using the DISTINCT and WHERE clauses
  • Creating ALIASES and using the ORDER BY clause
  • Using the BETWEEN operator
  • Identifying database keywords
8

Relational Algebra

  • Understanding relational set operator
  • Using cartesian product
  • Using the UNION operator
  • Understanding relational algebraic operations
  • Identifying database operation
  • Using the equi join operator
  • Using LEFT JOIN
  • Understanding joins
  • Identifying types of joins
9

Transactions and Database Security

  • Understanding ACID properties
  • Identifying terms related to database security

Related Courses

All Courses