Coursera
SubscriptionThe Complete Oracle SQL Bootcamp
4.6(372)28k studentsALL LEVELSEnglish
UdemyUdemyPrice
No active coupon right now
View Course →No coupon right now. We'll tell you when there is one.
Mark your own learning status. Opening a course link does not establish enrollment.
Loading saved status…
The bootcamp is aimed at people who want to work as Oracle SQL developers and who plan to sit the 1Z0-071 Oracle Certified Associate exam. It opens with installation, covering Oracle Database Express 18c and Oracle SQL Developer, then connections through both SQL Developer and SQLPlus.
The first half is about retrieval, with filtering, sorting, substitution variables, single-row functions and group functions. Joins, subqueries and set operators follow, then data manipulation, table creation and the data dictionary. The second half moves to views, sequences, synonyms, indexes, schema management, user access control and time zones.
Exercises sit inside the lessons, and the solutions come later in each video. The course asks you to attempt each task before playing the answer, which is the right way to use it.
Welcome to the Complete Oracle SQL Bootcamp 2024.
If you want to get ready and become a professional Oracle SQL Developer and Prepare for an Oracle SQL Certification Exam 1Z0-071: Oracle Certified Associate (OCA), then this course is the best for you.
Do you want to get a better job?
Are you bored with watching a lot of stuff, but could not learn anything?
Are you looking for a really professional course?
Then this is best Oracle SQL course you are looking for.
You have come to the right place!
If you are new to Oracle SQL, no problem! You can easily learn with all the details of SQL. If you already know SQL and want to improve you skills, this course explains all the details including all of the subjects.
Get this course, and go get a better job!
In this course, all the subjects are explained in a professional way.
All practices and solutions are in the lessons. you can pause the video and complete the practice before resuming to watch the solution. Make sure you solve the practice on your own before moving on to the solution!
Topics covered in this course:
Downloading and installing Oracle database express 18c in details
Downloading and installing Oracle SQL Developer
Connecting to Oracle Database using SQL Developer and SQLPlus
Retrieving data using the select statement
Restricting / Filtering Data
Sorting Data
Using 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 Part I
Using the Set Operators
Manipulating tables using DML Statements ( Insert, Update, Delete )
Using Data Definition Language / Creating tables
Managing objects with data dictionary views
Creating Views in details
Creating sequences, synonyms, and indexes
Managing Schema Objects
Retrieving Data By Using Subqueries Part II
Manipulating Data By Using Subqueries
Controlling User Access in details
Manipulating Data using DML Part II
Managing Data in Different Time Zones
Advertisement
Tracking since 15 Nov — not enough history yet to tell you whether today's price is any good. Watch the course and we'll tell you when it drops.
This is what we recorded in US pricing — not every price this course has ever had, and prices differ by country.
No Korshub reviews yet.
