17 OCT 2024 - Welcome Back to TorrentFunk! Get your pirate hat back out. Streaming is dying and torrents are the new trend. Account Registration works again and so do Torrent Uploads. We invite you all to start uploading torrents again!
TORRENT DETAILS
SQL Mastery From Zero To Superstar
TORRENT SUMMARY
Status:
All the torrents in this section have been verified by our verification system
Master SQL starting with basics to advanced features like views, Common Table Expressions, and Window Functions
What you’ll learn
Query databases and answer business question Perform joins across multiple tables Use Group By to generate aggregate data
Requirements
Basic computer skills Ability to install basic software on your system Computer that can run PostgreSQL database (I will show how to install.
Description
Learning SQL was one of the most valuable skills I learned while building Match. We had one of the largest instances of Microsoft SQL Server in the 90s with millions of records to keep the site running. The better we got at SQL, the better we could make the site work for our users and answers sophisticated questions about our users.
I want to teach you how to start talking to databases through SQL, the universal language of SQL databases. We will walk through
Basic selection statements Joining multiple tables together Grouping records to get aggregate data Inserting, updating and deleting records Creating tables and indexes
Who is the target audience?
Anyone needing to talk to a database Entrepreneurs trying to build their MVP
visit for more udemy courses free download
VISITOR COMMENTS (0 )
FILE LIST
Filename
Size
SQL Mastery From Zero to Superstar/1. Introduction/1. Introduction.mp4
59.2 MB
SQL Mastery From Zero to Superstar/1. Introduction/1. Introduction.vtt
5.6 KB
SQL Mastery From Zero to Superstar/1. Introduction/Must Read.txt
540 B
SQL Mastery From Zero to Superstar/2. Installing PostgreSQL and pgAdmin/1. Installing PostgreSQL on Mac and Windows.mp4
41.9 MB
SQL Mastery From Zero to Superstar/2. Installing PostgreSQL and pgAdmin/1. Installing PostgreSQL on Mac and Windows.vtt
3 KB
SQL Mastery From Zero to Superstar/2. Installing PostgreSQL and pgAdmin/2. Installing PostgreSQL on Ubuntu.mp4
103.5 MB
SQL Mastery From Zero to Superstar/2. Installing PostgreSQL and pgAdmin/2. Installing PostgreSQL on Ubuntu.vtt
7.3 KB
SQL Mastery From Zero to Superstar/2. Installing PostgreSQL and pgAdmin/2.1 135_Installing Postgres on Ubuntu.txt.txt
752 B
SQL Mastery From Zero to Superstar/2. Installing PostgreSQL and pgAdmin/3. Install Northwind Database.mp4
41.8 MB
SQL Mastery From Zero to Superstar/2. Installing PostgreSQL and pgAdmin/3. Install Northwind Database.vtt
4 KB
SQL Mastery From Zero to Superstar/2. Installing PostgreSQL and pgAdmin/3.1 northwind.sql.sql
193.3 KB
SQL Mastery From Zero to Superstar/2. Installing PostgreSQL and pgAdmin/3.2 northwind.tar.tar
64.6 KB
SQL Mastery From Zero to Superstar/2. Installing PostgreSQL and pgAdmin/4. Install some additional databases..html
578 B
SQL Mastery From Zero to Superstar/2. Installing PostgreSQL and pgAdmin/4.1 usda.tar.tar
19.2 MB
SQL Mastery From Zero to Superstar/2. Installing PostgreSQL and pgAdmin/4.2 AdventureWorks.tar.tar
85.8 MB
SQL Mastery From Zero to Superstar/2. Installing PostgreSQL and pgAdmin/4.3 pagila.tar.tar
2.8 MB
SQL Mastery From Zero to Superstar/27. Triggers/2. Statement Triggers.mp4
160.7 MB
SQL Mastery From Zero to Superstar/3. Simple Selection of All Records/1. Selecting All Data From a Table.mp4
24.8 MB
SQL Mastery From Zero to Superstar/3. Simple Selection of All Records/1. Selecting All Data From a Table.vtt
4 KB
SQL Mastery From Zero to Superstar/3. Simple Selection of All Records/1.1 04_Selecting All Data From a Table.sql.sql
51 B
SQL Mastery From Zero to Superstar/3. Simple Selection of All Records/2. Selecting Specific Fields.mp4
18.9 MB
SQL Mastery From Zero to Superstar/3. Simple Selection of All Records/2. Selecting Specific Fields.mp4.jpg
72.9 KB
SQL Mastery From Zero to Superstar/3. Simple Selection of All Records/2. Selecting Specific Fields.txt
246 B
SQL Mastery From Zero to Superstar/3. Simple Selection of All Records/2. Selecting Specific Fields.vtt
2.4 KB
SQL Mastery From Zero to Superstar/3. Simple Selection of All Records/2.1 05_Selecting Specific Fields.sql.sql
101 B
SQL Mastery From Zero to Superstar/3. Simple Selection of All Records/3. Selecting Distinct Values.mp4
18.6 MB
SQL Mastery From Zero to Superstar/3. Simple Selection of All Records/3. Selecting Distinct Values.vtt
2.6 KB
SQL Mastery From Zero to Superstar/3. Simple Selection of All Records/3.1 06_Selecting Distinct Values.sql.sql
127 B
SQL Mastery From Zero to Superstar/3. Simple Selection of All Records/4. Counting Results.mp4
16.2 MB
SQL Mastery From Zero to Superstar/3. Simple Selection of All Records/4. Counting Results.vtt
2.8 KB
SQL Mastery From Zero to Superstar/3. Simple Selection of All Records/4.1 07_Counting Results.sql.sql
162 B
SQL Mastery From Zero to Superstar/3. Simple Selection of All Records/5. Combining Fields in SELECT.mp4
15.4 MB
SQL Mastery From Zero to Superstar/3. Simple Selection of All Records/5. Combining Fields in SELECT.vtt
1.9 KB
SQL Mastery From Zero to Superstar/3. Simple Selection of All Records/5.1 08_Combining fields in SELECT.sql.sql
111 B
SQL Mastery From Zero to Superstar/3. Simple Selection of All Records/6. Practice What You've Learned.html
1.3 KB
SQL Mastery From Zero to Superstar/3. Simple Selection of All Records/6.1 01_Simple Selection of all records.sql.sql
522 B
SQL Mastery From Zero to Superstar/4. Using WHERE to Select Records/1. WHERE Selection for Text Fields.mp4
16.9 MB
SQL Mastery From Zero to Superstar/4. Using WHERE to Select Records/1. WHERE Selection for Text Fields.vtt
2.6 KB
SQL Mastery From Zero to Superstar/4. Using WHERE to Select Records/1.1 09_Where with text fields.sql.sql
126 B
SQL Mastery From Zero to Superstar/4. Using WHERE to Select Records/10. Practice What You've Learned.html
2 KB
SQL Mastery From Zero to Superstar/4. Using WHERE to Select Records/10.1 02_Using where to select records.sql.sql
1.1 KB
SQL Mastery From Zero to Superstar/4. Using WHERE to Select Records/2. WHERE Selection for Numeric Fields.mp4
7.3 MB
SQL Mastery From Zero to Superstar/4. Using WHERE to Select Records/2. WHERE Selection for Numeric Fields.vtt
2.5 KB
SQL Mastery From Zero to Superstar/4. Using WHERE to Select Records/2.1 10_Where with Numeric Fields.sql.sql
152 B
SQL Mastery From Zero to Superstar/4. Using WHERE to Select Records/3. WHERE with Date Fields.mp4
10.4 MB
SQL Mastery From Zero to Superstar/4. Using WHERE to Select Records/3. WHERE with Date Fields.vtt
1.6 KB
SQL Mastery From Zero to Superstar/4. Using WHERE to Select Records/3.1 11_WHERE with Date fields.sql.sql
124 B
SQL Mastery From Zero to Superstar/4. Using WHERE to Select Records/4. WHERE Using Logical AND Operator.mp4
7.8 MB
SQL Mastery From Zero to Superstar/4. Using WHERE to Select Records/4. WHERE Using Logical AND Operator.vtt
2.7 KB
SQL Mastery From Zero to Superstar/4. Using WHERE to Select Records/5. WHERE Using Logical OR Operator.mp4
8.6 MB
SQL Mastery From Zero to Superstar/4. Using WHERE to Select Records/5. WHERE Using Logical OR Operator.vtt
2.7 KB
SQL Mastery From Zero to Superstar/4. Using WHERE to Select Records/5.1 13_WHERE using OR.sql.sql
253 B
SQL Mastery From Zero to Superstar/4. Using WHERE to Select Records/6. WHERE Using Logical NOT Operator.mp4
4.1 MB
SQL Mastery From Zero to Superstar/4. Using WHERE to Select Records/6. WHERE Using Logical NOT Operator.vtt
1.4 KB
SQL Mastery From Zero to Superstar/4. Using WHERE to Select Records/6.1 14_WHERE Using NOT.sql.sql
116 B
SQL Mastery From Zero to Superstar/4. Using WHERE to Select Records/7. WHERE Combining AND, OR, and NOT.mp4
6.3 MB
SQL Mastery From Zero to Superstar/4. Using WHERE to Select Records/7. WHERE Combining AND, OR, and NOT.vtt
2.5 KB
SQL Mastery From Zero to Superstar/4. Using WHERE to Select Records/7.1 15_WHERE Combining AND OR NOT.sql.sql
202 B
SQL Mastery From Zero to Superstar/4. Using WHERE to Select Records/8. Using BETWEEN.mp4
5.6 MB
SQL Mastery From Zero to Superstar/4. Using WHERE to Select Records/8. Using BETWEEN.vtt
1.6 KB
SQL Mastery From Zero to Superstar/4. Using WHERE to Select Records/8.1 16_Using BETWEEN.sql.sql
156 B
SQL Mastery From Zero to Superstar/4. Using WHERE to Select Records/9. Using IN.mp4
9.6 MB
SQL Mastery From Zero to Superstar/4. Using WHERE to Select Records/9. Using IN.vtt
1.8 KB
SQL Mastery From Zero to Superstar/4. Using WHERE to Select Records/9.1 16_Using BETWEEN.sql.sql
156 B
SQL Mastery From Zero to Superstar/5. Schemas/1. Schema Basics.mp4
23.8 MB
SQL Mastery From Zero to Superstar/5. Schemas/1. Schema Basics.vtt
3.6 KB
SQL Mastery From Zero to Superstar/5. Schemas/1.1 124_Schema basics.sql.sql
173 B
SQL Mastery From Zero to Superstar/5. Schemas/ReadMe.txt
538 B
SQL Mastery From Zero to Superstar/6. Intermediate SELECT Statements/1. ORDER BY.mp4
10.2 MB
SQL Mastery From Zero to Superstar/6. Intermediate SELECT Statements/1. ORDER BY.vtt
3.3 KB
SQL Mastery From Zero to Superstar/6. Intermediate SELECT Statements/1.1 PostgreSQL Documentation on Sorting Rows.html
119 B
SQL Mastery From Zero to Superstar/6. Intermediate SELECT Statements/1.2 18_ORDER BY.sql.sql
330 B
SQL Mastery From Zero to Superstar/6. Intermediate SELECT Statements/2. Using MIN and MAX Functions.mp4
6.4 MB
SQL Mastery From Zero to Superstar/6. Intermediate SELECT Statements/2. Using MIN and MAX Functions.vtt
2.4 KB
SQL Mastery From Zero to Superstar/6. Intermediate SELECT Statements/2.1 19_Using MIN and MAX.sql.sql
201 B
SQL Mastery From Zero to Superstar/6. Intermediate SELECT Statements/3. Using AVG and SUM.mp4
6.7 MB
SQL Mastery From Zero to Superstar/6. Intermediate SELECT Statements/3. Using AVG and SUM.vtt
2.1 KB
SQL Mastery From Zero to Superstar/6. Intermediate SELECT Statements/3.1 20_Using AVG and SUM.sql.sql
182 B
SQL Mastery From Zero to Superstar/6. Intermediate SELECT Statements/4. LIKE to Match Patterns.mp4
10.9 MB
SQL Mastery From Zero to Superstar/6. Intermediate SELECT Statements/4. LIKE to Match Patterns.vtt
4.3 KB
SQL Mastery From Zero to Superstar/6. Intermediate SELECT Statements/4.1 21_LIKE to Match Patterns.sql.sql
206 B
SQL Mastery From Zero to Superstar/6. Intermediate SELECT Statements/4.2 PostgreSQL Documentation on LIKE.html
125 B
SQL Mastery From Zero to Superstar/6. Intermediate SELECT Statements/5. Renaming Columns With Alias.mp4
22.4 MB
SQL Mastery From Zero to Superstar/6. Intermediate SELECT Statements/5. Renaming Columns With Alias.vtt
3.5 KB
SQL Mastery From Zero to Superstar/6. Intermediate SELECT Statements/5.1 22_Renaming Column With Alias.sql.sql
358 B
SQL Mastery From Zero to Superstar/6. Intermediate SELECT Statements/6. LIMIT to Control Number of Records Returned.mp4
27.6 MB
SQL Mastery From Zero to Superstar/6. Intermediate SELECT Statements/6. LIMIT to Control Number of Records Returned.vtt
3.2 KB
SQL Mastery From Zero to Superstar/6. Intermediate SELECT Statements/6.1 23_LIMIT to Control.sql.sql
213 B
SQL Mastery From Zero to Superstar/6. Intermediate SELECT Statements/6.2 PostgreSQL Documentation on LIMIT.html
115 B
SQL Mastery From Zero to Superstar/6. Intermediate SELECT Statements/7. NULL Values.mp4
7 MB
SQL Mastery From Zero to Superstar/6. Intermediate SELECT Statements/7. NULL Values.vtt
2.4 KB
SQL Mastery From Zero to Superstar/6. Intermediate SELECT Statements/7.1 24_NULL Values.sql.sql
166 B
SQL Mastery From Zero to Superstar/6. Intermediate SELECT Statements/8. Practice What You've Learned.html
1.9 KB
SQL Mastery From Zero to Superstar/6. Intermediate SELECT Statements/8.1 04_Intermediate Select Statements.sql.sql
