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

Any questions?
Check out the FAQs

Still have unanswered questions and need to get in touch?

Contact Us Now

Related Courses

All Courses
We use cookies for improving site experience and analytics. Learn More