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

Course Enquiry