fbpx

Oracle Courses

Introduction to SQL

20
overview
Topics
Prerequisites
Objectives
Certification
overview

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.

Topics
  • Introduction
  • 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
Prerequisites
  • Familiarity with data processing concepts and techniques
  • Data processing
Objectives

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
Certification

This course prepares you for the following certifications:

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

Programme

At Institute of Software Technologies, we have flexible training schedule that suit your availability.

You can choose from the following available options:

FLY me a trainer

We have conducted onsite trainings for corporate clients all over the world including in over 100 companies in Kenya, Uganda, Tanzania, Rwanda, Zambia, Somalia, Ethiopia, South Sudan, Zanzibar, Malawi, Mozambique, Ghana, Nigeria, Sierra Leone, just to mention a few. References can be provided on request.

Fly me a Trainer is no different from classroom training, since it consists of the same setup. The only difference is that the trainer travels instead of the participants.

Apply Now For Our Next Intake

Website Enquiry

Relative Courses

Programing

SQL Fundamentals

SUSE Linux

Server Administration

VMware Courses

VMware – Foundation Course

Security Courses

Certified Chief Information Security Officer (CCISO)

Security Courses

EC-council Certified Security Analyst (ECSA)

VMware Courses

VMware Data Center Virtualization Course

Programing

PL/SQL

Adobe Certification

Dreamweaver

Adobe Certification

Flash Professional

Adobe Certification

Adobe Photoshop

Programing

ZEND PHP

Oracle Database 12c R2: Program with PL/SQL Ed 2

0 student

Oracle Database 12c: Backup & Recovery Workshop

0 student
Programing

PHP

Security Courses

Computer Hacking Forensic Investigator Certification

Oracle Courses

Oracle Database 11g: Administration Workshop I

UNIX and Linux Essentials

0 student

E-Business Suite Financial Management Training and Certification

0 student

Oracle Cash Management Fundamentals

0 student

Oracle E-Business Tax Fundamentals

0 student
Security Courses

Licensed Penetration Tester (LPT)

Oracle General Ledger Management Fundamentals

0 student

Oracle Inventory Management Fundamentals

0 student
Adobe Certification

Adobe Illustrator

Oracle iProcurement Fundamentals

0 student
Oracle Courses

Oracle Database 11g: Administration Workshop II

Oracle Order Management Fundamentals

0 student
Adobe Certification

Adobe InDesign

Short Courses

Corel Draw

Oracle Courses

Oracle Database 11g: Performance Tuning

Security Courses

Certified Network Defender Certification (CND)

Short Courses

ICDL Certification

Management

ITIL 2011 Foundation

Programing

Core Java

J2EE Architecture & JSP

Oracle Courses

Oracle Database 12c: Managing Multitenant Architecture

Programing

SQL / EJB&RM

Oracle Courses

Oracle Database 12c: Install and Upgrade Workshop

Oracle Courses

Data Modeling & Relational Database Design

Oracle Courses

Oracle 10g Forms Developer: Build Internet Apps

Oracle Courses

Oracle Reports Developer 10g: Build Reports

Microsoft

Administering Windows Server 2012

Android Application Development

Diploma Courses

Diploma in Database Administration & Application Development

Microsoft

Installing and Configuring Server

Diploma Courses

Diploma in Information Security & Ethical Hacking

Microsoft

Configuring Advanced Windows Server

Programing

Python

Management

PRINCE2

Oracle Courses

Oracle Solaris 10 OS Part 1

Microsoft

Designing and Implementing a Server Infrastructure

Red Hat

System Administration III With RHCSA & RHCE

Red Hat

System Administration II With RHCSA

Red Hat

RHCSA Rapid Track

Red Hat

System Administration I

Oracle Courses

Oracle Solaris 10 OS Part 1

Oracle Courses

Oracle Solaris 10 OS Part 2

Microsoft

Implementing an Advanced Server Infrastructure

Oracle Courses

Oracle Solaris 10 OS Essentials

SUSE Linux

Linux Enterprise

Short Courses

Appin Front Runner

Security Courses

Certified Ethical Hacker Certification (CEH)

SUSE Linux

SUSE Linux Enterprise 11 Administration