SQL & PL/SQL - Innozant MIS & Data Analytics & Data Science

Administrator Expert


No prior technical experience is required! This course teaches SQL & PL/SQL from the very basics

SQL is Structured Query Language, It is used to communicate with database for storing, manipulating and retrieving data stored in a relational database.

PL/SQL is basically a procedural language, which provides the functionality of decision making, iteration and many more features of procedural programming languages. … One can create a PL/SQL unit such as procedures, functions, packages, triggers, and types, which are stored in the database for reuse by applications

What you will learn

  • Become an expert in SQL & Learn how to code in SQL
  • Create, design, and operate with SQL databases
  • The ability to take control of your dataset – insert, update, and delete records from your database
  • Handle complex SQL joins with ease
  • Approach more advanced topics in programming like SQL’s triggers, sequences, local and global variables, indexes, and more
  • Become a proficient SQL user by writing flawless and efficient queries
  • Create an executable section and write control structures.
  • Create and manage procedures, functions, packages and triggers.
  • Some Advanced SQL Techniques
  • Use SQL Developer Efficiently for PL/SQL
  • Learn PL/SQL Architecture Very Well
  • Create Your Dynamic SQL & PL/SQL Queries
  • Learn PL/SQL Object Oriented Programming
  • Learn PL/SQL Tuning for Performance
  • Learn & Master PL/SQL by Coding with Hundreds of Practical Examples!
  • Work with composite data types and cursors utilising Oracle supplied packages in application development including exception handling, manage dependencies and large objects

Download Brochure

Topics for this course

113 Lessons59h 59m 59s

Structured Query Language (SQL)

Introduction To SQL

Data Retrieval Techniques

Working With DDL Commands

Working With DML Commands

Integrity Constraints

Built In Functions

Data Aggregation

Importance Of JOIN

Set Operators And Pseudo Columns

Sub Queries

Database Transaction And Security

Design Of Schema Objects

PL/SQL (Procedural Language Extension to SQL)

Introduction To PL/SQL

Creating And Using Cursors

Understanding Exception Handling

Creation Of Stored Procedures

Creating & Using Functions

Creating & Using Packages

Triggers In PL/SQL

Collections In PL/SQL

  • Course level: Expert
  • Duration 59h 59m 59s