Database

This course offers a comprehensive introduction to Oracle Database 23c. You learn how to design, build and manage robust cloud based database applications with Oracle database tools. Oracle 23c is a large, complex system. This course provides an overview of the power and flexibility of Oracle databases and serves as the foundation for other courses in the Learning Tree Oracle Databases curriculum.

Course Description

Oracle Database 23c: 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.

This course will teach you about the Oracle Database architecture and you will discover how to effectively manage an Oracle Database instance. You will also be provided key information on how to install and administer Oracle Database 23c.

The Oracle Database 23c Administration Workshop II Release 2 training takes the database administrator beyond the basic tasks covered in the first workshop. You’ll begin by gaining a deep understanding of the most important responsibilities a DBA has such as performing backup and recovery, diagnosing and repairing data failures with Flashback technology etc

Who will benefit from this course? This course benefits a wide range of professionals, including:

• Developers, analysts, administrators, managers, programmers, consultants, power users and others who design and write Oracle applications using Oracle 23c
• Database administrators who want to become proficient in querying and manipulating an Oracle database
• Data processing professionals with experience working in a traditional database system (hierarchical or network), who are now moving to a client/server or Web environment Technology managers and project leaders who need a general overview of Oracle 23c

Certificate Earned

• Oracle Certified Associate (OCA), Oracle Certified Professional (OCP)

Career Prospects

• Database Administrator, Data Analyst, IT manager, IT Consultants

Course Outline

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

Duration:

• Weekdays: 4 Months
• Weekends: 5 Months