Oracle Database Concepts & Design Fundamental

Oracle Database Concepts & Design Fundamentals

 (Customized Workshop)

Duration: 10 Hours

Objectives:

• Describe the components of a database system               

• Describe types of database models
• Compare the differences between the different types of databases      

• Describe the characteristics of a relational database       
• Explain the importance of relational databases in business          
• List the major transformations in database technology  

• Define the terminology used for database storage  

Topics:

The Language of Database and Data Modeling

• Defining a Table in a Database
• Describe the structure of a single table
• Using Conceptual Data Modeling
• Describe a conceptual data model
• Explain the components of a conceptual/logical model
• Defining Instance and Schema in Relational Databases
• Examine examples of an entity and a corresponding table
• Examine examples of an attribute and a corresponding column
• Explain instances and schemas in a relational database
• Using Unique Identifiers, Primary and Foreign Keys

Data Modeling:

• Creating Physical Data Models
• Compare conceptual and  physical data models
• Describe an example of an entity

• Describe attributes for a given entity
• Distinguish between mandatory and optional attributes
• Using Unique Identifiers (UIDs)

Identifying Relationships

• Explain  one-to-one,  one-to-many, and many-to-many relationships
• Identify the optionality necessary for a relationship
• Identify the cardinality necessary for a relationship

Overview to SQL

• Using Structured Query Language (SQL)
• Explain the relationship between a database and SQL
• Using Data Definition Language (DDL)
• Describe the purpose of DDL
• Use DDL to manage tables and their relationships
• Describe the purpose of  DML
• Use DML to manage data in tables
• Use TCL to manage transactions
• Defining and using Basic Select statements
• Identify the connection between an ERD and a Relational Database using SQL SELECT statements
• Build a SELECT statement to retrieve data from an Oracle Database table
• Use the WHERE clause to the SELECT statement to filter query results
• Use the ORDER BY clause to sort SQL query results