1Z0-071 Oracle SQL Developer: Certified Associate (Database) from Udemy

This course is the foundation for the Oracle Database SQL 1Z0-071 certification. It covers the SELECT statement in detail, with additional requirements for controlling user access. It is divided into 6 sessions, each of which should take a morning or afternoon to complete.

What do people like you say about this course?

Prashant says: "Course has been designed in way that a person with no knowledge of Oracle can understand it. Good learning and thanks a lot for making such nice course."

Shubho says: "Awesome course. The instructor explains the concepts very thorougly and in a easy-to-grasp way. Also, the practice exercises are super helpful. If you want to master Oracle SQL, this is the course for you."

Henry says: "I want to thank Phillip for this formidable course. This course along with other materials helped me to pass the 1Z0-071 Exam last Saturday."

Session 1

We'll install for free Oracle Express Edition and Oracle SQL Developer. Then we'll take a look at the 6 principal clauses of the SELECT statement:

Then we'll start creating tables, but find that we can't get very far without understanding data types. We'll then look at string, date and number types and functions, together with looking at functions converting between them.

Session 2

We'll revisit the SELECT statement and go into more detail. We'll create tables and JOIN them together. Once you have finished this session, you should be secure in your knowledge of the 6 principal clauses of the SELECT statement, the most important part of Oracle SQL.

Session 3

In session 3, we'll looking for missing data, and find out how to delete and update data. We'll look at the difference between implicit and explicit transactions, and various constraints, including primary and foreign keys.

Session 4

We'll start off by saving our queries in views. Then we'll combine tables, not by adding additional columns using JOINS, but adding additional rows such Oracle SQL set operators such as Then we'll look at analytical functions using the OVER clause.

Session 5

Session 5 starts off by adding totals to our SELECT queries. We'll then look at subqueries, and how you can add them into the Finally, we'll look at Oracle SQL self-joins, which are useful when you have hierarchies.

Session 6

Session 6 starts off with two additional data types, TIME ZONE and We'll then have a look at SEQUENCEs and INDEXes, together with how these are shown in the Data Dictionary. We'll then create new users, and assign privileges and roles to them, and we'll finish with the last few requirements for the exam.

No prior knowledge is required - we'll even install Oracle Database and Oracle SQL Developer on your computer for free.

Once finished, you will know what how to manipulate numbers, strings and dates, and create database and tables, create tables, insert data and create analyses, and have an appreciation of how they can all be used in Oracle SQL.

What's inside

Learning objectives

Create tables in a database and alter columns in the table.
Know what data type to use in various situations, and use functions to manipulate date, number and string data values.
Retrieve data using select, from, where, group by, having and order by.
Join two or more tables together, finding missing data.
Insert new data, update and delete existing data, and export data into a new table.

Create constraints, views and sequences, subqueries and ctes
Use union, case, merge and error checking
Apply ranking and analytic functions, grouping
Learn about transactions, indexes, users, privileges, roles and more

Create tables in a database and alter columns in the table.
Know what data type to use in various situations, and use functions to manipulate date, number and string data values.
Retrieve data using select, from, where, group by, having and order by.
Join two or more tables together, finding missing data.
Insert new data, update and delete existing data, and export data into a new table.
Create constraints, views and sequences, subqueries and ctes
Use union, case, merge and error checking
Apply ranking and analytic functions, grouping
Learn about transactions, indexes, users, privileges, roles and more

Syllabus

Introduction

Welcome to Udemy

The Udemy Interface

Do you want auto-translated subtitles in more languages?

Now it's your turn.

This exercise is to practice writing a query, and creating simple mathematical expressions.

NVL, NVL2, NULLIF and COALESCE

Traffic lights

Read about what's good

what should give you pause

and possible dealbreakers

Develops foundational skills in querying an Oracle database using SQL and Oracle SQL Developer

Taught by Phillip Burton, recognized for his work in Oracle SQL

Provides a comprehensive foundation for the Oracle Database SQL certification 1Z0-071

Covers advanced SQL concepts such as subqueries and analytical functions

Requires prior knowledge of Oracle Express Edition and Oracle SQL Developer

Does not provide hands-on labs or interactive materials

Reviews summary

Oracle sql 1z0-071 exam prep

Based on typical feedback for this type of course, learners say this program is a highly effective preparation tool for the 1Z0-071 Oracle SQL Developer Certified Associate exam. It is often highlighted as being suitable for beginners with no prior SQL knowledge, thanks to clear explanations and a logical structure. The practice exercises are frequently mentioned as being very helpful for reinforcing concepts. While the core content is well-received, some learners note that setting up the required software (Oracle XE and SQL Developer) can sometimes be a challenging initial step. The course focuses squarely on covering the exam objectives, meaning it provides sufficient depth for certification but may not delve into advanced topics as deeply as some intermediate users might hope.

Starts simple, suitable for no prior SQL knowledge.

"Course has been designed in way that a person with no knowledge of Oracle can understand it."

"Great starting point for someone completely new to SQL and Oracle databases."

"Very easy to follow even without any database background."

"Breaks down concepts simply enough for a complete beginner."

Practice activities reinforce learning effectively.

"Also, the practice exercises are super helpful."

"The hands-on activities and practice problems solidified my understanding."

"Enjoyed the exercises after each section; they really helped apply the concepts."

"Found the practice activities valuable for retaining information."

Instructor explains concepts in an easy-to-grasp way.

"The instructor explains the concepts very thorougly and in an easy-to-grasp way."

"Explanations are clear and concise, making complex ideas understandable."

"The way the instructor presents the information is excellent and easy to digest."

"Found the instructor's delivery and explanations very helpful."

Highly effective for 1Z0-071 certification.

"This course along with other materials helped me to pass the 1Z0-071 Exam last Saturday."

"Covers all the necessary topics to be well-prepared for the 1Z0-071 exam."

"I feel confident after this course that I can pass the Oracle SQL certification test."

"Excellent content aligned with the 1Z0-071 certification objectives."

Sufficient for exam, may lack advanced detail.

"Covers the exam objectives well, but don't expect a deep dive into every topic."

"Adequate for the associate certification level, perhaps too basic for experienced users."

"The course focuses on breadth for the exam rather than deep dives into specific functions."

"I felt the depth was just right for the exam requirements."

Setting up software can be tricky.

"Struggled quite a bit with the installation part of Oracle XE and SQL Developer."

"The initial setup instructions could be a bit clearer or updated."

"Had some issues getting the software installed correctly before starting."

"Getting the environment ready was the most challenging step for me."

Activities

Be better prepared before your course. Deepen your understanding during and after it. Supplement your coursework and achieve mastery of the topics covered in 1Z0-071 Oracle SQL Developer: Certified Associate (Database) with these activities:

Review SQL SELECT clauses

Show steps

Reviewing SQL SELECT clauses will help solidify your understanding of the building blocks of SQL queries.

Browse courses on Oracle SQL

Show steps

Start by reviewing the syntax of the SELECT clause.
Practice writing SELECT queries for various data types.
Test your understanding by completing practice problems.

Read 'Oracle Database 12c SQL'

Show steps

Supplement your learning by reading a book dedicated to Oracle Database SQL.

View Oracle Database 12c The Complete Reference... on Amazon

Show steps

Purchase or borrow the book.
Read through the chapters relevant to the course topics.
Take notes and highlight important concepts.

Follow tutorials on data types and their usage

Show steps

Supplement the course material and enhance understanding of different data types used in SQL.

Browse courses on Data Types

Show steps

Search online for tutorials on data types in Oracle SQL
Follow the steps in the tutorials to create tables and insert data
Experiment with different data types to understand their properties
Attempt practice exercises to solidify learning
Review the course material on data types for reinforcement

Nine other activities

Expand to see all activities and additional details

Show all 12 activities

Follow tutorials on Oracle SQL

Show steps

Following tutorials on Oracle SQL will allow you to learn from experts and reinforce your understanding of the concepts.

Browse courses on Oracle SQL

Show steps

Search for tutorials that cover the core concepts of Oracle SQL.
Work through the tutorials step-by-step and try the practice exercises.
Take notes on the key concepts and examples provided in the tutorials.

Follow tutorials on data types and constraints in Oracle SQL

Show steps

Deepen your understanding of data types and constraints by following guided tutorials.

Browse courses on Data Types

Show steps

Find online tutorials on data types and constraints in Oracle SQL.
Follow the tutorials to learn about different data types and constraints.

Practice SQL queries

Show steps

Reinforce SQL skills and improve proficiency in writing queries.

Browse courses on SQL

Show steps

Create a table in Oracle SQL Developer
Insert data into the table
Write a query to select specific columns from the table
Practice joining tables together
Use aggregate functions to summarize data

Practice SELECT, INSERT, UPDATE, DELETE & JOIN queries

Show steps

Reinforce your understanding of the fundamental SQL operations by practicing writing queries.

Browse courses on SQL Queries

Show steps

Create a sample database and tables.
Write SQL queries to perform data manipulation operations (SELECT, INSERT, UPDATE, DELETE).
Write SQL queries to join multiple tables.

Create a cheat sheet of SQL functions

Show steps

Solidify your knowledge of SQL functions by creating a handy reference guide.

Browse courses on SQL Functions

Show steps

List down all the SQL functions covered in the course.
Provide a brief description and syntax for each function.

Join a study group for Oracle SQL

Show steps

Collaborate with fellow learners by joining a study group to discuss concepts and practice queries.

Browse courses on Oracle SQL

Show steps

Find or create a study group focused on Oracle SQL.
Meet regularly to discuss course materials, work on assignments together, and prepare for assessments.

Create a data visualization of your Oracle SQL project results

Show steps

Showcase your understanding of data analysis by creating a visually appealing representation of your project findings.

Browse courses on Data Visualization

Show steps

Choose an appropriate data visualization tool.
Import your Oracle SQL project data into the tool.
Create a data visualization that effectively communicates your findings.

Attend a workshop on advanced Oracle SQL techniques

Show steps

Expand your knowledge and skills by attending a workshop focused on advanced Oracle SQL techniques.

Browse courses on Oracle SQL

Show steps

Identify a workshop that aligns with your learning goals.
Register for the workshop.
Attend the workshop and actively participate in the sessions.

Participate in a SQL coding competition

Show steps

Test your problem-solving abilities and enhance your competitive edge by participating in a SQL coding competition.

Browse courses on SQL

Show steps

Find a SQL coding competition that interests you.
Register for the competition and familiarize yourself with the rules.
Complete the competition and submit your solutions.

Career center

Learners who complete 1Z0-071 Oracle SQL Developer: Certified Associate (Database) will develop knowledge and skills that may be useful to these careers:

Data Analyst

Data analysts sift through data to uncover insights that can help businesses make better decisions. This course can help you develop the skills needed to succeed in this role, including data manipulation, analysis, and visualization. You'll learn how to use SQL to extract and analyze data, and how to use statistical techniques to identify trends and patterns. You'll also learn how to communicate your findings effectively to stakeholders.

See salaries and explore the career path for Data Analyst

Database Administrator

Database administrators are responsible for the day-to-day operation and maintenance of databases. This course can help you develop the skills needed to succeed in this role, including database design, implementation, and performance tuning. You'll learn how to use SQL to create and manage databases, and how to use database management tools to monitor and maintain database performance.

See salaries and explore the career path for Database Administrator

Data Scientist

Data scientists use data to solve business problems. This course can help you develop the skills needed to succeed in this role, including data mining, machine learning, and statistical modeling. You'll learn how to use SQL to extract and analyze data, and how to use statistical and machine learning techniques to build predictive models.

See salaries and explore the career path for Data Scientist

Software Engineer

Software engineers design, develop, and maintain software applications. This course can help you develop the skills needed to succeed in this role, including software design, development, and testing. You'll learn how to use SQL to interact with databases, and how to use software development tools to build and test software applications.

See salaries and explore the career path for Software Engineer

Business Analyst

Business analysts help businesses understand their data and make better decisions. This course can help you develop the skills needed to succeed in this role, including data analysis, visualization, and communication. You'll learn how to use SQL to extract and analyze data, and how to use data visualization tools to communicate your findings effectively to stakeholders.

See salaries and explore the career path for Business Analyst

IT Consultant

IT consultants help businesses with their technology needs. This course may be useful for developing the skills needed to succeed in this role, including data analysis, database management, and software development. You'll learn how to use SQL to interact with databases, and how to use software development tools to build and test software applications.

See salaries and explore the career path for IT Consultant

Project Manager

Project managers lead and manage projects. This course may be useful for developing the skills needed to succeed in this role, including project planning, execution, and monitoring. You'll learn how to use SQL to extract and analyze data, and how to use project management tools to plan and track project progress.

See salaries and explore the career path for Project Manager

Product Manager

Product managers are responsible for the development and management of products. This course may be useful for developing the skills needed to succeed in this role, including product design, development, and marketing. You'll learn how to use SQL to extract and analyze data, and how to use product management tools to plan and track product development.

See salaries and explore the career path for Product Manager

Data Engineer

Data engineers build and maintain the infrastructure that supports data analysis and machine learning. This course may be useful for developing the skills needed to succeed in this role, including data architecture, design, and implementation. You'll learn how to use SQL to create and manage databases, and how to use data engineering tools to build and maintain data pipelines.

See salaries and explore the career path for Data Engineer

Database Designer

Database designers design and develop databases. This course can help you develop the skills needed to succeed in this role, including data modeling, normalization, and performance tuning. You'll learn how to use SQL to create and manage databases, and how to use database design tools to design and optimize databases.

See salaries and explore the career path for Database Designer

Systems Analyst

Systems analysts analyze and design computer systems. This course may be useful for developing the skills needed to succeed in this role, including systems analysis, design, and implementation. You'll learn how to use SQL to extract and analyze data, and how to use systems analysis tools to design and implement computer systems.

See salaries and explore the career path for Systems Analyst

Information Architect

Information architects design and manage information systems. This course may be useful for developing the skills needed to succeed in this role, including information architecture, design, and implementation. You'll learn how to use SQL to extract and analyze data, and how to use information architecture tools to design and implement information systems.

See salaries and explore the career path for Information Architect

Web Developer

Web developers design and develop websites. This course may be useful for developing the skills needed to succeed in this role, including web design, development, and testing. You'll learn how to use SQL to interact with databases, and how to use web development tools to build and test websites.

See salaries and explore the career path for Web Developer

Technical Writer

Technical writers create and maintain technical documentation. This course may be useful for developing the skills needed to succeed in this role, including technical writing, editing, and publishing. You'll learn how to use SQL to extract and analyze data, and how to use technical writing tools to create and maintain technical documentation.

See salaries and explore the career path for Technical Writer

UX Designer

UX designers design and evaluate user interfaces. This course may be useful for developing the skills needed to succeed in this role, including UX design, research, and evaluation. You'll learn how to use SQL to extract and analyze data, and how to use UX design tools to design and evaluate user interfaces.

See salaries and explore the career path for UX Designer