Udemy - SQL Mastery From Zero to Superstar [Course Drive]

seeders: 0

leechers: 4

Download torrent

Added 6 years ago by coursedrive in Other

Main
Technical
Comments

Download Fast Safe Anonymous
movies, software, shows...

Files

Udemy - SQL Mastery From Zero to Superstar [Course Drive] (Size: 5.72 GB)

		Course Downloaded from coursedrive.org.txt	538 B
		SQL Mastery From Zero to Superstar
		1. Introduction
		1. Introduction.mp4	59.21 MB
		1. Introduction.vtt	5.59 KB
		Must Read.txt	540 B
		Visit Coursedrive.org.url	124 B
		10. Subqueries
		1. Subquery Using EXISTS.mp4	23.3 MB
		1. Subquery Using EXISTS.vtt	7.01 KB
		1.1 PostgreSQL Documentation on EXISTS.html	150 B
		1.2 35_Subquery Using EXISTS.sql.sql	1.29 KB
		2. Subquery Using ANY and ALL.mp4	19.22 MB
		2. Subquery Using ANY and ALL.vtt	6.08 KB
		2.1 PostgreSQL Documentation on ANY.html	152 B
		2.2 PostgreSQL Documentation on ALL.html	147 B
		2.3 36_Subquery Using ANY and ALL.sql.sql	1.08 KB
		3. IN Using Subquery.mp4	5.25 MB
		3. IN Using Subquery.vtt	1.59 KB
		3.1 PostgreSQL Documentation on IN subquery.html	146 B
		3.2 37_IN Using Subquery.sql.sql	255 B
		ReadMe.txt	538 B
		Visit Coursedrive.org.url	124 B
		11. Modifying Data In Tables INSERT, UPDATE and DELETE
		1. INSERT INTO.mp4	18.56 MB
		1. INSERT INTO.vtt	6.75 KB
		1.1 PostgreSQL Documentation on Inserting Data.html	116 B
		1.2 38_INSERT INTO.sql.sql	816 B
		2. UPDATE.mp4	28.24 MB
		2. UPDATE.vtt	3.63 KB
		2.1 PostgreSQL Documentation on Updating Data.html	116 B
		2.2 39_UPDATE.sql.sql	165 B
		3. DELETE.mp4	5.78 MB
		3. DELETE.vtt	2.3 KB
		3.1 PostgreSQL Documentation on Deleting Data.html	116 B
		3.2 40_DELETE.sql.sql	105 B
		4. SELECT INTO.mp4	8.72 MB
		4. SELECT INTO.vtt	2.54 KB
		4.1 PostgreSQL Documentation on SELECT INTO.html	116 B
		4.2 41_SELECT INTO.sql.sql	181 B
		5. INSERT INTO SELECT.mp4	15.53 MB
		5. INSERT INTO SELECT.vtt	1.95 KB
		5.1 42_INSERT INTO SELECT.sql.sql	199 B
		6. Returning Data From Update, Delete, and Insert.mp4	50.2 MB
		6. Returning Data From Update, Delete, and Insert.vtt	7.15 KB
		6.1 82_Returning Data from update delete and insert.sql.sql	733 B
		6.2 PostgreSQL Documentation on Returning Data From Rows.html	119 B
		12. Indexes and Performance Tuning
		1. CREATE INDEX.mp4	21.97 MB
		1. CREATE INDEX.vtt	3.41 KB
		1.1 49_CREATE INDEX.sql.sql	149 B
		1.2 PostgreSQL Documentation on CREATE INDEX.html	117 B
		2. DROP INDEX.mp4	13.72 MB
		2. DROP INDEX.vtt	2.04 KB
		2.1 PostgreSQL Documentation on DROP INDEX.html	115 B
		2.2 50_DROP INDEX.sql.sql	80 B
		3. Using Explain To See Query Plan.mp4	62.09 MB
		3. Using Explain To See Query Plan.vtt	8.21 KB
		3.1 136_Using Explain To See Performance of Queries.sql.sql	873 B
		3.2 PostgreSQL Documentation on Using Explain.html	115 B
		4. Use Analyze To Update Table Statistics.mp4	25 MB
		4. Use Analyze To Update Table Statistics.vtt	3.43 KB
		4.1 137_Use Analyze To Update Table Statistics.sql.sql	444 B
		4.2 PostgreSQL Documentation on ANALYZE.html	117 B
		4.3 PostgreSQL Documentation on Explain.html	113 B
		5. How Is Query Plan Cost Calculated.mp4	86.25 MB
		5. How Is Query Plan Cost Calculated.vtt	12.31 KB
		5.1 138_How is query plan cost calculated.sql.sql	1.37 KB
		6. Using Indexes On More Than One Field.mp4	42.61 MB
		6. Using Indexes On More Than One Field.vtt	5.52 KB
		6.1 139_Using Indexes On More Than One Field.sql.sql	617 B
		7. Expression Indexes.mp4	42.25 MB
		7. Expression Indexes.vtt	6 KB
		7.1 PostgreSQL Documentation on Indexes On Expressions.html	126 B
		7.2 142_ Expression indexes.sql.sql	1.31 KB
		8. Types Of Indexes.mp4	13.3 MB
		8. Types Of Indexes.vtt	5.65 KB
		8.1 PostgreSQL Documentation on Index Types.html	119 B
		9. Speeding Up Text Matching.mp4	33.96 MB
		9. Speeding Up Text Matching.vtt	4.42 KB
		9.1 PostgreSQL Documentation on pg_trm.html	112 B
		9.2 141_Speeding Up Text Matching.sql.sql	627 B
		13. Database Design and Normalization
		1. Design Process Overview.mp4	22.92 MB
		1. Design Process Overview.vtt	9.09 KB
		2. Database Terminology.mp4	23.7 MB
		2. Database Terminology.vtt	9.54 KB
		2.1 Wikipedia Article On OLTP.html	120 B
		2.10 Wikipedia Article On Foreign Keys.html	102 B
		2.11 Wikipedia Article On Referential Integrity.html	112 B
		2.12 Wikipedia Article On Relations.html	110 B
		2.2 Wikipedia Article On OLAP.html	119 B
		2.3 Wikipedia Article On Tuples.html	105 B
		2.4 Wikipedia Article On Relational Database.html	110 B
		2.5 Wikipedia Article On Attribute.html	108 B
		2.6 Wikipedia Article On Views.html	101 B
		2.7 Wikipedia Article On Primary Keys.html	102 B
		2.8 Wikipedia Article On Data Integrity.html	105 B
		2.9 Wikipedia Article On Entity Integrity.html	107 B
		3. A Design Process.mp4	16.31 MB
		3. A Design Process.vtt	6.61 KB
		4. Finding Mission Statement And Ojectives.mp4	26.39 MB
		4. Finding Mission Statement And Ojectives.vtt	4.56 KB
		5. Analyzing Current Systems.mp4	33.28 MB
		5. Analyzing Current Systems.vtt	4.57 KB
		6. Create Table Structure.mp4	49.23 MB
		7. Establishing Keys.mp4	34.55 MB
		8. Specifying Fields.mp4	35.43 MB
		8.1 Anatomy of a Field Specification.html	212 B
		9. Relationships Between Tables.mp4	48.87 MB
		14. Creating and Modifying Tables
		1. CREATE TABLE.mp4	73.68 MB
		1. CREATE TABLE.vtt	9.75 KB
		1.1 PostgreSQL Documentation on Table Basics.html	116 B
		1.2 PostgreSQL Documentation on CREATE TABLE.html	121 B
		1.3 45_CREATE_TABLE.sql.sql	307 B
		2. ALTER TABLE - Part One.mp4	25.41 MB
		2. ALTER TABLE - Part One.vtt	3.42 KB
		2.1 PostgreSQL Documentation on Renaming a Table.html	129 B
		2.2 PostgreSQL Documentation on Renaming a Column.html	129 B
		2.3 46_ALTER TABLE Part One.sql.sql	208 B
		3. ALTER TABLE - Part Two.mp4	35.99 MB
		3. ALTER TABLE - Part Two.vtt	4.31 KB
		3.1 PostgreSQL Documentation on Removing a Column.html	143 B
		3.2 PostgreSQL Documentation on Adding a Column.html	141 B
		3.3 47_ALTER TABLE Part 2.sql.sql	221 B
		4. ALTER TABLE - Part Three.mp4	20.86 MB
		4. ALTER TABLE - Part Three.vtt	2.8 KB
		4.1 48_ALTER TABLE Part 3.sql.sql	142 B
		4.2 PostgreSQL Documentation on Changing a Column's Data Type.html	129 B
		5. DROP TABLE.mp4	11.44 MB
		5. DROP TABLE.vtt	1.71 KB
		5.1 PostgreSQL Documentation on DROP TABLE.html	115 B
		5.2 51_DROP TABLE.sql.sql	54 B
		15. Table Constraints
		1. NOT NULL Constraint.mp4	12.58 MB
		1. NOT NULL Constraint.vtt	5.83 KB
		1.1 PostgreSQL Documentation on Not-Null Constraint.html	134 B
		1.2 52_NOT NULL Constraint.sql.sql	381 B
		2. UNIQUE Constraint.mp4	11.46 MB
		2. UNIQUE Constraint.vtt	3.49 KB
		2.1 53_UNIQUE Constraint.sql.sql	522 B
		3. PRIMARY KEY Constraint.mp4	16.58 MB
		3. PRIMARY KEY Constraint.vtt	5.3 KB
		3.1 PostgreSQL Documentation on Unique Constraints.html	156 B
		3.2 54_PRIMARY KEY Constraint.sql.sql	625 B
		4. FOREIGN KEY Constraint.mp4	19.2 MB
		4. FOREIGN KEY Constraint.vtt	5.91 KB
		4.1 55_FOREIGN KEY Constraint.sql.sql	772 B
		4.2 PostgreSQL Documentation on Foreign Keys.html	140 B
		5. CHECK Constraint.mp4	16.29 MB
		5. CHECK Constraint.vtt	5.01 KB
		5.1 54_CHECK Constraint.sql.sql	719 B
		5.2 PostgreSQL Documentation on Check Constraints.html	155 B
		6. DEFAULT Values.mp4	8.58 MB
		6. DEFAULT Values.vtt	2.72 KB
		6.1 57_Default constraint.sql.sql	709 B
		6.2 PostgreSQL Documentation on Default Values.html	117 B
		7. Changing a Column's Default Value.mp4	22.82 MB
		7. Changing a Column's Default Value.vtt	3.07 KB
		7.1 81_Changing_Column_Default_Value.sql.sql	243 B
		7.2 PostgreSQL Documentation on Changing a Column's Default Value.html	128 B
		8. Adding and Removing a Column's Constraint.mp4	63.79 MB
		8. Adding and Removing a Column's Constraint.vtt	9.68 KB
		8.1 PostgreSQL Documentation on Adding and Removing Constraints.html	145 B
		8.2 84_Adding and removing column constraints.sql.sql	621 B
		ReadMe.txt	538 B
		Visit Coursedrive.org.url	124 B
		16. Sequences
		1. Create A Sequence.mp4	100.39 MB
		1. Create A Sequence.vtt	12.39 KB
		1.1 PostgreSQL Documentation On CREATE SEQUENCE.html	120 B
		1.2 76_Create a Sequence.sql.sql	1.49 KB
		1.3 PostgreSQL Documentation On sequence manipulation functions.html	124 B
		2. Alter and Delete Sequences.mp4	33.66 MB
		2. Alter and Delete Sequences.vtt	4.29 KB
		2.1 PostgreSQL Documentation on ALTER SEQUENCE.html	119 B
		2.2 76_Alter and delete squences.sql.sql	372 B
		2.3 PostgreSQL Documentation on DROP SEQUENCE.html	118 B
		3. Using Serial Datatypes.mp4	21.34 MB
		3. Using Serial Datatypes.vtt	3.5 KB
		3.1 PostgreSQL Documentation on SERIAL datatypes.html	138 B
		3.2 78_Using Serial Datatypes.sql.sql	283 B
		17. CTE - Common Table Expressions
		1. WITH Queries.mp4	68.8 MB
		1. WITH Queries.vtt	6.88 KB
		1.1 PostgreSQL Documentation on WITH Queries.html	138 B
		1.2 74_With Queries.sql.sql	907 B
		2. Creating Hierarchical Data To Use For Recursive WITH Queries.mp4	10.88 MB
		2. Creating Hierarchical Data To Use For Recursive WITH Queries.vtt	1.15 KB
		2.1 78_AddEmployees.sql.sql	3.07 KB
		3. Using Recursion in CTEs.mp4	82.62 MB
		3. Using Recursion in CTEs.vtt	9.66 KB
		3.1 79_Using Recursions.sql.sql	1.04 KB
		3.2 PostgreSQL Documentation on WITH RECURSIVE.html	138 B
		18. Views
		1. Views - How To Create.mp4	68.44 MB
		1. Views - How To Create.vtt	8.3 KB
		1.1 PostgreSQL Documentation on CREATE VIEW.html	120 B
		1.2 64_Views how to create.sql.sql	845 B
		2. Views - How To Modify.mp4	35.31 MB
		2. Views - How To Modify.vtt	4.43 KB
		2.1 65_Views how to modify.sql.sql	858 B
		2.2 PostgreSQL Documentation on ALTER VIEW.html	119 B
		3. Creating Updatable Views.mp4	49.62 MB
		3. Creating Updatable Views.vtt	6.19 KB
		3.1 67_CreatingUpdateableViews.sql.sql	840 B
		4. With Check Option.mp4	37.63 MB
		4. With Check Option.vtt	5.02 KB
		4.1 68_WithCheckOption.sql.sql	1001 B
		5. Deleting Views.mp4	8.24 MB
		5. Deleting Views.vtt	1.64 KB
		5.1 PostgreSQL Documentation on DROP VIEW.html	118 B
		5.2 66_DeletingViews.sql.sql	83 B
		19. Conditional Expressions
		1. CASE WHEN.mp4	71.48 MB
		1. CASE WHEN.vtt	9.11 KB
		1.1 PostgreSQL Documentation on CASE WHEN.html	142 B
		1.2 61_CaseWhen.sql.sql	970 B
		2. COALESCE.mp4	12.36 MB
		2. COALESCE.vtt	2.23 KB
		2.1 PostgreSQL Documentation on COALESCE.html	157 B
		2.2 62_Coalesce.sql.sql	128 B
		3. NULLIF.mp4	26.38 MB
		3. NULLIF.vtt	4.02 KB
		3.1 PostgreSQL Documentation on NULLIF.html	144 B
		3.2 63_NULLIF.sql.sql	281 B
		2. Installing PostgreSQL and pgAdmin
		1. Installing PostgreSQL on Mac and Windows.mp4	41.86 MB
		1. Installing PostgreSQL on Mac and Windows.vtt	2.99 KB
		2. Installing PostgreSQL on Ubuntu.mp4	103.47 MB
		2. Installing PostgreSQL on Ubuntu.vtt	7.32 KB
		2.1 135_Installing Postgres on Ubuntu.txt.txt	752 B
		3. Install Northwind Database.mp4	41.84 MB
		3. Install Northwind Database.vtt	4.04 KB
		3.1 northwind.sql.sql	193.29 KB
		3.2 northwind.tar.tar	64.64 KB
		4. Install some additional databases..html	578 B
		4.1 usda.tar.tar	19.17 MB
		4.2 AdventureWorks.tar.tar	85.8 MB
		4.3 pagila.tar.tar	2.82 MB
		20. Using DateTime In PostgreSQL
		1. Date, Time, and Timestamp Data Types.mp4	68.82 MB
		1. Date, Time, and Timestamp Data Types.vtt	12.68 KB
		1.1 PostgreSQL Documentation on DateTime Input and Output.html	147 B
		1.2 83_Date Time Input and Output.sql.sql	415 B
		2. Time Zones.mp4	57.77 MB
		2. Time Zones.vtt	8.05 KB
		2.1 PostgreSQL Documentation on Time Zones.html	137 B
		2.2 84_Time Zones.sql.sql	638 B
		3. Interval Data Type.mp4	56.85 MB
		3. Interval Data Type.vtt	9.25 KB
		3.1 PostgreSQL Documentation on Interval Data Type.html	142 B
		3.2 87_Interval Data Type.sql.sql	780 B
		4. Date Arithmetic.mp4	80.42 MB
		4. Date Arithmetic.vtt	10.61 KB
		4.1 PostgreSQL Documentation on DateTime Functions.html	119 B
		4.2 88_Date Arithmetic.sql.sql	1.12 KB
		5. Pulling Out Parts of Dates and Times.mp4	23.04 MB
		5. Pulling Out Parts of Dates and Times.vtt	3.26 KB
		5.1 PostgreSQL Documentation on EXTRACT, date_part.html	146 B
		5.2 100_Pulling Out Parts of Dates and Times.sql.sql	287 B
		6. Converting One Data Type Into Another.mp4	21.06 MB
		6. Converting One Data Type Into Another.vtt	2.84 KB
		6.1 PostgreSQL Documentation on Type Casts.html	138 B
		6.2 101_Converting One Data Type Into Another.sql.sql	224 B
		ReadMe.txt	538 B
		Visit Coursedrive.org.url	124 B
		21. Window Functions
		1. Basic Window Function Example.mp4	66.34 MB
		1. Basic Window Function Example.vtt	7.23 KB
		1.1 59_Basic Window Examples.sql.sql	554 B
		2. Using Window Functions With Subqueries.mp4	89.85 MB
		2. Using Window Functions With Subqueries.vtt	11.95 KB
		2.1 60_Using Window Functions With Subqueries.sql.sql	1.08 KB
		3. Using Rank() To Find The First N Records In Join.mp4	55.74 MB
		3. Using Rank() To Find The First N Records In Join.vtt	6.38 KB
		3.1 125_Using Rank to find first N records.sql.sql	497 B
		22. Composite Types
		1. Composite Type Basics.mp4	50.53 MB
		1. Composite Type Basics.vtt	7.45 KB
		1.1 PostgreSQL Documentation on Declaration of Composite Type.html	128 B
		1.2 PostgreSQL Documentation on DROP TYPE.html	118 B
		1.3 89_Composite Type Basics.sql.sql	758 B
		2. Using Composite Types.mp4	54.2 MB
		2. Using Composite Types.vtt	8.21 KB
		2.1 PostgreSQL Documentation on Accessing Composite Types.html	128 B
		2.2 PostgreSQL Documentation on Modifying Composite Types.html	123 B
		2.3 PostgreSQL Documentation on Constructing Composite Types.html	123 B
		2.4 90_Using Composite Types.sql.sql	938 B
		23. SQL Functions and Procedures
		1. Write Your First Function.mp4	37.91 MB
		1. Write Your First Function.vtt	6.41 KB
		1.1 91_Write Your First Function.sql.sql	395 B
		10. Procedures - Functions That Don't Return Anything.mp4	26.09 MB
		10. Procedures - Functions That Don't Return Anything.vtt	4.44 KB
		10.1 PostgreSQL Documentation on CREATE PROCEDURE.html	125 B
		10.2 PostgreSQL Documentation on User-defined Procedures.html	106 B
		10.3 102_Procedures.sql.sql	341 B
		2. Write A Function That Returns A Single Value.mp4	26.65 MB
		2. Write A Function That Returns A Single Value.vtt	4.43 KB
		2.1 92_Write a function that returns a single value.sql.sql	381 B
		3. Functions With Parameters.mp4	63.78 MB
		3. Functions With Parameters.vtt	7.95 KB
		3.1 93_Functions with parameters.sql.sql	759 B
		4. Functions That Have Composite Parameters.mp4	41 MB
		4. Functions That Have Composite Parameters.vtt	6.38 KB
		4.1 94_Functions that have composite parameters.sql.sql	449 B
		4.2 PostgreSQL Documentation on SQL Functions On Composite Types.html	140 B
		5. Functions That Return A Composite.mp4	40.13 MB
		5. Functions That Return A Composite.vtt	5.38 KB
		5.1 PostgreSQL Documentation on SQL Functions On Composite Types.html	140 B
		5.2 95_Functions That Return A Composite.sql.sql	480 B
		6. Functions With Output Parameters.mp4	26.63 MB
		6. Functions With Output Parameters.vtt	4.35 KB
		6.1 96_Functions With Output Parameters.sql.sql	351 B
		6.2 PostgreSQL Documentation on SQL Functions with Output Parameters.html	134 B
		7. Functions With Default Values.mp4	29.21 MB
		7. Functions With Default Values.vtt	3.81 KB
		7.1 97_Functions With Default Values.sql.sql	409 B
		7.2 PostgreSQL Documentation on SQL Functions with Default Values For Arguments.html	139 B
		8. Using Functions as Table Source.mp4	14.69 MB
		8. Using Functions as Table Source.vtt	2.38 KB
		8.1 PostgreSQL Documentation on SQL Functions as Table Sources.html	136 B
		8.2 98_Using Functions as Table Source.sql.sql	172 B
		9. Functions That Return More Than One Row.mp4	115.67 MB
		9. Functions That Return More Than One Row.vtt	13.59 KB
		9.1 PostgreSQL Documentation on SQL Functions Returning Sets.html	144 B
		9.2 99_Functions that return more than one row.sql.sql	693 B
		24. Transactions And Concurrency Control
		1. ACID Transactions.mp4	7.15 MB
		1. ACID Transactions.vtt	3.39 KB
		2. Simple Transaction Control.mp4	31.9 MB
		2. Simple Transaction Control.vtt	4.58 KB
		2.1 104_Simple Transaction Control.sql.sql	462 B
		2.2 PostgreSQL Documentation on Transactions.html	122 B
		2.3 PostgreSQL Documentation on BEGIN.html	115 B
		2.4 PostgreSQL Documentation on START TRANSACTION.html	127 B
		2.5 PostgreSQL Documentation on COMMIT.html	116 B
		2.6 PostgreSQL Documentation on END TRANSACTION.html	113 B
		3. Rollbacks & Savepoints.mp4	39.25 MB
		3. Rollbacks & Savepoints.vtt	5.66 KB
		3.1 PostgreSQL Documentation on ROLLBACK.html	118 B
		3.2 105_Rollbacks savepoints.sql.sql	501 B
		3.3 PostgreSQL Documentation on SAVEPOINT.html	119 B
		3.4 PostgreSQL Documentation on ROLLBACK TO SAVEPOINT.html	121 B
		4. SQL Transaction Isolation.mp4	10.85 MB
		4. SQL Transaction Isolation.vtt	4.8 KB
		4.1 Wikipedia article on database isolation.html	133 B
		5. PostgreSQL Transaction Isolation.mp4	12.35 MB
		5. PostgreSQL Transaction Isolation.vtt	4.05 KB
		5.1 PostgreSQL Documentation on Transaction Isolation.html	116 B
		5.2 PostgreSQL Documentation on SET TRANSACTION.html	120 B
		5.3 PostgreSQL Documentation on START TRANSACTION.html	127 B
		5.4 Wikipedia article on MVCC - multiversion concurrency control.html	123 B
		ReadMe.txt	538 B
		Visit Coursedrive.org.url	124 B
		25. Array Data Type
		1. Declaring Arrays.mp4	21.07 MB
		1. Declaring Arrays.vtt	3.99 KB
		1.1 108_Declaring Arrays.sql.sql	306 B
		1.2 PostgreSQL Documentation on Declaration of Array Types.html	126 B
		2. Inputting Array Values.mp4	31.71 MB
		2. Inputting Array Values.vtt	4.15 KB
		2.1 PostgreSQL Documentation on Array Value Input.html	120 B
		2.2 109_Inputting Array Values.sql.sql	774 B
		3. Accessing Arrays.mp4	19.85 MB
		3. Accessing Arrays.vtt	3.84 KB
		3.1 PostgreSQL Documentation on Accessing Arrays.html	124 B
		3.2 110_Accessing Arrays.sql.sql	217 B
		4. Modifying Arrays.mp4	36.63 MB
		4. Modifying Arrays.vtt	5.22 KB
		4.1 PostgreSQL Documentation on Modifying Arrays.html	124 B
		4.2 111_Modifying Arrays.sql.sql	920 B
		5. Searching Arrays.mp4	18.68 MB
		5. Searching Arrays.vtt	3.14 KB
		5.1 PostgreSQL Documentation on Searching In Arrays.html	129 B
		5.2 112_Searching Arrays.sql.sql	246 B
		6. Array Operators.mp4	40.05 MB
		6. Array Operators.vtt	6.37 KB
		6.1 PostgreSQL Documentation on Array Operators.html	121 B
		6.2 113_Array Operators.sql.sql	775 B
		26. PLpgSQL - SQL Procedural Language
		1. Build Your First PLpgSQL Function.mp4	36.68 MB
		1. Build Your First PLpgSQL Function.vtt	6.16 KB
		1.1 PostgreSQL Documentation on Stucture of PLpgSQL.html	118 B
		1.2 PostgreSQL Documentation on Returning From a Function.html	156 B
		1.3 114_Build first pgpsql function.sql.sql	464 B
		2. Handling Functions With Output Variables.mp4	30.36 MB
		2. Handling Functions With Output Variables.vtt	4.35 KB
		2.1 115_Handling functions with output variables.sql.sql	425 B
		2.2 PostgreSQL Documentation on Assignment.html	149 B
		3. Returning Query Results.mp4	46.85 MB
		3. Returning Query Results.vtt	4.6 KB
		3.1 116_Returning Query Results.sql.sql	754 B
		3.2 PostgreSQL Documentation on Returning From a Function.html	156 B
		4. Declaring Variables.mp4	96.74 MB
		4. Declaring Variables.vtt	9.62 KB
		4.1 PostgreSQL Documentation on Declarations.html	121 B
		4.2 117_Declaring variables.sql.sql	1.21 KB
		5. Looping Through Query Results.mp4	92.24 MB
		5. Looping Through Query Results.vtt	13.1 KB
		5.1 119_Looping Through Query results.sql.sql	1.43 KB
		5.2 PostgreSQL Documentation on Looping Through Query Results.html	158 B
		6. Using If-Then Statements.mp4	60.49 MB
		6. Using If-Then Statements.vtt	7.58 KB
		6.1 PostgreSQL Documentation on Conditionals.html	153 B
		6.2 120_Using If-then statements.sql.sql	776 B
		7. Returning Query Results Continued.mp4	80.45 MB
		7. Returning Query Results Continued.vtt	9.49 KB
		7.1 121_Returning Query Results Continued.cmproj.zip.zip	42.39 MB
		7.2 PostgreSQL Documentation on RETURN NEXT and RETURN QUERY.html	161 B
		8. Loop and While Loops.mp4	36.26 MB
		8. Loop and While Loops.vtt	6.31 KB
		8.1 123_Loop and while loop.sql.sql	701 B
		8.2 PostgreSQL Documentation on Simple Loops.html	165 B
		9. Looping Over Array Elements.mp4	73.46 MB
		9. Looping Over Array Elements.vtt	9.69 KB
		9.1 PostgreSQL Documentation on Looping Through Arrays.html	154 B
		9.2 126_Looping Over Array Elements.sql.sql	1.02 KB
		27. Triggers
		1. Build Your First Trigger.mp4	64.45 MB
		1. Build Your First Trigger.vtt	10.54 KB
		1.1 PostgreSQL Documentation on Trigger Functions.html	116 B
		1.2 118_Building Your First Trigger.sql.sql	1.12 KB
		2. Statement Triggers.mp4	160.73 MB
		2. Statement Triggers.vtt	18.47 KB
		2.1 122_Statement_triggers.sql.sql	3.34 KB
		28. Using psql To Connect To Postgres
		1. Connecting With psql.mp4	17.54 MB
		1. Connecting With psql.vtt	3.79 KB
		1.1 127_Connecting With psql.sql.sql	176 B
		1.2 PostgreSQL Documentation on psql.html	109 B
		2. Eliminate Typing Connection Parameters.mp4	28.22 MB
		2. Eliminate Typing Connection Parameters.vtt	6.17 KB
		2.1 149_Eliminate Typing Connection Parameters.txt.txt	318 B
		2.2 PostgreSQL Documentation on Environment Variables.html	118 B
		2.3 PostgreSQL Documentation on The Password File.html	113 B
		2.4 PostgreSQL Documentation on the Service File.html	117 B
		29. Importing CSV
		1. Import CSV File.mp4	87.97 MB
		1. Import CSV File.vtt	10.61 KB
		1.1 128_Import CSV files.sql.sql	1.43 KB
		1.2 PostgreSQL Documentation on COPY.html	114 B
		1.3 Our Airports link to get the CSV files..html	89 B
		2. Practice What You've Learned.html	564 B
		2.1 03_Importing CSV.sql.sql	2.27 KB
		3. Simple Selection of All Records
		1. Selecting All Data From a Table.mp4	24.78 MB
		1. Selecting All Data From a Table.vtt	3.96 KB
		1.1 04_Selecting All Data From a Table.sql.sql	51 B
		2. Selecting Specific Fields.mp4	18.9 MB
		2. Selecting Specific Fields.mp4.jpg?042148	72.87 KB
		2. Selecting Specific Fields.txt	246 B
		2. Selecting Specific Fields.vtt	2.45 KB
		2.1 05_Selecting Specific Fields.sql.sql	101 B
		3. Selecting Distinct Values.mp4	18.62 MB
		3. Selecting Distinct Values.vtt	2.6 KB
		3.1 06_Selecting Distinct Values.sql.sql	127 B
		4. Counting Results.mp4	16.23 MB
		4. Counting Results.vtt	2.81 KB
		4.1 07_Counting Results.sql.sql	162 B
		5. Combining Fields in SELECT.mp4	15.36 MB
		5. Combining Fields in SELECT.vtt	1.94 KB
		5.1 08_Combining fields in SELECT.sql.sql	111 B
		6. Practice What You've Learned.html	1.28 KB
		6.1 01_Simple Selection of all records.sql.sql	522 B
		30. JSON and JSONB Data Types
		1. What Is JSON And How To Store In Database.mp4	43.86 MB
		1. What Is JSON And How To Store In Database.vtt	6.32 KB
		1.1 PostgreSQL Documentation on JSON Types.html	119 B
		1.2 128_What is JSON and how to store.sql.sql	762 B
		2. Create JSON From Tables.mp4	91.06 MB
		2. Create JSON From Tables.vtt	10.17 KB
		2.1 129_Create JSON from tables.sql.sql	3.1 KB
		3. Aggregating JSON Fields.mp4	52.91 MB
		3. Aggregating JSON Fields.vtt	5.64 KB
		3.1 130_Aggregating JSON fields.sql.sql	1.05 KB
		4. Building airports_json Table.mp4	74.99 MB
		4. Building airports_json Table.vtt	8.16 KB
		5. Selecting Information Out of JSON Fields.mp4	36.05 MB
		5. Selecting Information Out of JSON Fields.vtt	6 KB
		5.1 133_Selecting Information Out of JSON fields.sql.sql	402 B
		6. Searching JSON Data.mp4	37.42 MB
		6. Searching JSON Data.vtt	5.52 KB
		6.1 132_Searching JSON data.sql.sql	492 B
		7. Updating And Deleting Information Inside JSON Fields.mp4	66.5 MB
		7. Updating And Deleting Information Inside JSON Fields.vtt	8.85 KB
		7.1 134_Updating and deleting information inside JSON fields.sql.sql	2.02 KB
		ReadMe.txt	538 B
		Visit Coursedrive.org.url	124 B
		31. Managing Databases
		1. CREATE DATABASE.mp4	16.33 MB
		1. CREATE DATABASE.vtt	2.8 KB
		1.1 PostgreSQL Documentation on CREATE DATABASE.html	124 B
		1.2 43_CREATE DATABASE.sql.sql	96 B
		1.3 PostgreSQL Documentation on createdb.html	118 B
		2. DROP DATABASE.mp4	17.01 MB
		2. DROP DATABASE.mp4.jpg?042148	68.42 KB
		2. DROP DATABASE.txt	233 B
		2. DROP DATABASE.vtt	2.99 KB
		2.1 PostgreSQL Documentation on DROP DATABASE.html	118 B
		2.2 PostgreSQL Documentation on dropdb.html	116 B
		2.3 44_DROP DATABASE.sql.sql	107 B
		32. Backups and Recovery
		1. Basic ImportExport With Copy.mp4	28.07 MB
		1. Basic ImportExport With Copy.vtt	8.2 KB
		1.1 146_Basic import export with copy.txt.txt	562 B
		1.2 PostgreSQL Documentation on COPY.html	114 B
		2. Basic pg_dump And Restore.mp4	20.21 MB
		2. Basic pg_dump And Restore.vtt	3.89 KB
		2.1 PostgreSQL Documentation on pg_dump.html	116 B
		2.2 147_Basic pg_dump and restore.txt.txt	375 B
		3. Custom Format Dumps.mp4	34.43 MB
		3. Custom Format Dumps.vtt	6.46 KB
		3.1 PostgreSQL Documentation on pg_restore.html	119 B
		3.2 148_Custom Format Dumps.txt.txt	408 B
		33. Introduction To PostGIS
		1. Install PostGIS on Ubuntu (Not needed for WindowsMac).mp4	13.02 MB
		1. Install PostGIS on Ubuntu (Not needed for WindowsMac).vtt	1.21 KB
		1.1 143_Install PostGIS on Ubuntu.txt.txt	48 B
		2. Converting Airport Data.mp4	64.75 MB
		2. Converting Airport Data.vtt	8.75 KB
		2.1 144_Converting Airport Data.sql.sql	1.13 KB
		2.2 PostGIS Documentation on ST_SetSRID.html	101 B
		2.3 PostGIS Documentation on AddGeometryColumn.html	108 B
		2.4 PostGIS Documentation on ST_MakePoint.html	103 B
		3. Your First Geographical Query.mp4	64.66 MB
		3. Your First Geographical Query.vtt	8.16 KB
		3.1 145_Your First Geographical Query.sql.sql	560 B
		3.2 PostGIS Documentation on ST_DWithin.html	101 B
		34. Thanks and Good Luck
		1. Thank You.mp4	734.98 KB
		1. Thank You.vtt	606 B
		ReadMe.txt	538 B
		Visit Coursedrive.org.url	124 B
		4. Using WHERE to Select Records
		1. WHERE Selection for Text Fields.mp4	16.89 MB
		1. WHERE Selection for Text Fields.vtt	2.6 KB
		1.1 09_Where with text fields.sql.sql	126 B
		10. Practice What You've Learned.html	1.99 KB
		10.1 02_Using where to select records.sql.sql	1.14 KB
		2. WHERE Selection for Numeric Fields.mp4	7.31 MB
		2. WHERE Selection for Numeric Fields.vtt	2.47 KB
		2.1 10_Where with Numeric Fields.sql.sql	152 B
		3. WHERE with Date Fields.mp4	10.45 MB
		3. WHERE with Date Fields.vtt	1.58 KB
		3.1 11_WHERE with Date fields.sql.sql	124 B
		4. WHERE Using Logical AND Operator.mp4	7.79 MB
		4. WHERE Using Logical AND Operator.vtt	2.74 KB
		5. WHERE Using Logical OR Operator.mp4	8.62 MB
		5. WHERE Using Logical OR Operator.vtt	2.71 KB
		5.1 13_WHERE using OR.sql.sql	253 B
		6. WHERE Using Logical NOT Operator.mp4	4.07 MB
		6. WHERE Using Logical NOT Operator.vtt	1.42 KB
		6.1 14_WHERE Using NOT.sql.sql	116 B
		7. WHERE Combining AND, OR, and NOT.mp4	6.3 MB
		7. WHERE Combining AND, OR, and NOT.vtt	2.53 KB
		7.1 15_WHERE Combining AND OR NOT.sql.sql	202 B
		8. Using BETWEEN.mp4	5.62 MB
		8. Using BETWEEN.vtt	1.58 KB
		8.1 16_Using BETWEEN.sql.sql	156 B
		9. Using IN.mp4	9.58 MB
		9. Using IN.vtt	1.77 KB
		9.1 16_Using BETWEEN.sql.sql	156 B
		5. Schemas
		1. Schema Basics.mp4	23.83 MB
		1. Schema Basics.vtt	3.61 KB
		1.1 124_Schema basics.sql.sql	173 B
		ReadMe.txt	538 B
		Visit Coursedrive.org.url	124 B
		6. Intermediate SELECT Statements
		1. ORDER BY.mp4	10.17 MB
		1. ORDER BY.vtt	3.33 KB
		1.1 PostgreSQL Documentation on Sorting Rows.html	119 B
		1.2 18_ORDER BY.sql.sql	330 B
		2. Using MIN and MAX Functions.mp4	6.42 MB
		2. Using MIN and MAX Functions.vtt	2.42 KB
		2.1 19_Using MIN and MAX.sql.sql	201 B
		3. Using AVG and SUM.mp4	6.66 MB
		3. Using AVG and SUM.vtt	2.13 KB
		3.1 20_Using AVG and SUM.sql.sql	182 B
		4. LIKE to Match Patterns.mp4	10.85 MB
		4. LIKE to Match Patterns.vtt	4.28 KB
		4.1 21_LIKE to Match Patterns.sql.sql	206 B
		4.2 PostgreSQL Documentation on LIKE.html	125 B
		5. Renaming Columns With Alias.mp4	22.4 MB
		5. Renaming Columns With Alias.vtt	3.46 KB
		5.1 22_Renaming Column With Alias.sql.sql	358 B
		6. LIMIT to Control Number of Records Returned.mp4	27.64 MB
		6. LIMIT to Control Number of Records Returned.vtt	3.23 KB
		6.1 23_LIMIT to Control.sql.sql	213 B
		6.2 PostgreSQL Documentation on LIMIT.html	115 B
		7. NULL Values.mp4	6.98 MB
		7. NULL Values.vtt	2.42 KB
		7.1 24_NULL Values.sql.sql	166 B
		8. Practice What You've Learned.html	1.95 KB
		8.1 04_Intermediate Select Statements.sql.sql	1.1 KB
		7. Joining multiple tables together
		1. Diagramming Table Relationships.mp4	6.59 MB
		1. Diagramming Table Relationships.vtt	3.77 KB
		1.1 01 Northwind_A4_size_for_Print.png.png	86.65 KB
		10. Practice What You've Learned.html	1.73 KB
		10.1 05_Joining multiple tables together.sql.sql	1.54 KB
		2. Inner Join for Two Tables.mp4	50.31 MB
		2. Inner Join for Two Tables.vtt	6.21 KB
		2.1 26_Inner Join for two tables.sql.sql	335 B
		3. Inner Join for Multiple Tables.mp4	60.09 MB
		3. Inner Join for Multiple Tables.vtt	6.33 KB
		3.1 27_Inner Joins for multiple tables.sql.sql	1.19 KB
		4. Left Joins.mp4	33.91 MB
		4. Left Joins.vtt	3.64 KB
		4.1 28_Left Joins.sql.sql	479 B
		5. Right Joins.mp4	9.82 MB
		5. Right Joins.vtt	3.5 KB
		5.1 29_Right Joins.sql.sql	388 B
		6. Full Joins.mp4	7.11 MB
		6. Full Joins.vtt	2.49 KB
		6.1 30_Full Joins.sql.sql	218 B
		7. Self Joins.mp4	22.04 MB
		7. Self Joins.vtt	3.27 KB
		7.1 31_Self Join.sql.sql	379 B
		8. USING To Reduce Typing.mp4	10.15 MB
		8. USING To Reduce Typing.vtt	1.61 KB
		8.1 69_USING to reduce typing.sql.sql	148 B
		9. Even Less Typing With NATURAL.mp4	27.65 MB
		9. Even Less Typing With NATURAL.vtt	4.29 KB
		9.1 PostgreSQL Documentation on Joins.html	144 B
		9.2 70_Even less typing with NATURAL.sql.sql	350 B
		8. Grouping and Aggregation Functions
		1. Group By.mp4	23.9 MB
		1. Group By.vtt	6.46 KB
		1.1 PostgreSQL Documentation on GROUP BY.html	145 B
		1.2 32_Group By.sql.sql	794 B
		2. Use HAVING to Filter Groups.mp4	38.97 MB
		2. Use HAVING to Filter Groups.vtt	4.27 KB
		2.1 PostgreSQL Documentation on HAVING.html	145 B
		2.2 32_HAVING to filter Groups.sql.sql	763 B
		3. Grouping Sets.mp4	53.97 MB
		3. Grouping Sets.vtt	6.92 KB
		3.1 PostgreSQL Documentation on GROUPING SETS.html	153 B
		3.2 73_Grouping Sets.sql.sql	857 B
		4. Rollup.mp4	50.08 MB
		4. Rollup.vtt	4.68 KB
		4.1 74_Rollup.sql.sql	661 B
		4.2 PostgreSQL Documentation on GROUPING SETS.html	153 B
		5. Cube - Rollup On Steroids.mp4	66.62 MB
		5. Cube - Rollup On Steroids.vtt	4.9 KB
		5.1 PostgreSQL Documentation on CUBE.html	153 B
		5.2 75_Cube Rollup on steroids.sql.sql	576 B
		9. Combining Queries
		1. Union.mp4	10.17 MB
		1. Union.vtt	3.59 KB
		1.1 PostgreSQL Documentation on UNION.html	119 B
		1.2 34_UNION.sql.sql	323 B
		2. Intersect.mp4	22.37 MB
		2. Intersect.vtt	3.58 KB
		2.1 71_Intersect.sql.sql	376 B
		2.2 PostgreSQL Documentation on INTERSECTION.html	119 B
		3. Except.mp4	19.91 MB
		3. Except.vtt	3.21 KB
		3.1 PostgreSQL Documentation on EXCEPT.html	119 B
		3.2 72_Except.sql.sql	431 B
		ReadMe.txt	538 B
		Visit Coursedrive.org.url	124 B
		Visit Coursedrive.org.url	124 B

Description

SQL Mastery: From Zero to Superstar Download

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

Related Torrents

torrent name	size	uploader	age	seed	leech
Udemy - SQL Interview Preparation Bootcamp SQL for Data Engineers Posted by freecoursewb in Other	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
Udemy - AI-Powered Data Analysis - ChatGPT, SQL, Python and BI Posted by freecoursewb in Other	2.5 GB	freecoursewb	1 month	26	4
Udemy - Transact SQL Bootcamp Posted by freecoursewb in Other	1.6 GB	freecoursewb	1 month	9	8

Udemy - SQL Mastery From Zero to Superstar [Course Drive]

Files

Description

Related Torrents

Trackers

All Comments

tracker name
udp://tracker.coppersurfer.tk:6969/announce
udp://9.rarbg.me:2850/announce
udp://9.rarbg.to:2920/announce
udp://tracker.opentrackr.org:1337
udp://tracker.leechers-paradise.org:6969/announce