Chapter 1 Retrieving Data Using the SQL SELECT Statement

Oracle 11g SQL Expert Training: from Learneeasy

Class Overview:

This course is designed for those who wish to learn advanced database programming concepts at expert level. In this course, participants learn queries, sub queries, multiple-queries, controlling privileges, creating indexes and constraints, and altering existing schema objects. Participants learn to create and query external tables and use the advanced features of SQL to query and manipulate data within the database.

Target Audience:
• Developer, Application Developers
• PL/SQL Developer ,Forms Developer
• System Analysts, Business Analysts

Prerequisites:
• Basic Programming Knowledge
• Knowledge about Database.

Class Goals
• Understand the basic concepts of relational databases ensure refined code by developers.
• Create reports of sorted and restricted data.
• Run data manipulation statements (DML).
• Control database access to specific objects.
• Utilize views to display data
• Control database access to specific objects
• Manage schema objects
• Display data from multiple tables using the SQL JOIN syntax
• Manage objects with data dictionary views
• Write multiple-column sub-queries
• Employ SQL functions to retrieve customized data
• Use scalar and correlated sub-queries
• Create reports of sorted and restricted data

Thanks