Oracle Database Administration: Introduction to SQL

This course requires the following;

• Familiarity with data processing concepts and techniques
• Data processing

You will learn how to:

• 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

This course covers the following;

• Working with Oracle Cloud Exadata Express Cloud Service
• Retrieving Data using the SQL SELECT Statement
• Restricting and Sorting Data
• Using the DEFINE and VERIFY command
• 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 Dictionary Views
• Introduction to Data Dictionary
• 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

This course prepares you for the following certifications:

• Oracle Certified Associate (OCA) – (Database Admin)