title
Please take a moment to fill out this form. We will get back to you as soon as possible.
All fields marked with an asterisk (*) are mandatory.
Introduction to Oracle Database 12c and SQL
Course Description
Overview
This course is designed for beginners: developers who are not experienced with Oracle Database and need to know how to query, update and create basic objects in Oracle databases.Students receive a comprehensive introduction to Oracle’s implementation of the SQL language and use common query tools such as SQL*Plus, SQL Developer, TOAD, etc. to do course workshops to reinforce all concepts.
Objectives
Audience
- Developers
Prerequisites
- Familiarity with Information Technology concepts and experience using computer applications. Having experience with a programming language is helpful but not required.
Topics
- Position the Server Technologies
- Understand Relational Structures
- Summarize the SQL Language
- Use the Client Tools
- Review the schemas to be used for workshops
- List the Capabilities of SQL SELECT Statements
- Execute a Basic SELECT Statement
- Limit the Rows Retrieved by a Query
- Sort the Rows Retrieved by a Query
- Ampersand Substitution
- Describe Various Types of Functions Available in SQL
- Use Character, Number, and Date Functions in SELECT Statements
- Describe Various Types of Conversion Functions Available in SQL
- Use the TO_CHAR, TO_NUMBER, and TO_DATE Conversion Functions
- Apply Conditional Expressions in a SELECT Statement
- Describe the Group Functions
- Identify the Available Group Functions
- Group Data Using the GROUP BY Clause
- Include or Exclude Grouped Rows Using the HAVING Clause
- Write SELECT Statements to Access Data from More Than One Table Using Equijoins and
- Non-equijoins
- Join a Table to itself Using a Self-join
- View Data that Does Not Meet a Join Condition Using Outer Joins
- Generate a Cartesian Product of Two or More Tables
- Define Subqueries
- Describe the Types of Problems That the Subqueries Can Solve
- List the Types of Subqueries
- Write Single-row and Multiple-row Subqueries
- Describe the Set Operators
- Use a Set Operators to Combine Multiple Queries into a Single Query
- Control the Order of Rows Returned
- Describe Each Data Manipulation Language (DML) Statement
- Insert Rows into Tables
- Update Rows in a Table
- Delete Rows from a Table
- Control Transactionson
- Categorize the Main Database Objects
- Review the Table Structure
- List the Data Types That Are Available for Columns
- Create a Simple Table
- Explain How Constraints Are Created at the Time of Table Creation
Related Courses
-
Oracle Database 12c: SQL II - Intermediate
DBOR-951- Duration: 3 Days
- Delivery Format: Classroom Training, Online Training
- Price: 2,100.00 USD
-
Oracle Database 12c: Architecture & Internals
DBOR-956- Duration: 3 Days
- Delivery Format: Classroom Training, Online Training
- Price: 2,100.00 USD
Self-Paced Training Info
Learn at your own pace with anytime, anywhere training
- Same in-demand topics as instructor-led public and private classes.
- Standalone learning or supplemental reinforcement.
- e-Learning content varies by course and technology.
- View the Self-Paced version of this outline and what is included in the SPVC course.
- Learn more about e-Learning
Course Added To Shopping Cart
bla
bla
bla
bla
bla
bla
Self-Paced Training Terms & Conditions
Exam Terms & Conditions
Sorry, there are no classes that meet your criteria.
Please contact us to schedule a class.
STOP! Before You Leave
Save 0% on this course!
Take advantage of our online-only offer & save 0% on any course !
Promo Code skip0 will be applied to your registration
Purchase Information
title
Please take a moment to fill out this form. We will get back to you as soon as possible.
All fields marked with an asterisk (*) are mandatory.