The Complete Oracle SQL Certification Course
Год выпуска: 12/2023
Производитель: Udemy
Сайт производителя:
https://www.udemy.com/course/the-complete-oracle-sql-certification-course/
Автор: Job Ready Programmer
Продолжительность: 16h 28m 1s
Тип раздаваемого материала: Видеоурок
Язык: Английский
Субтитры: Английский
Описание:
Don't Just Learn the SQL Language, Become Job-Ready and Launch Your Career as a Certified Oracle SQL Developer!
What you'll learn
- Become Job Ready to Start Contributing as a Database Developer Day 1
- Be Equipped to confidently tackle SQL Interview Questions
- MASTER the Content Required to Pass the Oracle 1Z0-071 Database SQL Exam
- Program in the SQL Language to Solve a Variety of Database Problems
- Code along with me to PRACTICE and IMPLEMENT everything you learn
- Become a SQL Ninja and Understand How the Oracle Database Works
- Obtain the Skills that are Necessary to Land a Job as a SQL Developer
- Have the Ability to Solve any SQL Problem
Requirements
- Absolutely no programming experience is required to master the content in this course
Description
Welcome to the
Complete Oracle SQL Certification Course !
Are you new to SQL and eager to start your journey in database management?
Do you want to land a better job or level up in your tech career?
Have you tried learning SQL before but struggled to apply it in real-world scenarios?
Are you seeking a structured, professional course designed to deliver practical skills, not just theory?
If you answered yes to any of these questions, you’ve come to the right place.
This course is tailored to provide a step-by-step approach, demystifying SQL concepts and preparing you for real-world challenges in database management and data analysis.
What Makes This Course Stand Out?
You will go from the basics of SQL to a professional level with a clear, step-by-step progression. Whether you’re a complete beginner or someone with prior experience looking to sharpen your SQL skills, this course has everything you need to succeed.
- Comprehensive Content: Every concept is explained in a logical and professional sequence, ensuring a smooth learning journey.
- Learn by Doing: Master SQL through practical exercises in a hands-on Oracle environment.
- Beginner-Friendly: No prior programming knowledge? No problem! We’ll guide you from scratch and help you build confidence.
- In-Depth Learning: This course doesn’t just scratch the surface; it dives deep into essential SQL concepts, preparing you for real-world challenges and professional environments.
- Job-Ready Skills: By the end of the course, you’ll not only understand SQL—you’ll know how to apply it effectively to solve problems and enhance your career prospects.
- Exam Preparation: Prepare for the Oracle Database SQL (1Z0-071) Certification Exam, setting yourself apart as a certified SQL professional.
Why wait? Equip yourself with one of the most in-demand skills in the industry and start transforming your career today!
Topics covered in the Complete Oracle SQL Certification Course:
Database Basics
- Oracle Database Introduction & Basics of Tables
- Creating the Workspace in Oracle
- Prepare the Sample Data
Single Table Queries
- Oracle Exams and Certification Information
- Retrieving Data Using the SELECT Clause
- Using the WHERE Clause in a Query
- Important Information from Instructor
- Using Operators in the WHERE Clause
- Combining WHERE, AND & OR with Operators
- Query Filtering Continued BETWEEN, IN and NULL
- Query Filtering Conditions & Operator Precedence
- Ordering, Concatenating And Aliasing Query Results
- Assignment 1: Practice with Single Table Queries
Single Row Functions
- Single Row Functions (SRF) & Using The Dual Table
- Using Functions in WHERE And Character Based SRFs
- Numeric and Date Data type SRFs
- Conversion SRFs and Date Formatting
- Some More Date Functions
- Concluding SRFs & NULL / NULLIF Functions
- Assignment 2: Practice with Single Row Functions
Grouping Functions
- Grouping Functions MIN, MAX, AVG, COUNT etc.
- GROUP BY Clause & HAVING Clause
- More Practice With The GROUP BY Clause
Multi-Table Queries and Joins
- SELECT within SELECT (Subqueries)
- Relating Tables Together Using JOINs
- Joins Continued INNER & OUTER Joins
- Correlated Subqueries with EXISTS & NOT EXIST operators
- SELF JOIN
- CROSS JOIN, NATURAL JOIN and the USING CLAUSE
- EQUIJOIN and NON-EQUIJOINs
- CASE Statements
Analytical Functions using OVER and PARTITION with ORDER BY
- OVER Clause with PARTITION BY
- Compute Running Totals with Ordering and Partitioning
- Unbounded Preceding Order in Over Clause
- Slicing Windows and Filtering with Analytic Functions
- Rank, Dense_rank, Lead, and Lag Functions
- Assignment: Application of Window Functions and SELF JOIN
Creating, Altering, and Updating Objects Using SQL
- Creating Your Own Tables & Design Considerations
- Inserting Data Into Our Table
- Create Table With a Primary Key Constraint
- INSERT ALL for Multi-table & Conditional Inserts
- Using ALTER to modify the table structure
- Create Table with SELECT + UPDATE Data
- MERGE Statement in Oracle
- Primary and Foreign Keys
- Sequence Statements in Oracle
- DELETE, TRUNCATE, and DROP Commands
- Working With Database Indexes
- System Tables, Pseudo Columns & Deleting Duplicates (Newly Added)
- Views and Other Objects and Commands (Newly Added)
- SQL could be tricky, check this out!
- Granting and Revoking Privileges
ADDITIONAL TOPICS + REVIEW for EXAM 170-071
- OFFSET and FETCH
- ERD Diagrams
- Commit, Rollback, and Savepoint
- Large Objects and Interval Data Types
- Using Cascade Constraints and On Delete Cascade
- UNUSED Columns
- External Tables
- SQL Plus and Substitution Variables
Exam Question Walkthrough Videos + 2 Exams
- QA 1- DML, DDL, and Transaction Control
- QA 2- Fetch and Substitution Variables
- QA 3 - Conversion Functions, TO_CHAR, NVL, and TO_DATE
- Practice Test 1 - 20 questions
- Practice Test 2 - 25 questions
APPENDIX - Installing Oracle on Windows2 lectures • 23min
- Install Oracle Database 19c in Windows
- Install Oracle SQL Developer in Windows
Inspiration
- What Will Make you Grow as a Software Developer
- Student Success Stories
- Career Advice
KEY BENEFITS OF ORACLE SQL MASTERY
SQL is the universal language for working with databases, enabling you to retrieve, manipulate, and analyze data efficiently. As companies generate immense volumes of data daily, they seek talented professionals who can extract valuable business insights from their databases. With SQL, you’ll gain a versatile skill that opens doors to roles like
Database Developer,
Data Analyst, or
Business Intelligence Specialist—careers that can earn upwards of $70,000–$90,000 annually for entry-level positions.
Oracle SQL is the gold standard in database management, used by top organizations worldwide. This course will teach you the SQL language used in Oracle databases, giving you a competitive edge in the job market. By the end of this course, you’ll be job-ready and able to:
- Write efficient SQL queries to solve business problems.
- Design, analyze, and optimize relational databases.
- Approach data challenges with confidence and clarity.
This course aligns with the
Oracle Database SQL (1Z0-071) exam, ensuring you master the content required to achieve certification. Oracle certifications are globally recognized and can significantly boost your career prospects. Completing this course and all assignments will prepare you to confidently pass the exam and validate your skills.
By the end of this course, you'll be equipped to confidently tackle
SQL interview questions and demonstrate your expertise in
real-world scenarios.
IMPORTANT NOTE FOR STUDENTS:
- All exercises and solutions are in the lectures.
- In several lectures, I ask students to pause the video and complete the assignment before resuming to watch my solution.
- MAKE SURE YOU WORK OUT THE PROBLEMS ON YOUR OWN BEFORE MOVING ON TO MY SOLUTION!!
STUDENT REVIEWS
With over 197,000 enrolled students and a 4.6 star-rating, this is a Udemy best-selling course.
Do you have no prior experience in SQL development?
This course is perfect for you. Don't take it from me, take it from actual students that took this course:
"I am a beginner and the way this course starts is perfect for the person who has no introduction of SQL or Oracle."
Do you have prior experience, but need a refresher or to fine-tune your skills?
This is the course for you. Again, I'll let my students do the talking:
"I had a good base of knowledge from my last employment. This course is constantly proving useful to supercharge my actual knowledge base. Very good one!"
Have you taken a SQL course before, but felt confused on certain topics or not completely satisfied in your abilities?
A lot of my students had shared similar concerns:
"I had previously taken a college course about databases and SQL, but these ten hours of content were more clear and useful than the course and textbook."
KEY TAKEAWAY
Data is the future, and SQL is your gateway to becoming a key player in it. With Oracle SQL mastery, you can transform your career, boost your earning potential, and become an asset to any organization.
Start your journey today to becoming an Oracle SQL Master! This course is designed to make SQL accessible, practical, and career-transforming—helping you unlock opportunities in the tech industry.
Who this course is for:
- Anyone willing to get into the software development career
- Anyone willing to Master SQL and get a job as a well paid Oracle SQL Developer
- Anyone willing to work hard in mastering the SQL language
- Anyone who is interested in passing the Oracle 1Z0-071 exam!
Author's YouTube channel:
https://www.youtube.com/@Jobreadyprogrammer
Формат видео: MP4
Видео: avc, 1280x720, 16:9, 30.000 к/с, 626 кб/с
Аудио: aac lc sbr, 44.1 кгц, 62.8 кб/с, 2 аудио
Изменения/Changes
Version 2020/3 compared to 2018/11 number of 4 lessons, and about 1 hour increased.
Version 2020/6 compared to 2020/3 of 21 Lessons, and about 5.5 hours increased.
Version 2020/11 compared to 2020/6 number of 6 lessons and a 15 minute increase.
Version 2023/12 compared to 2020/11 has increased the number of 3 lessons and the duration of 7 minutes.
MediaInfo
General
Complete name : D:\2_1\Udemy - The Complete Oracle SQL Certification Course (12.2023)\05 - Multi-Table Queries and Joins (Exercises and Solutions In the Lectures)\005 Correlated Subqueries with EXISTS & NOT EXIST operators.mp4
Format : MPEG-4
Format profile : Base Media
Codec ID : isom (isom/iso2/avc1/mp41)
File size : 106 MiB
Duration : 21 min 14 s
Overall bit rate : 695 kb/s
Frame rate : 30.000 FPS
Movie name : 005 Correlated Subqueries with EXISTS & NOT EXIST operators
Video
ID : 1
Format : AVC
Format/Info : Advanced Video Codec
Format profile : Main@L3.1
Format settings : CABAC / 4 Ref Frames
Format settings, CABAC : Yes
Format settings, Reference frames : 4 frames
Format settings, GOP : M=4, N=60
Codec ID : avc1
Codec ID/Info : Advanced Video Coding
Duration : 21 min 14 s
Bit rate : 626 kb/s
Nominal bit rate : 1 600 kb/s
Width : 1 280 pixels
Height : 720 pixels
Display aspect ratio : 16:9
Frame rate mode : Constant
Frame rate : 30.000 FPS
Color space : YUV
Chroma subsampling : 4:2:0
Bit depth : 8 bits
Scan type : Progressive
Bits/(Pixel*Frame) : 0.023
Stream size : 95.1 MiB (90%)
Writing library : x264 core 148
Encoding settings : cabac=1 / ref=3 / deblock=1:0:0 / analyse=0x1:0x111 / me=umh / subme=6 / psy=1 / psy_rd=1.00:0.00 / mixed_ref=1 / me_range=16 / chroma_me=1 / trellis=1 / 8x8dct=0 / cqm=0 / deadzone=21,11 / fast_pskip=1 / chroma_qp_offset=-2 / threads=22 / lookahead_threads=3 / sliced_threads=0 / nr=0 / decimate=1 / interlaced=0 / bluray_compat=0 / constrained_intra=0 / bframes=3 / b_pyramid=2 / b_adapt=1 / b_bias=0 / direct=1 / weightb=1 / open_gop=0 / weightp=2 / keyint=60 / keyint_min=6 / scenecut=0 / intra_refresh=0 / rc_lookahead=60 / rc=cbr / mbtree=1 / bitrate=1600 / ratetol=1.0 / qcomp=0.60 / qpmin=0 / qpmax=69 / qpstep=4 / vbv_maxrate=1600 / vbv_bufsize=3200 / nal_hrd=none / filler=0 / ip_ratio=1.40 / aq=1:1.00
Codec configuration box : avcC
Audio
ID : 2
Format : AAC LC SBR
Format/Info : Advanced Audio Codec Low Complexity with Spectral Band Replication
Commercial name : HE-AAC
Format settings : Explicit
Codec ID : mp4a-40-2
Duration : 21 min 14 s
Bit rate mode : Constant
Bit rate : 62.8 kb/s
Channel(s) : 2 channels
Channel layout : L R
Sampling rate : 44.1 kHz
Frame rate : 21.533 FPS (2048 SPF)
Compression mode : Lossy
Stream size : 9.54 MiB (9%)
Default : Yes
Alternate group : 1
