# Define and describe data Madeline
# Identify and describe the components of the E-R model
# Identify the relationships that can be formed between entities
# Explain E-R diagrams and their use
# Describe symbols used in an E-R diagram
# Define normalization
# Describe the various normal forms
# Outline the various relational operators used in relational data models

# Exploring the Oracle Database Architecture
# Explain the Memory Structures
# Describe the Process Structures
# Overview of Storage Structures

# List the capabilities of SQL SELECT statement
# Execute a basic SELECT statement

# Limit the rows that are retrieved by a query
# Sort the rows that are retrieved by a query
# Use ampersand substitution to restrict and sort output at runtime

# Describe various types of functions available in SQL
# Use character, number, and date functions in SELECT statements

# Describe various types of conversion functions that are available in SQL
# Use the TO_CHAR, TO_NUMBER, and TO_DATE conversion functions
# Apply conditional expressions in a SELECT statement

# Identify the available group functions
# Describe the use of group functions
# Group data by using the GROUP BY clause
# Include or exclude grouped rows by using the HAVING clause

# Write SELECT statements to access data from more than one table using equijoins and nonequijoinsJoin # a table to itself by using a self-join
# View data that generally does not meet a join condition by using outer joins
# Generate a Cartesian product of all rows from two or more tables

# Define subqueries
# Describe the types of problems that the subqueries can solve
# List the types of subqueries
# Write single-row and multiple-row subqueries

# Describe set operators
# Use a set operator to combine multiple queries into a single query
# Control the order of rows returned

# Describe each data manipulation language (DML) statement
# Insert rows into a table
# Update rows in a table
# Delete rows from a table
# Control transactions

# Categorize the main database objects
# Review the table structure
# List the data types that are available for columns
# Create a simple table
# Explain how constraints are created at the time of table creation
# Describe how schema objects work

# Create simple and complex views
# Retrieve data from views
# Create, maintain, and use sequences
# Create and maintain indexes
# Create private and public synonyms

# Identify the available analytical functions
# Describe the use of analytical functions
# Query based on analytical functions