Oracle Database: SQL Workshop I Ed 2

loading..

loading..
or GET IT WITH SATVs

The Oracle Database: SQL Workshop I Ed 2 course offers students an introduction to Oracle Database 12c database technology. The students are also introduced to Oracle Database Exadata Express Cloud Service. In this class students learn the concepts of relational databases and the powerful SQL programming language. 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.

Lessons

  • Capabilities of the SELECT statement
  • Arithmetic expressions and NULL values in the SELECT statement
  • Column aliases
  • Use of concatenation operator, literal character strings, alternative quote operator, and the DISTINCT keyword
  • Use of the DESCRIBE command

Lessons

  • Limiting the Rows
  • Rules of precedence for operators in an expression
  • Sorting rows using ORDER BY clause
  • SQL row limiting clause in a query
  • Substitution Variables
  • Using the DEFINE and VERIFY command

Lessons

  • Describe the differences between single row and multiple row functions
  • Manipulate strings with character function in the SELECT and WHERE clauses
  • Nesting Functions
  • Manipulate numbers with the ROUND, TRUNC and MOD functions
  • Perform arithmetic with date data
  • Manipulate dates with the date functions

Lessons

  • Describe implicit and explicit data type conversion
  • Use the TO_CHAR, TO_NUMBER, and TO_DATE conversion functions
  • Apply the NVL, NULLIF, and COALESCE functions to data
  • Conditional Expressions

Lessons

  • Group Functions
  • Grouping Rows (GROUP BY and HAVING clause)
  • Nesting Group Functions

Lessons

  • Introduction to JOINS
  • Types of Joins
  • Natural join
  • Self-join
  • Nonequijoins
  • OUTER join
  • Cartesian product

Lessons

  • Introduction to Subqueries
  • Single Row Subqueries
  • Multiple Row Subqueries
  • Null values in a subquery

Lessons

  • Set Operators
  • UNION and UNION ALL operator
  • INTERSECT operator
  • MINUS operator
  • Matching the SELECT statements
  • Using ORDER BY clause in set operations

Lessons

  • Data Manipulation Language
  • Database Transactions
  • Manual Data Locking

Lessons

  • Database Objects
  • CREATE TABLE statement
  • Data types
  • Overview of constraint
  • Creating a table using subquery
  • Use the ALTER TABLE statement to add, modify, and drop a column
  • DROP TABLE statement

•Application Developers•Database Administrators•System Analysts•Forms Developer•Functional Implementer•PL/SQL Developer

•Required Prerequisites:•Familiarity with data processing concepts and techniques•Familiarity with programming language

After completing this course, students will be able to:

Register

In Class

    Show all

    In Class

      Show all

      In Class

        Show all

        In Class

          Show all

          OnlineLive

            Show all

            Connected Classroom

              Show all

              Not currently scheduled

              Fast track the availability of this course.
              Add to watch list or call 1300 794 006.

              Need your team upskilled?
              Request a Quote
              blah is false
              top