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.

Learn To

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.

• Understand the basic concepts of relational databases to 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.

Audience

• Administrator

• Analyst

• Developer

• Systems Administrator

Course Objectives

• Identify the major structural components of the Oracle Database

• Create reports of aggregated data

• Write SELECT statements that include queries

• Retrieve row and column data from tables

• Run data manipulation statements (DML) in Oracle Database 12c

• Create tables to store data

• Utilize views to display data

• Control database access to specific objects

• Manage schema objects