SQL Activity Guide

Lesson  1 : Introduction to SQL and sql developer

Lesson 2 : Retrieving data using select statement and tables introduction

Lesson 3 : Restricting and Sorting Data

Lesson 4 : Using Single-Row Functions to Customize Output

Lesson 5 : Using Conversion Functions and conditional operations

Lesson 6 : Reporting Aggregated Data Using the Group Functions

Lesson 7 : Using SET operators  and Index concepts

Lesson 8 : Displaying Data from Multiple Tables Using Joins

Lesson 9 : Using Sub queries to Solve Queries

Lesson 10 : Using DDL/DML/DCL Statements to Create and Manage Tables

Lesson 11 : Views and its implementations

Lesson 12 : Discussing logical Queries like hierarchy rownum with clause  and implementations

Lesson 13 : Sequences , Synonyms , indexes , partitions, dimension tables.

Lesson 14 : Oracle 12C New Features

Lesson 15: Advanced Analytical Concepts of SQL

Lesson  1 : Introduction to SQL and sql developer

• Introduction to Oracle
• Two/Three tier architecture
• DBMS Concepts
• Definition of Database
• Database Management System
• Database models and Relations
• Relational Database management System
• E.F. Codd Rules
• Database Design
• Entity Relationship Diagram
• Lesson 2 : Retrieving data using select statement and tables introduction
• Tables
• Selecting
• Structure
• Data Types
• Constraints
• Lesson 3 : Restricting and Sorting Data
• Where Clause
• Sorting Data
• Types of Restriction
• From Clauses
• Lesson 4 : Using Single-Row Functions to Customize Output
• Aggregate functions
• Character functions
• Date functions
• Arithmetic functions
• General functions
• Lesson 5 : Using Conversion Functions and conditional operations
• Decode
• Case
• IF , Else IF
• Nested IF Conditions
• Boolean Operators
• Conditional Operations
• Lesson 6 : Reporting Aggregated Data Using the Group Functions
• MIN , MAX
• More Aggregate Functions
• Grouping Functions
• Having Clause
• Having with Order Clause
• Lesson 7 : Using SET operators and Index concepts
• UNION
• Union ALL
• Intersection
• Minus
• Indexing Concepts

• Lesson 8 : Displaying Data from Multiple Tables Using Joins
• Joins
• Equi joins
• Non equi joins
• Self joins
• Outer joins
• Cartesian joins
• Full outer joins
• Natural joins
• Inner joins
• Lesson 9 : Using Sub queries to Solve Queries
• Sub queries
• Correlated Sub queries
• Sub Queries with Exists Clause
• Nested Sub Queries
• Lesson 10 : Using DDL/DML/DCL Statements to Create and Manage Tables
• DML ( Insert / Delete / Update)
• DDL
• DCL
• TCL
• Lesson 11 : Views and its implementations
• Views
• Materialized Views
• Lesson 12 : Discussing logical Queries like hierarchy rownum with clause and implementations
• With Clause
• Merge Clauses
• Rownum Clause
• Start , Connect By
• Lesson 13 : Sequences , Synonyms , indexes , partitions, dimension tables.
• Sequences
• Synonyms
• Partitioning
• Dimensions
• Lesson 14 : Oracle 12C New Features
• Lesson 15: Advanced Analytical Concepts of SQL
• Rank / Dense Rank / REG_EXP / Exp Functions