UNIRAC.IN

We offer world class Oracle SQL Online Training.
Actual Price : 12000Rs/- 10000/-

None

Data analyst

Database administrator

Database developer

Database designer

Power BI

Business Intelligence

Become an Oracle Database SQL Certified Associate and demonstrate understanding of fundamental SQL concepts needed to undertake any database project. Passing the exam illustrates depth of knowledge of SQL and its use when working with the Oracle Database server. Gain a working knowledge of queries , insert, update and delete SQL statements as well as some Data Definition language and Data Control Language, the optimizer, tales and indexes, data modeling and normalization. By passing this exam, a certified individual proves fluency in and a solid understanding of SQL language, data modeling and using SQL to create amd manipulate tables in an Oracle Database.

Introduction Relational Database Design Using Oracle

Position the Server Technologies

Understand Relational Structures

Create the Demonstration Schemas

Data Retrieval Using the SQL SELECT Statement

List the Capabilities of SQL SELECT Statements

Execute a Basic SELECT Statement

Restricting and Sorting Data

Limit the Rows Retrieved by a Query

Sort the Rows Retrieved by a Query

Ampersand Substitution

Single-Row Functions

Describe Various Types of Functions Available in SQL

Use Character, Number, and Date Functions in SELECT Statements

Using Conversion Functions and Conditional Expressions

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

Reporting Aggregated Data Using the Group Functions

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

Displaying Data from Multiple Tables

Write SELECT Statements to Access Data from More Than One Table Using Equijoins and Nonequijoins

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

Using Subqueries to Solve Problems

Define Subqueries

Describe the Types of Problems That the Subqueries Can Solve

List the Types of Subqueries

Write Single-Row and Multiple-Row Subqueries

Using the Set Operators

Describe the Set Operators

Use a Set Operator to Combine Multiple Queries into a Single Query

Control the Order of Rows Returned

Manipulating Data

Describe Each Data Manipulation Language (DML)Statement

Inserting rows into a table

Update rows in a table

Delete rows in a table

Control Transactions

DML Statement Failures

Using DDL Statements to Create and Manage Tables

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

Working with

Sequences

Synonyms

Indexes

Views

DCL,TCL commands

USer Management