+91 88606 33966            edu_sales@siriam.in                   Job Opening : On-site Functional Trainer/Instructor | Supply Chain Management (SCM)
Placeholder

SQL/PLSQL

Overview
Curriculum
Reviews

What is SQL/PLSQL?

SQL is a standard database language used to access and manipulate data in databases. SQL stands for Structured Query Language. SQL was developed by IBM Computer Scientists in the 1970s. By executing queries SQL can create, update, delete, and retrieve data in databases like MySQL, Oracle, PostgreSQL, etc. Overall SQL is a query language that communicates with databases.

PL/SQL is a combination of SQL along with the procedural features of programming languages. It was developed by Oracle Corporation in the early 90's to enhance the capabilities of SQL. PL/SQL is one of three key programming languages embedded in the Oracle Database, along with SQL itself and Java. This tutorial will give you a great understanding on PL/SQL to proceed with Oracle database and other advanced RDBMS concepts.

PL/SQL is a block-structured language that enables developers to combine the power of SQL with procedural statements. All the statements of a block are passed to Oracle engine all at once which increases processing speed and decreases the traffic. 

Prerequisites for Learning SQL:

  • Basic Computer Skills: You should have a fundamental understanding of how computers, operating systems, and software work.

  • Relational Database Concepts: It's helpful to have a basic understanding of relational database concepts, such as tables, rows, columns, and relationships.

 

Curriculum

  • 2 Sections
  • 33 Lessons
  • 0 Quizzes
  • 40h Duration
Expand All
SQL
12 Lessons0 Quizzes
  1. Introduction To SQL
  2. Retrieving Data Using the SQL SELECT Statement
  3. Restricting and Sorting Data
  4. Using Single-Row Functions to Customize Output
  5. Using Conversion Functions and Conditional Expressions
  6. Reporting Aggregated Data Using the Group Functions
  7. Displaying Data from Multiple Tables Using Joins
  8. Using Subqueries to Solve Queries
  9. Using Set Operators
  10. Managing Tables Using DML Statements
  11. Introduction to Data Definition Language
  12. Oracle Cloud Overview
PLSQL
21 Lessons0 Quizzes
  1. Introduction To PLSQL
  2. Declaring PL/SQL Variables
  3. Writing Executable Statements
  4. Using SQL Statements Within a PL/SQL Block
  5. Writing Control Structures
  6. Working with Composite Data Types
  7. Using Explicit Cursors
  8. Handling Exceptions
  9. Introducing Stored Procedures and Functions
  10. Creating Procedures
  11. Creating Functions
  12. Debugging Subprograms
  13. Creating Packages
  14. Working with Packages
  15. Using Oracle-Supplied Packages in Application Development
  16. Using Dynamic SQL
  17. Creating Triggers
  18. Creating Compound, DDL, and Event Database Triggers
  19. Design Considerations for the PL/SQL Code
  20. Tuning the PL/SQL Compiler
  21. Managing Dependencies
0 out of 5

0 user ratings

Deleting Course Review

Are you sure? You can't restore this back
Scroll to top