| 1. CASE Clause-en_US.srt | 4 KB | ||
| 1. CASE Clause.mp4 | 29.2 MB | ||
| 1. COUNT( ) Function, CREATE TABLE & INSERT INTO TABLE-en_US.srt | 4.5 KB | ||
| 1. COUNT( ) Function, CREATE TABLE & INSERT INTO TABLE.mp4 | 25.9 MB | ||
| 1. LIMIT & ORDER BY-en_US.srt | 7.4 KB | ||
| 1. LIMIT & ORDER BY.mp4 | 51.6 MB | ||
| 1. Overview of Time Functions in PostgreSQL-en_US.srt | 2.1 KB | ||
| 1. Overview of Time Functions in PostgreSQL.mp4 | 30.5 MB | ||
| 1. SQL Course Intro-en_US.srt | 4.8 KB | ||
| 1. SQL Course Intro.mp4 | 52.1 MB | ||
| 1. SQL Database Overview Part 1-en_US.srt | 2.5 KB | ||
| 1. SQL Database Overview Part 1.mp4 | 8.7 MB | ||
| 1. Select Statement-en_US.srt | 5.7 KB | ||
| 1. Select Statement.mp4 | 36.7 MB | ||
| 1. Where Clause-en_US.srt | 6.7 KB | ||
| 1. Where Clause.mp4 | 49.7 MB | ||
| 2. FETCH vs LIMIT-en_US.srt | 2.6 KB | ||
| 2. FETCH vs LIMIT.mp4 | 22.5 MB | ||
| 2. NULLIF()-en_US.srt | 3.7 KB | ||
| 2. NULLIF().mp4 | 24.4 MB | ||
| 2. Operators used with Where Clause-en_US.srt | 4.3 KB | ||
| 2. Operators used with Where Clause.mp4 | 32 MB | ||
| 2. SQL Database Overview Part 2-en_US.srt | 4.3 KB | ||
| 2. SQL Database Overview Part 2.mp4 | 18.8 MB | ||
| 2. SQL PostgreSQL Down and install-en_US.srt | 2.9 KB | ||
| 2. SQL PostgreSQL Down and install.mp4 | 21.4 MB | ||
| 2. SUM( ) Function-en_US.srt | 1 KB | ||
| 2. SUM( ) Function.mp4 | 6.2 MB | ||
| 2. Select Challenge Solution-en_US.srt | 2.6 KB | ||
| 2. Select Challenge Solution.mp4 | 18.4 MB | ||
| 2. TIMESTAMP EXTRACT()-en_US.srt | 2.7 KB | ||
| 2. TIMESTAMP EXTRACT().mp4 | 25.4 MB | ||
| 3. COALESCE() Function in SQL-en_US.srt | 2.4 KB | ||
| 3. COALESCE() Function in SQL.mp4 | 24.3 MB | ||
| 3. DATE_TRUNC() & DATE_PART()-en_US.srt | 7.1 KB | ||
| 3. DATE_TRUNC() & DATE_PART().mp4 | 38.7 MB | ||
| 3. MIN( ) , MAX( ) & AVG( ) Functions-en_US.srt | 2.1 KB | ||
| 3. MIN( ) , MAX( ) & AVG( ) Functions.mp4 | 10.9 MB | ||
| 3. NOT IN-en_US.srt | 3.8 KB | ||
| 3. NOT IN.mp4 | 28.5 MB | ||
| 3. PostgreSQL Database creation-en_US.srt | 1.3 KB | ||
| 3. PostgreSQL Database creation.mp4 | 6.7 MB | ||
| 3. SQL Data Types-en_US.srt | 1.2 KB | ||
| 3. SQL Data Types.mp4 | 11 MB | ||
| 3. Select Statement For all Airlines Database Tables-en_US.srt | 1.6 KB | ||
| 3. Select Statement For all Airlines Database Tables.mp4 | 30 MB | ||
| 3. Where Clause + AND & Where Clause + OR-en_US.srt | 3.2 KB | ||
| 3. Where Clause + AND & Where Clause + OR.mp4 | 17.2 MB | ||
| 4. Distinct-en_US.srt | 1.9 KB | ||
| 4. Distinct.mp4 | 11.7 MB | ||
| 4. Double Column + DATE IN PostgreSQL & CURRENT_DATE & now( )-en_US.srt | 3.3 KB | ||
| 4. Double Column + DATE IN PostgreSQL & CURRENT_DATE & now( ).mp4 | 19.6 MB | ||
| 4. GROUP BY & HAVING-en_US.srt | 2.1 KB | ||
| 4. GROUP BY & HAVING.mp4 | 14.5 MB | ||
| 4. ISNULL & IS NOT NULL-en_US.srt | 2.6 KB | ||
| 4. ISNULL & IS NOT NULL.mp4 | 22 MB | ||
| 4. SQL Restore-en_US.srt | 1.2 KB | ||
| 4. SQL Restore.mp4 | 10.6 MB | ||
| 4. Where Clause + LIKE-en_US.srt | 5.1 KB | ||
| 4. Where Clause + LIKE.mp4 | 24.9 MB | ||
| 5. (Where Clause + BETWEEN & IN) & AS-en_US.srt | 5.1 KB | ||
| 5. (Where Clause + BETWEEN & IN) & AS.mp4 | 41.6 MB | ||
| 5. CAST-en_US.srt | 4.1 KB | ||
| 5. CAST.mp4 | 30.7 MB | ||
| Airlines.sql | 99.1 MB | ||
| Bonus Resources.txt | 307.2 B | ||
| Challenge(1).html | 204.8 B | ||
| Challenge(2).html | 512 B | ||
| Challenge(3).html | 102.4 B | ||
| Challenge(4).html | 716.8 B | ||
| Get Bonus Downloads Here.url | 204.8 B | ||
| Solution.html | 1.2 KB | ||
| Thank You.html | 2.4 KB | ||
| ▲ 73 total files | |||
SQL Introduction: SQL Crash Course.
MP4 | Video: h264, 1280x720 | Audio: AAC, 44.1 KHz
Language: English | Size: 895 MB | Duration: 1h 59m
Using PostgreSQL & applicable to Oracle SQL, Microsoft SQL Server, and MySQL for Data, Apps and Web development.
What you'll learn
Using Real World PostgreSQL Database Airlines Database.
Use SQL to create databases.
Use SQL to Query & retrieve data from databases.
Use SQL to Sort records after retrieving from databases.
Use SQL to Filter data by using where clause.
Use SQL to Group data by specific conditions.
SQL Challenge to test what you are learning.
Requirements
Computer and internet.
No prior knowledge required for this course
Description
You will learn many tips and tricks in PostgreSQL to query data through the following Topics covered in this course:
Using Real World PostgreSQL Database Airlines Database.
What is a Database
SQL database for beginners.
| 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 | 1 month | 26 | 4 | |
| 1.6 GB | freecoursewb | 1 month | 9 | 8 |
All Comments