Oracle Database 11g: Introduction for Experienced SQL Users
In this course students with previous ANSI SQL experience are introduced to the Oracle Database 11g environment, SQL Developer, the SQL language and extensions to the ANSI SQL standard.
The course provides students with an overview of the basic elements of SQL. Students learn about the SELECT statement, pseudonyms, and different types of operators, conditions, expressions, and functions in SQL. Students also learn how to query from tables using joins and other advanced subqueries. Students learn to create and manage database objects such as tables, views, indexes, sequences, and synonyms. In addition, you learn how to control user access to the database and how to create roles and grant privileges.
Learn To:
Describe the Oracle database environment
Use various features of SQL Developer
Describe and work with the basic elements of Oracle SQL
Combine tables using joins and subqueries
Create and manage tables, synonyms, sequences, indexes, and views
Implement database security by granting privileges and creating roles
Skills Gained
Describe the Oracle database environment
Use various features of SQL*Developer
Describe and work with the basic elements of Oracle SQL
Combine tables using joins and subqueries
Create and manage tables, synonyms, sequences, indexes, and views
Implement database security by granting privileges and creating roles
Who Can Benefit
Administrator
Application Developers
Database Administrators
Forms Developer
PL/SQL Developer
Portal Developer
System Analysts
Technical Consultant
Prerequisites
Proficiency in ANSI SQL
Basic database concepts
Code:
11g-SQL-USER
Length:
2 days
Type:
Instructor-Led
Certified By:
Oracle
Tuition:
$1,200
This course is taught by Certified Oracle instructors. There is a difference. Learn More
This course is in the following categories. Click the categories to find similar courses and topics of interest.
There are currently no scheduled dates for this course. If you are interested in this course, request a course date with the links below. We can also contact you when the course is scheduled in your area.
Understanding the Oracle Database Environment
Identify Oracle Database components
Define an instance and how to connect to it
Describe parsing of a SQL statement
Describe the processing of a SQL statement
Declare, reference, and display bind variables
Describe read consistency
Using SQL Developer
List the key features of Oracle SQL Developer
Install Oracle SQL Developer
Identify the menu items of Oracle SQL Developer
Create a database connection
Manage database objects
Use SQL Worksheet
Save and Run SQL scripts
Create and save reports
Getting Started with Oracle SQL
Execute a SELECT statement
Implement pseudocolumns in SQL
Utilize the different types operators, conditions, expressions, and functions in SQL
Convert between data types using explicit data type conversion
Describe how SQL treats NULL values
Combining Tables using Advanced Queries
Write subqueries
Update and delete rows using correlated subqueries
Explain the concept of hierarchical query
Perform joins in SQL
Create a tree-structured report
Exclude branches from the tree structure
Creating and Managing Tables
Create and maintain tables by using the CREATE, ALTER, DROP, RENAME, and TRUNCATE statements
Use the data dictionary to view and maintain information about tables
Create and maintain integrity constraints
Discuss constraint states
Creating and Managing Other Oracle Database Objects
Create and maintain a view
Retrieve, insert, update, and delete data through a view
Create, maintain, and use sequences
Create and maintain indexes
Create private and public synonyms
Controlling User Access
Discuss the concepts of users, roles, and privileges
Create users
Create roles
Grant and revoke object privileges
Create and access database links
Oracle Database Extensions to DML and DDL Statements
Describe the features of multi table INSERT statements
Use multi table INSERT statements
Merge rows using the MERGE statement
Create and use external tables
Describe transaction processing
When you take a certified course with ExitCertified, you are learning from
the creators of the products you use. Our commitment to your IT
community, along with our authorization to deliver certified courses,
ensures you receive a premium training experience.
