Untitled Document
SQL/PL-SQL

Intro to SQL training teaches you basic concepts of relational databases and the SQL programming language. You'll gain essential SQL skills to write queries against single & multiple tables, manipulate data in tables & create database objects.

PL/SQL training shows you how to develop stored procedures, functions, packages and database triggers. You'll learn to manage PL/SQL program units and dependencies, while using of some of the Oracle-supplied packages.

SQL/PL-SQL Course Content

SQL

  1. Database Design
    • Database Models
    • Beginnings
    • Some Introductory Terminology
    • Codd's 12 Rules
    • Normalization
    • First Normal Form
    • Higher Order Normal Forms
  2. Oracle Standard Interfaces
    • SQL
    • SQL*Plus
    • Oracle Architecture
    • Interfaces to Oracle
    • Command Line Interface
    • Viewing a Sample Table
    • The Graphical User Interface
    • The SQL Buffer
    • The Web-Based Interface
    • Describe
  3. The Sample Database
    • The Entity Relationship Model
    • Entity Relationship Diagrams
    • The Sample Database
    • ER Diagram for Sample Database
    • Creating the Sample Data
    • Viewing Sample Data
    • Data Types of the Sample Data
  4. Data Definition Language
    • Categories of SQL Statements
    • Oracle Datatypes
    • The CREATE Statement
    • The DROP Command
    • The ALTER Command
    • Integrity Constraints
    • Entity Integrity Constraints
    • Referential Integrity Constraints
    • Modifying Table to Use Constraints
    • Checking Constraints
    • The Data Dictionary
  5. Data Manipulation Language
    • DML Statements
    • The SELECT Statement
    • The INSERT Statement
    • The DELETE Statement
    • The UPDATE Statement
    • More SQL*Plus Commands
  6. Transaction Control
    • Transactions
    • Command Classification
    • Savepoints
    • The SET TRANSACTION Command
  7. SQL Operators
    • Simple Selects
    • Comparison Operators
    • IN and NOT IN Operators
    • BETWEEN Operator
    • The LIKE Operator
    • Logical Operators
    • IS NULL and IS NOT NULL
    • ANY
    • ALL
  8. SQL FUNCTIONS
    • Introduction
    • The DISTINCT Keyword
    • Aliases
    • Miscellaneous Functions
    • Mathematical Functions
    • String Functions
    • Date Functions
    • Conversion Functions
    • Pseudo Columns
  9. Joining Tables
    • Joins
    • Cartesian Product
    • Inner Joins
    • Equi-Join
    • Table Aliases
    • Non-Equi Join
    • Non-Key Join
    • Reflexive Join
    • Natural Join
    • Outer Joins
    • Right Outer Join
    • Left Outer Join
    • Full Outer Join
    • Oracle-Specific Syntax for Outer Joins
  10. Set Operators
    • Introduction
    • Selection Criteria
    • Union
    • Union All
    • Intersect
    • Minus
  11. SQL Subqueries
    • Introduction
    • Using a Subquery with a DML Statement
    • Typical Subqueries
    • Subquery Operators
    • Standard vs. Correlated Subqueries
    • Correlated Subquery Example
    • Predicate Operators
  12. Groups
    • SQL Statements
    • GROUP BY Clause
    • HAVING Clause
    • Order of a SELECT Statement
  13. More Database Objects
    • More Database Objects
    • Relational Views
    • Updating a View
    • Create or Replace
    • Forcing a View
    • The Data Dictionary Revisited
    • Indexes
    • Synonyms
  14. Reports
    • Report Features
    • Session Control
    • The SET Command
    • The COLUMN Command
    • The BREAK Command
    • The COMPUTE Command

PL/SQL

  1. Introduction
    • SQL vs. PL/SQL
    • A Few Simple Examples
    • Saving Procedures
    • A More Complete Picture
    • Comments
    • Variable Substitution
    • Simple Exception Handling
    • Advantages of PL/SQL
    • Assignments
  2. Declarations and Data Types
    • Declarations
    • Standard Data Types
    • Initialization
    • Variable Names
    • Specialized Data Types - %TYPE
    • Specialized Data Types - %ROWTYPE
    • Building Your Own Data Types - Records
    • A Quick look at Loops
    • Arrays
    • Tables
    • Nested Blocks
  3. Language Components
    • Introduction
    • Assignments
    • Decision Making Statements
    • Simple Loops
    • Loops - for
    • Loops - indefinite
    • Loops - while
    • Simple Loops
    • Nested Loops
    • Boolean Variables
    • PL/SQL Relational Operators
    • PL/SQL Logical Operators
    • The CASE Construct
  4. Cursors
    • Introduction
    • Cursor Manipulation
    • Using the Cursor
    • For Loops Cursors
    • Cursor Attributes
    • Cursor Parameters
    • Nested Cursors
    • Cursor Exceptions
  5. Exceptions
    • Errors in Programs
    • Run Time Exceptions
    • Oracle Built In Exceptions
    • Unnamed Exceptions
    • Built in Exception Functions
    • Creating Your Own Exceptions
    • Building Non Terminating Exceptions
  6. Functions and Procedures
    • Introduction
    • Creating a Procedure
    • Example Procedure
    • Using Parameters
    • Functions
    • Procedures and Exceptions
  7. An SQL and SQL*Plus Reference
    • DDL Statements
    • DML Statements
    • Transaction Control Statements
    • Operators
  8. Common SQL*Plus Commands
Untitled Document
Get In Touch
Testimonials

"He is excellent in everything and is productive, he likes to take challenges. He is trustworthy and responsible. He is too much serious in his work. His nature, attitude, behavior is also good. I liked to work with him."


-- Vishal Singh, Noida

"Vijay Sir, is a highly organized, goal oriented, independent and hard working perfectionist always ready to put all their energy and stamina to get the job done. Well educated and energetic. Is able to work in a fast-paced environment."


-- Saurabh Parashar, Delhi
Contact Us

Copyright@logiquemantra technologies

Number of Visitors 9112 hits

Home | About Us | Services | Training | Portfolio | Blog | Contact Us