The Complete Oracle SQL Certification Course

The Complete Oracle SQL Certification Course

Size
6.1 GB
Seeders
8
Leechers
7
Files
99
Category
Added
01/26/21 at 5:14pm GMT+1
Infohash
db44096e5cf9fd0c34c6e6cc06311616f50a6f28

Description
Description

LAST UPDATED: November 2020

(Source Code Included for Lectures)

Get ready to acquire some seriously marketable programming skills! You can’t consider yourself a complete end to end developer until you can code in SQL. Today, data has become the hottest topic in technology and a company’s biggest asset is their data. All databases require the language SQL to store and retrieve data. Salaries for junior level SQL Developers are upwards of $70,000 – $90,000 dollars a year! The great thing is, for this course, you do not need any prior experience in programming what so ever. SQL is a different animal and we’re going to demystify the language from scratch and prepare you with plenty of progressively challenging assignments so that by the time you’ve completed the course (in 2 months), you can call your self an Oracle SQL Master! Oracle is the most popular relational database in the world! This course will prepare you to be job-ready in just 1 month of study and practice.

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!!

With over 62,000 enrolled students and a 4.5 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.”

Topics covered in this course :

Basics of Tables
SELECT and WHERE Clause
WHERE, AND & OR with Operators
BETWEEN, IN and NULL
Single Table Queries
Single Row Functions
Grouping Functions
GROUP BY and HAVING Clause
Joins
Inner and Outer Joins
EXISTS & NOT EXIST Operators
Creating Your Own Tables
Using ALTER
Creating Tables with SELECT & UPDATE Data
DELETE, TRUNCATE, and DROP Commands
System Tables, Pseudo Columns & Deleting Duplicates (Newly Added)
Views and Other Objects and Commands (Newly Added)

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!

Requirements

Absolutely no programming experience is required to master the content in this course

Last Updated 11/2020

File list
  • The Complete Oracle SQL Certification Course
  • .pad/0 78 B
  • .pad/1 6 B
  • .pad/2 7 B
  • TutsNode.com.txt 63 B
  • [TutsNode.com] - The Complete Oracle SQL Certification Course/1. Database Basics/2. Creating the Workspace in Oracle.srt 10.2 KB
  • [TutsNode.com] - The Complete Oracle SQL Certification Course/1. Database Basics/3. IMPORTANT Prepare the Sample Data.srt 5.8 KB
  • [TutsNode.com] - The Complete Oracle SQL Certification Course/1. Database Basics/3.1 course_data.txt 2.4 KB
  • [TutsNode.com] - The Complete Oracle SQL Certification Course/1. Database Basics/4. How to Proceed in This Course.srt 4.1 KB
  • [TutsNode.com] - The Complete Oracle SQL Certification Course/10. APPENDIX - Installing Oracle on Windows/1. Install Oracle Database 19c in Windows.srt 16.2 KB
  • [TutsNode.com] - The Complete Oracle SQL Certification Course/10. APPENDIX - Installing Oracle on Windows/2. Install Oracle SQL Developer in Windows.srt 21.9 KB
  • [TutsNode.com] - The Complete Oracle SQL Certification Course/2. Single Table Queries (Exercises & Solutions in the Lectures)/1. Oracle Exams and Certification Information.html 688 B
  • [TutsNode.com] - The Complete Oracle SQL Certification Course/2. Single Table Queries (Exercises & Solutions in the Lectures)/10. Ordering, Concatenating & Aliasing Query Results.srt 25.8 KB
  • [TutsNode.com] - The Complete Oracle SQL Certification Course/2. Single Table Queries (Exercises & Solutions in the Lectures)/10.1 Code for Ordering, Concatenating & Aliasing Query Results.txt 683 B
  • [TutsNode.com] - The Complete Oracle SQL Certification Course/2. Single Table Queries (Exercises & Solutions in the Lectures)/11. Assignment 1 Practice with Single Table Queries.html 5.3 KB
  • [TutsNode.com] - The Complete Oracle SQL Certification Course/2. Single Table Queries (Exercises & Solutions in the Lectures)/2. Retrieving Data Using the SELECT Clause.srt 20 KB
  • [TutsNode.com] - The Complete Oracle SQL Certification Course/2. Single Table Queries (Exercises & Solutions in the Lectures)/2.1 Code for Select Clause.txt 245 B
  • [TutsNode.com] - The Complete Oracle SQL Certification Course/2. Single Table Queries (Exercises & Solutions in the Lectures)/3. Using the WHERE Clause in a Query.srt 26 KB
  • [TutsNode.com] - The Complete Oracle SQL Certification Course/2. Single Table Queries (Exercises & Solutions in the Lectures)/3.1 Code for WHERE Clause.txt 130 B
  • [TutsNode.com] - The Complete Oracle SQL Certification Course/2. Single Table Queries (Exercises & Solutions in the Lectures)/4. Using Operators in the WHERE Clause.srt 28.3 KB
  • [TutsNode.com] - The Complete Oracle SQL Certification Course/2. Single Table Queries (Exercises & Solutions in the Lectures)/4.1 Code for Using Operators in the WHERE Clause.txt 659 B
  • [TutsNode.com] - The Complete Oracle SQL Certification Course/2. Single Table Queries (Exercises & Solutions in the Lectures)/5. Some Inspiration.srt 4.5 KB
  • [TutsNode.com] - The Complete Oracle SQL Certification Course/2. Single Table Queries (Exercises & Solutions in the Lectures)/6. Combining WHERE, AND & OR with Operators.srt 28.4 KB
  • [TutsNode.com] - The Complete Oracle SQL Certification Course/2. Single Table Queries (Exercises & Solutions in the Lectures)/6.1 Code for Combining WHERE, AND & OR Operators.txt 263 B
  • [TutsNode.com] - The Complete Oracle SQL Certification Course/2. Single Table Queries (Exercises & Solutions in the Lectures)/7. Query Filtering Continued BETWEEN, IN and NULL.srt 26.9 KB
  • [TutsNode.com] - The Complete Oracle SQL Certification Course/2. Single Table Queries (Exercises & Solutions in the Lectures)/8. What Will Make you Grow as a Software Developer.srt 5.9 KB
  • [TutsNode.com] - The Complete Oracle SQL Certification Course/2. Single Table Queries (Exercises & Solutions in the Lectures)/9. Query Filtering Conditions & Operator Precedence.srt 27.3 KB
  • [TutsNode.com] - The Complete Oracle SQL Certification Course/2. Single Table Queries (Exercises & Solutions in the Lectures)/9.1 Code for Query Filtering Conditions & Operator Precedence.txt 689 B
  • [TutsNode.com] - The Complete Oracle SQL Certification Course/3. Single Row Functions (Exercises and Solutions In the Lectures)/1. Single Row Functions (SRF) & Using The Dual Table.srt 26.6 KB
  • [TutsNode.com] - The Complete Oracle SQL Certification Course/3. Single Row Functions (Exercises and Solutions In the Lectures)/1.1 Code for Single Row Functions (SRF) & Using the Dual Table.txt 715 B
  • [TutsNode.com] - The Complete Oracle SQL Certification Course/3. Single Row Functions (Exercises and Solutions In the Lectures)/2. Using Functions in WHERE And Character Based SRFs.srt 26.5 KB
  • [TutsNode.com] - The Complete Oracle SQL Certification Course/3. Single Row Functions (Exercises and Solutions In the Lectures)/2.1 Code for Using Functions in WHERE and Character Based SRFs.txt 1 KB
  • [TutsNode.com] - The Complete Oracle SQL Certification Course/3. Single Row Functions (Exercises and Solutions In the Lectures)/3. Numeric and Date Data type SRFs.srt 27.6 KB
  • [TutsNode.com] - The Complete Oracle SQL Certification Course/3. Single Row Functions (Exercises and Solutions In the Lectures)/3.1 Code for Numeric and Date Datatype SRFs.txt 1.1 KB
  • [TutsNode.com] - The Complete Oracle SQL Certification Course/3. Single Row Functions (Exercises and Solutions In the Lectures)/4. Conversion SRFs and Date Formatting.srt 27.4 KB
  • [TutsNode.com] - The Complete Oracle SQL Certification Course/3. Single Row Functions (Exercises and Solutions In the Lectures)/4.1 Code for Conversion SRFs & Date Formatting.txt 528 B
  • [TutsNode.com] - The Complete Oracle SQL Certification Course/3. Single Row Functions (Exercises and Solutions In the Lectures)/5. Some More Date Functions.html 723 B
  • [TutsNode.com] - The Complete Oracle SQL Certification Course/3. Single Row Functions (Exercises and Solutions In the Lectures)/6. Concluding SRFs & NULL NULLIF Functions.srt 23.3 KB
  • [TutsNode.com] - The Complete Oracle SQL Certification Course/3. Single Row Functions (Exercises and Solutions In the Lectures)/6.1 Code for Concluding SRFs & NULLNULLIF Functions.txt 778 B
  • [TutsNode.com] - The Complete Oracle SQL Certification Course/3. Single Row Functions (Exercises and Solutions In the Lectures)/7. Assignment 2 Practice with Single Row Functions.html 6.6 KB
  • [TutsNode.com] - The Complete Oracle SQL Certification Course/4. Grouping Functions (Exercises and Solutions In the Lectures)/1. Grouping Functions MIN, MAX, AVG, COUNT etc..srt 27.4 KB
  • [TutsNode.com] - The Complete Oracle SQL Certification Course/4. Grouping Functions (Exercises and Solutions In the Lectures)/1.1 Code for Grouping Functions MIN, MAX, AVG, COUNT etc.txt 865 B
  • [TutsNode.com] - The Complete Oracle SQL Certification Course/4. Grouping Functions (Exercises and Solutions In the Lectures)/2. GROUP BY Clause & HAVING Clause.srt 28.3 KB
  • [TutsNode.com] - The Complete Oracle SQL Certification Course/4. Grouping Functions (Exercises and Solutions In the Lectures)/2.1 Code for GROUP BY Clause & HAVING CLAUSE.txt 601 B
  • [TutsNode.com] - The Complete Oracle SQL Certification Course/4. Grouping Functions (Exercises and Solutions In the Lectures)/3. More Practice With The GROUP BY Clause.srt 17.6 KB
  • [TutsNode.com] - The Complete Oracle SQL Certification Course/4. Grouping Functions (Exercises and Solutions In the Lectures)/3.1 Code for More Practice with the GROUP BY Clause.txt 259 B
  • [TutsNode.com] - The Complete Oracle SQL Certification Course/5. Multi-Table Queries and Joins (Exercises and Solutions In the Lectures)/1. SELECT within SELECT (Subqueries).srt 34.3 KB
  • [TutsNode.com] - The Complete Oracle SQL Certification Course/5. Multi-Table Queries and Joins (Exercises and Solutions In the Lectures)/1.1 Code for SELECT within SELECT (Nested Queries Subqueries).txt 1.2 KB
  • [TutsNode.com] - The Complete Oracle SQL Certification Course/5. Multi-Table Queries and Joins (Exercises and Solutions In the Lectures)/2. Relating Tables Together Using JOINs.srt 27.4 KB
  • [TutsNode.com] - The Complete Oracle SQL Certification Course/5. Multi-Table Queries and Joins (Exercises and Solutions In the Lectures)/2.1 Code for Relating Tables together using JOINs .txt 1.2 KB
  • [TutsNode.com] - The Complete Oracle SQL Certification Course/5. Multi-Table Queries and Joins (Exercises and Solutions In the Lectures)/3. Joins Continued INNER & OUTER Joins.srt 30.3 KB
  • [TutsNode.com] - The Complete Oracle SQL Certification Course/5. Multi-Table Queries and Joins (Exercises and Solutions In the Lectures)/3.1 Code for JOINS Continued INNER & OUTER Joins.txt 1.2 KB
  • [TutsNode.com] - The Complete Oracle SQL Certification Course/5. Multi-Table Queries and Joins (Exercises and Solutions In the Lectures)/4. Career Advice.srt 2.7 KB
  • [TutsNode.com] - The Complete Oracle SQL Certification Course/5. Multi-Table Queries and Joins (Exercises and Solutions In the Lectures)/5. Correlated Subqueries with EXISTS & NOT EXIST operators.srt 29.9 KB
  • [TutsNode.com] - The Complete Oracle SQL Certification Course/5. Multi-Table Queries and Joins (Exercises and Solutions In the Lectures)/5.1 Code for More JOINS with Correlated Subqueries .txt 1.1 KB
  • [TutsNode.com] - The Complete Oracle SQL Certification Course/5. Multi-Table Queries and Joins (Exercises and Solutions In the Lectures)/6. SELF JOIN.srt 16.7 KB
  • [TutsNode.com] - The Complete Oracle SQL Certification Course/5. Multi-Table Queries and Joins (Exercises and Solutions In the Lectures)/7. CROSS JOIN, NATURAL JOIN and the USING CLAUSE.srt 12.6 KB
  • [TutsNode.com] - The Complete Oracle SQL Certification Course/5. Multi-Table Queries and Joins (Exercises and Solutions In the Lectures)/8. EQUIJOIN and NON-EQUIJOINs.srt 14.4 KB
  • [TutsNode.com] - The Complete Oracle SQL Certification Course/5. Multi-Table Queries and Joins (Exercises and Solutions In the Lectures)/8.1 Code for EQUI and NON-EQUI Joins.txt 421 B
  • [TutsNode.com] - The Complete Oracle SQL Certification Course/5. Multi-Table Queries and Joins (Exercises and Solutions In the Lectures)/9. CASE Statements.srt 11.9 KB
  • [TutsNode.com] - The Complete Oracle SQL Certification Course/5. Multi-Table Queries and Joins (Exercises and Solutions In the Lectures)/9.1 Oracle COALESCE Function.pdf 283.2 KB
  • [TutsNode.com] - The Complete Oracle SQL Certification Course/5. Multi-Table Queries and Joins (Exercises and Solutions In the Lectures)/9.2 Code for CASE Statement.txt 379 B
  • [TutsNode.com] - The Complete Oracle SQL Certification Course/6. Analytical Functions using OVER and PARTITION with ORDER BY/1. OVER Clause with PARTITION BY.srt 27.5 KB
  • [TutsNode.com] - The Complete Oracle SQL Certification Course/6. Analytical Functions using OVER and PARTITION with ORDER BY/2. Compute Running Totals with Ordering and Partitioning.srt 28.8 KB
  • [TutsNode.com] - The Complete Oracle SQL Certification Course/6. Analytical Functions using OVER and PARTITION with ORDER BY/3. Unbounded Preceding Order in Over Clause.srt 13.9 KB
  • [TutsNode.com] - The Complete Oracle SQL Certification Course/6. Analytical Functions using OVER and PARTITION with ORDER BY/4. Slicing Windows and Filtering with Analytic Functions.srt 10.1 KB
  • [TutsNode.com] - The Complete Oracle SQL Certification Course/6. Analytical Functions using OVER and PARTITION with ORDER BY/5. Rank, Dense_rank, Lead, and Lag Functions.srt 23.9 KB
  • [TutsNode.com] - The Complete Oracle SQL Certification Course/7. Creating, Altering, and Updating Objects Using SQL (Exercises in Lectures)/1. Creating Your Own Tables & Design Considerations.srt 31.2 KB
  • [TutsNode.com] - The Complete Oracle SQL Certification Course/7. Creating, Altering, and Updating Objects Using SQL (Exercises in Lectures)/1.1 Code for Creating Your Own Tables & Design Considerations.txt 158 B
  • [TutsNode.com] - The Complete Oracle SQL Certification Course/7. Creating, Altering, and Updating Objects Using SQL (Exercises in Lectures)/10. DELETE, TRUNCATE, and DROP Commands.srt 25.5 KB
  • [TutsNode.com] - The Complete Oracle SQL Certification Course/7. Creating, Altering, and Updating Objects Using SQL (Exercises in Lectures)/11. Working With Database Indexes.srt 20 KB
  • [TutsNode.com] - The Complete Oracle SQL Certification Course/7. Creating, Altering, and Updating Objects Using SQL (Exercises in Lectures)/12. System Tables, Pseudo Columns & Deleting Duplicates (Newly Added).srt 32.5 KB
  • [TutsNode.com] - The Complete Oracle SQL Certification Course/7. Creating, Altering, and Updating Objects Using SQL (Exercises in Lectures)/13. Views and Other Objects and Commands (Newly Added).srt 32.9 KB
  • [TutsNode.com] - The Complete Oracle SQL Certification Course/7. Creating, Altering, and Updating Objects Using SQL (Exercises in Lectures)/15. Granting and Revoking Privileges.mp4 339.9 MB
  • [TutsNode.com] - The Complete Oracle SQL Certification Course/7. Creating, Altering, and Updating Objects Using SQL (Exercises in Lectures)/15. Granting and Revoking Privileges.srt 20 KB
  • [TutsNode.com] - The Complete Oracle SQL Certification Course/7. Creating, Altering, and Updating Objects Using SQL (Exercises in Lectures)/2. Inserting Data Into Our Table.srt 27.5 KB
  • [TutsNode.com] - The Complete Oracle SQL Certification Course/7. Creating, Altering, and Updating Objects Using SQL (Exercises in Lectures)/3. Create Table With a Primary Key Constraint.srt 32.7 KB
  • [TutsNode.com] - The Complete Oracle SQL Certification Course/7. Creating, Altering, and Updating Objects Using SQL (Exercises in Lectures)/4. INSERT ALL for Multi-table & Conditional Inserts.srt 15.7 KB
  • [TutsNode.com] - The Complete Oracle SQL Certification Course/7. Creating, Altering, and Updating Objects Using SQL (Exercises in Lectures)/5. Using ALTER to modify the table structure.srt 22.5 KB
  • [TutsNode.com] - The Complete Oracle SQL Certification Course/7. Creating, Altering, and Updating Objects Using SQL (Exercises in Lectures)/6. Create Table with SELECT + UPDATE Data.srt 27.2 KB
  • [TutsNode.com] - The Complete Oracle SQL Certification Course/7. Creating, Altering, and Updating Objects Using SQL (Exercises in Lectures)/7. MERGE Statement in Oracle.srt 23.4 KB
  • [TutsNode.com] - The Complete Oracle SQL Certification Course/7. Creating, Altering, and Updating Objects Using SQL (Exercises in Lectures)/7.2 merge_sql_example.txt 2.9 KB
  • [TutsNode.com] - The Complete Oracle SQL Certification Course/7. Creating, Altering, and Updating Objects Using SQL (Exercises in Lectures)/8. Primary and Foreign Keys.html 1.6 KB
  • [TutsNode.com] - The Complete Oracle SQL Certification Course/7. Creating, Altering, and Updating Objects Using SQL (Exercises in Lectures)/9. Sequence Statements.srt 17.8 KB
  • [TutsNode.com] - The Complete Oracle SQL Certification Course/7. Creating, Altering, and Updating Objects Using SQL (Exercises in Lectures)/9.1 Code for Sequence Statements.txt 315 B
  • [TutsNode.com] - The Complete Oracle SQL Certification Course/8. ADDITIONAL TOPICS + REVIEW for EXAM 170-071/1. OFFSET and FETCH.srt 16.6 KB
  • [TutsNode.com] - The Complete Oracle SQL Certification Course/8. ADDITIONAL TOPICS + REVIEW for EXAM 170-071/2. ERD Diagrams.srt 28.6 KB
  • [TutsNode.com] - The Complete Oracle SQL Certification Course/8. ADDITIONAL TOPICS + REVIEW for EXAM 170-071/3. Commit, Rollback, and Savepoint.srt 22.5 KB
  • [TutsNode.com] - The Complete Oracle SQL Certification Course/8. ADDITIONAL TOPICS + REVIEW for EXAM 170-071/4. Large Objects and Interval Data Types.srt 28.6 KB
  • [TutsNode.com] - The Complete Oracle SQL Certification Course/8. ADDITIONAL TOPICS + REVIEW for EXAM 170-071/5. Using Cascade Constraints and On Delete Cascade.srt 27.8 KB
  • [TutsNode.com] - The Complete Oracle SQL Certification Course/8. ADDITIONAL TOPICS + REVIEW for EXAM 170-071/6. UNUSED Columns.srt 12 KB
  • [TutsNode.com] - The Complete Oracle SQL Certification Course/8. ADDITIONAL TOPICS + REVIEW for EXAM 170-071/7. External Tables.srt 24.3 KB
  • [TutsNode.com] - The Complete Oracle SQL Certification Course/8. ADDITIONAL TOPICS + REVIEW for EXAM 170-071/8. SQL Plus and Substitution Variables.mp4 225.5 MB
  • [TutsNode.com] - The Complete Oracle SQL Certification Course/8. ADDITIONAL TOPICS + REVIEW for EXAM 170-071/8. SQL Plus and Substitution Variables.srt 53.8 KB
  • [TutsNode.com] - The Complete Oracle SQL Certification Course/9. Exam Question Walkthrough Videos + 2 Exams/1. QA 1- DML, DDL, and Transaction Control.mp4 167.9 MB
  • [TutsNode.com] - The Complete Oracle SQL Certification Course/9. Exam Question Walkthrough Videos + 2 Exams/1. QA 1- DML, DDL, and Transaction Control.srt 40.9 KB
  • [TutsNode.com] - The Complete Oracle SQL Certification Course/9. Exam Question Walkthrough Videos + 2 Exams/2. QA 2- Fetch and Substitution Variables.mp4 177 MB
  • [TutsNode.com] - The Complete Oracle SQL Certification Course/9. Exam Question Walkthrough Videos + 2 Exams/2. QA 2- Fetch and Substitution Variables.srt 42.1 KB
  • [TutsNode.com] - The Complete Oracle SQL Certification Course/9. Exam Question Walkthrough Videos + 2 Exams/3. QA 3- Conversion Functions, T0_CHAR, TO_DATE, and NVL.mp4 213.9 MB
  • [TutsNode.com] - The Complete Oracle SQL Certification Course/9. Exam Question Walkthrough Videos + 2 Exams/3. QA 3- Conversion Functions, T0_CHAR, TO_DATE, and NVL.srt 48.5 KB

Rating
Not rated yet
Log in to rate

Comments

No comments yet.