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
Udemy - The Complete Oracle SQL Certification Course 2020-6 [AhLaN]
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.
VISITOR COMMENTS (0 )
FILE LIST
Filename
Size
1. Database Basics/1. Oracle Database Introduction & Basics of Tables.mp4
67.5 MB
1. Database Basics/2. Creating the Workspace in Oracle.mp4
50.4 MB
1. Database Basics/3. IMPORTANT Prepare the Sample Data.mp4
24.3 MB
1. Database Basics/3.1 course_data.txt
764 B
2. Single Table Queries (Exercises & Solutions in the Lectures)/1. Oracle Exams and Certification Information.html
688 B
2. Single Table Queries (Exercises & Solutions in the Lectures)/2. Retrieving Data Using the SELECT Clause.mp4
25.3 MB
2. Single Table Queries (Exercises & Solutions in the Lectures)/2.1 Code for Select Clause.txt
132 B
2. Single Table Queries (Exercises & Solutions in the Lectures)/3. Using the WHERE Clause in a Query.mp4
93.9 MB
2. Single Table Queries (Exercises & Solutions in the Lectures)/3.1 Code for WHERE Clause.txt
130 B
2. Single Table Queries (Exercises & Solutions in the Lectures)/4. Using Operators in the WHERE Clause.mp4
122.9 MB
2. Single Table Queries (Exercises & Solutions in the Lectures)/4.1 Code for Using Operators in the WHERE Clause.txt
277 B
2. Single Table Queries (Exercises & Solutions in the Lectures)/5. Combining WHERE, AND & OR with Operators.mp4
104.5 MB
2. Single Table Queries (Exercises & Solutions in the Lectures)/5.1 Code for Combining WHERE, AND & OR Operators.txt
199 B
2. Single Table Queries (Exercises & Solutions in the Lectures)/6. Query Filtering Continued BETWEEN, IN and NULL.mp4
109.9 MB
2. Single Table Queries (Exercises & Solutions in the Lectures)/6.1 Code for Query Filtering Continued BETWEEN, IN & NULL.txt
281 B
2. Single Table Queries (Exercises & Solutions in the Lectures)/7. Query Filtering Conditions & Operator Precedence.mp4
110.1 MB
2. Single Table Queries (Exercises & Solutions in the Lectures)/7.1 Code for Query Filtering Conditions & Operator Precedence.txt
326 B
2. Single Table Queries (Exercises & Solutions in the Lectures)/8. Ordering, Concatenating & Aliasing Query Results.mp4
109.5 MB
2. Single Table Queries (Exercises & Solutions in the Lectures)/8.1 Code for Ordering, Concatenating & Aliasing Query Results.txt
331 B
2. Single Table Queries (Exercises & Solutions in the Lectures)/9. Practice with single table queries.html
159 B
3. Single Row Functions (Exercises and Solutions In the Lectures)/1. Single Row Functions (SRF) & Using The Dual Table.mp4
96.5 MB
3. Single Row Functions (Exercises and Solutions In the Lectures)/1.1 Code for Single Row Functions (SRF) & Using the Dual Table.txt
295 B
3. Single Row Functions (Exercises and Solutions In the Lectures)/2. Using Functions in WHERE And Character Based SRFs.mp4
103.4 MB
3. Single Row Functions (Exercises and Solutions In the Lectures)/2.1 Code for Using Functions in WHERE and Character Based SRFs.txt
281 B
3. Single Row Functions (Exercises and Solutions In the Lectures)/3. Numeric and Date Data type SRFs.mp4
98.6 MB
3. Single Row Functions (Exercises and Solutions In the Lectures)/3.1 Code for Numeric and Date Datatype SRFs.txt
1.1 KB
3. Single Row Functions (Exercises and Solutions In the Lectures)/4. Conversion SRFs and Date Formatting.mp4
95.1 MB
3. Single Row Functions (Exercises and Solutions In the Lectures)/4.1 Code for Conversion SRFs & Date Formatting.txt
528 B
3. Single Row Functions (Exercises and Solutions In the Lectures)/5. Some More Date Functions.html
723 B
3. Single Row Functions (Exercises and Solutions In the Lectures)/6. Concluding SRFs & NULL NULLIF Functions.mp4
78.3 MB
3. Single Row Functions (Exercises and Solutions In the Lectures)/6.1 Code for Concluding SRFs & NULLNULLIF Functions.txt
778 B
3. Single Row Functions (Exercises and Solutions In the Lectures)/7. Practice with Single Row Functions.html
159 B
4. Grouping Functions (Exercises and Solutions In the Lectures)/1. Grouping Functions MIN, MAX, AVG, COUNT etc..mp4
100.9 MB
4. Grouping Functions (Exercises and Solutions In the Lectures)/1.1 Code for Grouping Functions MIN, MAX, AVG, COUNT etc.txt
865 B
4. Grouping Functions (Exercises and Solutions In the Lectures)/2. GROUP BY Clause & HAVING Clause.mp4
99.2 MB
4. Grouping Functions (Exercises and Solutions In the Lectures)/2.1 Code for GROUP BY Clause & HAVING CLAUSE.txt
200 B
4. Grouping Functions (Exercises and Solutions In the Lectures)/3. More Practice With The GROUP BY Clause.mp4
65.3 MB
4. Grouping Functions (Exercises and Solutions In the Lectures)/3.1 Code for More Practice with the GROUP BY Clause.txt
98 B
5. Multi-Table Queries and Joins (Exercises and Solutions In the Lectures)/1. SELECT within SELECT (Subqueries).mp4
127.2 MB
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
5. Multi-Table Queries and Joins (Exercises and Solutions In the Lectures)/2. Relating Tables Together Using JOINs.mp4
110.3 MB
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
5. Multi-Table Queries and Joins (Exercises and Solutions In the Lectures)/3. Joins Continued INNER & OUTER Joins.mp4
137.5 MB
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
5. Multi-Table Queries and Joins (Exercises and Solutions In the Lectures)/4. Correlated Subqueries with EXISTS & NOT EXIST operators.mp4
122.6 MB
5. Multi-Table Queries and Joins (Exercises and Solutions In the Lectures)/4.1 Code for More JOINS with Correlated Subqueries .txt
1.1 KB
5. Multi-Table Queries and Joins (Exercises and Solutions In the Lectures)/5. SELF JOIN.mp4
59 MB
5. Multi-Table Queries and Joins (Exercises and Solutions In the Lectures)/6. CROSS JOIN, NATURAL JOIN and the USING CLAUSE.mp4
53.1 MB
5. Multi-Table Queries and Joins (Exercises and Solutions In the Lectures)/7. EQUIJOIN and NON-EQUIJOINs.mp4
45.9 MB
5. Multi-Table Queries and Joins (Exercises and Solutions In the Lectures)/7.1 Code for EQUI and NON-EQUI Joins.txt
421 B
5. Multi-Table Queries and Joins (Exercises and Solutions In the Lectures)/8. CASE Statements.mp4
61.6 MB
5. Multi-Table Queries and Joins (Exercises and Solutions In the Lectures)/8.1 Code for CASE Statement.txt
379 B
6. Analytical Functions using OVER and PARTITION with ORDER BY/1. OVER Clause with PARTITION BY.mp4
118.1 MB
6. Analytical Functions using OVER and PARTITION with ORDER BY/2. Compute Running Totals with Ordering and Partitioning.mp4
128.3 MB
6. Analytical Functions using OVER and PARTITION with ORDER BY/3. Unbounded Preceding Order in Over Clause.mp4
61.1 MB
6. Analytical Functions using OVER and PARTITION with ORDER BY/4. Slicing Windows and Filtering with Analytic Functions.mp4
44.8 MB
6. Analytical Functions using OVER and PARTITION with ORDER BY/5. Rank, Dense_rank, Lead, and Lag Functions.mp4
107.9 MB
7. Creating, Altering, and Updating Objects Using SQL (Exercises in Lectures)/1. Creating Your Own Tables & Design Considerations.mp4
117.5 MB
7. Creating, Altering, and Updating Objects Using SQL (Exercises in Lectures)/1.1 Code for Creating Your Own Tables & Design Considerations.txt
158 B
7. Creating, Altering, and Updating Objects Using SQL (Exercises in Lectures)/10. DELETE, TRUNCATE, and DROP Commands.mp4
114.2 MB
7. Creating, Altering, and Updating Objects Using SQL (Exercises in Lectures)/10.1 Code for Delete, Truncate and Drop Commands.txt
397 B
7. Creating, Altering, and Updating Objects Using SQL (Exercises in Lectures)/11. Working With Database Indexes.mp4
80.4 MB
7. Creating, Altering, and Updating Objects Using SQL (Exercises in Lectures)/11.1 Code for Database Indexes.txt
601 B
7. Creating, Altering, and Updating Objects Using SQL (Exercises in Lectures)/12. System Tables, Pseudo Columns & Deleting Duplicates (Newly Added).mp4
159.1 MB
7. Creating, Altering, and Updating Objects Using SQL (Exercises in Lectures)/12.1 Code for System Tables, Pseudo Columns, & Deleting Duplicate Data.txt
1.2 KB
7. Creating, Altering, and Updating Objects Using SQL (Exercises in Lectures)/13. Views and Other Objects and Commands (Newly Added).mp4
138.3 MB
7. Creating, Altering, and Updating Objects Using SQL (Exercises in Lectures)/13.1 Code for Other Objects and Commands VIEWs UNIONALL etc.txt
1.6 KB
7. Creating, Altering, and Updating Objects Using SQL (Exercises in Lectures)/14. SQL could be tricky, check this out!.html
1.2 KB
7. Creating, Altering, and Updating Objects Using SQL (Exercises in Lectures)/15. Granting and Revoking Privileges.mp4
339.9 MB
7. Creating, Altering, and Updating Objects Using SQL (Exercises in Lectures)/16. BECOME A SQL QUERY WIZARD!.html
704 B
7. Creating, Altering, and Updating Objects Using SQL (Exercises in Lectures)/17. Bonus Lecture Lifetime Access to All My Courses.html
995 B
7. Creating, Altering, and Updating Objects Using SQL (Exercises in Lectures)/2. Inserting Data Into Our Table.mp4
113.8 MB
7. Creating, Altering, and Updating Objects Using SQL (Exercises in Lectures)/2.1 Code for Inserting Data Into our Table.txt
984 B
7. Creating, Altering, and Updating Objects Using SQL (Exercises in Lectures)/3. Create Table With a Primary Key Constraint.mp4
146.5 MB
7. Creating, Altering, and Updating Objects Using SQL (Exercises in Lectures)/3.1 Code for Create Table With Primary Key Constraint.txt
1.9 KB
7. Creating, Altering, and Updating Objects Using SQL (Exercises in Lectures)/4. INSERT ALL for Multi-table & Conditional Inserts.mp4
77.1 MB
7. Creating, Altering, and Updating Objects Using SQL (Exercises in Lectures)/4.1 Code for Multi-Table Insert Using INSERT ALL.txt
1 KB
7. Creating, Altering, and Updating Objects Using SQL (Exercises in Lectures)/5. Using ALTER to modify the table structure.mp4
100 MB
7. Creating, Altering, and Updating Objects Using SQL (Exercises in Lectures)/5.1 Code for Alter Table and Modify Column Attributes.txt
690 B
7. Creating, Altering, and Updating Objects Using SQL (Exercises in Lectures)/6. Create Table with SELECT + UPDATE Data.mp4
123.5 MB
7. Creating, Altering, and Updating Objects Using SQL (Exercises in Lectures)/6.1 Code for Create Table with SELECT and UPDATE existing Data.txt
706 B
7. Creating, Altering, and Updating Objects Using SQL (Exercises in Lectures)/7. MERGE Statement in Oracle.mp4
117.4 MB
7. Creating, Altering, and Updating Objects Using SQL (Exercises in Lectures)/7.1 Code for MERGE Statement.txt
1.1 KB
7. Creating, Altering, and Updating Objects Using SQL (Exercises in Lectures)/7.2 merge_sql_example.txt
2.9 KB
7. Creating, Altering, and Updating Objects Using SQL (Exercises in Lectures)/8. Primary and Foreign Keys.html
1.6 KB
7. Creating, Altering, and Updating Objects Using SQL (Exercises in Lectures)/9. Sequence Statements.mp4
64.6 MB
7. Creating, Altering, and Updating Objects Using SQL (Exercises in Lectures)/9.1 Code for Sequence Statements.txt
315 B
8. ADDITIONAL TOPICS + REVIEW for EXAM 170-071/1. OFFSET and FETCH.mp4
65.9 MB
8. ADDITIONAL TOPICS + REVIEW for EXAM 170-071/2. ERD Diagrams.mp4
61.9 MB
8. ADDITIONAL TOPICS + REVIEW for EXAM 170-071/3. Commit, Rollback, and Savepoint.mp4
54.4 MB
8. ADDITIONAL TOPICS + REVIEW for EXAM 170-071/4. Large Objects and Interval Data Types.mp4
131.3 MB
8. ADDITIONAL TOPICS + REVIEW for EXAM 170-071/5. Using Cascade Constraints and On Delete Cascade.mp4
114.7 MB
8. ADDITIONAL TOPICS + REVIEW for EXAM 170-071/5.1 code for cascade constraints.txt
798 B
8. ADDITIONAL TOPICS + REVIEW for EXAM 170-071/6. UNUSED Columns.mp4
38.7 MB
8. ADDITIONAL TOPICS + REVIEW for EXAM 170-071/7. External Tables.mp4
107.6 MB
8. ADDITIONAL TOPICS + REVIEW for EXAM 170-071/7.1 code for external tables.txt
![Udemy - The Complete Oracle SQL Certification Course 2020-6 [AhLaN]](https://f.t0r.site/cover/35428152.webp)
