Oracle Database: SQL Workshop (sf) (synchronous E-Learning)

• Identify the major components of an Oracle Database
• Retrieve row and column data from tables with the SELECT statements.
• Create reports of sorted and restricted data
• Employ SQL Functions to generate and retrieve customized data
• Run complex queries to retrieve data from multiple tables
• Run data manipulation language (DML) statements to update data in Oracle Database
• Run data definition language (DDL) statements to create and manage schema objects
• Manage objects with data dictionary views
• Create schema objects
• Manage schema objects
• Write multiple-column subqueries
• Use scalar and correlated subqueries
• Control user access to specific database objects
• Add new users with different levels of access privileges
• Manipulate large data sets in the Oracle database by using subqueries
• Manage data in different time zones

What You'll Learn

The Oracle Database: SQL Workshop 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.

Minimum Entry Requirement

• Some familiarity with basic file system navigation, browser, and other tools usage.
• Preferably from simple math's or analytical background (not mandatory).
• No prior coding experience is required.
• Non-IT domain users switching to IT.