▲
0
0

report

Udemy - The Complete Oracle SQL Certification Course 2020-6 [AhLaN]

seeders: 0
leechers: 0
Download torrent
Added 5 years ago by abidmail in Other
Download Fast Safe Anonymous
movies, software, shows...

Files

Udemy - The Complete Oracle SQL Certification Course 2020-6 [AhLaN] (Size: 5.8 GB)
  1. Creating Your Own Tables & Design Considerations.mp4 117.5 MB
  1. Grouping Functions MIN, MAX, AVG, COUNT etc..mp4 100.9 MB
  1. Install Oracle Database 19c in Windows.mp4 78.5 MB
  1. OFFSET and FETCH.mp4 65.9 MB
  1. OVER Clause with PARTITION BY.mp4 118.1 MB
  1. Oracle Database Introduction & Basics of Tables.mp4 67.5 MB
  1. Oracle Exams and Certification Information.html 716 B
  1. QA 1- DML, DDL, and Transaction Control.mp4 167.9 MB
  1. SELECT within SELECT (Subqueries).mp4 127.2 MB
  1. Single Row Functions (SRF) & Using The Dual Table.mp4 96.5 MB
  1.1 Code for Creating Your Own Tables & Design Considerations.txt 204 B
  1.1 Code for Grouping Functions MIN, MAX, AVG, COUNT etc.txt 819 B
  1.1 Code for SELECT within SELECT (Nested Queries Subqueries).txt 1.2 KB
  1.1 Code for Single Row Functions (SRF) & Using the Dual Table.txt 307 B
  10. DELETE, TRUNCATE, and DROP Commands.mp4 114.2 MB
  10.1 Code for Delete, Truncate and Drop Commands.txt 409 B
  11. Working With Database Indexes.mp4 80.4 MB
  11.1 Code for Database Indexes.txt 614 B
  12. System Tables, Pseudo Columns & Deleting Duplicates (Newly Added).mp4 159.1 MB
  12.1 Code for System Tables, Pseudo Columns, & Deleting Duplicate Data.txt 1.2 KB
  13. Views and Other Objects and Commands (Newly Added).mp4 138.3 MB
  13.1 Code for Other Objects and Commands VIEWs UNIONALL etc.txt 1.6 KB
  14. SQL could be tricky, check this out!.html 1.2 KB
  15. Granting and Revoking Privileges.mp4 339.9 MB
  16. BECOME A SQL QUERY WIZARD!.html 716 B
  17. Bonus Lecture Lifetime Access to All My Courses.html 1 KB
  2. Compute Running Totals with Ordering and Partitioning.mp4 128.3 MB
  2. Creating the Workspace in Oracle.mp4 50.4 MB
  2. ERD Diagrams.mp4 61.9 MB
  2. GROUP BY Clause & HAVING Clause.mp4 99.2 MB
  2. Inserting Data Into Our Table.mp4 113.8 MB
  2. Install Oracle SQL Developer in Windows.mp4 95.1 MB
  2. QA 2- Fetch and Substitution Variables.mp4 177 MB
  2. Relating Tables Together Using JOINs.mp4 110.3 MB
  2. Retrieving Data Using the SELECT Clause.mp4 25.3 MB
  2. Using Functions in WHERE And Character Based SRFs.mp4 103.4 MB
  2.1 Code for GROUP BY Clause & HAVING CLAUSE.txt 204 B
  2.1 Code for Inserting Data Into our Table.txt 1 KB
  2.1 Code for Relating Tables together using JOINs .txt 1.2 KB
  2.1 Code for Select Clause.txt 102 B
  2.1 Code for Using Functions in WHERE and Character Based SRFs.txt 307 B
  3. Commit, Rollback, and Savepoint.mp4 54.4 MB
  3. Create Table With a Primary Key Constraint.mp4 146.5 MB
  3. IMPORTANT Prepare the Sample Data.mp4 24.3 MB
  3. Joins Continued INNER & OUTER Joins.mp4 137.5 MB
  3. More Practice With The GROUP BY Clause.mp4 65.3 MB
  3. Numeric and Date Data type SRFs.mp4 98.6 MB
  3. QA 3- Conversion Functions, T0_CHAR, TO_DATE, and NVL.mp4 213.9 MB
  3. Unbounded Preceding Order in Over Clause.mp4 61.1 MB
  3. Using the WHERE Clause in a Query.mp4 93.9 MB
  3.1 Code for Create Table With Primary Key Constraint.txt 1.9 KB
  3.1 Code for JOINS Continued INNER & OUTER Joins.txt 1.2 KB
  3.1 Code for More Practice with the GROUP BY Clause.txt 102 B
  3.1 Code for Numeric and Date Datatype SRFs.txt 1.1 KB
  3.1 Code for WHERE Clause.txt 102 B
  3.1 course_data.txt 716 B
  4. Conversion SRFs and Date Formatting.mp4 95.1 MB
  4. Correlated Subqueries with EXISTS & NOT EXIST operators.mp4 122.6 MB
  4. INSERT ALL for Multi-table & Conditional Inserts.mp4 77.1 MB
  4. Large Objects and Interval Data Types.mp4 131.3 MB
  4. Practice Test 1.html 204 B
  4. Slicing Windows and Filtering with Analytic Functions.mp4 44.8 MB
  4. Using Operators in the WHERE Clause.mp4 122.9 MB
  4.1 Code for Conversion SRFs & Date Formatting.txt 512 B
  4.1 Code for More JOINS with Correlated Subqueries .txt 1.1 KB
  4.1 Code for Multi-Table Insert Using INSERT ALL.txt 1 KB
  4.1 Code for Using Operators in the WHERE Clause.txt 307 B
  5. Combining WHERE, AND & OR with Operators.mp4 104.5 MB
  5. Practice Test 2.html 204 B
  5. Rank, Dense_rank, Lead, and Lag Functions.mp4 107.9 MB
  5. SELF JOIN.mp4 59 MB
  5. Some More Date Functions.html 716 B
  5. Using ALTER to modify the table structure.mp4 100 MB
  5. Using Cascade Constraints and On Delete Cascade.mp4 114.7 MB
  5.1 Code for Alter Table and Modify Column Attributes.txt 716 B
  5.1 Code for Combining WHERE, AND & OR Operators.txt 204 B
  5.1 code for cascade constraints.txt 819 B
  6. CROSS JOIN, NATURAL JOIN and the USING CLAUSE.mp4 53.1 MB
  6. Concluding SRFs & NULL NULLIF Functions.mp4 78.3 MB
  6. Create Table with SELECT + UPDATE Data.mp4 123.5 MB
  6. Query Filtering Continued BETWEEN, IN and NULL.mp4 109.9 MB
  6. UNUSED Columns.mp4 38.7 MB
  6.1 Code for Concluding SRFs & NULLNULLIF Functions.txt 819 B
  6.1 Code for Create Table with SELECT and UPDATE existing Data.txt 716 B
  6.1 Code for Query Filtering Continued BETWEEN, IN & NULL.txt 307 B
  7. EQUIJOIN and NON-EQUIJOINs.mp4 45.9 MB
  7. External Tables.mp4 107.6 MB
  7. MERGE Statement in Oracle.mp4 117.4 MB
  7. Practice with Single Row Functions.html 204 B
  7. Query Filtering Conditions & Operator Precedence.mp4 110.1 MB
  7.1 Code for EQUI and NON-EQUI Joins.txt 409 B
  7.1 Code for MERGE Statement.txt 1.1 KB
  7.1 Code for Query Filtering Conditions & Operator Precedence.txt 307 B
  7.1 code for external tables.txt 1 KB
  7.2 merge_sql_example.txt 2.9 KB
  8. CASE Statements.mp4 61.6 MB
  8. Ordering, Concatenating & Aliasing Query Results.mp4 109.5 MB
  8. Primary and Foreign Keys.html 1.6 KB
  8. SQL Plus and Substitution Variables.mp4 225.5 MB
  8.1 Code for CASE Statement.txt 409 B
  8.1 Code for Ordering, Concatenating & Aliasing Query Results.txt 307 B
  9. Practice with single table queries.html 204 B
  9. Sequence Statements.mp4 64.6 MB
  9.1 Code for Sequence Statements.txt 307 B
  Download - Lynda,Udemy,Skillshare,Teamtreehouse,Frontend Masters,Pluralsight,Phlearn,Coursera,Egghead,MasterClass.txt 204 B
  Downloaded from Ahlanedu.com.txt 1 KB
  Visit us at www.Ahlanedu.com.url 0 B
  ▲ 107 total files

Description


---------------------------------------------------------------------------------

-----------------------------------------------------------------------------------
Proudly Presents
-----------------------------------------------------------------------------------
Udemy - The Complete Oracle SQL Certification Course 2020-6 [AhLaN]





SUPPLiER.......: WWW RELEASE DATE......: 02/10/20
Uploader.......: abidmail Collector.........: abidmail
... About this course ...


Description
LAST UPDATED: JUNE 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.

Related Torrents

torrent name size uploader age seed leech
Udemy - Walking off the Weight Posted by freecoursewb in Other
503.7 MB freecoursewb 6 days 20 11
Udemy - Technical Analysis - The Art of Trendlines Posted by freecoursewb in Other
784.3 MB freecoursewb 1 week 18 6
Udemy - The Complete Course for Reading and Writing Arabic Posted by freecoursewb in Other
2.2 GB freecoursewb 1 week 0 0
Udemy - The Complete Diploma in Business Writing and Emails Posted by freecoursewb in Other
3.7 GB freecoursewb 1 week 0 0
Udemy - The Complete Diploma in Cold Calling and Lead Generation Posted by freecoursewb in Other
3.3 GB freecoursewb 1 week 24 16