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

Topics Covered

Writing Basic SQL SELECT Statements Restricting and Sorting Data Single-Row Functions Displaying Data from Multiple Tables Aggregating Data Using Group Functions Subqueries Database Objects What is a Sequence The CREATE SEQUENCE Statement Syntax Creating a Sequence Confirming Sequences 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 Confirming Indexes Function-Based Indexes Removing an Index Synonyms Creating and Removing Synonyms MAMY MORE TOPICS...

Who should attend

College Students and Software Developers/Programmers

Pre-requisites

Basic programing

What you need to bring

Note book,pen and laptop prefered

Key Takeaways

WIll be able to play role of PL/SQL developer