| 1. AS.mp4 | 25.6 MB | ||
| 1. AS.srt | 4.9 KB | ||
| 1. CASE WHEN.mp4 | 28.5 MB | ||
| 1. CASE WHEN.srt | 6.6 KB | ||
| 1. CEIL & FLOOR.mp4 | 21 MB | ||
| 1. CEIL & FLOOR.srt | 4.8 KB | ||
| 1. COUNT.mp4 | 38.4 MB | ||
| 1. COUNT.srt | 6.8 KB | ||
| 1. CREATE.mp4 | 63.8 MB | ||
| 1. CREATE.srt | 16.2 KB | ||
| 1. CURRENT DATE & TIME.mp4 | 32.3 MB | ||
| 1. CURRENT DATE & TIME.srt | 6.3 KB | ||
| 1. Converting Numbers Date to String.mp4 | 73.2 MB | ||
| 1. Converting Numbers Date to String.srt | 13.1 KB | ||
| 1. Course Overview.mp4 | 29.3 MB | ||
| 1. Course Overview.srt | 7.4 KB | ||
| 1. Course Resources.html | 102 B | ||
| 1. GROUP BY.mp4 | 93.3 MB | ||
| 1. GROUP BY.srt | 13.8 KB | ||
| 1. IN.mp4 | 29.4 MB | ||
| 1. IN.srt | 5.3 KB | ||
| 1. Installation.mp4 | 45.6 MB | ||
| 1. Installation.srt | 7.3 KB | ||
| 1. Introduction to Joins.mp4 | 17.8 MB | ||
| 1. Introduction to Joins.srt | 3.6 KB | ||
| 1. LENGTH.mp4 | 18.6 MB | ||
| 1. LENGTH.srt | 4.6 KB | ||
| 1. PATTERN MATCHING BASICS.mp4 | 40.9 MB | ||
| 1. PATTERN MATCHING BASICS.srt | 11.2 KB | ||
| 1. Practice Problem 1.html | 204 B | ||
| 1. Restore and Back-up.mp4 | 72.1 MB | ||
| 1. Restore and Back-up.srt | 9.8 KB | ||
| 1. Side Lecture Commenting in SQL.mp4 | 12.3 MB | ||
| 1. Side Lecture Commenting in SQL.srt | 2 KB | ||
| 1. Subqueries.mp4 | 103.8 MB | ||
| 1. Subqueries.srt | 19.4 KB | ||
| 1. TIP 1 (EXPLAIN).mp4 | 25.5 MB | ||
| 1. TIP 1 (EXPLAIN).srt | 4.2 KB | ||
| 1. Tablespace.mp4 | 36.3 MB | ||
| 1. Tablespace.srt | 7.1 KB | ||
| 1. User Access Control.mp4 | 80.5 MB | ||
| 1. User Access Control.srt | 16.2 KB | ||
| 1. VIEWS.mp4 | 42.5 MB | ||
| 1. VIEWS.srt | 9.7 KB | ||
| 1. What is SQL.mp4 | 10.8 MB | ||
| 1. What is SQL.srt | 3 KB | ||
| 1.1 Files_sql.zip | 10 MB | ||
| 1.1 Installing PostgreSQL on Mac.pdf | 209.8 KB | ||
| 1.1 IntroV_01.pdf | 707.1 KB | ||
| 1.1 Lecture_04_create_Queries.pdf | 219.3 KB | ||
| 1.1 Lecture_1.pdf | 220.3 KB | ||
| 1.1 Lecture_12_IN_12.pdf | 157.4 KB | ||
| 1.1 Lecture_17_AS.pdf | 151.7 KB | ||
| 1.1 Lecture_18_count.pdf | 158.2 KB | ||
| 1.1 Lecture_22_group by.pdf | 164.6 KB | ||
| 1.1 Lecture_24_Joins_Query.txt | 204 B | ||
| 1.1 Lecture_31_SUBQUERY.pdf | 207.5 KB | ||
| 1.1 Lecture_32_VIEWS.pdf | 220.7 KB | ||
| 1.1 Lecture_34_STRING functions.pdf | 209.5 KB | ||
| 1.1 Lecture_35_MATH functions.pdf | 192.9 KB | ||
| 1.1 Lecture_36_DATETIME functions.pdf | 232.4 KB | ||
| 1.1 Lecture_37_Conversion functions.pdf | 219.7 KB | ||
| 1.1 Lecture_38_ACCESS control.pdf | 207.9 KB | ||
| 1.1 Lecture_CASE.pdf | 160 KB | ||
| 1.1 Lecture_Pattern_Matching.pdf | 238.9 KB | ||
| 1.1 Lecture_Performance_Tuning.pdf | 285 KB | ||
| 1.1 Lecture_TABLESPACE.pdf | 188.7 KB | ||
| 1.1 Supermart_DB_new.zip | 297.8 KB | ||
| 1.2 Lecture_17_AS.pdf | 151.7 KB | ||
| 10. Joins.html | 204 B | ||
| 10. Logical Operators.mp4 | 41.8 MB | ||
| 10. Logical Operators.srt | 6.8 KB | ||
| 10.1 Lecture_09_AND&OR.pdf | 176.3 KB | ||
| 11. Exercise 3 SELECT & WHERE.mp4 | 7.2 MB | ||
| 11. Exercise 3 SELECT & WHERE.srt | 2 KB | ||
| 12. UPDATE.mp4 | 37.7 MB | ||
| 12. UPDATE.srt | 5.6 KB | ||
| 12.1 Lecture_10_UPDATEDelete.pdf | 211 KB | ||
| 13. DELETE.mp4 | 29.2 MB | ||
| 13. DELETE.srt | 5.4 KB | ||
| 14. ALTER.mp4 | 125.7 MB | ||
| 14. ALTER.srt | 19.4 KB | ||
| 14.1 Lecture_11_ALTER.pdf | 201.7 KB | ||
| 15. Exercise 4 Updating Table.mp4 | 3.9 MB | ||
| 15. Exercise 4 Updating Table.srt | 1.5 KB | ||
| 16. Fundamental SQL statements.html | 204 B | ||
| 2. ADVANCE PATTERN MATCHING (REGULAR EXPRESSIONS).mp4 | 103.1 MB | ||
| 2. ADVANCE PATTERN MATCHING (REGULAR EXPRESSIONS).srt | 18.5 KB | ||
| 2. AGE.mp4 | 26.6 MB | ||
| 2. AGE.srt | 4.2 KB | ||
| 2. BETWEEN.mp4 | 49.7 MB | ||
| 2. BETWEEN.srt | 6.5 KB | ||
| 2. CSV files.html | 512 B | ||
| 2. Case Study Part 1.mp4 | 28 MB | ||
| 2. Case Study Part 1.srt | 6.1 KB | ||
| 2. Converting String to Numbers Date.mp4 | 39.1 MB | ||
| 2. Converting String to Numbers Date.srt | 6.4 KB | ||
| 2. Exercise 1 Create DB and Table.mp4 | 5.9 MB | ||
| 2. Exercise 1 Create DB and Table.srt | 2.6 KB | ||
| 2. Exercise 11 Subqueries.mp4 | 5.1 MB | ||
| 2. Exercise 11 Subqueries.srt | 2 KB | ||
| 2. HAVING.mp4 | 37.9 MB | ||
| 2. HAVING.srt | 5.4 KB | ||
| 2. INDEX.mp4 | 40.3 MB | ||
| 2. INDEX.srt | 9.9 KB | ||
| 2. Inner Join.mp4 | 59.3 MB | ||
| 2. Inner Join.srt | 10.2 KB | ||
| 2. ORDER BY.mp4 | 71.4 MB | ||
| 2. ORDER BY.srt | 10.4 KB | ||
| 2. PRIMARY KEY & FOREIGN KEY.mp4 | 25.4 MB | ||
| 2. PRIMARY KEY & FOREIGN KEY.srt | 8.6 KB | ||
| 2. RANDOM.mp4 | 31.4 MB | ||
| 2. RANDOM.srt | 6.6 KB | ||
| 2. SUM.mp4 | 21.1 MB | ||
| 2. SUM.srt | 3.8 KB | ||
| 2. TIP 2.mp4 | 5.8 MB | ||
| 2. TIP 2.srt | 1.8 KB | ||
| 2. Tables and DBMS.mp4 | 17.4 MB | ||
| 2. Tables and DBMS.srt | 4.7 KB | ||
| 2. UPPER LOWER.mp4 | 11.6 MB | ||
| 2. UPPER LOWER.srt | 3.4 KB | ||
| 2.1 Lecture_13_BETWEEN.pdf | 187.6 KB | ||
| 2.1 Lecture_15_ORDER BY.pdf | 180.1 KB | ||
| 2.1 Lecture_19_SUM.pdf | 162.9 KB | ||
| 2.1 Lecture_2.pdf | 289.5 KB | ||
| 2.1 Lecture_23_HAVING.pdf | 166.5 KB | ||
| 2.1 Lecture_24_INNER join.pdf | 214.2 KB | ||
| 2.1 Lecture_33_INDEX.pdf | 201.6 KB | ||
| 2.1 Lecture_5_Keys.pdf | 234.6 KB | ||
| 2.1 Product.csv | 139.5 KB | ||
| 2.1 User_table.txt | 204 B | ||
| 2.2 Customer.csv | 64 KB | ||
| 2.3 Sales.csv | 983.7 KB | ||
| 3. ACID compliance.mp4 | 42.7 MB | ||
| 3. ACID compliance.srt | 10.2 KB | ||
| 3. AVERAGE.mp4 | 17.5 MB | ||
| 3. AVERAGE.srt | 3.5 KB | ||
| 3. Case Study Part 2.mp4 | 51.2 MB | ||
| 3. Case Study Part 2.srt | 8.7 KB | ||
| 3. EXTRACT.mp4 | 58.6 MB | ||
| 3. EXTRACT.srt | 10.3 KB | ||
| 3. Exercise 12 Views.mp4 | 3.2 MB | ||
| 3. Exercise 12 Views.srt | 1.2 KB | ||
| 3. Exercise 16 Pattern Matching.mp4 | 8.3 MB | ||
| 3. Exercise 16 Pattern Matching.srt | 2.7 KB | ||
| 3. Exercise 5 Restore and Back-up.mp4 | 3 MB | ||
| 3. Exercise 5 Restore and Back-up.srt | 1.3 KB | ||
| 3. Exercise 9 Group By.mp4 | 6.2 MB | ||
| 3. Exercise 9 Group By.srt | 1.8 KB | ||
| 3. LIKE.mp4 | 61.2 MB | ||
| 3. LIKE.srt | 12.3 KB | ||
| 3. LIMIT.mp4 | 29.6 MB | ||
| 3. LIMIT.srt | 5.1 KB | ||
| 3. Left Join.mp4 | 50.4 MB | ||
| 3. Left Join.srt | 10.1 KB | ||
| 3. REPLACE.mp4 | 25.3 MB | ||
| 3. REPLACE.srt | 5.5 KB | ||
| 3. SETSEED.mp4 | 24.8 MB | ||
| 3. SETSEED.srt | 4.5 KB | ||
| 3. Solutions to all Exercises.html | 102 B | ||
| 3. TIP 3.mp4 | 14.3 MB | ||
| 3. TIP 3.srt | 4.1 KB | ||
| 3. Types of SQL commands.mp4 | 25.3 MB | ||
| 3. Types of SQL commands.srt | 6.6 KB | ||
| 3.1 Lecture_14_LIKE.pdf | 173.7 KB | ||
| 3.1 Lecture_16_LIMIT.pdf | 162.1 KB | ||
| 3.1 Lecture_20_AVG.pdf | 157.5 KB | ||
| 3.1 Lecture_25_LEFT join.pdf | 219 KB | ||
| 3.1 Lecture_3_Queries.pdf | 208.4 KB | ||
| 3.1 Lecture_ACID.pdf | 190.7 KB | ||
| 3.1 Solution.pdf | 733.9 KB | ||
| 4. Exercise 15 Date-time functions.mp4 | 5.7 MB | ||
| 4. Exercise 15 Date-time functions.srt | 1.9 KB | ||
| 4. Exercise 6 In, Like & Between.mp4 | 5.3 MB | ||
| 4. Exercise 6 In, Like & Between.srt | 1 KB | ||
| 4. Exercise 7 Sorting.mp4 | 3.2 MB | ||
| 4. Exercise 7 Sorting.srt | 1.1 KB | ||
| 4. INSERT.mp4 | 56.4 MB | ||
| 4. INSERT.srt | 10.5 KB | ||
| 4. MIN & MAX.mp4 | 32.5 MB | ||
| 4. MIN & MAX.srt | 4.8 KB | ||
| 4. PostgreSQL.mp4 | 17.2 MB | ||
| 4. PostgreSQL.srt | 3.8 KB | ||
| 4. Quiz.html | 204 B | ||
| 4. ROUND.mp4 | 16.8 MB | ||
| 4. ROUND.srt | 3.2 KB | ||
| 4. Right Join.mp4 | 48.6 MB | ||
| 4. Right Join.srt | 7.6 KB | ||
| 4. TIP 4 (VACCUM).mp4 | 2.9 MB | ||
| 4. TIP 4 (VACCUM).srt | 819 B | ||
| 4. TRIM, LTRIM, RTRIM.mp4 | 50 MB | ||
| 4. TRIM, LTRIM, RTRIM.srt | 9.6 KB | ||
| 4. Truncate.mp4 | 21.1 MB | ||
| 4. Truncate.srt | 5.3 KB | ||
| 4.1 Lecture_06_INSERT and COPY.pdf | 219.2 KB | ||
| 4.1 Lecture_21_MIN&MAX.pdf | 164.1 KB | ||
| 4.1 Lecture_26_RIGHT join.pdf | 221.8 KB | ||
| 4.1 Lecture_5_Postgresql.pdf | 216.4 KB | ||
| 4.1 Lecture_TRUNCATE.pdf | 160.5 KB | ||
| 5. CONCATENATION.mp4 | 16.9 MB | ||
| 5. CONCATENATION.srt | 3.8 KB | ||
| 5. Congratulations & About your certificate.html | 1.6 KB | ||
| 5. Exercise 8 Aggregate functions.mp4 | 6.4 MB | ||
| 5. Exercise 8 Aggregate functions.srt | 2 KB | ||
| 5. Full Outer Join.mp4 | 39.3 MB | ||
| 5. Full Outer Join.srt | 5.2 KB | ||
| 5. Import data from File.mp4 | 32.6 MB | ||
| 5. Import data from File.srt | 6 KB | ||
| 5. POWER.mp4 | 12.1 MB | ||
| 5. POWER.srt | 3.1 KB | ||
| 5. Practice Test 1.html | 204 B | ||
| 5. TIP 5.mp4 | 11.5 MB | ||
| 5. TIP 5.srt | 3.4 KB | ||
| 5.1 Lecture_27_OUTER join.pdf | 219.1 KB | ||
| 5.1 copytext.txt | 0 B | ||
| 5.2 copy.csv | 102 B | ||
| 6. Bonus Lecture.html | 1.4 KB | ||
| 6. Cross Join.mp4 | 26 MB | ||
| 6. Cross Join.srt | 6 KB | ||
| 6. Exercise 14 Mathematical Functions.mp4 | 10.3 MB | ||
| 6. Exercise 14 Mathematical Functions.srt | 2.5 KB | ||
| 6. Exercise 2 Inserting and Importing.mp4 | 4.6 MB | ||
| 6. Exercise 2 Inserting and Importing.srt | 1.2 KB | ||
| 6. Quiz.html | 204 B | ||
| 6. SQL Quiz.html | 204 B | ||
| 6. SUBSTRING.mp4 | 42.3 MB | ||
| 6. SUBSTRING.srt | 7.4 KB | ||
| 6. TIP 6 (STRING FUNCTIONS).mp4 | 13.7 MB | ||
| 6. TIP 6 (STRING FUNCTIONS).srt | 3.4 KB | ||
| 6.1 Lecture_28_Cross join.pdf | 186.7 KB | ||
| 6.1 Student.csv | 102 B | ||
| 7. Except.mp4 | 17.3 MB | ||
| 7. Except.srt | 4 KB | ||
| 7. LIST AGGREGATION.mp4 | 33.1 MB | ||
| 7. LIST AGGREGATION.srt | 6.7 KB | ||
| 7. SELECT statement.mp4 | 27.1 MB | ||
| 7. SELECT statement.srt | 4.7 KB | ||
| 7. TIP 7 (JOINS).mp4 | 10.8 MB | ||
| 7. TIP 7 (JOINS).srt | 2.8 KB | ||
| 7.1 Lecture_07_SELECT & DISTINCT.pdf | 179.2 KB | ||
| 7.1 Lecture_29_EXCEPT.pdf | 173.9 KB | ||
| 8. Exercise 13 String Functions.mp4 | 16.5 MB | ||
| 8. Exercise 13 String Functions.srt | 3.9 KB | ||
| 8. SELECT DISTINCT.mp4 | 43.2 MB | ||
| 8. SELECT DISTINCT.srt | 7.3 KB | ||
| 8. TIP 8 (SCHEMAS).mp4 | 32 MB | ||
| 8. TIP 8 (SCHEMAS).srt | 6.3 KB | ||
| 8. Union.mp4 | 19.7 MB | ||
| 8. Union.srt | 4.3 KB | ||
| 8.1 Lecture_30_UNION.pdf | 166.9 KB | ||
| 9. Exercise 10 Joins.mp4 | 6.9 MB | ||
| 9. Exercise 10 Joins.srt | 1.7 KB | ||
| 9. WHERE.mp4 | 27.7 MB | ||
| 9. WHERE.srt | 4.7 KB | ||
| 9.1 Lecture_08_WHERE.pdf | 175.6 KB | ||
| Verify Files.txt | 1 KB | ||
| [FreeAllCourse.Com].url | 102 B | ||
| ▲ 258 total files | |||
SQL Masterclass: SQL for Data AnalyticsSQL Masterclass: SQL for Data Analytics
SQL course covering basic to advanced SQL topics for SQL Database ( PostgreSQL ). Elucidates SQL Database for beginners.
For More Paid Udemy Courses Visit:
FreeAllCourse.Com
What you'll learn?
# Knowledge of all the essential SQL commands
# Become proficient in SQL tools like GROUP BY, JOINS and Subqueries
# Become competent in using sorting and filtering commands in SQL
# Master SQL's most popular string, mathematical and date-time functions
# Enhance the performance of your Database by using Views and Indexes
# Increase your efficiency by learning the best practices while writing SQL queries
# Relevant theoretical concepts also covered so that you excel in BI Job interviews and Vivas
# Solid understanding of SQL
Description
Created by Start-Tech Academy
Last updated 6/2020
Audio: English
Caption: English
| torrent name | size | uploader | age | seed | leech |
|---|---|---|---|---|---|
| 274.1 MB | freecoursewb | 1 week | 17 | 1 | |
|
Udemy - Data Analytics for Beginners - Excel, SQL, and AI Dashboards Posted by
freecoursewb in Other
|
2.1 GB | freecoursewb | 4 weeks | 0 | 0 |
|
Udemy - Databricks Spark Streaming, Delta Lake and SQL, AI Analytics Posted by
freecoursewb in Other
|
3.3 GB | freecoursewb | 4 weeks | 1 | 5 |
| 2.5 GB | freecoursewb | 4 weeks | 26 | 4 | |
| 1.6 GB | freecoursewb | 1 month | 9 | 8 |
All Comments