Oracle Database Administration: Introduction to SQL – Institute of Software Technologies

Oracle Database Administration: Introduction to SQL

Oracle Database Administration: Introduction to SQL

This Intro to SQL training teaches you basic concepts of relational databases and the SQL programming language. You'll gain essential SQL skills to write queries against single & multiple tables, manipulate data in tables & create database objects.

This course requires the following;

  • Familiarity with data processing concepts and techniques
  • Data processing

You will learn how to:

  • Identify the major structural components of the Oracle Database 12c
  • Manage objects with data dictionary views
  • Manage schema objects
  • Retrieve row and column data from tables
  • Run data manipulation statements (DML) in Oracle Database 12c
  • Use scalar and correlated sub-queries
  • Utilize views to display data
  • Write SELECT statements that include queries
  • Write multiple-column sub-queries
  • Control database access to specific objects
  • Create reports of aggregated data
  • Create reports of sorted and restricted data
  • Create tables to store data
  • Display data from multiple tables using the ANSI SQL 99 JOIN syntax
  • Employ SQL functions to retrieve customized data

This course covers the following;

  • Working with Oracle Cloud Exadata Express Cloud Service
  • Retrieving Data using the SQL SELECT Statement
  • Restricting and Sorting Data
  • Using the DEFINE and VERIFY command
  • Using Conversion Functions and Conditional Expressions
  • Reporting Aggregated Data Using the Group Functions
  • Displaying Data from Multiple Tables Using Joins
  • Using Subqueries to Solve Queries
  • Using the SET Operators
  • Managing Tables using DML statements
  • Introduction to Data Dictionary Views
  • Introduction to Data Dictionary
  • Creating Sequences, Synonyms, Indexes
  • Creating Views
  • Managing Schema Objects
  • Retrieving Data by Using Subqueries
  • Manipulating Data by Using Subqueries
  • Controlling User Access
  • Manipulating Data
  • Managing Data in Different Time Zones

This course prepares you for the following certifications:

  • Oracle Certified Associate (OCA) – (Database Admin)

How you will be assessed?

Theory
50%
Practical
50%
Exam
50%

Deadline

7th Feb 2020

Deadline

7th March 2020

Deadline

7th Sept 2020