Tutorialsplanet NET Udemy Oracle SQL Step by Step SQL | A151B5E210B270C3E0006A14D933272A2F562A04

Tutorialsplanet NET Udemy Oracle SQL Step by Step SQL

Name	[Tutorialsplanet.NET] Udemy - Oracle SQL - Step by Step SQL	DOWNLOAD Copy Link Trouble downloading? see How To
Total Size	1.2 GB
Total Files	237
Hash	A151B5E210B270C3E0006A14D933272A2F562A04

/1. Chapter 1/
1. Closed CaptionsSub Titles for the course.pdf	238.9 KB
2. Welcome!!.mp4	24.3 MB
2. Welcome!!.srt	8.1 KB
3. How to make best use of the program.pdf	209.3 KB
/10. How do we combine data from 2 tables/
1. SET Operators.mp4	4.8 MB
1. SET Operators.srt	3.5 KB
2. UNION operator.mp4	7.9 MB
2. UNION operator.srt	5.7 KB
3. UNION ALL operator.mp4	2.8 MB
3. UNION ALL operator.srt	2.1 KB
4. INTERSECT operator.mp4	3.7 MB
4. INTERSECT operator.srt	3.0 KB
5. MINUS operator.mp4	3.8 MB
5. MINUS operator.srt	3.2 KB
6. Lab 6 (Exercises with Answers).pdf	280.4 KB
/11. Lets group the data/
1. AggregateSummary Functions.mp4	10.9 MB
1. AggregateSummary Functions.srt	7.2 KB
2. GROUP BY clause.mp4	8.5 MB
2. GROUP BY clause.srt	5.2 KB
3. GROUP BY with multiple columns.mp4	14.3 MB
3. GROUP BY with multiple columns.srt	7.0 KB
4. GROUP BY with HAVING clause.mp4	8.8 MB
4. GROUP BY with HAVING clause.srt	3.7 KB
5. Lab 7 (Exercises with Answers).pdf	298.9 KB
/12. Joining data from 2 or more tables (JOINS)/
1. Why Joins.mp4	32.0 MB
1. Why Joins.srt	5.1 KB
10. Adding filters to Joins.mp4	24.0 MB
10. Adding filters to Joins.srt	4.1 KB
11. Lab 8 (Exercises with Answers).pdf	279.2 KB
2. Inner Join.mp4	11.8 MB
2. Inner Join.srt	6.1 KB
3. Left Outer Join.mp4	6.3 MB
3. Left Outer Join.srt	3.8 KB
4. Right Outer Join.mp4	6.0 MB
4. Right Outer Join.srt	3.6 KB
5. Full Outer Join.mp4	5.2 MB
5. Full Outer Join.srt	3.3 KB
6. Cross Join.mp4	7.0 MB
6. Cross Join.srt	3.9 KB
7. Natural Join.mp4	5.7 MB
7. Natural Join.srt	3.2 KB
8. Joining the 3rd table.mp4	12.8 MB
8. Joining the 3rd table.srt	2.2 KB
9. Joining the 4th table and so on....mp4	9.9 MB
9. Joining the 4th table and so on....srt	1.8 KB
/13. Functions available for us to use/
1. DUAL (What is this).mp4	4.3 MB
1. DUAL (What is this).srt	3.4 KB
2. Why do we need functions.mp4	2.6 MB
2. Why do we need functions.srt	2.0 KB
3. NUMBER related functions.mp4	23.7 MB
3. NUMBER related functions.srt	4.5 KB
4. CHARACTER related functions.mp4	8.0 MB
4. CHARACTER related functions.srt	4.6 KB
5. DATE related functions.mp4	11.0 MB
5. DATE related functions.srt	5.5 KB
6. Lab 9 (Exercises with Answers).pdf	287.2 KB
/14. Interesting THINGS!!!/
1. IF THEN ELSE (CASE statement).mp4	8.5 MB
1. IF THEN ELSE (CASE statement).srt	4.7 KB
2. Alternative Name (ALIAS name).mp4	12.0 MB
2. Alternative Name (ALIAS name).srt	4.9 KB
3. DISTINCT values.mp4	8.3 MB
3. DISTINCT values.srt	5.0 KB
4. PSEUDO Columns.mp4	9.1 MB
4. PSEUDO Columns.srt	4.4 KB
/15. Data Definition Language (DDL)/
1. Let's create a table (CREATE).mp4	5.2 MB
1. Let's create a table (CREATE).srt	3.9 KB
2. Let's change the structure of a table (ALTER).mp4	10.8 MB
2. Let's change the structure of a table (ALTER).srt	5.4 KB
3. Let's delete the table (DROP).mp4	2.0 MB
3. Let's delete the table (DROP).srt	1.2 KB
4. Create Table AS - CTAS.mp4	21.4 MB
4. Create Table AS - CTAS.srt	3.9 KB
5. Lab 11 (Exercises with Answers).pdf	383.3 KB
/16. Data Manipulation Language (DML)/
1. COMMIT and ROLLBACK.mp4	1.6 MB
1. COMMIT and ROLLBACK.srt	2.0 KB
2. Insert data into a table (INSERT).mp4	11.5 MB
2. Insert data into a table (INSERT).srt	6.7 KB
3. Delete data from a table (DELETE).mp4	8.5 MB
3. Delete data from a table (DELETE).srt	4.5 KB
4. Modify existing data in a table (UPDATE).mp4	7.8 MB
4. Modify existing data in a table (UPDATE).srt	4.4 KB
5. Delete all the data from a table (TRUNCATE).mp4	6.3 MB
5. Delete all the data from a table (TRUNCATE).srt	4.0 KB
6. Lab 12 (Exercises with Answers).pdf	298.4 KB
/17. Lets put some restrictions on a table (Constraints)/
1. Why constraints.mp4	2.1 MB
1. Why constraints.srt	2.3 KB
10. Lab 13 (Exercises with Answers).pdf	313.8 KB
2. No empty data allowed (NOT NULL).mp4	7.9 MB
2. No empty data allowed (NOT NULL).srt	4.1 KB
3. No Duplicate data (UNIQUE).mp4	7.1 MB
3. No Duplicate data (UNIQUE).srt	4.1 KB
4. What is NOT NULL + UNIQUE = PRIMARY KEY.mp4	8.1 MB
4. What is NOT NULL + UNIQUE = PRIMARY KEY.srt	4.2 KB
5. Accept only few values (CHECK).mp4	8.1 MB
5. Accept only few values (CHECK).srt	4.5 KB
6. Check data in other table before insertingdeleting (FOREIGN KEY).mp4	12.5 MB
6. Check data in other table before insertingdeleting (FOREIGN KEY).srt	5.6 KB
7. Constraints on multiple columns.mp4	6.3 MB
7. Constraints on multiple columns.srt	4.2 KB
8. Adding constraints to an existing table.mp4	3.4 MB
8. Adding constraints to an existing table.srt	2.7 KB
9. More operations on Constraints....mp4	4.6 MB
9. More operations on Constraints....srt	2.8 KB
/18. Views/
1. Why Views.mp4	12.8 MB
1. Why Views.srt	8.2 KB
2. Lets modify an existing view.mp4	4.8 MB
2. Lets modify an existing view.srt	2.6 KB
3. Lets update View Data.mp4	6.8 MB
3. Lets update View Data.srt	3.5 KB
4. Create View from more than 1 Table.mp4	15.5 MB
4. Create View from more than 1 Table.srt	7.8 KB
5. Lab 14 (Exercises with Answers).pdf	369.3 KB
/19. Other Database Objects/
1. Alternative name for Objects (SYNONYMS).mp4	5.8 MB
1. Alternative name for Objects (SYNONYMS).srt	4.1 KB
2. Series of Numbers (SEQUENCE).mp4	7.7 MB
2. Series of Numbers (SEQUENCE).srt	5.3 KB
/2. Software Installation/
1. Installing Oracle.mp4	23.6 MB
1. Installing Oracle.srt	3.5 KB
1.1 Oracle database URL.txt	0.1 KB
2. Installing Java SDK.mp4	24.9 MB
2. Installing Java SDK.srt	2.6 KB
2.1 Java URL.txt	0.1 KB
3. Installing SQL Developer.mp4	31.6 MB
3. Installing SQL Developer.srt	28.2 MB
3.1 SQL Developer URL.txt	0.1 KB
4. Running scripts necessary for the course.mp4	19.2 MB
4. Running scripts necessary for the course.srt	3.0 KB
4.1 Create User.txt	0.2 KB
5. Scripts for our Lab Exercises.pdf	170.4 KB
/20. Giving Permissions to other users (GRANT)/
1. I like him (GRANT).mp4	25.1 MB
1. I like him (GRANT).srt	5.7 KB
2. I don't like him (REVOKE).mp4	18.2 MB
2. I don't like him (REVOKE).srt	3.8 KB
3. List of all GRANT's.pdf	199.7 KB
/21. SUB Queries/
1. What is a SUB Query.mp4	33.2 MB
1. What is a SUB Query.srt	5.4 KB
2. Sub queries on multiple columns (Pairwise Comparision).mp4	25.9 MB
2. Sub queries on multiple columns (Pairwise Comparision).srt	5.3 KB
3. Sub queries on multiple columns (Non-Pairwise Comparision).mp4	22.8 MB
3. Sub queries on multiple columns (Non-Pairwise Comparision).srt	22.8 MB
4. Sub queries in the FROM clause.mp4	29.9 MB
4. Sub queries in the FROM clause.srt	6.0 KB
5. Sub queries in the WITH clause.mp4	9.6 MB
5. Sub queries in the WITH clause.srt	2.1 KB
6. Scalar Sub queries.mp4	16.4 MB
6. Scalar Sub queries.srt	3.1 KB
7. Correlated SUB Query.mp4	43.0 MB
7. Correlated SUB Query.srt	6.8 KB
/22. Advanced Topics - Index/
1. Book Index.mp4	4.5 MB
1. Book Index.srt	3.2 KB
2. Lets create an Index....mp4	8.7 MB
2. Lets create an Index....srt	4.6 KB
3. UNIQUE Index.mp4	5.6 MB
3. UNIQUE Index.srt	3.8 KB
4. Dropping and Renaming an Index.mp4	3.8 MB
4. Dropping and Renaming an Index.srt	2.2 KB
/23. Bonus Lets Recap with a 5 Step Process/
1. Scripts for this Section.pdf	209.3 KB
2. Business Requirement.mp4	23.6 MB
2. Business Requirement.srt	5.3 KB
3. Step 1 Let's Select all the columns needed....mp4	56.4 MB
3. Step 1 Let's Select all the columns needed....srt	8.3 KB
4. Step 2 Let's add the necessary Filters....mp4	9.2 MB
4. Step 2 Let's add the necessary Filters....srt	1.2 KB
5. Step 3 Let's perform the Grouping....mp4	19.7 MB
5. Step 3 Let's perform the Grouping....srt	2.6 KB
6. Step 4 Let's perform Filtering at Group level....mp4	10.5 MB
6. Step 4 Let's perform Filtering at Group level....srt	1.7 KB
7. Step 5 Lets Sort the data....mp4	8.8 MB
7. Step 5 Lets Sort the data....srt	1.4 KB
8. Recap the 10 things we have done....mp4	13.3 MB
8. Recap the 10 things we have done....srt	3.1 KB
/24. Where to Go From Here/
1. Project Work.pdf	217.3 KB
2. Advanced Database concepts you can explore!!!.pdf	209.4 KB
/3. Database Concepts/
1. What is a Table.mp4	6.2 MB
1. What is a Table.srt	3.5 KB
2. What is a Database.mp4	8.3 MB
2. What is a Database.srt	4.2 KB
3. What is a Relational Database (RDBMS).mp4	3.8 MB
3. What is a Relational Database (RDBMS).srt	2.7 KB
4. What is a Transaction.mp4	5.2 MB
4. What is a Transaction.srt	2.9 KB
5. What is ACID.mp4	5.2 MB
5. What is ACID.srt	3.7 KB
6. RDBMS Vendors.mp4	2.5 MB
6. RDBMS Vendors.srt	1.8 KB
/4. Enter the Dragon (Database)/
1. Building SQL Template....html	0.1 KB
1.1 Building SQL Template.pdf	244.0 KB
2. How do you talk with a Database.mp4	3.4 MB
2. How do you talk with a Database.srt	2.8 KB
3. What are the most common commands.mp4	2.3 MB
3. What are the most common commands.srt	3.1 KB
4. What type of Data can we store.mp4	6.7 MB
4. What type of Data can we store.srt	4.0 KB
5. Data Model for our Course.mp4	8.2 MB
5. Data Model for our Course.srt	2.2 KB
/5. Lets see the Data/
1. What data can I see.mp4	21.9 MB
1. What data can I see.srt	4.9 KB
2. How do I see data (SELECT) .mp4	5.6 MB
2. How do I see data (SELECT) .srt	3.3 KB
3. How do I see a part of the data (SELECT) .mp4	6.0 MB
3. How do I see a part of the data (SELECT) .srt	3.2 KB
4. Lab 1 (Exercises with Answers).pdf	282.7 KB
/6. Lets limit the data we see (Filtering)/
1. Filtering Data (WHERE command).mp4	6.1 MB
1. Filtering Data (WHERE command).srt	3.8 KB
2. Comparison Operators.mp4	2.2 MB
2. Comparison Operators.srt	2.0 KB
3. Filtering Data (More Examples...).mp4	7.1 MB
3. Filtering Data (More Examples...).srt	4.3 KB
4. Filters on Character and Date values....mp4	9.5 MB
4. Filters on Character and Date values....srt	5.7 KB
5. Filtering based on a column in a table....mp4	8.2 MB
5. Filtering based on a column in a table....srt	4.6 KB
6. Lab 2 (Exercises with Answers).pdf	283.2 KB
/7. Logical Operators/
1. BETWEEN and NOT BETWEEN.mp4	4.8 MB
1. BETWEEN and NOT BETWEEN.srt	3.4 KB
2. IN and NOT IN.mp4	5.1 MB
2. IN and NOT IN.srt	3.4 KB
3. LIKE operator.mp4	27.3 MB
3. LIKE operator.srt	6.0 KB
4. ALL and ANY.mp4	6.2 MB
4. ALL and ANY.srt	4.5 KB
5. Lets learn about NULL....mp4	4.0 MB
5. Lets learn about NULL....srt	2.7 KB
6. IS NULL and IS NOT NULL.mp4	6.0 MB
6. IS NULL and IS NOT NULL.srt	4.3 KB
7. AND and OR.mp4	10.3 MB
7. AND and OR.srt	5.6 KB
8. Lab 3 (Exercises with Answers).pdf	289.6 KB
/8. Arithmetic operators/
1. They are simple!!! (10 + 20 = 30).mp4	6.0 MB
1. They are simple!!! (10 + 20 = 30).srt	3.1 KB
2. Lab 4 (Exercises with Answers).pdf	211.4 KB
/9. Lets sort the data we see (Sorting)/
1. ORDER BY clause.mp4	8.8 MB
1. ORDER BY clause.srt	5.9 KB
2. How are NULL values treated while Sorting Data.mp4	4.5 MB
2. How are NULL values treated while Sorting Data.srt	2.2 KB
3. Lab 5 (Exercises with Answers).pdf	277.9 KB
/
[Tutorialsplanet.NET].url	0.1 KB
Total files 237