This course provides the essential SQL skills that allow developers to write queries against single and multiple tables, manipulate data in tables, and create database objects. participants learn to control privileges at the object and system level. This course covers creating indexes and constraints, and altering existing schema objects. participants also learn how to create and query external tables.At the end of Oracle PL/SQL Application Programming, training course, the participant will be competent to code PL/SQL applications incorporating PL/SQL components
Writing Basic SQL SELECT Statements
Restricting and Sorting Data
Displaying Data from Multiple Tables
Aggregating Data Using Group Functions
What is a Sequence
The CREATE SEQUENCE Statement Syntax
Creating a Sequence
NEXTVAL and CURRVAL Pseudocolumns
Using a Sequence
Modifying a Sequence
Guidelines for Modifying a Sequence
Removing a Sequence
What is an Index?
How Are Indexes Created?
Creating an Index
When to Create an Index
When Not to Create an Index
Removing an Index
Creating and Removing Synonyms
MAMY MORE TOPICS...
College Students and Software Developers/Programmers