Oracle Database 12c SQL Certified Associate 1Z0-071 from Udemy

What's inside

Learning objectives

The full track of oracle database 12c: introduction to sql ed 2.
You will be prepared 100% to pass exams oracle database sql 1z0-071 and also exam oracle database 12c: sql fundamentals 1z0-061
Very strong introduction to make you understand the oracle database and rdbms.
Oracle database 12c architecture
Downloading and installing oracle database 12c in details
Connecting to the database
Retrieving data using the select statement / restricting and sorting data
Substitution variables
Using single-row functions to customize output
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 statments ( insert, update, delete )

Data definition language / creating tables
Data dictionary views
Creating sequences, synonyms, and indexes
Creating views in details
Managing schema objects
Retrieving data by using subqueries
Manipulating data by using subqueries
Controlling user access in details
Manipulating data
Managing data in different time zones
Exam information / exams details / exam practice
Many other information, you can see the full curriculum
Show more
Show less

The full track of oracle database 12c: introduction to sql ed 2.
You will be prepared 100% to pass exams oracle database sql 1z0-071 and also exam oracle database 12c: sql fundamentals 1z0-061
Very strong introduction to make you understand the oracle database and rdbms.
Oracle database 12c architecture
Downloading and installing oracle database 12c in details
Connecting to the database
Retrieving data using the select statement / restricting and sorting data
Substitution variables
Using single-row functions to customize output
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 statments ( insert, update, delete )
Data definition language / creating tables
Data dictionary views
Creating sequences, synonyms, and indexes
Creating views in details
Managing schema objects
Retrieving data by using subqueries
Manipulating data by using subqueries
Controlling user access in details
Manipulating data
Managing data in different time zones
Exam information / exams details / exam practice
Many other information, you can see the full curriculum
Show more
Show less

Syllabus

Introduction

Course Agenda

System Development Life Cycle & Database Definition

What is a Table?

Data Models & ERM

About Primary key & foreign key

SQL and Types of SQL Statements

Oracle Database 12c Architecture

HR Schema in this Course

Live SQL & Download/ Install

Oracle Live SQL / No Installation for anything

Oracle Live SQL limitation

before you install oracle DB

Downloading Oracle DB 12c

Installing Oracle DB 12c

About Oracle 18c express edition

About oracle 11g express edition

Connecting to the Database

Connecting SYS using SQL plus & SQL Developer

if you do not remember the sys password

Unlock HR Account Part 1

Unlock HR Account Part 2

ORA-01033 oracle initialization or shutdown in progress 12c

ORA-65054: Cannot open a pluggable database in the desired mode

Creating new pluggable database contains HR user

Retrieving data using the select statement

Navigate HR schema

Capabilities of SQL SELECT Statements

Arithmetic expressions and NULL values

Column Alias, Concatenation , Distinct and DESCRIBE

Important Notes in Select Statement

Restricting and Sorting Data

The WHERE Clause & Comparison Operators

Using Between and / IN / Like Operators

Using IS NULL / NOT / Not equal Operators

Logical Operators (AND/ OR/ NOT)

Order by Clause

The FETCH Clause

Substitution Variables

What is a Substitution Variables (&)

DEFINE / UNDEFINE

ACCEPT / PROMPT

Double-Ampersand / SET VERIFY / SET DEFINE

Using Single-Row Functions to Customize Output

Single Row Function Introduction

Character functions (Upper, Lower, Initcap )

Character functions (concat, substr, length )

Character functions ( instr )

Character functions ( lpad, rpad , replace, trim)

Number functions ( Round, Trunc, MOD )

Date Functions ( Sysdate)

Date Functions ( months_between, add_months, next_day, last_day)

Date Functions ( round , trunc )

Nesting Functions

Using Conversion Functions and Conditional Expressions

Implicit Data Conversion VS Explicit

TO_CHAR with dates

TO_CHAR with numbers

TO_NUMBER , TO_DATE Functions

nvl , nvl2 , nullif and coalesce Functions

The CASE Function

The DECODE Function

Reporting Aggregated Data Using the Group Functions

Group functions Introduction

Group functions (sum, count, max, min, avg & more)

Group by Clause, Having Clause

Displaying Data from multiple tables using joins

Before You Start, important notes

HR Tables Diagram, Joins Clarification

What is Cartesian product?

Old Joins: Equijoin

Old Joins: nonEquijoins

Old Joins: outer join

Old Joins: Self Join and More Practices

1999 Syntax: Cross Join (Cartesian product )

1999 Syntax: Natural Join

1999 Syntax: USING Clause

1999 Syntax: ON Clause

1999 Syntax: Left/Right/full Outer Join

Using Subqueries to Solve Queries

Single row Subqueries

Multiple rows Subqueries

NULL values and Subqueries

Exists and not Exists

Using the Set Operators

Overview (Union, union all, intersect, minus )

Practice (Union, union all, intersect, minus )

Managing tables using DML Statments

Introduction to DML

Insert Statement

Inserting common errors

Update Statement

Delete Statement

What is Database Transactions?

About Commit & Rollback

Practice ( Commit and rollback )

SAVEPOINT

ROW Lock

FOR UPDATE Clause

Introduction to Data Definition Language

Good to know

Know what's good

, what to watch for

, and possible dealbreakers

Uses leading industry knowledge and practices

Helps prepare learners for career advancement

Offers hands-on exercises

Provides an opportunity to learn from an expert

Offers comprehensive study materials

Reviews summary

Refresher for experienced oracle database 12c sql professionals

Learners say this Oracle Certified Associate 1Z0-071 course is very interesting and a good refresher for experienced Oracle Database 12c SQL users. While the course has not been reviewed by enough learners to say definitively, this review suggests that it may be a helpful course for experienced Oracle Database 12c SQL Professionals looking to refresh their skills.

Course is good for experienced professionals looking to refresh their skills.

"Very interesting course."

"Did not do the certification test but used the course as a refresher."

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 Oracle Database 12c SQL Certified Associate 1Z0-071 with these activities:

Review Database Concepts

Show steps

solidify your understanding of basic database concepts.

Browse courses on Database Concepts

Show steps

Review notes or textbooks on database concepts.
Attend a refresher course or workshop on database fundamentals.

Review Data Types

Show steps

Refresh your understanding of data types used in Oracle SQL.

Browse courses on Data Types

Show steps

Review data types and their properties.
Practice declaring and using data types in SQL queries.

SQL Study Group

Show steps

Engage with peers and discuss SQL concepts and challenges.

Show steps

Find a group of peers who are also interested in learning SQL.
Meet regularly to discuss course materials, solve problems, and share knowledge.

Five other activities

Expand to see all activities and additional details

Show all eight activities

SQL Practice Problems

Show steps

Reinforce your SQL skills by solving practice problems.

Browse courses on Problem Solving

Show steps

Identify a set of practice problems.
Solve the problems using SQL.
Review your solutions and identify areas for improvement.

Attend SQL Meetups

Show steps

Connect with other SQL professionals and learn about industry trends.

Browse courses on Networking

Show steps

Find local SQL meetups or conferences.
Attend the events and participate in discussions.

Advanced SQL Workshop

Show steps

Gain hands-on experience with advanced SQL techniques.

Browse courses on Query Optimization

Show steps

Find an advanced SQL workshop that aligns with your learning goals.
Attend the workshop and actively participate in the exercises.
Apply the skills you learned in your own SQL projects.

SQL Coding Exercises

Show steps

Deepen your understanding of SQL syntax and query optimization.

Show steps

Find a set of SQL coding exercises.
Solve the exercises and test your solutions.
Analyze the performance of your queries and identify areas for improvement.

SQL Query Portfolio

Show steps

Demonstrate your SQL skills by creating a portfolio of complex queries.

Browse courses on Data Analysis

Show steps

Identify a set of real-world data analysis problems.
Design and implement SQL queries to solve the problems.
Document your queries and explain their purpose and implementation.

Career center

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

Database Administrator

Database Administrators are tasked with managing and maintaining an organization's databases. This course can help build your foundation in how to manage and maintain databases, which can help you succeed as a Database Administrator.

See salaries and explore the career path for Database Administrator

Database Manager

Database Managers are responsible for planning, implementing, and maintaining an organization's database systems. This course can help you build a strong foundation in database management.

See salaries and explore the career path for Database Manager

Data Engineer

Data Engineers are responsible for designing, building, and maintaining data pipelines. This course can help you build a solid foundation in data management, which can be beneficial in helping you find success as a Data Engineer.

See salaries and explore the career path for Data Engineer

Statistician

Statisticians collect, analyze, interpret, and present data. This course can help you build a foundation in data analysis, which is essential for success as a Statistician.

See salaries and explore the career path for Statistician

Data Scientist

Data Scientists are responsible for collecting and analyzing data, and for developing solutions based on their analysis. These professionals are also expected to have strong communication skills, as they are frequently tasked with explaining their analysis to stakeholders. This course can help you develop a strong foundation in data analysis, which can help you succeed in this role.

See salaries and explore the career path for Data Scientist

Quantitative Analyst

Quantitative Analysts use mathematical and statistical techniques to analyze data and develop financial models. This course can help you build a foundation in data analysis, which can be beneficial in helping you find success as a Quantitative Analyst.

See salaries and explore the career path for Quantitative Analyst

ETL Developer

ETL Developers are responsible for designing and building data pipelines that extract, transform, and load data from one system to another. This course can be useful as it can help build a foundation in data management and data integration.

See salaries and explore the career path for ETL Developer

Data Warehouse Architect

Data Warehouse Architects are responsible for designing and managing an organization's data warehouse. This course can be useful as it can help you build a foundation in data warehousing.

See salaries and explore the career path for Data Warehouse Architect

Data Governance Analyst

Data Governance Analysts are responsible for developing and implementing data governance policies and procedures. This course can be useful as it can help you understand data governance best practices.

See salaries and explore the career path for Data Governance Analyst

Data Analyst

A Data Analyst has several duties, which can include gathering, cleaning, and organizing data, before analyzing it to derive meaningful insights. This course is an excellent resource to help you understand how data is organized and analyzed, helping you build a foundation for extracting insights from data.

See salaries and explore the career path for Data Analyst

Data Architect

Data Architects are responsible for designing and managing an organization's data architecture. This course can be useful as it can help you build a foundation in data management best practices.

See salaries and explore the career path for Data Architect

Information Security Analyst

Information Security Analysts are responsible for protecting an organization's IT infrastructure from cyber threats. This course can be useful as it can help you build a foundation in data security.

See salaries and explore the career path for Information Security Analyst

Operations Research Analyst

Operations Research Analysts use mathematical and statistical techniques to solve complex business problems. This course may be useful as it can help you build a foundation in data analysis.

See salaries and explore the career path for Operations Research Analyst

Business Analyst

Business Analysts are responsible for understanding the needs of a business and translating those needs into requirements for software systems. This course may be useful as it can help you understand how to analyze data and communicate your analysis to stakeholders.

See salaries and explore the career path for Business Analyst

Software Developer

Software Developers build and maintain software applications. They are frequently required to work closely with databases, making this course a potentially helpful resource.

See salaries and explore the career path for Software Developer