Oracle Database: Introduction to SQL

Kursziele

• 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

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.

Kurssparche: Deutsch

Enthaltene Leistungen:

• Schulungsunterlagen
• Teilnahmezertifikat
• Getränke (Kalte und Warme)
• Obst und Snacks
• Mittagessen