Oracle SQL

RDBMS Concepts9 (Day1, Day2, Day3 and Day4)

Explain the concept of data and database

Describe the approaches to data management

Define a database management system and list its benefits

Explain the different database models

Define and explain RDBMS

Describe entities and tables and list the characteristics of tables

List the differences between a DBMS and RDBMS

Entity-Relationship(E-R) Model and Normalization (Day5, Day6, Day7 and Day8)

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

Introduction to Oracle (Day9, Day10, Day11, Day12 and Day13)

Exploring the Oracle Database Architecture

Explain the Memory Structures

Describe the Process Structures

Overview of Storage Structures

Retrieving Data Using the SQL SELECT Statement (Day14, Day15)

List the capabilities of SQL SELECT statement

Execute a basic SELECT statement

Restricting and Sorting Data (Day16, Day17 and Day18)

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

Using Single-Row Functions to Customize Output (Day19, Day20, Day21)

Describe various types of functions available in SQL

Use character, number, and date functions in SELECT statements

Using Conversion Functions and Conditional Expressions (Day22, Day23)

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

Reporting Aggregated Data Using the Group Functions (Day24, Day25 and Day26)

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

Displaying Data from Multiple Tables (Day27, Day28, and Day29)

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

Using Subqueries to Solve Queries (Day30, Day31, Day32)

Define subqueries

Describe the types of problems that the subqueries can solve

List the types of subqueries

Write single-row and multiple-row subqueries

Using the Set Operators (Day33, Day34, Day35)

Describe set operators

Use a set operator to combine multiple queries into a single query

Control the order of rows returned

Manipulating Data (Day36, Day37 and Day38)

Describe each data manipulation language (DML) statement

Insert rows into a table

Update rows in a table

Delete rows from a table

Control transactions

Using DDL Statements to Create and Manage Tables (Day39, Day40, Day41 and Day42)

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

Creating Other Schema Objects (Day43, Day44, Day45 and Day46)

Create simple and complex views

Retrieve data from views

Create, maintain, and use sequences

Create and maintain indexes 

Create private and public synonyms

Oracle Analytical functions and their usage (Day47, Day48 and Day49)

Identify the available analytical functions

Describe the use of analytical functions

Query based on analytical functions