Database module, Oracle PL/SQLDatabase Module (Oracle)

The Oracle PL/SQL language is a flexible procedural extension to SQL. Gain practical knowledge to write PL/SQL programs and build stored procedures and modular applications.

Book an appointment Call 847-350-9034

Oracle SQLLabsMidterm and final exam

Ten parts of the course

From database basics to advanced SQL. 1

Databases and Oracle

DBMS basics, Oracle Database, SQL Developer setup, connecting.2

SQL basics

SELECT, WHERE, ORDER BY and column aliases.3

Joins

INNER, LEFT, RIGHT, CROSS and SELF joins, UNION and UNION ALL.4

Advanced filtering

BETWEEN, NULL, IN, AND/OR/NOT, subqueries.5

Data modification

INSERT, UPDATE, DELETE, COMMIT, ROLLBACK, savepoints.6

Aggregation

GROUP BY, aggregate functions, HAVING, ROLLUP, Cube.7

Date and time

Date types and functions, date differences and components.8

DDL

Create and alter tables, constraints and indexes.9

Views and sequences

Views, sequences, synonyms, privileges and security.10

Advanced SQL

Analytic functions and working with large data sets.

Detailed course content

Topics covered in each part.

1 to 3. Basics and joins

✓Databases and Database Management Systems (DBMS)✓Oracle SQL Developer setup and connecting to the database✓SELECT, WHERE, ORDER BY, aliases for column names✓INNER, LEFT, RIGHT, CROSS and SELF joins; USING clause✓UNION and UNION ALL operators

4 and 5. Filtering and transactions

✓BETWEEN, NULL values, IN and NOT IN, AND, OR, NOT✓Subqueries and nested queries✓INSERT, UPDATE and DELETE statements✓COMMIT, ROLLBACK, transactions and savepoints

6 and 7. Grouping and dates

✓GROUP BY and aggregate functions (SUM, AVG, COUNT, MAX, MIN)✓HAVING, GROUPING SETS, ROLLUP and Cube✓Date functions (TO_DATE, TO_CHAR, TO_TIMESTAMP)✓Calculating date differences and extracting date components

8 to 10. DDL, views, advanced SQL

✓Creating and altering tables✓Constraints (PRIMARY KEY, FOREIGN KEY, UNIQUE, CHECK) and indexes✓Views, sequences and synonyms; privileges and security✓Analytic functions (ROW_NUMBER, RANK, DENSE_RANK, LAG, LEAD)

Assessments, support and features

Assessments and projects come with the course.

Assessments and projects

✓Weekly quizzes or assignments✓Midterm exam and final exam✓Hands-on projects, for example building a database application

Staffing support

✓Resume preparation✓Mock interview preparation✓Phone interview preparation✓Face to face interview preparation✓Project and technology preparation✓Internship with internal project work✓Externship with client project work

Our salient features

✓Hands-on labs and homework✓Group discussion and case study✓Course project work✓Regular quiz and exam✓Regular support beyond the classroom✓Students can re-take the class at no cost✓Dedicated conference rooms for group project work✓Live streaming for remote students✓Video recording to catch up on a missed class

Explore more training

See other programs, funding options and the class schedule. All training programs Education grant program Upcoming classes

Ready to start work with Oracle databases?

Call 847-350-9034 or book an appointment to talk about this course and funding options.Book an appointment Call 847-350-9034 Education grant program

Ten parts of the course

From database basics to advanced SQL.1

Databases and Oracle

DBMS basics, Oracle Database, SQL Developer setup, connecting.2

SQL basics

SELECT, WHERE, ORDER BY and column aliases.3

Joins

INNER, LEFT, RIGHT, CROSS and SELF joins, UNION and UNION ALL.4

Advanced filtering

BETWEEN, NULL, IN, AND/OR/NOT, subqueries.5

Data modification

INSERT, UPDATE, DELETE, COMMIT, ROLLBACK, savepoints.6

Aggregation

GROUP BY, aggregate functions, HAVING, ROLLUP, Cube.7

Date and time

Date types and functions, date differences and components.8

DDL

Create and alter tables, constraints and indexes.9

Views and sequences

Views, sequences, synonyms, privileges and security.10

Advanced SQL

Analytic functions and working with large data sets.

Detailed course content

Topics covered in each part.1

1 to 3. Basics and joins

✓Databases and Database Management Systems (DBMS)✓Oracle SQL Developer setup and connecting to the database✓SELECT, WHERE, ORDER BY, aliases for column names✓INNER, LEFT, RIGHT, CROSS and SELF joins; USING clause✓UNION and UNION ALL operators2

4 and 5. Filtering and transactions

✓BETWEEN, NULL values, IN and NOT IN, AND, OR, NOT✓Subqueries and nested queries✓INSERT, UPDATE and DELETE statements✓COMMIT, ROLLBACK, transactions and savepoints3

6 and 7. Grouping and dates

✓GROUP BY and aggregate functions (SUM, AVG, COUNT, MAX, MIN)✓HAVING, GROUPING SETS, ROLLUP and Cube✓Date functions (TO_DATE, TO_CHAR, TO_TIMESTAMP)✓Calculating date differences and extracting date components4

8 to 10. DDL, views, advanced SQL

✓Creating and altering tables✓Constraints (PRIMARY KEY, FOREIGN KEY, UNIQUE, CHECK) and indexes✓Views, sequences and synonyms; privileges and security✓Analytic functions (ROW_NUMBER, RANK, DENSE_RANK, LAG, LEAD)

Assessments, support and features

Assessments and projects come with the course.1

Assessments and projects

✓Weekly quizzes or assignments✓Midterm exam and final exam✓Hands-on projects, for example building a database application2

Staffing support

✓Resume preparation✓Mock interview preparation✓Phone interview preparation✓Face to face interview preparation✓Project and technology preparation✓Internship with internal project work✓Externship with client project work3

Our salient features

✓Hands-on labs and homework✓Group discussion and case study✓Course project work✓Regular quiz and exam✓Regular support beyond the classroom✓Students can re-take the class at no cost✓Dedicated conference rooms for group project work✓Live streaming for remote students✓Video recording to catch up on a missed class

Explore more training

See other programs, funding options and the class schedule.All training programs Education grant program Upcoming classes

Ready to start work with Oracle databases?

Call 847-350-9034 or book an appointment to talk about this course and funding options.Book an appointment Call 847-350-9034 Education grant program