Name: Oracle Database 11g: Introduction to SQL
Course Code: OR49988
Duration: 5
Scheduled Dates for OR49988
In this course students learn the concepts of relational databases. 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. Students learn to control privileges at the object and system level.
This course covers creating indexes and constraints, and altering existing schema objects. Students also learn how to create and query external tables. Students learn to use the advanced features of SQL in order to query and manipulate data within the database, use the dictionary views to retrieve metadata and create reports about their schema objects. Students also learn some of the date-time functions available in the Oracle Database. This course discusses how to use the regular expression support in SQL.
Target Audience
Forms Developer
Data Warehouse Administrator
Business Analysts
Developer
System Analysts
Application Developers
PL/SQL Developer
Key Topics
- Introducing Oracle Database 11g
- Retrieving Data Using the SQL SELECT Statement
- Restricting and Sorting Data
- Using Single-Row Functions to Customize Output
- Using Conversion Functions and Conditional Expressions
- Reporting Aggregated Data Using the Group Functions
- Displaying Data From Multiple Tables
- Using Sub-queries to Solve Queries
- Using the SET Operators
- Manipulating Data
- Using DDL Statements to Create and Manage Tables
- Creating Other Schema Objects
- Controlling User Access
- Managing Schema Objects
- Managing Objects with Data Dictionary Views
- Manipulating Large Data Sets
- Managing Data in Different Time Zones
- Retrieving Data Using Sub-queries
- Regular Expression Support
Objectives
- Retrieve row and column data from tables with the SELECT statement
- Create reports of sorted and restricted data
- Employ SQL functions to generate and retrieve customized data
- Display data from multiple tables using the ANSI SQL 99 JOIN syntax
- Identify the major structural components of the Oracle Database 11g
- Create reports of aggregated data
- Write SELECT statements that include queries
- Run data manipulation statements (DML) to update data in the Oracle Database 11g
- Create tables to store data
- Utilize views to display and retrieve data
- Control database access to specific objects
- Manage schema objects
- Manage objects with data dictionary views
- Write multiple-column sub-queries
- Use scalar and correlated sub-queries
- Use the regular expression support in SQL
Required Skills/Experience
- Familiarity with data processing concepts and techniques
- Data processing
Suggested Next Course(s)
- Oracle Database 11g: PL/SQL Fundamentals New
- Oracle Database 11g: Program with PL/SQL New
Fee: $3,000.00
Course Schedule:
Back to Course Description
Austin
Charlotte
Columbia
Hunt Valley
Lansing
Madison
Milwaukee
Minneapolis
Oak Brook
Oklahoma City
Phoenix
Raleigh
San Antonio
Schaumburg
Tulsa
Washington DC
