Semos Education Semos Education
  • Monday - Friday 9:00AM - 10:00PM
  • Call us now +44 7487633466
  • Keep in touch info@semosedu.com
EN / МК / RS
Кошничка
reserve a seat
  • Description
  • Content
  • Target Audience
  • Benefits
  • Certificates

This Oracle Database: Introduction to SQL training teaches you how to write subqueries, combine multiple queries into a
single query using SET operators and report aggregated data using group functions.

 

Expert Oracle University instructors will help you explore how to control privileges at the object and system level.

MODULE 1

Introduction to Oracle Database

 

MODULE 2

Retrieve Data Using the SQL SELECT Statement

 

MODULE 3

Learn to Restrict and Sort Data

 

MODULE 4

Usage of Single-Row Functions to Customize Output

 

MODULE 5

Invoke Conversion Functions and Conditional Expressions

 

MODULE 6

Aggregate Data Using the Group Functions

 

MODULE 7

Display Data From Multiple Tables Using Joins

 

MODULE 8

Use Sub-queries to Solve Queries

 

MODULE 9

The SET Operators

 

MODULE 10

Data Manipulation Statements

 

MODULE 11

Use of DDL Statements to Create and Manage Tables

 

MODULE 12

Other Schema Objects

 

MODULE 13

Control User Access

 

MODULE 14

Management of Schema Objects

 

MODULE 15

Manage Objects with Data Dictionary Views

 

MODULE 16

Manipulate Large Data Sets

 

MODULE 17

Data Management in Different Time Zones

 

MODULE 18

Retrieve Data Using Sub-queries

 

MODULE 19

Regular Expression Support

  • Application Developers
  • Business Analysts
  • Data Warehouse Administrator
  • Developer
  • Forms Developer
  • PL/SQL Developer
  • System Analysts

Benefits to You:

 

You’ll also learn to query and manipulate data within the database, use the dictionary views to retrieve metadata and create reports about their schema objects. Some of the date-time functions available in the Oracle Database are also covered.

 

 

Learn To:

 

  • Create reports of sorted and restricted data.
  • Run data manipulation statements (DML).
  • Control database access to specific objects.
  • Manage schema objects.
  • Manage objects with data dictionary views.
  • Retrieve data from tables.
  • Create indexes and constraints and alter existing schema objects.
  • Create and query external tables.
  • Use the regular expression support in SQL.

Course attendance certificate issued by Semos Education

Description

This Oracle Database: Introduction to SQL training teaches you how to write subqueries, combine multiple queries into a
single query using SET operators and report aggregated data using group functions.

 

Expert Oracle University instructors will help you explore how to control privileges at the object and system level.

Content

MODULE 1

Introduction to Oracle Database

 

MODULE 2

Retrieve Data Using the SQL SELECT Statement

 

MODULE 3

Learn to Restrict and Sort Data

 

MODULE 4

Usage of Single-Row Functions to Customize Output

 

MODULE 5

Invoke Conversion Functions and Conditional Expressions

 

MODULE 6

Aggregate Data Using the Group Functions

 

MODULE 7

Display Data From Multiple Tables Using Joins

 

MODULE 8

Use Sub-queries to Solve Queries

 

MODULE 9

The SET Operators

 

MODULE 10

Data Manipulation Statements

 

MODULE 11

Use of DDL Statements to Create and Manage Tables

 

MODULE 12

Other Schema Objects

 

MODULE 13

Control User Access

 

MODULE 14

Management of Schema Objects

 

MODULE 15

Manage Objects with Data Dictionary Views

 

MODULE 16

Manipulate Large Data Sets

 

MODULE 17

Data Management in Different Time Zones

 

MODULE 18

Retrieve Data Using Sub-queries

 

MODULE 19

Regular Expression Support

Target Audience
  • Application Developers
  • Business Analysts
  • Data Warehouse Administrator
  • Developer
  • Forms Developer
  • PL/SQL Developer
  • System Analysts
Benefits

Benefits to You:

 

You’ll also learn to query and manipulate data within the database, use the dictionary views to retrieve metadata and create reports about their schema objects. Some of the date-time functions available in the Oracle Database are also covered.

 

 

Learn To:

 

  • Create reports of sorted and restricted data.
  • Run data manipulation statements (DML).
  • Control database access to specific objects.
  • Manage schema objects.
  • Manage objects with data dictionary views.
  • Retrieve data from tables.
  • Create indexes and constraints and alter existing schema objects.
  • Create and query external tables.
  • Use the regular expression support in SQL.
Certificates

Course attendance certificate issued by Semos Education

Past experiences

What people say about us

  • - Marko Krstevski Microsoft .NET Academy

    Seeking to expand my knowledge, I decided to enroll in Semos Education, where I am gaining the necessary knowledge and experience.

  • - Teodor Markovski Student

    The desire to become a Cloud architect led me to Semos Education. I am thrilled by the positive experiences of former students and the way in which the instructors and Career Center take care of the students.

  • - Viktorija Georgieva Summer Mentorship Program for Python Develope

    The reputation of Semos Education for quality training and the opportunity to learn from experienced instructors played an additional significant role in my decision.

  • - Borche Peltekovski Accredited Academy for Graphic Design

    After completing my studies at Semos Education, I envision myself working in a technology company, such as Samsung, Apple, or a company of similar caliber.

  • - Vasilija Uzunova Oracle Certified Instructor

    For me, there was no other choice but Semos Education. I want to be part of the best, I want to share my knowledge in a company that is global, and ours.

Meet the instructors

  • Biljana Barukchieva  

    Senior project manager

    @Quinshift

     

    20+ years of experience