Udemy - The Complete Oracle SQL Certification Course
movies, software, shows...
Files
| .pad | |||
| 0 | 78 B | ||
| 1 | 6 B | ||
| 2 | 7 B | ||
| 3 | 64.39 KB | ||
| 4 | 948.8 KB | ||
| 5 | 520.21 KB | ||
| 6 | 727.23 KB | ||
| 7 | 527.87 KB | ||
| 8 | 687.42 KB | ||
| 9 | 666.34 KB | ||
| 10 | 853.53 KB | ||
| 11 | 476.65 KB | ||
| 12 | 87.72 KB | ||
| 13 | 451.32 KB | ||
| 14 | 954.64 KB | ||
| 15 | 561.7 KB | ||
| 16 | 563.58 KB | ||
| 17 | 291.58 KB | ||
| 18 | 779.05 KB | ||
| 19 | 227.74 KB | ||
| 20 | 696.13 KB | ||
| 21 | 918.14 KB | ||
| 22 | 58.66 KB | ||
| 23 | 485.66 KB | ||
| 24 | 135.21 KB | ||
| 25 | 436.04 KB | ||
| 26 | 501.57 KB | ||
| 27 | 645.42 KB | ||
| 28 | 122.98 KB | ||
| 29 | 1019.04 KB | ||
| 30 | 853.2 KB | ||
| 31 | 383.9 KB | ||
| 32 | 479.44 KB | ||
| 33 | 884.58 KB | ||
| 34 | 894.24 KB | ||
| 35 | 139.76 KB | ||
| 36 | 567.33 KB | ||
| 37 | 461.16 KB | ||
| 38 | 732.78 KB | ||
| 39 | 979 KB | ||
| 40 | 472.96 KB | ||
| 41 | 112.13 KB | ||
| 42 | 690.03 KB | ||
| 43 | 1010.35 KB | ||
| 44 | 419.09 KB | ||
| 45 | 126.02 KB | ||
| 46 | 399.94 KB | ||
| 47 | 933.82 KB | ||
| 48 | 1001.73 KB | ||
| 49 | 621.41 KB | ||
| 50 | 878.9 KB | ||
| 51 | 61.37 KB | ||
| 52 | 651.86 KB | ||
| 53 | 554.26 KB | ||
| 54 | 99.46 KB | ||
| 55 | 222.42 KB | ||
| 56 | 295.72 KB | ||
| 57 | 718.72 KB | ||
| 58 | 741.63 KB | ||
| 59 | 749.27 KB | ||
| TutsNode.com.txt | 63 B | ||
| [TGx]Downloaded from torrentgalaxy.to .txt | 585 B | ||
| [TutsNode.com] - The Complete Oracle SQL Certification Course | |||
| 1. Database Basics | |||
| 1. Oracle Database Introduction & Basics of Tables.mp4 | 67.54 MB | ||
| 1. Oracle Database Introduction & Basics of Tables.srt | 20.18 MB | ||
| 2. Creating the Workspace in Oracle.mp4 | 50.36 MB | ||
| 2. Creating the Workspace in Oracle.srt | 10.22 KB | ||
| 3. IMPORTANT Prepare the Sample Data.mp4 | 24.27 MB | ||
| 3. IMPORTANT Prepare the Sample Data.srt | 5.82 KB | ||
| 3.1 course_data.txt | 2.43 KB | ||
| 4. How to Proceed in This Course.mp4 | 47.46 MB | ||
| 4. How to Proceed in This Course.srt | 4.09 KB | ||
| 10. APPENDIX - Installing Oracle on Windows | |||
| 1. Install Oracle Database 19c in Windows.mp4 | 78.55 MB | ||
| 1. Install Oracle Database 19c in Windows.srt | 16.18 KB | ||
| 2. Install Oracle SQL Developer in Windows.mp4 | 95.13 MB | ||
| 2. Install Oracle SQL Developer in Windows.srt | 21.94 KB | ||
| 2. Single Table Queries (Exercises & Solutions in the Lectures) | |||
| 1. Oracle Exams and Certification Information.html | 688 B | ||
| 10. Ordering, Concatenating & Aliasing Query Results.mp4 | 109.53 MB | ||
| 10. Ordering, Concatenating & Aliasing Query Results.srt | 25.81 KB | ||
| 10.1 Code for Ordering, Concatenating & Aliasing Query Results.txt | 683 B | ||
| 11. Assignment 1 Practice with Single Table Queries.html | 5.3 KB | ||
| 2. Retrieving Data Using the SELECT Clause.mp4 | 25.28 MB | ||
| 2. Retrieving Data Using the SELECT Clause.srt | 20 KB | ||
| 2.1 Code for Select Clause.txt | 245 B | ||
| 3. Using the WHERE Clause in a Query.mp4 | 93.86 MB | ||
| 3. Using the WHERE Clause in a Query.srt | 26 KB | ||
| 3.1 Code for WHERE Clause.txt | 130 B | ||
| 4. Using Operators in the WHERE Clause.mp4 | 122.91 MB | ||
| 4. Using Operators in the WHERE Clause.srt | 28.33 KB | ||
| 4.1 Code for Using Operators in the WHERE Clause.txt | 659 B | ||
| 5. Some Inspiration.mp4 | 50.94 MB | ||
| 5. Some Inspiration.srt | 4.5 KB | ||
| 6. Combining WHERE, AND & OR with Operators.mp4 | 104.51 MB | ||
| 6. Combining WHERE, AND & OR with Operators.srt | 28.37 KB | ||
| 6.1 Code for Combining WHERE, AND & OR Operators.txt | 263 B | ||
| 7. Query Filtering Continued BETWEEN, IN and NULL.mp4 | 109.94 MB | ||
| 7. Query Filtering Continued BETWEEN, IN and NULL.srt | 26.89 KB | ||
| 7.1 Code for Query Filtering Continued BETWEEN, IN & NULL.txt | 618 B | ||
| 8. What Will Make you Grow as a Software Developer.mp4 | 65.01 MB | ||
| 8. What Will Make you Grow as a Software Developer.srt | 5.92 KB | ||
| 9. Query Filtering Conditions & Operator Precedence.mp4 | 110.1 MB | ||
| 9. Query Filtering Conditions & Operator Precedence.srt | 27.31 KB | ||
| 9.1 Code for Query Filtering Conditions & Operator Precedence.txt | 689 B | ||
| 3. Single Row Functions (Exercises and Solutions In the Lectures) | |||
| 1. Single Row Functions (SRF) & Using The Dual Table.mp4 | 96.53 MB | ||
| 1. Single Row Functions (SRF) & Using The Dual Table.srt | 26.64 KB | ||
| 1.1 Code for Single Row Functions (SRF) & Using the Dual Table.txt | 715 B | ||
| 2. Using Functions in WHERE And Character Based SRFs.mp4 | 103.37 MB | ||
| 2. Using Functions in WHERE And Character Based SRFs.srt | 26.49 KB | ||
| 2.1 Code for Using Functions in WHERE and Character Based SRFs.txt | 1.02 KB | ||
| 3. Numeric and Date Data type SRFs.mp4 | 98.63 MB | ||
| 3. Numeric and Date Data type SRFs.srt | 27.63 KB | ||
| 3.1 Code for Numeric and Date Datatype SRFs.txt | 1.1 KB | ||
| 4. Conversion SRFs and Date Formatting.mp4 | 95.14 MB | ||
| 4. Conversion SRFs and Date Formatting.srt | 27.44 KB | ||
| 4.1 Code for Conversion SRFs & Date Formatting.txt | 528 B | ||
| 5. Some More Date Functions.html | 723 B | ||
| 6. Concluding SRFs & NULL NULLIF Functions.mp4 | 78.28 MB | ||
| 6. Concluding SRFs & NULL NULLIF Functions.srt | 23.32 KB | ||
| 6.1 Code for Concluding SRFs & NULLNULLIF Functions.txt | 778 B | ||
| 7. Assignment 2 Practice with Single Row Functions.html | 6.63 KB | ||
| 4. Grouping Functions (Exercises and Solutions In the Lectures) | |||
| 1. Grouping Functions MIN, MAX, AVG, COUNT etc..mp4 | 100.88 MB | ||
| 1. Grouping Functions MIN, MAX, AVG, COUNT etc..srt | 27.38 KB | ||
| 1.1 Code for Grouping Functions MIN, MAX, AVG, COUNT etc.txt | 865 B | ||
| 2. GROUP BY Clause & HAVING Clause.mp4 | 99.17 MB | ||
| 2. GROUP BY Clause & HAVING Clause.srt | 28.32 KB | ||
| 2.1 Code for GROUP BY Clause & HAVING CLAUSE.txt | 601 B | ||
| 3. More Practice With The GROUP BY Clause.mp4 | 65.33 MB | ||
| 3. More Practice With The GROUP BY Clause.srt | 17.61 KB | ||
| 3.1 Code for More Practice with the GROUP BY Clause.txt | 259 B | ||
| 5. Multi-Table Queries and Joins (Exercises and Solutions In the Lectures) | |||
| 1. SELECT within SELECT (Subqueries).mp4 | 127.17 MB | ||
| 1. SELECT within SELECT (Subqueries).srt | 34.32 KB | ||
| 1.1 Code for SELECT within SELECT (Nested Queries Subqueries).txt | 1.24 KB | ||
| 2. Relating Tables Together Using JOINs.mp4 | 110.32 MB | ||
| 2. Relating Tables Together Using JOINs.srt | 27.38 KB | ||
| 2.1 Code for Relating Tables together using JOINs .txt | 1.18 KB | ||
| 3. Joins Continued INNER & OUTER Joins.mp4 | 137.48 MB | ||
| 3. Joins Continued INNER & OUTER Joins.srt | 30.33 KB | ||
| 3.1 Code for JOINS Continued INNER & OUTER Joins.txt | 1.2 KB | ||
| 4. Career Advice.mp4 | 30.3 MB | ||
| 4. Career Advice.srt | 2.72 KB | ||
| 5. Correlated Subqueries with EXISTS & NOT EXIST operators.mp4 | 122.56 MB | ||
| 5. Correlated Subqueries with EXISTS & NOT EXIST operators.srt | 29.87 KB | ||
| 5.1 Code for More JOINS with Correlated Subqueries .txt | 1.11 KB | ||
| 6. SELF JOIN.mp4 | 59.02 MB | ||
| 6. SELF JOIN.srt | 16.69 KB | ||
| 7. CROSS JOIN, NATURAL JOIN and the USING CLAUSE.mp4 | 53.14 MB | ||
| 7. CROSS JOIN, NATURAL JOIN and the USING CLAUSE.srt | 12.59 KB | ||
| 8. EQUIJOIN and NON-EQUIJOINs.mp4 | 45.9 MB | ||
| 8. EQUIJOIN and NON-EQUIJOINs.srt | 14.43 KB | ||
| 8.1 Code for EQUI and NON-EQUI Joins.txt | 421 B | ||
| 9. CASE Statements.mp4 | 61.61 MB | ||
| 9. CASE Statements.srt | 11.85 KB | ||
| 9.1 Oracle COALESCE Function.pdf | 283.16 KB | ||
| 9.2 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.07 MB | ||
| 1. OVER Clause with PARTITION BY.srt | 27.54 KB | ||
| 2. Compute Running Totals with Ordering and Partitioning.mp4 | 128.35 MB | ||
| 2. Compute Running Totals with Ordering and Partitioning.srt | 28.79 KB | ||
| 3. Unbounded Preceding Order in Over Clause.mp4 | 61.09 MB | ||
| 3. Unbounded Preceding Order in Over Clause.srt | 13.86 KB | ||
| 4. Slicing Windows and Filtering with Analytic Functions.mp4 | 44.78 MB | ||
| 4. Slicing Windows and Filtering with Analytic Functions.srt | 10.12 KB | ||
| 5. Rank, Dense_rank, Lead, and Lag Functions.mp4 | 107.87 MB | ||
| 5. Rank, Dense_rank, Lead, and Lag Functions.srt | 23.91 KB | ||
| 7. Creating, Altering, and Updating Objects Using SQL (Exercises in Lectures) | |||
| 1. Creating Your Own Tables & Design Considerations.mp4 | 117.45 MB | ||
| 1. Creating Your Own Tables & Design Considerations.srt | 31.23 KB | ||
| 1.1 Code for Creating Your Own Tables & Design Considerations.txt | 158 B | ||
| 10. DELETE, TRUNCATE, and DROP Commands.mp4 | 114.24 MB | ||
| 10. DELETE, TRUNCATE, and DROP Commands.srt | 25.54 KB | ||
| 10.1 Code for Delete, Truncate and Drop Commands.txt | 397 B | ||
| 11. Working With Database Indexes.mp4 | 80.45 MB | ||
| 11. Working With Database Indexes.srt | 20.01 KB | ||
| 11.1 Code for Database Indexes.txt | 601 B | ||
| 12. System Tables, Pseudo Columns & Deleting Duplicates (Newly Added).mp4 | 159.07 MB | ||
| 12. System Tables, Pseudo Columns & Deleting Duplicates (Newly Added).srt | 32.5 KB | ||
| 12.1 Code for System Tables, Pseudo Columns, & Deleting Duplicate Data.txt | 1.17 KB | ||
| 13. Views and Other Objects and Commands (Newly Added).mp4 | 138.29 MB | ||
| 13. Views and Other Objects and Commands (Newly Added).srt | 32.89 KB | ||
| 13.1 Code for Other Objects and Commands VIEWs UNIONALL etc.txt | 1.57 KB | ||
| 14. SQL could be tricky, check this out!.html | 1.2 KB | ||
| 15. Granting and Revoking Privileges.mp4 | 339.87 MB | ||
| 15. Granting and Revoking Privileges.srt | 20.01 KB | ||
| 16. BECOME A SQL QUERY WIZARD!.html | 704 B | ||
| 17. Bonus Lecture Lifetime Access to All My Courses.html | 995 B | ||
| 2. Inserting Data Into Our Table.mp4 | 113.78 MB | ||
| 2. Inserting Data Into Our Table.srt | 27.48 KB | ||
| 2.1 Code for Inserting Data Into our Table.txt | 984 B | ||
| 3. Create Table With a Primary Key Constraint.mp4 | 146.49 MB | ||
| 3. Create Table With a Primary Key Constraint.srt | 32.66 KB | ||
| 3.1 Code for Create Table With Primary Key Constraint.txt | 1.91 KB | ||
| 4. INSERT ALL for Multi-table & Conditional Inserts.mp4 | 77.04 MB | ||
| 4. INSERT ALL for Multi-table & Conditional Inserts.srt | 15.74 KB | ||
| 4.1 Code for Multi-Table Insert Using INSERT ALL.txt | 1.01 KB | ||
| 5. Using ALTER to modify the table structure.mp4 | 100 MB | ||
| 5. Using ALTER to modify the table structure.srt | 22.53 KB | ||
| 5.1 Code for Alter Table and Modify Column Attributes.txt | 690 B | ||
| 6. Create Table with SELECT + UPDATE Data.mp4 | 123.53 MB | ||
| 6. Create Table with SELECT + UPDATE Data.srt | 27.17 KB | ||
| 6.1 Code for Create Table with SELECT and UPDATE existing Data.txt | 706 B | ||
| 7. MERGE Statement in Oracle.mp4 | 117.45 MB | ||
| 7. MERGE Statement in Oracle.srt | 23.43 KB | ||
| 7.1 Code for MERGE Statement.txt | 1.05 KB | ||
| 7.2 merge_sql_example.txt | 2.88 KB | ||
| 8. Primary and Foreign Keys.html | 1.57 KB | ||
| 9. Sequence Statements.mp4 | 64.59 MB | ||
| 9. Sequence Statements.srt | 17.76 KB | ||
| 9.1 Code for Sequence Statements.txt | 315 B | ||
| 8. ADDITIONAL TOPICS + REVIEW for EXAM 170-071 | |||
| 1. OFFSET and FETCH.mp4 | 65.89 MB | ||
| 1. OFFSET and FETCH.srt | 16.63 KB | ||
| 2. ERD Diagrams.mp4 | 61.88 MB | ||
| 2. ERD Diagrams.srt | 28.57 KB | ||
| 3. Commit, Rollback, and Savepoint.mp4 | 54.39 MB | ||
| 3. Commit, Rollback, and Savepoint.srt | 22.5 KB | ||
| 4. Large Objects and Interval Data Types.mp4 | 131.33 MB | ||
| 4. Large Objects and Interval Data Types.srt | 28.56 KB | ||
| 4.1 code for building_lease example.txt | 506 B | ||
| 5. Using Cascade Constraints and On Delete Cascade.mp4 | 114.72 MB | ||
| 5. Using Cascade Constraints and On Delete Cascade.srt | 27.83 KB | ||
| 5.1 code for cascade constraints.txt | 798 B | ||
| 6. UNUSED Columns.mp4 | 38.71 MB | ||
| 6. UNUSED Columns.srt | 12.04 KB | ||
| 7. External Tables.mp4 | 107.57 MB | ||
| 7. External Tables.srt | 24.27 KB | ||
| 7.1 code for external tables.txt | 1.02 KB | ||
| 8. SQL Plus and Substitution Variables.mp4 | 225.52 MB | ||
| 8. SQL Plus and Substitution Variables.srt | 53.82 KB | ||
| 9. Exam Question Walkthrough Videos + 2 Exams | |||
| 1. QA 1- DML, DDL, and Transaction Control.mp4 | 167.91 MB | ||
| 1. QA 1- DML, DDL, and Transaction Control.srt | 40.86 KB | ||
| 2. QA 2- Fetch and Substitution Variables.mp4 | 176.99 MB | ||
| 2. QA 2- Fetch and Substitution Variables.srt | 42.13 KB | ||
| 3. QA 3- Conversion Functions, T0_CHAR, TO_DATE, and NVL.mp4 | 213.93 MB | ||
| 3. QA 3- Conversion Functions, T0_CHAR, TO_DATE, and NVL.srt | 48.52 KB | ||
| 4. Practice Test 1.html | 155 B | ||
| 5. Practice Test 2.html | 155 B |
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
Related Torrents
| torrent name | size | uploader | age | seed | leech |
|---|---|---|---|---|---|
|
Udemy - ISO 26262 Automotive Functional Safety - The Blueprint Method Posted by
freecoursewb in Other
|
1.9 GB | freecoursewb | 4 days | 1 | 17 |
|
Udemy - Databricks Playbook - Operate, Govern and Defend the Lakehouse Posted by
freecoursewb in Other
|
2.3 GB | freecoursewb | 5 days | 1 | 6 |
| 426.3 MB | freecoursewb | 5 days | 33 | 10 | |
| 473.8 MB | freecoursewb | 1 week | 16 | 5 | |
| 3.7 GB | freecoursewb | 2 weeks | 5 | 7 |
All Comments