Udemy - The Complete Oracle SQL Certification Course

seeders: 28
leechers: 41
updated:
Added by tutsnode in Other > Tutorials

Download Fast Safe Anonymous
movies, software, shows...
  • Downloads: 156
  • Language: English

Files

The Complete Oracle SQL Certification Course [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)
  • 1.1 Code for Creating Your Own Tables & Design Considerations.txt (0.2 KB)
  • 13. Views and Other Objects and Commands (Newly Added).srt (32.9 KB)
  • 3. Create Table With a Primary Key Constraint.srt (32.7 KB)
  • 12. System Tables, Pseudo Columns & Deleting Duplicates (Newly Added).srt (32.5 KB)
  • 1. Creating Your Own Tables & Design Considerations.srt (31.2 KB)
  • 9.1 Code for Sequence Statements.txt (0.3 KB)
  • 8. Primary and Foreign Keys.html (1.6 KB)
  • 2. Inserting Data Into Our Table.srt (27.5 KB)
  • 6. Create Table with SELECT + UPDATE Data.srt (27.2 KB)
  • 10. DELETE, TRUNCATE, and DROP Commands.srt (25.5 KB)
  • 7. MERGE Statement in Oracle.srt (23.4 KB)
  • 5. Using ALTER to modify the table structure.srt (22.5 KB)
  • 11. Working With Database Indexes.srt (20.0 KB)
  • 15. Granting and Revoking Privileges.srt (20.0 KB)
  • 9. Sequence Statements.srt (17.8 KB)
  • 4. INSERT ALL for Multi-table & Conditional Inserts.srt (15.7 KB)
  • 7.2 merge_sql_example.txt (2.9 KB)
  • 3.1 Code for Create Table With Primary Key Constraint.txt (1.9 KB)
  • 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)
  • 12.1 Code for System Tables, Pseudo Columns, & Deleting Duplicate Data.txt (1.2 KB)
  • 7.1 Code for MERGE Statement.txt (1.1 KB)
  • 2.1 Code for Inserting Data Into our Table.txt (1.0 KB)
  • 4.1 Code for Multi-Table Insert Using INSERT ALL.txt (1.0 KB)
  • 17. Bonus Lecture Lifetime Access to All My Courses.html (1.0 KB)
  • 6.1 Code for Create Table with SELECT and UPDATE existing Data.txt (0.7 KB)
  • 16. BECOME A SQL QUERY WIZARD!.html (0.7 KB)
  • 5.1 Code for Alter Table and Modify Column Attributes.txt (0.7 KB)
  • 11.1 Code for Database Indexes.txt (0.6 KB)
  • 10.1 Code for Delete, Truncate and Drop Commands.txt (0.4 KB)
  • 12. System Tables, Pseudo Columns & Deleting Duplicates (Newly Added).mp4 (159.1 MB)
  • 3. Create Table With a Primary Key Constraint.mp4 (146.5 MB)
  • 13. Views and Other Objects and Commands (Newly Added).mp4 (138.3 MB)
  • 6. Create Table with SELECT + UPDATE Data.mp4 (123.5 MB)
  • 1. Creating Your Own Tables & Design Considerations.mp4 (117.5 MB)
  • 7. MERGE Statement in Oracle.mp4 (117.4 MB)
  • 10. DELETE, TRUNCATE, and DROP Commands.mp4 (114.2 MB)
  • 2. Inserting Data Into Our Table.mp4 (113.8 MB)
  • 5. Using ALTER to modify the table structure.mp4 (100.0 MB)
  • 11. Working With Database Indexes.mp4 (80.4 MB)
  • 4. INSERT ALL for Multi-table & Conditional Inserts.mp4 (77.0 MB)
  • 9. Sequence Statements.mp4 (64.6 MB)
8. ADDITIONAL TOPICS + REVIEW for EXAM 170-071
  • 8. SQL Plus and Substitution Variables.srt (53.8 KB)
  • 5. Using Cascade Constraints and On Delete Cascade.srt (27.8 KB)
  • 8. SQL Plus and Substitution Variables.mp4 (225.5 MB)
  • 7. External Tables.srt (24.3 KB)
  • 2. ERD Diagrams.srt (28.6 KB)
  • 4. Large Objects and Interval Data Types.srt (28.6 KB)
  • 3. Commit, Rollback, and Savepoint.srt (22.5 KB)
  • 1. OFFSET and FETCH.srt (16.6 KB)
  • 6. UNUSED Columns.srt (12.0 KB)
  • 7.1 code for external tables.txt (1.0 KB)
  • 5.1 code for cascade constraints.txt (0.8 KB)
  • 4.1 code for building_lease example.txt (0.5 KB)
  • 4. Large Objects and Interval Data Types.mp4 (131.3 MB)
  • 5. Using Cascade Constraints and On Delete Cascade.mp4 (114.7 MB)
  • 7. External Tables.mp4 (107.6 MB)
  • 1. OFFSET and FETCH.mp4 (65.9 MB)
  • 2. ERD Diagrams.mp4 (61.9 MB)
  • 3. Commit, Rollback, and Savepoint.mp4 (54.4 MB)
  • 6. UNUSED Columns.mp4 (38.7 MB)
9. Exam Question Walkthrough Videos + 2 Exams
  • 3. QA 3- Conversion Functions, T0_CHAR, TO_DATE, and NVL.srt (48.5 KB)
  • 2. QA 2- Fetch and Substitution Variables.srt (42.1 KB)
  • 1. QA 1- DML, DDL, and Transaction Control.srt (40.9 KB)
  • 3. QA 3- Conversion Functions, T0_CHAR, TO_DATE, and NVL.mp4 (213.9 MB)
  • 2. QA 2- Fetch and Substitution Variables.mp4 (177.0 MB)
  • 1. QA 1- DML, DDL, and Transaction Control.mp4 (167.9 MB)
  • 4. Practice Test 1.html (0.2 KB)
  • 5. Practice Test 2.html (0.2 KB)
1. Database Basics
  • 3.1 course_data.txt (2.4 KB)
  • 2. Creating the Workspace in Oracle.srt (10.2 KB)
  • 3. IMPORTANT Prepare the Sample Data.srt (5.8 KB)
  • 4. How to Proceed in This Course.srt (4.1 KB)
  • 1. Oracle Database Introduction & Basics of Tables.mp4 (67.5 MB)
  • 2. Creating the Workspace in Oracle.mp4 (50.4 MB)
  • 4. How to Proceed in This Course.mp4 (47.5 MB)
  • 3. IMPORTANT Prepare the Sample Data.mp4 (24.3 MB)
  • 1. Oracle Database Introduction & Basics of Tables.srt (20.2 MB)
5. Multi-Table Queries and Joins (Exercises and Solutions In the Lectures)
  • 9.1 Oracle COALESCE Function.pdf (283.2 KB)
  • 1. SELECT within SELECT (Subqueries).srt (34.3 KB)
  • 3. Joins Continued INNER & OUTER Joins.srt (30.3 KB)
  • 5. Correlated Subqueries with EXISTS & NOT EXIST operators.srt (29.9 KB)
  • 2. Relating Tables Together Using JOINs.srt (27.4 KB)
  • 1.1 Code for SELECT within SELECT (Nested Queries Subqueries).txt (1.2 KB)
  • 2.1 Code for Relating Tables together using JOINs .txt (1.2 KB)
  • 3.1 Code for JOINS Continued INNER & OUTER Joins.txt (1.2 KB)
  • 4. Career Advice.srt (2.7 KB)
  • 5.1 Code for More JOINS with Correlated Subqueries .txt (1.1 KB)
  • 6. SELF JOIN.srt (16.7 KB)
  • 8.1 Code for EQUI and NON-EQUI Joins.txt (0.4 KB)
  • 8. EQUIJOIN and NON-EQUIJOINs.srt (14.4 KB)
  • 9.2 Code for CASE Statement.txt (0.4 KB)
  • 7. CROSS JOIN, NATURAL JOIN and the USING CLAUSE.srt (12.6 KB)
  • 9. CASE Statements.srt (11.9 KB)
  • 3. Joins Continued INNER & OUTER Joins.mp4 (137.5 MB)
  • 1. SELECT within SELECT (Subqueries).mp4 (127.2 MB)
  • 5. C

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



Download torrent
6.1 GB
seeders:28
leechers:41
Udemy - The Complete Oracle SQL Certification Course


Trackers

tracker name
udp://inferno.demonoid.pw:3391/announce
udp://tracker.openbittorrent.com:80/announce
udp://tracker.opentrackr.org:1337/announce
udp://torrent.gresille.org:80/announce
udp://glotorrents.pw:6969/announce
udp://tracker.leechers-paradise.org:6969/announce
udp://tracker.pirateparty.gr:6969/announce
udp://tracker.coppersurfer.tk:6969/announce
udp://ipv4.tracker.harry.lu:80/announce
udp://9.rarbg.to:2710/announce
udp://shadowshq.yi.org:6969/announce
udp://tracker.zer0day.to:1337/announce
µTorrent compatible trackers list

Download torrent
6.1 GB
seeders:28
leechers:41
Udemy - The Complete Oracle SQL Certification Course


Torrent hash: DB44096E5CF9FD0C34C6E6CC06311616F50A6F28