1Z0-071 Learn Oracle SQL: prepare for Certified Associate
Learn about the SELECT statement, DDL, DML, functions + more using Oracle SQL. For Oracle Database 11g to 19c.
Affiliate disclosure: if you enroll through links on this page, the course provider may pay us a commission. This comes at no extra cost to you and does not influence how we describe courses.
What You'll Learn in This Course
Master key concepts and practical skills through structured learning modules. By completing this curriculum, you'll gain valuable expertise applicable to real-world scenarios.
Learning Outcome 1
Create tables in a database and ALTER columns in the table.
Learning Outcome 2
Know what data type to use in various situations, and use functions to manipulate date, number and string data values.
Learning Outcome 3
Retrieve data using SELECT, FROM, WHERE, GROUP BY, HAVING and ORDER BY.
Learning Outcome 4
JOIN two or more tables together, finding missing data.
Learning Outcome 5
INSERT new data, UPDATE and DELETE existing data, and export data into a new table.
Skills You'll Develop
This comprehensive 1Z0-071 Learn Oracle SQL: prepare for Certified Associate curriculum is designed to take you from foundational concepts to advanced implementation. Each module builds upon the previous, ensuring a structured learning path that maximizes knowledge retention and practical application.
Course Requirements & Target Audience
Understand what you need to succeed in this course and determine if it's the right fit for your learning goals
Prerequisites & Requirements
What you need before starting this 1Z0-071 Learn Oracle SQL: prepare for Certified Associate course:
- You need to know how to use a computer, and hopefully know how to use a spreadsheet.
- No prior knowledge of Oracle SQL Database or any other database required - although the more knowledge you do have, the better.
- Oracle 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.
- You don't even need Oracle SQL Database installed - I'll show you have to install it on your computer for free!
- There is a 30-day money back guarantee of this Udemy course.
Who This Course Is For
This course is perfect for:
- Motivated learners at any level
- Self-paced students
- Anyone interested in the subject
This course might not be suitable if:
- • You're looking for a quick tutorial rather than comprehensive learning
- • You prefer learning without structured curriculum
- • You need highly specialized or niche content
Course Information & Details
Everything you need to know about this online course, from duration to certification
Course Instructor
Phillip Burton
Expert instructor with industry experience
Course Language
English
All materials in English
Start Your Learning Journey Today
This online course offers comprehensive training with expert instruction, practical exercises, and a certificate of completion. Join thousands of students advancing their careers through quality online education.
Course Enrollment
Comprehensive Program
Professional training from $199.99
Pricing may vary. Check the course provider for current promotions and exact pricing.
What's Included
- 19 hours on-demand video
- 14 downloadable resources
- 28 articles
- Access on mobile and TV
- Certificate of Completion
- Full lifetime access
Affiliate disclosure: if you enroll through links on this page, the course provider may pay us a commission. This comes at no extra cost to you and does not influence how we describe courses.
- ✓Instant access after enrollment
- ✓Learn at your own pace
- ✓Direct enrollment with Udemy
Where this course fits
Certifications in this area
Concepts behind this area
Security Risk Assessment
A security risk assessment identifies the threats to an organisation's assets, estimates how likely each is and how much harm it would do, and ranks them so that limited effort goes where it reduces the most harm.
Zero Trust
Zero trust is a security model in which no request is trusted because of where it comes from, so every access to a resource is authenticated, authorised and checked against policy each time.
Encryption
Encryption transforms readable data into ciphertext with a key so that only someone holding the right key can turn it back, protecting the data while it is stored or in transit.
Wireless LAN (Wi-Fi)
A wireless LAN connects devices to a network over radio using the 802.11 family of standards, through access points that bridge the wireless medium onto the wired network and enforce the authentication and encryption that the shared airwaves demand.
TCP/IP
TCP/IP is the family of protocols on which the internet runs: IP moves packets between addresses without guarantees, and TCP or UDP ride on top to deliver either a reliable ordered stream or fast unordered messages.
OSI Model
The OSI model is a seven-layer reference framework that separates networking into physical transmission, link, network, transport, session, presentation and application concerns, used to reason about where a problem sits rather than to describe any real protocol stack.
Caching
Caching keeps the result of expensive work, such as a rendered page or a database query, and serves that stored copy until it expires, making it the largest single source of speed on any busy website.
Uptime & SLA
Uptime is the proportion of time a service answers requests, quoted in nines, and a service level agreement is the contract clause setting out how that proportion is counted and what the provider owes when it falls short.
Kubernetes
Kubernetes is an open-source system that runs containers across a cluster of machines, keeping the number and placement of running copies matched to a declared desired state, and restarting, rescheduling and scaling them without a person intervening.
The field, explained: Hosting & Cloud
Wider context: the fields we cover, the glossary and certification exams, all written by us rather than pulled from a provider feed.