.jpg){kind=logo}
1Z0-006 ISBN: 978-1-64459-059-1
Database Design Foundation
Self-paced · 1 year access
48 Hands-On LiveLabs
Practice real IT tasks in guided environments.
- Real environments
- Auto-graded
- No installation
01 / Lessons & labs
See exactly what you will learn and practice
Lessons
12 Interactive Lessons · 80 topics01 Introduction to Databases 7 topics · 1 LiveLab +
- 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
1 LiveLab in this lesson — see the labs panel →
02 Relational Database Fundamentals 11 topics · 2 LiveLab +
- 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
2 LiveLab in this lesson — see the labs panel →
03 Database Planning 6 topics · 3 LiveLab +
- Introduction to Database Planning
- Database Design Life Cycle
- Database Requirements Document
- Selecting a DBMS
- Selecting an Application Interface
- Lesson Summary
3 LiveLab in this lesson — see the labs panel →
04 Overview of Database Design Methodology 6 topics · 1 LiveLab +
- Introduction to Database Design Methodology
- Effects of Poor Database Design Practices
- Database Design Phases
- Conceptual Database Design
- Entity-Relationship (ER) Models
- Lesson Summary
1 LiveLab in this lesson — see the labs panel →
05 Normalization 8 topics · 4 LiveLab +
- Introduction to Normalization
- What Is Normalization?
- Normal Forms
- First Normal Form
- Second Normal Form
- Third Normal Form
- Boyce-Codd Normal Form (BCNF)
- Lesson Summary
4 LiveLab in this lesson — see the labs panel →
06 Logical Database Design 8 topics +
- 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
07 Physical Database Design 9 topics · 6 LiveLab +
- 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
6 LiveLab in this lesson — see the labs panel →
08 Structured Query Language 7 topics · 20 LiveLab +
- Introduction to Structured Query Language
- SQL Basics
- Data Definition Language
- Data Manipulation Language
- Retrieving Data from Relations
- Data Control Language
- Lesson Summary
20 LiveLab in this lesson — see the labs panel →
09 Relational Algebra 10 topics · 9 LiveLab +
- Introduction to Relational Algebra
- Defining Relational Algebra
- Selection
- Projection
- Cartesian Product
- Union
- Difference
- Intersection
- Joins
- Lesson Summary
9 LiveLab in this lesson — see the labs panel →
10 Transactions and Database Security 5 topics · 2 LiveLab +
- Introduction to Database Transactions and Security
- Transactions
- Concurrency Control
- Database Security
- Lesson Summary
2 LiveLab in this lesson — see the labs panel →
11 Appendix A: Installation of Oracle Database 1 topics +
- Installing Oracle Database
12 Appendix B: Guide to Use Oracle Database 2 topics +
- Connecting to Oracle Database
- Adding an Entry to the tnsnames.ora File
Hands-On Labs Our edge
48 LiveLabs- Understanding DBMS
- Identifying database keys
- Understanding types of relationships
- Identifying database design lifecycle phases
- Understanding white box and black box testing
- Understanding DBMS selection criteria
- Understanding anomalies
- 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
- Creating a table
- Deleting check constraints
- Understanding SQL constraints
- Creating index
- Creating views
- Understanding database privileges
- 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
- 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
- Understanding ACID properties
- Identifying terms related to database security
Labs run in your browser — nothing to install.
02 / FAQs
Questions before you start
![1Z0-071.AO1: [ORACLE PRESS] Oracle Database SQL_Image](http://d3hu3i8dxloald.cloudfront.net/images/new/MHE-1Z0-071_pro.png?202608009V)
Prepare for Database Design Foundation
One-time payment. Full access for 1 year. Start with a free trial if you want to look around first.
- 1 year of full access
- 48 LiveLab included
- Certificate of completion
No credit card required