Careertail
About UsCoursesCareer PathsBlogOpportunities
Log In
Courses>IT Certifications>1Z0-071 Oracle SQL Developer: Certified Associate (Database)
IT & Software1Z0-071 Oracle SQL Developer: Certified Associate (Database)
Price:Paid
Length:19.5 hours
Content type:video
level:beginner
Updated:26 February 2024
Published:21 August 2022
Similar courses
Opportunities
Courses>IT Certifications>1Z0-071 Oracle SQL Developer: Certified Associate (Database)
1Z0-071 Oracle SQL Developer: Certified Associate (Database)
4.7 (7.1k)
19.5 hours
7068 students
What you will learn
1Create tables in a database and ALTER columns in the table.
2Know what data type to use in various situations, and use functions to manipulate date, number and string data values.
3Retrieve data using SELECT, FROM, WHERE, GROUP BY, HAVING and ORDER BY.
4JOIN two or more tables together, finding missing data.
5INSERT new data, UPDATE and DELETE existing data, and export data into a new table.
6Create constraints, views and sequences, subqueries and CTEs
7Use UNION, CASE, MERGE and error checking
8Apply ranking and analytic functions, grouping
9Learn about transactions, indexes, users, privileges, roles and more
Target audiences
1This SQL course is meant for you, if you have not used Oracle SQL Database much (or at all), and want to learn SQL.
2This course is also for you if you want a refresher on SQL. However, no prior Oracle SQL Database knowledge is required.
Requirements
1You need to know how to use a computer, and hopefully know how to use a spreadsheet.
2No prior knowledge of Oracle SQL Database or any other database required - although the more knowledge you do have, the better.
3To install Oracle SQL Database on your computer, you will need a 64-bit machine.
4Oracle SQL Database cannot easily be installed on the Mac OS. If you wish to install it on a Mac, you will need either to dual boot into Windows or be running Parallel Desktop.
5You don't even need Oracle SQL Database installed - I'll show you have to install it on your computer for free!
6There is a 30-day money back guarantee of this Udemy course.
7Why not have a look at the curriculum below and see what you can learn?
FAQ
You can view and review the lecture materials indefinitely, like an on-demand channel.
Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don't have an internet connection, some instructors also let their students download course lectures. That's up to the instructor though, so make sure you get on their good side!
Description

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: SELECT, FROM, WHERE, GROUP BY, HAVING and ORDER BY.

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 UNION, INTERSECT and MERGE. 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 FROM, SELECT and WHERE clauses, and also into the WITH clause. 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 INTERVAL data types and functions. 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.

Similar courses
Opportunities
Make the most out of your online education
Careertail
Copyright © 2021 Careertail.
All rights reserved
Quick Links
Get StartedLog InAbout UsCourses
Company
BlogContactsPrivacy PolicyCookie PolicyTerms and Conditions
Stay up to date
Trustpilot
Careertail
Courses>IT Certifications>1Z0-071 Oracle SQL Developer: Certified Associate (Database)
IT & Software1Z0-071 Oracle SQL Developer: Certified Associate (Database)
Price:Paid
Length:19.5 hours
Content type:video
level:beginner
Updated:26 February 2024
Published:21 August 2022
Similar courses
Opportunities
Courses>IT Certifications>1Z0-071 Oracle SQL Developer: Certified Associate (Database)
1Z0-071 Oracle SQL Developer: Certified Associate (Database)
4.7 (7.1k)
19.5 hours
7068 students
What you will learn
1Create tables in a database and ALTER columns in the table.
2Know what data type to use in various situations, and use functions to manipulate date, number and string data values.
3Retrieve data using SELECT, FROM, WHERE, GROUP BY, HAVING and ORDER BY.
4JOIN two or more tables together, finding missing data.
5INSERT new data, UPDATE and DELETE existing data, and export data into a new table.
6Create constraints, views and sequences, subqueries and CTEs
7Use UNION, CASE, MERGE and error checking
8Apply ranking and analytic functions, grouping
9Learn about transactions, indexes, users, privileges, roles and more
Target audiences
1This SQL course is meant for you, if you have not used Oracle SQL Database much (or at all), and want to learn SQL.
2This course is also for you if you want a refresher on SQL. However, no prior Oracle SQL Database knowledge is required.
Requirements
1You need to know how to use a computer, and hopefully know how to use a spreadsheet.
2No prior knowledge of Oracle SQL Database or any other database required - although the more knowledge you do have, the better.
3To install Oracle SQL Database on your computer, you will need a 64-bit machine.
4Oracle SQL Database cannot easily be installed on the Mac OS. If you wish to install it on a Mac, you will need either to dual boot into Windows or be running Parallel Desktop.
5You don't even need Oracle SQL Database installed - I'll show you have to install it on your computer for free!
6There is a 30-day money back guarantee of this Udemy course.
7Why not have a look at the curriculum below and see what you can learn?
FAQ
You can view and review the lecture materials indefinitely, like an on-demand channel.
Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don't have an internet connection, some instructors also let their students download course lectures. That's up to the instructor though, so make sure you get on their good side!
Description

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: SELECT, FROM, WHERE, GROUP BY, HAVING and ORDER BY.

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 UNION, INTERSECT and MERGE. 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 FROM, SELECT and WHERE clauses, and also into the WITH clause. 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 INTERVAL data types and functions. 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.

Similar courses
Opportunities
Make the most out of your online education
Careertail
Copyright © 2021 Careertail.
All rights reserved
Quick Links
Get StartedLog InAbout UsCourses
Company
BlogContactsPrivacy PolicyCookie PolicyTerms and Conditions
Stay up to date
Trustpilot