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

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.,

$650

  • 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