Oracle SQL- IT Course

Training/Coaching/Tuition by Complete Analytics Training Institute Bangalore View Contact

Request Info

CHAPTER 1: DATABASE DESIGN

1. Database Models

2. Beginnings

3. Some Introductory Terminology

4. Codd's 12 Rules

5. Normalization

6. First Normal Form

7. Higher Order Normal Forms

CHAPTER 2: ORACLE STANDARD INTERFACES

1. SQL

2. SQL*Plus

3. Oracle Architecture

4. Interfaces to Oracle

5. Command Line Interface

6. Viewing a Sample Table

7. The Graphical User Interface

8. The SQL Buffer

9. The Web-Based Interface

10. Describe

CHAPTER 3: THE SAMPLE DATABASE

1. The Entity Relationship Model

2. Entity Relationship Diagrams

3. The Sample Database

4. ER Diagram for Sample Databas

5. Creating the Sample Data

6. Viewing Sample Data

7. Data Types of the Sample Da

CHAPTER 4: DATA DEFINITION LANGUAGE

1. Categories of SQL Statements

2. Oracle Datatypes

3. The CREATE Statement

4. The DROP Command

5. The ALTER Command

6. Integrity Constraints

7. Entity Integrity Constraints

8. Referential Integrity Constraints

9. Modifying Table to Use Constraints

10. Checking Constraints

11. The Data Dictionary

CHAPTER 5: DATA MANIPULATION LANGUAGE

1. DML Statements

2. The SELECT Statement

3. The INSERT Statement

4. The DELETE Statement

5. The UPDATE Statement

6. More SQL*Plus Commands

CHAPTER 6: TRANSACTION CONTROL

1. Transactions

2. Command Classification

3. Savepoints

4. The SET TRANSACTION Command

CHAPTER 7: SQL OPERATORS

1. Simple Selects

2. Comparison Operators

3. IN and NOT IN Operators

4. BETWEEN Operator

5. The LIKE Operator

6. Logical Operators

7. IS NULL and IS NOT NULL

8. ANY

9. All

CHAPTER 8: SQL FUNCTIONS

1. Introduction

2. The DISTINCT Keyword

3. Aliases

4. Miscellaneous Functions

5. Mathematical Functions

6. String Functions

7. Date Functions

8. Conversion Functions

9. Pseudo Columns

CHAPTER 9: JOINING TABLES

1. Joins

2. Cartesian Product

3. Inner Joins

4. Equi-Join

5. Table Aliases

6. Non-Equi Join

7. Non-Key Join

8. Reflexive Join/li>

9. Natural Join

10. Outer Joins

11. Right Outer Join

12. Left Outer Join

13. Full Outer Join

14. Oracle-Specific Syntax for Outer Joins

CHAPTER 10: SET OPERATORS

1. Introduction

2. Selection Criteria

3. Union

4. Union All

5. Intersect

6. Minus

CHAPTER 11: SQL SUBQUERIES

1. Introduction

2. Using a Subquery with a DML Statement

3. Typical Subqueries

4. Subquery Operators

5. Standard vs. Correlated Subqueries

6. Correlated Subquery Example

7. Predicate Operators

CHAPTER 12: GROUPS

1. SQL Statements

2. GROUP BY Clause

3. HAVING Clause

4. Order of a SELECT Statement

CHAPTER 13: MORE DATABASE OBJECTS

1. More Database Objects

2. Relational Views

3. Updating a View

4. Create or Replace

5. Forcing a View

6. The Data Dictionary Revisited

7. Indexes

8. Synonyms

CHAPTER 14: REPORTS

1. Report Features

2. Session Control

3. The SET Command

4. The COLUMN Command

5. The BREAK Command

6. The COMPUTE Command

Oracle PLSQL

CHAPTER 1: DATABASE DESIGN

1. Database Models

2. Beginnings

3. Some Introductory Terminology

4. Codd's 12 Rules

5. Normalization

6. First Normal Form

7. Higher Order Normal Forms

CHAPTER 2: ORACLE STANDARD INTERFACES

1. SQL

2. SQL*Plus

3. Oracle Architecture

4. Interfaces to Oracle

5. Command Line Interface

6. Viewing a Sample Table

7. The Graphical User Interface

8. The SQL Buffer

9. The Web-Based Interface

10. Describe

CHAPTER 3: THE SAMPLE DATABASE

1. The Entity Relationship Model

2. Entity Relationship Diagrams

3. The Sample Database

4. ER Diagram for Sample Database

5. Creating the Sample Data

6. Viewing Sample Data

7. Data Types of the Sample Data

CHAPTER 4: DATA DEFINITION LANGUAGE

1. Categories of SQL Statements

2. Oracle Datatypes

3. The CREATE Statement

4. The DROP Command

5. The ALTER Command

6. Integrity Constraints

7. Entity Integrity Constraints

8. Referential Integrity Constraints

9. Modifying Table to Use Constraints

10. Checking Constraints

11. The Data Dictionary

CHAPTER 5: DATA MANIPULATION LANGUAGE

1. DML Statements

2. The SELECT Statement

3. The INSERT Statement

4. The DELETE Statement

5. The UPDATE Statement

6. More SQL*Plus Commands

CHAPTER 6: TRANSACTION CONTROL

1. Transactions

2. Command Classification

3. Savepoints

4. The SET TRANSACTION Command

CHAPTER 7: SQL OPERATORS

1. Simple Selects

2. Comparison Operators

3. IN and NOT IN Operators

4. BETWEEN Operator

5. The LIKE Operator

6. Logical Operators

7. IS NULL and IS NOT NULL

8. ANY

9. ALL

CHAPTER 8: SQL FUNCTIONS

1. Introduction

2. The DISTINCT Keyword

3. Aliases

4. Miscellaneous Functions

5. Mathematical Functions

6. String Functions

7. Date Functions

8. Conversion Functions

9. Pseudo Columns

CHAPTER 9: JOINING TABLES

1. Joins

2. Cartesian Product

3. Inner Joins

4. Equi-Join

5. Table Aliases

6. Non-Equi Join

7. Non-Key Join

8. Reflexive Join

9. Natural Join

10. Outer Joins

11. Right Outer Join

12. Left Outer Join

13. Full Outer Join

14. Oracle-Specific Syntax for Outer Joins

CHAPTER 10: SET OPERATORS

1. Introduction

2. Selection Criteria

3. Union

4. Union All

5. Intersect

6. Minus

CHAPTER 11: SQL SUBQUERIES

1. Introduction

2. Using a Subquery with a DML Statement

3. Typical Subqueries

4. Subquery Operators

5. Standard vs. Correlated Subqueries

6. Correlated Subquery Example

7. Predicate Operators

CHAPTER 12: GROUPS

1. SQL Statements

2. GROUP BY Clause

3. HAVING Clause

4. Order of a SELECT Statement

CHAPTER 13: MORE DATABASE OBJECTS

1. More Database Objects

2. Relational Views

3. Updating a View

4. Create or Replace

5. Forcing a View

6. The Data Dictionary Revisited

7. Indexes

8. Synonyms

CHAPTER 14: REPORTS

1. Report Features

2. Session Control

3. The SET Command

4. The COLUMN Command

5. The BREAK Command

6. The COMPUTE Command

CHAPTER 15: INTRODUCTION

1. SQL vs. PL/SQL

2. A Few Simple Examples

3. Saving Procedures

4. A More Complete Picture

5. Comments

6. Variable Substitution

7. Simple Exception Handling

8. Advantages of PL/SQL

9. Assignments

CHAPTER 16: DECLARATIONS AND DATA TYPES

1. Declarations

2. Standard Data Types

3. Initialization

4. Variable Names

5. Specialized Data Types - %TYPE

6. Specialized Data Types - %ROWTYPE

7. Building Your Own Data Types - Records

8. A Quick look at Loops

9. Arrays

10. Tables

11. Nested Blocks

CHAPTER 17: LANGUAGE COMPONENTS

1. Introduction

2. Assignments

3. Decision Making Statements

4. Simple Loops

5. Loops - for

6. Loops - indefinite

7. Loops - while

8. Simple Loops

9. Nested Loops

10. Boolean Variables

11. PL/SQL Relational Operators

12. PL/SQL Logical Operators

13. The CASE Construct

CHAPTER 18: CURSORS

1. Introduction

2. Cursor Manipulation

3. Using the Cursor

4. For Loops Cursors

5. Cursor Attributes

6. Cursor Parameters

7. Nested Cursors

8. Cursor Exceptions

CHAPTER 19: EXCEPTIONS

1. Errors in Programs

2. Run Time Exceptions

3. Oracle Built In Exceptions

4. Unnamed Exceptions

5. Built in Exception Functions

6. Creating Your Own Exceptions

7. Building Non Terminating Exceptions

CHAPTER 20: FUNCTIONS AND PROCEDURES

1. Introduction

2. Creating a Procedure

3. Example Procedure

4. Using Parameters

5. Functions

6. Procedures and Exceptions

APPENDIX A: AN SQL AND SQL*PLUS REFERENCE

1. DDL Statements

2. DML Statements

3. Transaction Control Statements

4. Operators

5. Common SQL*Plus Commands

Complete Analytics Training Institute

Complete Analytics Training Institute aimed at providing world class training in the area of Research Analytics. We train people to think analytically, communicate efficiently, reason logically, and make smarter choices and to solve problems in a structured manner.

Our Courses invest in you the power to make smarter decisions in every sphere of your life. They empower you with the analytical intelligence that guarantees success in every human endeavor to find out more about how these courses can empower your career of your organization's Future; explore this space and come, partner in this incredible journey with us. A Mid Career professional can use Analytics Training Institute's Courses to refresh his/her skills, apply for the next Promotion or to make an overall career change to one of the fastest growing industries like KPO, IT, Healthcare, etc.,

At Complete Analytics training Institute, we have been helping in analyzing all kind of statistical data. We can enhance and analyze your data to turn it into information you can act upon to meet your short and long term business objectives. Our team of data analysts uses a wide range of proven data modeling tools and methods which they will draw upon to meet your business needs.