Trust Your IT Training |
Oracle University Awards ExitCertified Corporation with North American Partner of the Year.
ExitCertified Strengthens Relationship with Red Hat with Advanced Reseller Status.
Oracle University Awards ExitCertified Outstanding Instructor Quality Award.
ExitCertified Featured in Dynamic Entrepreneurs of the 21st Century Book Release.
ExitCertified Corporation Receives Third Nomination for the Chamber of Commerce Awards.
ExitCertified Expands Apple relationship with the Addition of Authorized Mac OS Education Delivery in Phoenix, AZ.
 |
Oracle Database 11g: Introduction for Experienced SQL Users |
 |
|
| Format: Instructor-Led Classroom |
| Other Formats: |
|
|
|
|
|
|
| |
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.
This is appropriate for a 10g audience too. There are few minor changes between 10g and 11g features.
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 creati
|
|
|
|
|
|
|
|
 |
|
 |
Skills Gained |
| |
Describe the Oracle database environmentUse various features of SQL*DeveloperDescribe and work with the basic elements of Oracle SQL
| | Combine tables using joins and subqueriesCreate and manage tables, synonyms, sequences, indexes, and viewsImplement database security by granting privileges and creating roles
| |
|
|
|
|
Who Can Benefit |
| |
AdministratorApplication DevelopersDatabase AdministratorsForms Developer
| | PL/SQL DeveloperPortal DeveloperSystem AnalystsTechnical Consultant
| |
|
|
|
| |
 | This course is taught by Certified Oracle instructors.
Oracle University has awarded ExitCertified the 2009 Partner of the Year and Outstanding Instructor Quality Awards
There is a difference....learn more.  |
|
 |
| Code: |
11g-SQL-USER |
| Format: |
Instructor-Led Classroom |
|
| Length: |
2 |
| Certified By: |
Oracle |
|
|
|
|
| |
|
|
 | 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. |
|
|
|
Oracle Database 11g: Introduction for Experienced SQL Users Content Details |
| |
| |
| 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
| |
- 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
| |
- 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.
There is a difference. Learn from the source. |
|
|
 |
|
|
 |
|
