Oracle Database: Introduction to SQL

Beschreibung

This course will be delivered with a live lab

This course offers students an introduction to Oracle Database 19c database technology. In this class students learn the concepts of relational databases and the powerful SQL programming language. This course provides the essential SQL skills that allow developers to write queries against single and multiple tables, manipulate data in tables, and create database objects.

Objectives:

Learn how to:

  • Retrieve Data using the SQL SELECT Statement
  • Restrict and Sort Data
  • Customize Output Using Single-Row Functions
  • Use Conversion Functions and Conditional Expressions
  • Report Aggregated Data Using the Group Functions
  • Display Data from Multiple Tables Using Joins
  • Manage Tables by Using DML Statements
  • Create Sequences, Synonyms, Indexes, Views, and Schema Objects
  • Manage Data by Using Subqueries and Advanced Queries
  • Control User Access and Manage Data in Different Time Zones

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.

Zielgruppe / Vorkenntnisse

  • Data Warehouse-Administrator
  • PL/SQL-Entwickler
  • Systemanalytiker
  • Businessanalytiker
  • Formsentwickler
  • Entwickler

Empfehlenswerte verwandte Kurse:

  • Oracle Database: SQL and PL/SQL Fundamentals Ed 2

This Database SQL & PL/SQL Fundamentals training teaches you the fundamentals of relational databases, SQL & PL/SQL programming language. Learn to write queries against single and multiple tables, manipulate data in tables & create database objects.

  • Oracle Database: SQL and PL/SQL Fundamentals

This Database SQL & PL/SQL Fundamentals training teaches you the fundamentals of relational databases, SQL & PL/SQL programming language. Learn to write queries against single and multiple tables, manipulate data in tables & create database objects.

  • Oracle Database: Program with PL/SQL

Dieser Kurs zur Datenbankprogrammierung mit PL/SQL behandelt die Entwicklung von Stored Procedures, Stored Functions, Packages und Datenbanktriggern. Die Teilnehmer lernen die Verwaltung von PL/SQL-Programmeinheiten und Abhängigkeiten sowie den Einsatz einiger der von Oracle bereitgestellten Packages kennen.

  • Oracle Database: Program with PL/SQL Ed 2

This Database Program with PL/SQL training shows you how to develop stored procedures, functions, packages and database triggers. You'll learn to manage PL/SQL program units and dependencies, while using of some of the Oracle-supplied packages.

  • Oracle Database: Program with PL/SQL

This Database Program with PL/SQL training shows you how to develop stored procedures, functions, packages and database triggers. You'll learn to manage PL/SQL program units and dependencies, while using of some of the Oracle-supplied packages.

Kursinhalt

  • Introduction
  • Working with Oracle Cloud Exadata Express Cloud Service
  • Retrieving Data using the SQL SELECT Statement
  • Restricting and Sorting Data
  • Using Single-Row Functions to Customize Output
  • 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 Definition Language
  • Introduction to Data Dictionary Views
  • 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

Weitere Infos

Beginn:
Am ersten Kurstag um 10.00 Uhr: Ca. 15 Minuten sind vor Kursbeginn für die Registrierung vorgesehen. An den nachfolgenden Tagen sind die Kurszeiten von 9.00 - 17.00 Uhr

Schulungsdauer: 5 Tage
Schulungsart: Kurs durch Trainer
Sprache: Deutsch / Englisch

Enthaltene Leistungen:

  • Schulungsunterlagen stehen jedem Teilnehmer drei Monate online zur Verfügung (Hersteller-Angaben)

  • Teilnahmezertifikat

Kursdetails

Startdatum 08.04.2024 - 09:00
Enddatum 12.04.2024 - 17:00
Anmeldungsende 05.04.2024 - 23:00
Netto Einzelpreis € 3.650,00
Speaker Deutsch
Number Hours 09:00 - 17:00
Kurs-Nr. D80174: Oracle Database: PL/SQL Fundamentals
Ort Live Online
Abgeschlossen