1Z0-071 Oracle SQL Developer: Certified Associate (Database) (Udemy.com)
Learn about the SELECT statement, DDL, DML, functions + more. Oracle Database 11g, 12c, 19c using Oracle SQL Developer.
Created by: Phillip Burton
Produced in 2021
What you will learn
- 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
Quality Score
Overall Score : 94 / 100
Course Description
Session 1We'll install for free Oracle Express Edition and Oracle SQLDeveloper. Then we'll take a look at the 6 principal clauses of the SELECTstatement:
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 2We'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 3In 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 4We'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 SQLset operators such as UNION, INTERSECT and MERGE. Then we'll look at analytical functions using the OVERclause.
Session 5Session 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 WHEREclauses, and also into the WITH clause. Finally, we'll look at Oracle SQLself-joins, which are useful when you have hierarchies.
Session 6Session 6 starts off with two additional data types, TIMEZONE 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. Who this course is for:
This SQL course is meant for you, if you have not used Oracle SQL Database much (or at all), and want to learn SQL.
This course is also for you if you want a refresher on SQL. However, no prior Oracle SQL Database knowledge is required.
Instructor Details
- 4.7 Rating
74 Reviews
Phillip Burton
Phillip is a Computing Consultant providing expert services in the development of computer systems and data analysis. He is a Microsoft Certified Technology Specialist. He has also been certified as a Microsoft Certified Solutions Expert for Business Intelligence, Microsoft Office 2010 Master, and as a Microsoft Project 2013 Specialist.
He enjoys investigating data, which allows him to maintain up to date and pro-active systems to help control and monitor day-to-day activities. He has also developed expertise and programmes to catalogue and process and control electronic data, large quantities of paper or electronic data for structured analysis and investigation.
He is one of 9 award winning Experts for Experts Exchange's 11th Annual Expert Awards and was one of Expert Exchange's top 10 experts for the first quarter of year 2015.
His interests are working with data, including Microsoft Excel, Access and SQL Server.
More courses by Phillip Burton
70-461, 761: Querying Microsoft SQL Server with Transact-SQL (2021)
4.6 (360 Reviews)
Provider: Udemy
Time: 29.5h
$11.99
SQL Server Integration Services (SSIS) - An Introduction (2021)
4.6 (355 Reviews)
- Provider: Udemy
- Time: 4h
$11.99
70-462: SQL Server Database Administration (DBA) (2021)
4.5 (350 Reviews)
- Provider: Udemy
- Time: 9.5h
$11.99
Microsoft SQL Server Reporting Services (SSRS) (2021)
4.2 (338 Reviews)
- Provider: Udemy
- Time: 6h
$11.99
70-778, DA-100: Analyzing and Visualizing Data with Power BI (2021)
4.5 (224 Reviews)
- Provider: Udemy
- Time: 24h
$11.99
SQL Server SSAS (Multidimensional MDX) - an Introduction (2021)
4.5 (207 Reviews)
- Provider: Udemy
- Time: 8h
$11.99
More sql courses
SQL Server - zapytania. Querying. Exam 70-761 (2021)
4.8 (99 Reviews)
- Provider: Udemy
- Time: 5h
$11.99
Oracle Database 12c SQL Certified Associate 1Z0-071 (2021)
4.7 (336 Reviews)
- Provider: Udemy
- Time: 20h
$11.99
Introduction to Structured Query Language (SQL) (2017)
4.7 (313 Reviews)
- Provider: Coursera
- Time: 3h
Free
Learn C# With Windows Forms and SQL Server (2021)
4.7 (269 Reviews)
- Provider: Udemy
- Time: 12.5h
$11.99
Microsoft Access SQL: SQL for Non-Programmers (2021)
4.7 (240 Reviews)
- Provider: Udemy
- Time: 3.5h
$11.99
Reviews
- Video Duration:
19h - Price: 11.99 Track Price 11.99 Track Price
- Provider: Udemy
- Year:
2021 - Language:
English - Certificate:
Yes
30-Day Money-Back Guarantee
Udemy Coupon Price Tracker
