SQL, PL SQL

$280.00


Duration
30-35hrs
Type
online

SKU: WOO-SINGLES Categories: ,

Course Description

SQL is a standard language for storing, manipulating and retrieving data in databases. SQL stands for Structured Query Language. SQL lets you access and manipulate databases. SQL is an ANSI (American National Standards Institute) standard.

Course Content

SQL, PL SQL Course Out Line

 

Total Duration 30 – 36 Hours

 

Introduction to RDBMS

 

SQL

 

1 Writing Basic  SQL SELECT Statements

 

2   Restricting and Sorting Data

 

3 Single-Row Functions

 

4   Displaying Data from Multiple Tables

 

5 Aggregating Data  Using Group Functions

 

6 Subqueries

 

8   Manipulating Data

 

9 Creating and Managing Tables

 

10 Including Constraints

 

11 Creating Views

 

12 Other Database Objects

 

13 Controlling User Access

 

 

Pl/Sql

 

1  Declaring Variables

 

2 Writing Executable Statements

 

3 Interacting with the Oracle Server

 

4 Writing Control Structures

 

5 Working with Composite Data Types

 

6 Writing Explicit Cursors

 

7 Advanced Explicit Cursor Concepts

 

8 Handling Exceptions

 

9   Creating Procedures

 

10 Creating Functions

 

11 Managing Subprograms

 

12 Creating Packages

 

13 More Package Concepts

 

14 Creating Database Triggers

 

15 Advanced Database coding techniques

 

 

You may also like…