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 helps you write subqueries, combine multiple queries into a single query using SET operators and report aggregated data using group functions. Learn this and more through hands-on exercises.

MODULE 1

Introduction

 

MODULE 2

Working with Oracle Cloud Exadata Express Cloud Service

 

MODULE 3

Retrieving Data using the SQL SELECT Statement

 

MODULE 4

Restricting and Sorting Data

 

MODULE 5

Using Single-Row Functions to Customize Output

 

MODULE 6

Using Conversion Functions and Conditional Expressions

 

MODULE 7

Reporting Aggregated Data Using the Group Functions

 

MODULE 8

Displaying Data from Multiple Tables Using Joins

 

MODULE 9

Using Subqueries to Solve Queries

 

MODULE 10

Using the SET Operators

 

MODULE 11

Managing Tables using DML statements

 

MODULE 12

Introduction to Data Definition Language

 

MODULE 13

Introduction to Data Dictionary Views

 

MODULE 14

Creating Sequences, Synonyms, Indexes

 

MODULE 15

Creating Views

 

MODULE 16

Managing Schema Objects

 

MODULE 17

Retrieving Data by Using Subqueries

 

MODULE 18

Manipulating Data by Using Subqueries

 

MODULE 19

Controlling User Access

 

MODULE 20

Manipulating Data

 

MODULE 21

Managing Data in Different Time Zones

  • Administrator
  • Architect
  • Database Administrator

Benefits to You:

 

  • Ensure fast, reliable, secure and easy to manage performance.
  • Optimize database workloads, lower IT costs and deliver a higher quality of service by enabling consolidation onto database clouds.
  • Learn Advanced Features of SQLThis course will help you understand the advanced features of SQL.
  • Learning these features will help you 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:

 

  • Understand the basic concepts of relational databases ensure refined code by developers.
  • 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 row and column data from tables.
  • Control privileges at the object and system level.
  • Create indexes and constraints; alter existing schema objects.
  • Create and query external tables.

Course attendance certificate issued by Semos Education

Description

This Oracle Database: Introduction to SQL training helps you write subqueries, combine multiple queries into a single query using SET operators and report aggregated data using group functions. Learn this and more through hands-on exercises.

Content

MODULE 1

Introduction

 

MODULE 2

Working with Oracle Cloud Exadata Express Cloud Service

 

MODULE 3

Retrieving Data using the SQL SELECT Statement

 

MODULE 4

Restricting and Sorting Data

 

MODULE 5

Using Single-Row Functions to Customize Output

 

MODULE 6

Using Conversion Functions and Conditional Expressions

 

MODULE 7

Reporting Aggregated Data Using the Group Functions

 

MODULE 8

Displaying Data from Multiple Tables Using Joins

 

MODULE 9

Using Subqueries to Solve Queries

 

MODULE 10

Using the SET Operators

 

MODULE 11

Managing Tables using DML statements

 

MODULE 12

Introduction to Data Definition Language

 

MODULE 13

Introduction to Data Dictionary Views

 

MODULE 14

Creating Sequences, Synonyms, Indexes

 

MODULE 15

Creating Views

 

MODULE 16

Managing Schema Objects

 

MODULE 17

Retrieving Data by Using Subqueries

 

MODULE 18

Manipulating Data by Using Subqueries

 

MODULE 19

Controlling User Access

 

MODULE 20

Manipulating Data

 

MODULE 21

Managing Data in Different Time Zones

Target Audience
  • Administrator
  • Architect
  • Database Administrator
Benefits

Benefits to You:

 

  • Ensure fast, reliable, secure and easy to manage performance.
  • Optimize database workloads, lower IT costs and deliver a higher quality of service by enabling consolidation onto database clouds.
  • Learn Advanced Features of SQLThis course will help you understand the advanced features of SQL.
  • Learning these features will help you 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:

 

  • Understand the basic concepts of relational databases ensure refined code by developers.
  • 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 row and column data from tables.
  • Control privileges at the object and system level.
  • Create indexes and constraints; alter existing schema objects.
  • Create and query external tables.
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