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.,
-
.NET
$650 -
C#_Introduction
$650 -
.NET
$550 -
Oracle (SQL and PL/SQL)
$650 -
Oracle SQL and PL/SQL
$600 -
SQL Server
$500 -
C#
$650 -
Amazon Web Services + Linux (Basics)
$800 -
SYMANTEC NET BACK-UP
$650 -
SCCM ( System Center Configuration Manager )
$600 -
IT Service Management with System Center Service Manager
$800 -
VMware CONCEPTS
$400 -
Embedded Systems, VLSI Design and RFID Technologies
$500 -
CISCO NETWORK
$900 -
CCNA
$600 -
CCNP
$600 -
CISCO MDS FABRIC SWITCHING
$500 -
BROCADE SAN ADMINISTRATION
$400 -
Linux
$400 -
RedHat OpenStack CloudComputing Administration
$700 -
Windows Power Shell
$700 -
CCNA + CCNP
$300 -
CCNA
$200 -
CCNP
$200 -
SYMANTEC NET BACK-UP
$200 -
VMware CONCEPTS
$200 -
Embedded Systems, VLSI Design and RFID Technologies
$200 -
CISCO MDS FABRIC SWITCHING
$200 -
.NET
$200 -
Amazon Web Services + Linux (Basics)
$200 -
RedHat OpenStack Cloud Computing Administration
$200 -
Cloud Computing
$299 -
Certified ScrumMaster (CSM)
$299 -
ITIL Foundation
$299 -
ITIL OSA
$299 -
ITIL PPO
$299 -
Lean Six Sigma Green Belt ( LSSGB )
$299 -
PRINCE2
$499 -
PRINCE2 AGILE
$499 -
TOGAF 9.1
$499
