Browse Courses

Oracle SQL and PL/SQL

Course Description

Curriculum

Chapter 1 : Database Fundamentals 

1Database Fundamentals

  • Introduction,
  • Database Concepts, ACID Properties
  • E.F. Codd 12 Rules, Data Models
  • SQL(Structured Query Language)

Chapter 2 : ORACLE 

1ORACLE

  • History of Oracle
  • Software installation, Client Connecting Tools for Oracle
  • SQL Statements, Column by expression, Concatenation, Column Alias
  • Oracle Admin Unser
  • Create or manage users.

Chapter 3 : Select Statement 

1Select Statement

  • Selection, Projection, joining
  • Clauses: ORDER BY, WHERE, DISTINCT, etc.,
  • Difference between SQL and ANSI Sql

Chapter 4 : Built in Functions 

1Built in Functions

  • Single Row and Group Functions,
  • Working with Group functions, Group by and Having clause
  • Working with Single Row Functions (String Functions, Mathematical Functions, Date and Time Functions, Conversion Functions and Miscellaneous Functions

Chapter 5 : Joins 

1Joins

  • Introduction, Cartesian Product, Types of Joins
  • CROSS JOIN, NATURAL JOIN, INNER JOIN, OUTER JOIN
  • ANSI Sql Join

Chapter 6 : Sub Queries 

1Sub Queries

  • Introduction, importance of Sub-Queries
  • Single row Sub-Queries, Multi row Sub-queries, Co-related sub queries, etc.,

Chapter 7 : DDL Commands 

1DDL Commands

  • Data types, Creating Table, Renaming a Table,
  • Alter a table, Drop a Table, Truncate Table

Chapter 8 : Constraint 

1Constraint

  • Introduction to Constraint,
  • Types of Constraints,
  • Row/Table Level Constraint,
  • Adding and Dropping Constraints,
  • Enable/Disable Constraints, Example

Chapter 9 : DML Commands 

1DML Commands

  • INSERT INTO, DELETE and UPDATE commands

Chapter 10 : Views 

1Views

  • Introduction, Table vs View,
  • Simple and Complex views

Chapter 11 : Indexes 

1Indexes

  • Introduction, Architecture
  • Table Scan, Using Index
  • Clustered and Non-clustered Index

Chapter 12 : Sequences 

1Sequences

  • Creation, Using Sequence, NEXTVAL and CURRVAL, dropping sequence, etc.,

Chapter 13 : Synonym 

1Synonym

  • Creating, using, deletion, display list of Synonyms

Chapter 14 : TCL 

1TCL

  • Transaction Control Language, ACID Test
  • Using Commit, Rollback
  • Understanding Lock, etc.,

Chapter 15 : DCL 

1DCL

  • Data Control Language (GRANT and REVOKE Commands)
  • ROLE

Chapter 16 : PL/SQL Introduction 

1PL/SQL Introduction

  • Introduction to PL/SQL
  • PL/SQL statements, Special character used in it.
  • DBMS_OUTPUT package, Control structures

Chapter 17 : PL/SQL Attributes 

1PL/SQL Attributes

  • %TYPE, %ROWTYPE attributes
  • SELECT collist INTO
  • SELECT * INTO
  • Types of PL/SQL blocks
  • Data types, etc.,

Chapter 18 : Cursors 

1Cursors

  • Introduction, Advantages and importance
  • Difference between Implicit and Explicit Cursor
  • Examples in detail

Chapter 19 : Stored Procedures 

1Stored Procedures

  • Introduction, Syntax, Creation of SP
  • Invoking a stored procedure, dropping, Task

Chapter 20 : Exception Handling 

1Exception Handling

  • Introduction, blocks, Example

Chapter 21 : Packages using PL/SQL 

1Packages using PL/SQL

  • Groping procedures

Chapter 22 : User Defined Functions 

1User Defined Functions

  • Introduction, Syntax, Creation of UDF
  • Invoking functions, dropping, Task

Chapter 23 : Triggers 

1Triggers

  • Introduction, Advantages
  • Creating a Trigger, Implementation
  • Examples and Task

Chapter 24 : Collection 

1Collection

  • Collections in PL/SQL
  • Types, etc.,

$600

  • Lectures0
  • Video
  • Skill level Full Course
  • Languages English

Take the world's best courses

and take your career to the next level!


New to Truway? Create a new account

By signing up, you agree to our Terms of Use and Privacy Policy.
Already have an account? Login