Overview
This course is targeted at Developers and Database Administrators and begins with the concepts of a relational database and the SQL programming language. It includes writing queries against single and multiple tables, manipulate data in tables, and create database objects.
You’ll also learn how to create sequences, synonyms, indexes, and views, manage schema objects, and manage data using subqueries. Additionally, the course covers controlling User Access and managing data in different time zones.
Skills Covered
Learn to:
- Retrieve Data using the SQL SELECT Statement
- Restrict and Sort Data
- Customize Output Using Single-Row Functions
- Use Conversion Functions and Conditional Expressions
- Report Aggregated Data Using the Group Functions
- Display Data from Multiple Tables Using Joins
- Manage Tables by Using DML Statements
- Create Sequences, Synonyms, Indexes, Views, and Schema Objects
- Manage Data by Using Subqueries and Advanced Queries
- Control User Access and Manage Data in Different Time Zones
Who Should Attend
- Database Administrator
- Developer
Course Curriculum
Prerequisites
There are no prerequisites required to attend this course.
Download Course Syllabus
Course Modules
- Course Overview – Oracle Database 23ai: SQL Workshop
- Course Practice Environment: Security Credentials
- Oracle Database 23ai SQL New Features
- Returning clause of UPDATE and MERGE Statements, IF (NOT) EXISTS
- Overview of Oracle Database 23ai and Related Products
- Overview of Relational Database Management Concepts and Terminologies
- Human Resources (HR) Schema and the Tables Used in This Course
- Introduction to SQL and Its Development Environments
- Oracle Database 23ai SQL Documentation and Additional Resources
- Capabilities of SQL SELECT Statements
- Arithmetic Expressions and NULL Values in the SELECT statement
- Column Aliases
- Use of the Concatenation Operator, Literal Character Strings, Alternative Quote Operator, and the DISTINCT Keyword
- DESCRIBE Command
- Limiting Rows
- Rules of Precedence for Operators in an Expression
- Sorting Rows Using the ORDER BY Clause
- SQL Row Limiting Clause in a Query
- Substitution Variables in Oracle
- Assigning Values to Variables
- Practices for Lesson 3: Restricting and Sorting Data
- Single-Row SQL Functions
- Character Functions
- Nesting Functions
- Number Functions
- Working with Dates in Oracle Databases
- Date Functions
- Implicit and Explicit Data Type Conversion
- TO_CHAR, TO_DATE, and TO_NUMBER Functions in Oracle
- General Functions
- Conditional Expressions
- JSON Functions
- Reporting Aggregated Data Using the Group Functions/Group Functions
- Grouping Rows
- Nesting Group Functions
- Displaying Data from Multiple Tables Using Joins
- Natural Join
- Join with the USING Clause
- Join with the ON Clause
- Self-Join
- Nonequijoins
- Outer Join
- Cartesian Product
- Using Subqueries to Solve Queries
- Single-Row Subqueries
- Multiple-Row Subqueries
- Multiple-Column Subqueries
- Null Values in a Subquery
- Using Set Operators
- Tables Used in This Lesson
- UNION and UNION ALL Operators
- INTERSECT Operator
- MINUS Operator
- Matching SELECT Statements
- Using the ORDER BY Clause in Set Operations
- Managing Tables Using DML Statement
- Changing Data in a Table
- Removing Rows from a Table
- Database Transaction Control
- Read Consistency
- Manual Data Locking
- Introduction to Data Definition Language
- CREATE TABLE Statement
- Data Types
- Constraints: Overview
- Creating a Table by Using a Subquery
- ALTER TABLE Statement
- DROP TABLE Statement
- Introduction to Data Dictionary
- Querying the Dictionary Views
- Adding a Comment to a Table and Querying the Dictionary Views
- Create, Maintain, and Use Sequences
- Create Private and Public Synonyms
- Create and Maintain Indexes
- Creating Views
- Creating, Modifying, and Retrieving Data from a View
- Data Manipulation Language (DML) Operations on a View
- Dropping a View
- Managing Schema Objects
- Create and Use Temporary Tables
- Creating and Using External Tables
- Retrieving Data by Using a Subquery as a Source
- Writing a Multiple - Column Subquery
- Using Scalar Subqueries in SQL
- Solving Problems with Correlated Subqueries
- Using the EXISTS and NOT EXISTS Operators
- Using the WITH Clause
- Manipulating Data by Using Subqueries
- Inserting Values by Using a Subquery as a Target
- Using the WITH CHECK OPTION keyword on DML statements
- Using Correlated Subqueries to Update and Delete Rows
- Controlling User Access
- Creating a Role
- Object Privileges
- Revoking Object Privileges
- Manipulating Data Using Advanced Queries
- Multitable INSERTs
- Merging Rows in a Table
- Performing Flashback Operations
- Tracking the Changes in Data Over a Period of Time
- Managing Data in Different Time Zones
- INTERVAL Data Types
- Aggregation over INTERVAL types
- Additional Date Functions
- SYSDATE and SYSTIMESTAMP Data Handling
Request More Information
Training Options
- ILT: Instructor-Led Training
- VILT: Virtual Instructor-Led Training
RM6,500.00Enroll Now
RM6,500.00Enroll Now
RM6,500.00Enroll Now
RM6,500.00Enroll Now
RM6,500.00Enroll Now
RM6,500.00Enroll Now
Exam & Certification
Oracle Database 23ai SQL Associate (1Z0-171).
Training & Certification Guide
With Oracle Cloud Infrastructure (OCI) emerging as a leader in the 2024 Gartner® Magic Quadrant™ for Strategic Cloud Platform Services, the platform presents an unparalleled opportunity for professionals to advance their careers. Beyond the technology, OCI represents a gateway to being part of a future where cloud computing defines how organizations operate, innovate, and succeed.
But why is upskilling in OCI so crucial now? Let’s explore the unique advantages of Oracle’s cloud solutions, the opportunities they unlock, and how they align with Malaysia’s booming cloud ecosystem.
Empower Your Career: How Oracle Helps You Thrive in Cloud and AI
According to Malaysia’s Ministry of Human Resources, nearly 4.5 million jobs in Malaysia could be affected by automation by 2030, emphasizing the need for urgent workforce reskilling (Ministry of Human Resources Malaysia, 2022). The rapid rise of cloud computing and AI is transforming the IT landscape, making upskilling more crucial than ever.
At Trainocate Malaysia, we understand the challenges IT professionals face—keeping up with innovations, staying competitive, and navigating the ever-changing demands of the industry. That’s why we offer Oracle-authorized training, giving you the skills and certifications needed to thrive in the digital era.
In this blog, we’ll explore how Trainocate Malaysia can help you stay ahead, enhance your expertise, and take your career to the next level.
