This Oracle Database: Introduction to SQL training helps you write subqueries, combine multiple queries into a single query using SET operators and report aggregated data using group functions. Learn this and more through hands-on exercises.
Benefits to You
Ensure fast, reliable, secure and easy to manage performance. Optimize database workloads, lower IT costs and deliver a higher quality of service by enabling consolidation onto database clouds.
Learn Advanced Features of SQL
This course will help you understand the advanced features of SQL. Learning these features will help you query and manipulate data within the database, use the dictionary views to retrieve metadata and create reports about their schema objects. Some of the date-time functions available in the Oracle Database are also covered. This course also discusses how to use the regular expression support in SQL through expert instruction.
Use Development Tools
The main development tool used in this training is Oracle SQL Developer. SQL*Plus is available as an optional development tool. This is appropriate for a 10g and 11g audience.
Note: This course is a combination of Oracle Database: SQL Workshop I and Oracle Database: SQL Workshop II courses.
Introduction to Oracle Database
Retrieve Data using the SQL SELECT Statement
Learn to Restrict and Sort Data
Usage of Single-Row Functions to Customize Output
Invoke Conversion Functions and Conditional Expressions
Aggregate Data Using the Group Functions
Display Data From Multiple Tables Using Joins
Use Sub-queries to Solve Queries
The SET Operators
Data Manipulation Statements
Use of DDL Statements to Create and Manage Tables
Other Schema Objects
Control User Access
Management of Schema Objects
Manage Objects with Data Dictionary Views
Manipulate Large Data Sets
Data Management in different Time Zones
Retrieve Data Using Sub-queries
Regular Expression Support
Recommended Related Training Courses:
Oracle Database: SQL and PL/SQL Fundamentals
This Database SQL & PL/SQL Fundamentals training teaches you the fundamentals of relational databases, SQL & PL/SQL programming language. Learn to write queries against single and multiple tables, manipulate data in tables & create database objects.
Oracle Database: Program with PL/SQL NEW
This Database Program with PL/SQL training shows you how to develop stored procedures, functions, packages and database triggers. You'll learn to manage PL/SQL program units and dependencies, while using of some of the Oracle-supplied packages.