17 OCT 2024 - Welcome Back to TorrentFunk! Get your pirate hat back out. Streaming is dying and torrents are the new trend. Account Registration works again and so do Torrent Uploads. We invite you all to start uploading torrents again!
TORRENT DETAILS
The Complete Oracle SQL Certification Course
TORRENT SUMMARY
Status:
All the torrents in this section have been verified by our verification system
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
VISITOR COMMENTS (0 )
FILE LIST
Filename
Size
.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
[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
