Oracle Database 23AI SQL Associate 1Z0-171
 
This course is the foundation for the Oracle Database SQL 1Z0-171 certification. It offers an in-depth exploration of the SELECT statement and essential concepts for controlling user access.
We'lll begin by installing Oracle Express Edition and Oracle SQL Developer—both provided for free. Next,we'lll dive into the six primary clauses of the SELECT statement: SELECT, FROM, WHERE, GROUP BY, HAVING, and ORDER BY. Understanding these clauses is crucial for mastering Oracle SQL.
As we progress,we'lll create tables and examine the importance of data types, including string, date, and number types, along with their respective functions.You'lll also learn how to convert between these types effectively.
 
Building on this foundation,we'lll revisit the SELECT statement in greater detail, exploring table creation and mastering table JOINs. By the end of this segment,you'lll have a solid grasp of the six SELECT statement clauses.
Next,we'lll address how to identify and handle missing data, as well as perform data updates and deletions.You'lll also learn about implicit and explicit transactions, constraints, and the roles of primary and foreign keys.We'lll then explore views, enabling you to save and reuse your queries. Moving beyond JOINs,you'lll learn how to combine rows from multiple tables using set operators such as UNION, INTERSECT, and MERGE.
 
Further,we'lll enhance SELECT queries with aggregate functions to calculate totals.You'll also gain expertise in subqueries, using them in the FROM, SELECT, WHERE, and WITH clauses, and explore self-joins for hierarchical data.
The course will then introduce TIME ZONE and INTERVAL data types and functions, SEQUENCES, and INDEXES. You'll also learn to navigate the Data Dictionary, create new users, and assign roles and privileges.
 
No prior knowledge of Oracle SQL is required. We'll guide you through the installation and setup of Oracle Database and SQL Developer step by step. By the end of the course, you'll be equipped to manipulate numbers, strings, and dates, create and manage databases and tables, insert and analyze data, and understand how these elements integrate within Oracle SQL.
 
Who this course is for:
Beginners with little to no experience in Oracle SQL.
Those seeking a refresher on SQL fundamentals.
No prior database experience is needed.
 
Requirements:
Basic computer skills and familiarity with spreadsheets.
A 64-bit machine for Oracle SQL installation.
Mac users will need to dual-boot Windows or use Parallel Desktop for installation.
What you'll learn:
Relational Database Concepts
Retrieving and Sorting Data using SELECT
Using SQL Functions
Displaying Data from Multiple Tables with SET Operators
Using Subqueries
Managing Indexes, Synonyms, and Sequences
Managing Tables and Relationships with DDL and DML
Controlling User Access
Navigating Data Dictionary Views and Time Zone Management
 
Explore the curriculum and embark on your journey to mastering Oracle SQL!