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

Torrent Contents Size: 5.72 GB

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

Course Downloaded from coursedrive.org.txt

TXT

538 B

SQL Mastery From Zero to Superstar

1. Introduction

1. Introduction.mp4	MP4	59.21 MB
1. Introduction.vtt	VTT	5.59 KB
Must Read.txt	TXT	540 B
Visit Coursedrive.org.url	URL	124 B

10. Subqueries

1. Subquery Using EXISTS.mp4	MP4	23.3 MB
1. Subquery Using EXISTS.vtt	VTT	7.01 KB
1.1 PostgreSQL Documentation on EXISTS.html	HTML	150 B
1.2 35_Subquery Using EXISTS.sql.sql	SQL	1.29 KB
2. Subquery Using ANY and ALL.mp4	MP4	19.22 MB
2. Subquery Using ANY and ALL.vtt	VTT	6.08 KB
2.1 PostgreSQL Documentation on ANY.html	HTML	152 B
2.2 PostgreSQL Documentation on ALL.html	HTML	147 B
2.3 36_Subquery Using ANY and ALL.sql.sql	SQL	1.08 KB
3. IN Using Subquery.mp4	MP4	5.25 MB
3. IN Using Subquery.vtt	VTT	1.59 KB
3.1 PostgreSQL Documentation on IN subquery.html	HTML	146 B
3.2 37_IN Using Subquery.sql.sql	SQL	255 B
ReadMe.txt	TXT	538 B
Visit Coursedrive.org.url	URL	124 B

11. Modifying Data In Tables INSERT, UPDATE and DELETE

1. INSERT INTO.mp4	MP4	18.56 MB
1. INSERT INTO.vtt	VTT	6.75 KB
1.1 PostgreSQL Documentation on Inserting Data.html	HTML	116 B
1.2 38_INSERT INTO.sql.sql	SQL	816 B
2. UPDATE.mp4	MP4	28.24 MB
2. UPDATE.vtt	VTT	3.63 KB
2.1 PostgreSQL Documentation on Updating Data.html	HTML	116 B
2.2 39_UPDATE.sql.sql	SQL	165 B
3. DELETE.mp4	MP4	5.78 MB
3. DELETE.vtt	VTT	2.3 KB
3.1 PostgreSQL Documentation on Deleting Data.html	HTML	116 B
3.2 40_DELETE.sql.sql	SQL	105 B
4. SELECT INTO.mp4	MP4	8.72 MB
4. SELECT INTO.vtt	VTT	2.54 KB
4.1 PostgreSQL Documentation on SELECT INTO.html	HTML	116 B
4.2 41_SELECT INTO.sql.sql	SQL	181 B
5. INSERT INTO SELECT.mp4	MP4	15.53 MB
5. INSERT INTO SELECT.vtt	VTT	1.95 KB
5.1 42_INSERT INTO SELECT.sql.sql	SQL	199 B
6. Returning Data From Update, Delete, and Insert.mp4	MP4	50.2 MB
6. Returning Data From Update, Delete, and Insert.vtt	VTT	7.15 KB
6.1 82_Returning Data from update delete and insert.sql.sql	SQL	733 B
6.2 PostgreSQL Documentation on Returning Data From Rows.html	HTML	119 B

12. Indexes and Performance Tuning

1. CREATE INDEX.mp4	MP4	21.97 MB
1. CREATE INDEX.vtt	VTT	3.41 KB
1.1 49_CREATE INDEX.sql.sql	SQL	149 B
1.2 PostgreSQL Documentation on CREATE INDEX.html	HTML	117 B
2. DROP INDEX.mp4	MP4	13.72 MB
2. DROP INDEX.vtt	VTT	2.04 KB
2.1 PostgreSQL Documentation on DROP INDEX.html	HTML	115 B
2.2 50_DROP INDEX.sql.sql	SQL	80 B
3. Using Explain To See Query Plan.mp4	MP4	62.09 MB
3. Using Explain To See Query Plan.vtt	VTT	8.21 KB
3.1 136_Using Explain To See Performance of Queries.sql.sql	SQL	873 B
3.2 PostgreSQL Documentation on Using Explain.html	HTML	115 B
4. Use Analyze To Update Table Statistics.mp4	MP4	25 MB
4. Use Analyze To Update Table Statistics.vtt	VTT	3.43 KB
4.1 137_Use Analyze To Update Table Statistics.sql.sql	SQL	444 B
4.2 PostgreSQL Documentation on ANALYZE.html	HTML	117 B
4.3 PostgreSQL Documentation on Explain.html	HTML	113 B
5. How Is Query Plan Cost Calculated.mp4	MP4	86.25 MB
5. How Is Query Plan Cost Calculated.vtt	VTT	12.31 KB
5.1 138_How is query plan cost calculated.sql.sql	SQL	1.37 KB
6. Using Indexes On More Than One Field.mp4	MP4	42.61 MB
6. Using Indexes On More Than One Field.vtt	VTT	5.52 KB
6.1 139_Using Indexes On More Than One Field.sql.sql	SQL	617 B
7. Expression Indexes.mp4	MP4	42.25 MB
7. Expression Indexes.vtt	VTT	6 KB
7.1 PostgreSQL Documentation on Indexes On Expressions.html	HTML	126 B
7.2 142_ Expression indexes.sql.sql	SQL	1.31 KB
8. Types Of Indexes.mp4	MP4	13.3 MB
8. Types Of Indexes.vtt	VTT	5.65 KB
8.1 PostgreSQL Documentation on Index Types.html	HTML	119 B
9. Speeding Up Text Matching.mp4	MP4	33.96 MB
9. Speeding Up Text Matching.vtt	VTT	4.42 KB
9.1 PostgreSQL Documentation on pg_trm.html	HTML	112 B
9.2 141_Speeding Up Text Matching.sql.sql	SQL	627 B

13. Database Design and Normalization

1. Design Process Overview.mp4	MP4	22.92 MB
1. Design Process Overview.vtt	VTT	9.09 KB
2. Database Terminology.mp4	MP4	23.7 MB
2. Database Terminology.vtt	VTT	9.54 KB
2.1 Wikipedia Article On OLTP.html	HTML	120 B
2.10 Wikipedia Article On Foreign Keys.html	HTML	102 B
2.11 Wikipedia Article On Referential Integrity.html	HTML	112 B
2.12 Wikipedia Article On Relations.html	HTML	110 B
2.2 Wikipedia Article On OLAP.html	HTML	119 B
2.3 Wikipedia Article On Tuples.html	HTML	105 B
2.4 Wikipedia Article On Relational Database.html	HTML	110 B
2.5 Wikipedia Article On Attribute.html	HTML	108 B
2.6 Wikipedia Article On Views.html	HTML	101 B
2.7 Wikipedia Article On Primary Keys.html	HTML	102 B
2.8 Wikipedia Article On Data Integrity.html	HTML	105 B
2.9 Wikipedia Article On Entity Integrity.html	HTML	107 B
3. A Design Process.mp4	MP4	16.31 MB
3. A Design Process.vtt	VTT	6.61 KB
4. Finding Mission Statement And Ojectives.mp4	MP4	26.39 MB
4. Finding Mission Statement And Ojectives.vtt	VTT	4.56 KB
5. Analyzing Current Systems.mp4	MP4	33.28 MB
5. Analyzing Current Systems.vtt	VTT	4.57 KB
6. Create Table Structure.mp4	MP4	49.23 MB
7. Establishing Keys.mp4	MP4	34.55 MB
8. Specifying Fields.mp4	MP4	35.43 MB
8.1 Anatomy of a Field Specification.html	HTML	212 B
9. Relationships Between Tables.mp4	MP4	48.87 MB

14. Creating and Modifying Tables

1. CREATE TABLE.mp4	MP4	73.68 MB
1. CREATE TABLE.vtt	VTT	9.75 KB
1.1 PostgreSQL Documentation on Table Basics.html	HTML	116 B
1.2 PostgreSQL Documentation on CREATE TABLE.html	HTML	121 B
1.3 45_CREATE_TABLE.sql.sql	SQL	307 B
2. ALTER TABLE - Part One.mp4	MP4	25.41 MB
2. ALTER TABLE - Part One.vtt	VTT	3.42 KB
2.1 PostgreSQL Documentation on Renaming a Table.html	HTML	129 B
2.2 PostgreSQL Documentation on Renaming a Column.html	HTML	129 B
2.3 46_ALTER TABLE Part One.sql.sql	SQL	208 B
3. ALTER TABLE - Part Two.mp4	MP4	35.99 MB
3. ALTER TABLE - Part Two.vtt	VTT	4.31 KB
3.1 PostgreSQL Documentation on Removing a Column.html	HTML	143 B
3.2 PostgreSQL Documentation on Adding a Column.html	HTML	141 B
3.3 47_ALTER TABLE Part 2.sql.sql	SQL	221 B
4. ALTER TABLE - Part Three.mp4	MP4	20.86 MB
4. ALTER TABLE - Part Three.vtt	VTT	2.8 KB
4.1 48_ALTER TABLE Part 3.sql.sql	SQL	142 B
4.2 PostgreSQL Documentation on Changing a Column's Data Type.html	HTML	129 B
5. DROP TABLE.mp4	MP4	11.44 MB
5. DROP TABLE.vtt	VTT	1.71 KB
5.1 PostgreSQL Documentation on DROP TABLE.html	HTML	115 B
5.2 51_DROP TABLE.sql.sql	SQL	54 B

15. Table Constraints

1. NOT NULL Constraint.mp4	MP4	12.58 MB
1. NOT NULL Constraint.vtt	VTT	5.83 KB
1.1 PostgreSQL Documentation on Not-Null Constraint.html	HTML	134 B
1.2 52_NOT NULL Constraint.sql.sql	SQL	381 B
2. UNIQUE Constraint.mp4	MP4	11.46 MB
2. UNIQUE Constraint.vtt	VTT	3.49 KB
2.1 53_UNIQUE Constraint.sql.sql	SQL	522 B
3. PRIMARY KEY Constraint.mp4	MP4	16.58 MB
3. PRIMARY KEY Constraint.vtt	VTT	5.3 KB
3.1 PostgreSQL Documentation on Unique Constraints.html	HTML	156 B
3.2 54_PRIMARY KEY Constraint.sql.sql	SQL	625 B
4. FOREIGN KEY Constraint.mp4	MP4	19.2 MB
4. FOREIGN KEY Constraint.vtt	VTT	5.91 KB
4.1 55_FOREIGN KEY Constraint.sql.sql	SQL	772 B
4.2 PostgreSQL Documentation on Foreign Keys.html	HTML	140 B
5. CHECK Constraint.mp4	MP4	16.29 MB
5. CHECK Constraint.vtt	VTT	5.01 KB
5.1 54_CHECK Constraint.sql.sql	SQL	719 B
5.2 PostgreSQL Documentation on Check Constraints.html	HTML	155 B
6. DEFAULT Values.mp4	MP4	8.58 MB
6. DEFAULT Values.vtt	VTT	2.72 KB
6.1 57_Default constraint.sql.sql	SQL	709 B
6.2 PostgreSQL Documentation on Default Values.html	HTML	117 B
7. Changing a Column's Default Value.mp4	MP4	22.82 MB
7. Changing a Column's Default Value.vtt	VTT	3.07 KB
7.1 81_Changing_Column_Default_Value.sql.sql	SQL	243 B
7.2 PostgreSQL Documentation on Changing a Column's Default Value.html	HTML	128 B
8. Adding and Removing a Column's Constraint.mp4	MP4	63.79 MB
8. Adding and Removing a Column's Constraint.vtt	VTT	9.68 KB
8.1 PostgreSQL Documentation on Adding and Removing Constraints.html	HTML	145 B
8.2 84_Adding and removing column constraints.sql.sql	SQL	621 B
ReadMe.txt	TXT	538 B
Visit Coursedrive.org.url	URL	124 B

16. Sequences

1. Create A Sequence.mp4	MP4	100.39 MB
1. Create A Sequence.vtt	VTT	12.39 KB
1.1 PostgreSQL Documentation On CREATE SEQUENCE.html	HTML	120 B
1.2 76_Create a Sequence.sql.sql	SQL	1.49 KB
1.3 PostgreSQL Documentation On sequence manipulation functions.html	HTML	124 B
2. Alter and Delete Sequences.mp4	MP4	33.66 MB
2. Alter and Delete Sequences.vtt	VTT	4.29 KB
2.1 PostgreSQL Documentation on ALTER SEQUENCE.html	HTML	119 B
2.2 76_Alter and delete squences.sql.sql	SQL	372 B
2.3 PostgreSQL Documentation on DROP SEQUENCE.html	HTML	118 B
3. Using Serial Datatypes.mp4	MP4	21.34 MB
3. Using Serial Datatypes.vtt	VTT	3.5 KB
3.1 PostgreSQL Documentation on SERIAL datatypes.html	HTML	138 B
3.2 78_Using Serial Datatypes.sql.sql	SQL	283 B

17. CTE - Common Table Expressions

1. WITH Queries.mp4	MP4	68.8 MB
1. WITH Queries.vtt	VTT	6.88 KB
1.1 PostgreSQL Documentation on WITH Queries.html	HTML	138 B
1.2 74_With Queries.sql.sql	SQL	907 B
2. Creating Hierarchical Data To Use For Recursive WITH Queries.mp4	MP4	10.88 MB
2. Creating Hierarchical Data To Use For Recursive WITH Queries.vtt	VTT	1.15 KB
2.1 78_AddEmployees.sql.sql	SQL	3.07 KB
3. Using Recursion in CTEs.mp4	MP4	82.62 MB
3. Using Recursion in CTEs.vtt	VTT	9.66 KB
3.1 79_Using Recursions.sql.sql	SQL	1.04 KB
3.2 PostgreSQL Documentation on WITH RECURSIVE.html	HTML	138 B

18. Views

1. Views - How To Create.mp4	MP4	68.44 MB
1. Views - How To Create.vtt	VTT	8.3 KB
1.1 PostgreSQL Documentation on CREATE VIEW.html	HTML	120 B
1.2 64_Views how to create.sql.sql	SQL	845 B
2. Views - How To Modify.mp4	MP4	35.31 MB
2. Views - How To Modify.vtt	VTT	4.43 KB
2.1 65_Views how to modify.sql.sql	SQL	858 B
2.2 PostgreSQL Documentation on ALTER VIEW.html	HTML	119 B
3. Creating Updatable Views.mp4	MP4	49.62 MB
3. Creating Updatable Views.vtt	VTT	6.19 KB
3.1 67_CreatingUpdateableViews.sql.sql	SQL	840 B
4. With Check Option.mp4	MP4	37.63 MB
4. With Check Option.vtt	VTT	5.02 KB
4.1 68_WithCheckOption.sql.sql	SQL	1001 B
5. Deleting Views.mp4	MP4	8.24 MB
5. Deleting Views.vtt	VTT	1.64 KB
5.1 PostgreSQL Documentation on DROP VIEW.html	HTML	118 B
5.2 66_DeletingViews.sql.sql	SQL	83 B

19. Conditional Expressions

1. CASE WHEN.mp4	MP4	71.48 MB
1. CASE WHEN.vtt	VTT	9.11 KB
1.1 PostgreSQL Documentation on CASE WHEN.html	HTML	142 B
1.2 61_CaseWhen.sql.sql	SQL	970 B
2. COALESCE.mp4	MP4	12.36 MB
2. COALESCE.vtt	VTT	2.23 KB
2.1 PostgreSQL Documentation on COALESCE.html	HTML	157 B
2.2 62_Coalesce.sql.sql	SQL	128 B
3. NULLIF.mp4	MP4	26.38 MB
3. NULLIF.vtt	VTT	4.02 KB
3.1 PostgreSQL Documentation on NULLIF.html	HTML	144 B
3.2 63_NULLIF.sql.sql	SQL	281 B

2. Installing PostgreSQL and pgAdmin

1. Installing PostgreSQL on Mac and Windows.mp4	MP4	41.86 MB
1. Installing PostgreSQL on Mac and Windows.vtt	VTT	2.99 KB
2. Installing PostgreSQL on Ubuntu.mp4	MP4	103.47 MB
2. Installing PostgreSQL on Ubuntu.vtt	VTT	7.32 KB
2.1 135_Installing Postgres on Ubuntu.txt.txt	TXT	752 B
3. Install Northwind Database.mp4	MP4	41.84 MB
3. Install Northwind Database.vtt	VTT	4.04 KB
3.1 northwind.sql.sql	SQL	193.29 KB
3.2 northwind.tar.tar	TAR	64.64 KB
4. Install some additional databases..html	HTML	578 B
4.1 usda.tar.tar	TAR	19.17 MB
4.2 AdventureWorks.tar.tar	TAR	85.8 MB
4.3 pagila.tar.tar	TAR	2.82 MB

20. Using DateTime In PostgreSQL

1. Date, Time, and Timestamp Data Types.mp4	MP4	68.82 MB
1. Date, Time, and Timestamp Data Types.vtt	VTT	12.68 KB
1.1 PostgreSQL Documentation on DateTime Input and Output.html	HTML	147 B
1.2 83_Date Time Input and Output.sql.sql	SQL	415 B
2. Time Zones.mp4	MP4	57.77 MB
2. Time Zones.vtt	VTT	8.05 KB
2.1 PostgreSQL Documentation on Time Zones.html	HTML	137 B
2.2 84_Time Zones.sql.sql	SQL	638 B
3. Interval Data Type.mp4	MP4	56.85 MB
3. Interval Data Type.vtt	VTT	9.25 KB
3.1 PostgreSQL Documentation on Interval Data Type.html	HTML	142 B
3.2 87_Interval Data Type.sql.sql	SQL	780 B
4. Date Arithmetic.mp4	MP4	80.42 MB
4. Date Arithmetic.vtt	VTT	10.61 KB
4.1 PostgreSQL Documentation on DateTime Functions.html	HTML	119 B
4.2 88_Date Arithmetic.sql.sql	SQL	1.12 KB
5. Pulling Out Parts of Dates and Times.mp4	MP4	23.04 MB
5. Pulling Out Parts of Dates and Times.vtt	VTT	3.26 KB
5.1 PostgreSQL Documentation on EXTRACT, date_part.html	HTML	146 B
5.2 100_Pulling Out Parts of Dates and Times.sql.sql	SQL	287 B
6. Converting One Data Type Into Another.mp4	MP4	21.06 MB
6. Converting One Data Type Into Another.vtt	VTT	2.84 KB
6.1 PostgreSQL Documentation on Type Casts.html	HTML	138 B
6.2 101_Converting One Data Type Into Another.sql.sql	SQL	224 B
ReadMe.txt	TXT	538 B
Visit Coursedrive.org.url	URL	124 B

21. Window Functions

1. Basic Window Function Example.mp4	MP4	66.34 MB
1. Basic Window Function Example.vtt	VTT	7.23 KB
1.1 59_Basic Window Examples.sql.sql	SQL	554 B
2. Using Window Functions With Subqueries.mp4	MP4	89.85 MB
2. Using Window Functions With Subqueries.vtt	VTT	11.95 KB
2.1 60_Using Window Functions With Subqueries.sql.sql	SQL	1.08 KB
3. Using Rank() To Find The First N Records In Join.mp4	MP4	55.74 MB
3. Using Rank() To Find The First N Records In Join.vtt	VTT	6.38 KB
3.1 125_Using Rank to find first N records.sql.sql	SQL	497 B

22. Composite Types

1. Composite Type Basics.mp4	MP4	50.53 MB
1. Composite Type Basics.vtt	VTT	7.45 KB
1.1 PostgreSQL Documentation on Declaration of Composite Type.html	HTML	128 B
1.2 PostgreSQL Documentation on DROP TYPE.html	HTML	118 B
1.3 89_Composite Type Basics.sql.sql	SQL	758 B
2. Using Composite Types.mp4	MP4	54.2 MB
2. Using Composite Types.vtt	VTT	8.21 KB
2.1 PostgreSQL Documentation on Accessing Composite Types.html	HTML	128 B
2.2 PostgreSQL Documentation on Modifying Composite Types.html	HTML	123 B
2.3 PostgreSQL Documentation on Constructing Composite Types.html	HTML	123 B
2.4 90_Using Composite Types.sql.sql	SQL	938 B

23. SQL Functions and Procedures

1. Write Your First Function.mp4	MP4	37.91 MB
1. Write Your First Function.vtt	VTT	6.41 KB
1.1 91_Write Your First Function.sql.sql	SQL	395 B
10. Procedures - Functions That Don't Return Anything.mp4	MP4	26.09 MB
10. Procedures - Functions That Don't Return Anything.vtt	VTT	4.44 KB
10.1 PostgreSQL Documentation on CREATE PROCEDURE.html	HTML	125 B
10.2 PostgreSQL Documentation on User-defined Procedures.html	HTML	106 B
10.3 102_Procedures.sql.sql	SQL	341 B
2. Write A Function That Returns A Single Value.mp4	MP4	26.65 MB
2. Write A Function That Returns A Single Value.vtt	VTT	4.43 KB
2.1 92_Write a function that returns a single value.sql.sql	SQL	381 B
3. Functions With Parameters.mp4	MP4	63.78 MB
3. Functions With Parameters.vtt	VTT	7.95 KB
3.1 93_Functions with parameters.sql.sql	SQL	759 B
4. Functions That Have Composite Parameters.mp4	MP4	41 MB
4. Functions That Have Composite Parameters.vtt	VTT	6.38 KB
4.1 94_Functions that have composite parameters.sql.sql	SQL	449 B
4.2 PostgreSQL Documentation on SQL Functions On Composite Types.html	HTML	140 B
5. Functions That Return A Composite.mp4	MP4	40.13 MB
5. Functions That Return A Composite.vtt	VTT	5.38 KB
5.1 PostgreSQL Documentation on SQL Functions On Composite Types.html	HTML	140 B
5.2 95_Functions That Return A Composite.sql.sql	SQL	480 B
6. Functions With Output Parameters.mp4	MP4	26.63 MB
6. Functions With Output Parameters.vtt	VTT	4.35 KB
6.1 96_Functions With Output Parameters.sql.sql	SQL	351 B
6.2 PostgreSQL Documentation on SQL Functions with Output Parameters.html	HTML	134 B
7. Functions With Default Values.mp4	MP4	29.21 MB
7. Functions With Default Values.vtt	VTT	3.81 KB
7.1 97_Functions With Default Values.sql.sql	SQL	409 B
7.2 PostgreSQL Documentation on SQL Functions with Default Values For Arguments.html	HTML	139 B
8. Using Functions as Table Source.mp4	MP4	14.69 MB
8. Using Functions as Table Source.vtt	VTT	2.38 KB
8.1 PostgreSQL Documentation on SQL Functions as Table Sources.html	HTML	136 B
8.2 98_Using Functions as Table Source.sql.sql	SQL	172 B
9. Functions That Return More Than One Row.mp4	MP4	115.67 MB
9. Functions That Return More Than One Row.vtt	VTT	13.59 KB
9.1 PostgreSQL Documentation on SQL Functions Returning Sets.html	HTML	144 B
9.2 99_Functions that return more than one row.sql.sql	SQL	693 B

24. Transactions And Concurrency Control

1. ACID Transactions.mp4	MP4	7.15 MB
1. ACID Transactions.vtt	VTT	3.39 KB
2. Simple Transaction Control.mp4	MP4	31.9 MB
2. Simple Transaction Control.vtt	VTT	4.58 KB
2.1 104_Simple Transaction Control.sql.sql	SQL	462 B
2.2 PostgreSQL Documentation on Transactions.html	HTML	122 B
2.3 PostgreSQL Documentation on BEGIN.html	HTML	115 B
2.4 PostgreSQL Documentation on START TRANSACTION.html	HTML	127 B
2.5 PostgreSQL Documentation on COMMIT.html	HTML	116 B
2.6 PostgreSQL Documentation on END TRANSACTION.html	HTML	113 B
3. Rollbacks & Savepoints.mp4	MP4	39.25 MB
3. Rollbacks & Savepoints.vtt	VTT	5.66 KB
3.1 PostgreSQL Documentation on ROLLBACK.html	HTML	118 B
3.2 105_Rollbacks savepoints.sql.sql	SQL	501 B
3.3 PostgreSQL Documentation on SAVEPOINT.html	HTML	119 B
3.4 PostgreSQL Documentation on ROLLBACK TO SAVEPOINT.html	HTML	121 B
4. SQL Transaction Isolation.mp4	MP4	10.85 MB
4. SQL Transaction Isolation.vtt	VTT	4.8 KB
4.1 Wikipedia article on database isolation.html	HTML	133 B
5. PostgreSQL Transaction Isolation.mp4	MP4	12.35 MB
5. PostgreSQL Transaction Isolation.vtt	VTT	4.05 KB
5.1 PostgreSQL Documentation on Transaction Isolation.html	HTML	116 B
5.2 PostgreSQL Documentation on SET TRANSACTION.html	HTML	120 B
5.3 PostgreSQL Documentation on START TRANSACTION.html	HTML	127 B
5.4 Wikipedia article on MVCC - multiversion concurrency control.html	HTML	123 B
ReadMe.txt	TXT	538 B
Visit Coursedrive.org.url	URL	124 B

25. Array Data Type

1. Declaring Arrays.mp4	MP4	21.07 MB
1. Declaring Arrays.vtt	VTT	3.99 KB
1.1 108_Declaring Arrays.sql.sql	SQL	306 B
1.2 PostgreSQL Documentation on Declaration of Array Types.html	HTML	126 B
2. Inputting Array Values.mp4	MP4	31.71 MB
2. Inputting Array Values.vtt	VTT	4.15 KB
2.1 PostgreSQL Documentation on Array Value Input.html	HTML	120 B
2.2 109_Inputting Array Values.sql.sql	SQL	774 B
3. Accessing Arrays.mp4	MP4	19.85 MB
3. Accessing Arrays.vtt	VTT	3.84 KB
3.1 PostgreSQL Documentation on Accessing Arrays.html	HTML	124 B
3.2 110_Accessing Arrays.sql.sql	SQL	217 B
4. Modifying Arrays.mp4	MP4	36.63 MB
4. Modifying Arrays.vtt	VTT	5.22 KB
4.1 PostgreSQL Documentation on Modifying Arrays.html	HTML	124 B
4.2 111_Modifying Arrays.sql.sql	SQL	920 B
5. Searching Arrays.mp4	MP4	18.68 MB
5. Searching Arrays.vtt	VTT	3.14 KB
5.1 PostgreSQL Documentation on Searching In Arrays.html	HTML	129 B
5.2 112_Searching Arrays.sql.sql	SQL	246 B
6. Array Operators.mp4	MP4	40.05 MB
6. Array Operators.vtt	VTT	6.37 KB
6.1 PostgreSQL Documentation on Array Operators.html	HTML	121 B
6.2 113_Array Operators.sql.sql	SQL	775 B

26. PLpgSQL - SQL Procedural Language

1. Build Your First PLpgSQL Function.mp4	MP4	36.68 MB
1. Build Your First PLpgSQL Function.vtt	VTT	6.16 KB
1.1 PostgreSQL Documentation on Stucture of PLpgSQL.html	HTML	118 B
1.2 PostgreSQL Documentation on Returning From a Function.html	HTML	156 B
1.3 114_Build first pgpsql function.sql.sql	SQL	464 B
2. Handling Functions With Output Variables.mp4	MP4	30.36 MB
2. Handling Functions With Output Variables.vtt	VTT	4.35 KB
2.1 115_Handling functions with output variables.sql.sql	SQL	425 B
2.2 PostgreSQL Documentation on Assignment.html	HTML	149 B
3. Returning Query Results.mp4	MP4	46.85 MB
3. Returning Query Results.vtt	VTT	4.6 KB
3.1 116_Returning Query Results.sql.sql	SQL	754 B
3.2 PostgreSQL Documentation on Returning From a Function.html	HTML	156 B
4. Declaring Variables.mp4	MP4	96.74 MB
4. Declaring Variables.vtt	VTT	9.62 KB
4.1 PostgreSQL Documentation on Declarations.html	HTML	121 B
4.2 117_Declaring variables.sql.sql	SQL	1.21 KB
5. Looping Through Query Results.mp4	MP4	92.24 MB
5. Looping Through Query Results.vtt	VTT	13.1 KB
5.1 119_Looping Through Query results.sql.sql	SQL	1.43 KB
5.2 PostgreSQL Documentation on Looping Through Query Results.html	HTML	158 B
6. Using If-Then Statements.mp4	MP4	60.49 MB
6. Using If-Then Statements.vtt	VTT	7.58 KB
6.1 PostgreSQL Documentation on Conditionals.html	HTML	153 B
6.2 120_Using If-then statements.sql.sql	SQL	776 B
7. Returning Query Results Continued.mp4	MP4	80.45 MB
7. Returning Query Results Continued.vtt	VTT	9.49 KB
7.1 121_Returning Query Results Continued.cmproj.zip.zip	ZIP	42.39 MB
7.2 PostgreSQL Documentation on RETURN NEXT and RETURN QUERY.html	HTML	161 B
8. Loop and While Loops.mp4	MP4	36.26 MB
8. Loop and While Loops.vtt	VTT	6.31 KB
8.1 123_Loop and while loop.sql.sql	SQL	701 B
8.2 PostgreSQL Documentation on Simple Loops.html	HTML	165 B
9. Looping Over Array Elements.mp4	MP4	73.46 MB
9. Looping Over Array Elements.vtt	VTT	9.69 KB
9.1 PostgreSQL Documentation on Looping Through Arrays.html	HTML	154 B
9.2 126_Looping Over Array Elements.sql.sql	SQL	1.02 KB

27. Triggers

1. Build Your First Trigger.mp4	MP4	64.45 MB
1. Build Your First Trigger.vtt	VTT	10.54 KB
1.1 PostgreSQL Documentation on Trigger Functions.html	HTML	116 B
1.2 118_Building Your First Trigger.sql.sql	SQL	1.12 KB
2. Statement Triggers.mp4	MP4	160.73 MB
2. Statement Triggers.vtt	VTT	18.47 KB
2.1 122_Statement_triggers.sql.sql	SQL	3.34 KB

28. Using psql To Connect To Postgres

1. Connecting With psql.mp4	MP4	17.54 MB
1. Connecting With psql.vtt	VTT	3.79 KB
1.1 127_Connecting With psql.sql.sql	SQL	176 B
1.2 PostgreSQL Documentation on psql.html	HTML	109 B
2. Eliminate Typing Connection Parameters.mp4	MP4	28.22 MB
2. Eliminate Typing Connection Parameters.vtt	VTT	6.17 KB
2.1 149_Eliminate Typing Connection Parameters.txt.txt	TXT	318 B
2.2 PostgreSQL Documentation on Environment Variables.html	HTML	118 B
2.3 PostgreSQL Documentation on The Password File.html	HTML	113 B
2.4 PostgreSQL Documentation on the Service File.html	HTML	117 B

29. Importing CSV

1. Import CSV File.mp4	MP4	87.97 MB
1. Import CSV File.vtt	VTT	10.61 KB
1.1 128_Import CSV files.sql.sql	SQL	1.43 KB
1.2 PostgreSQL Documentation on COPY.html	HTML	114 B
1.3 Our Airports link to get the CSV files..html	HTML	89 B
2. Practice What You've Learned.html	HTML	564 B
2.1 03_Importing CSV.sql.sql	SQL	2.27 KB

3. Simple Selection of All Records

1. Selecting All Data From a Table.mp4	MP4	24.78 MB
1. Selecting All Data From a Table.vtt	VTT	3.96 KB
1.1 04_Selecting All Data From a Table.sql.sql	SQL	51 B
2. Selecting Specific Fields.mp4	MP4	18.9 MB
2. Selecting Specific Fields.mp4.jpg	JPG	72.87 KB
2. Selecting Specific Fields.txt	TXT	246 B
2. Selecting Specific Fields.vtt	VTT	2.45 KB
2.1 05_Selecting Specific Fields.sql.sql	SQL	101 B
3. Selecting Distinct Values.mp4	MP4	18.62 MB
3. Selecting Distinct Values.vtt	VTT	2.6 KB
3.1 06_Selecting Distinct Values.sql.sql	SQL	127 B
4. Counting Results.mp4	MP4	16.23 MB
4. Counting Results.vtt	VTT	2.81 KB
4.1 07_Counting Results.sql.sql	SQL	162 B
5. Combining Fields in SELECT.mp4	MP4	15.36 MB
5. Combining Fields in SELECT.vtt	VTT	1.94 KB
5.1 08_Combining fields in SELECT.sql.sql	SQL	111 B
6. Practice What You've Learned.html	HTML	1.28 KB
6.1 01_Simple Selection of all records.sql.sql	SQL	522 B

30. JSON and JSONB Data Types

1. What Is JSON And How To Store In Database.mp4	MP4	43.86 MB
1. What Is JSON And How To Store In Database.vtt	VTT	6.32 KB
1.1 PostgreSQL Documentation on JSON Types.html	HTML	119 B
1.2 128_What is JSON and how to store.sql.sql	SQL	762 B
2. Create JSON From Tables.mp4	MP4	91.06 MB
2. Create JSON From Tables.vtt	VTT	10.17 KB
2.1 129_Create JSON from tables.sql.sql	SQL	3.1 KB
3. Aggregating JSON Fields.mp4	MP4	52.91 MB
3. Aggregating JSON Fields.vtt	VTT	5.64 KB
3.1 130_Aggregating JSON fields.sql.sql	SQL	1.05 KB
4. Building airports_json Table.mp4	MP4	74.99 MB
4. Building airports_json Table.vtt	VTT	8.16 KB
5. Selecting Information Out of JSON Fields.mp4	MP4	36.05 MB
5. Selecting Information Out of JSON Fields.vtt	VTT	6 KB
5.1 133_Selecting Information Out of JSON fields.sql.sql	SQL	402 B
6. Searching JSON Data.mp4	MP4	37.42 MB
6. Searching JSON Data.vtt	VTT	5.52 KB
6.1 132_Searching JSON data.sql.sql	SQL	492 B
7. Updating And Deleting Information Inside JSON Fields.mp4	MP4	66.5 MB
7. Updating And Deleting Information Inside JSON Fields.vtt	VTT	8.85 KB
7.1 134_Updating and deleting information inside JSON fields.sql.sql	SQL	2.02 KB
ReadMe.txt	TXT	538 B
Visit Coursedrive.org.url	URL	124 B

31. Managing Databases

1. CREATE DATABASE.mp4	MP4	16.33 MB
1. CREATE DATABASE.vtt	VTT	2.8 KB
1.1 PostgreSQL Documentation on CREATE DATABASE.html	HTML	124 B
1.2 43_CREATE DATABASE.sql.sql	SQL	96 B
1.3 PostgreSQL Documentation on createdb.html	HTML	118 B
2. DROP DATABASE.mp4	MP4	17.01 MB
2. DROP DATABASE.mp4.jpg	JPG	68.42 KB
2. DROP DATABASE.txt	TXT	233 B
2. DROP DATABASE.vtt	VTT	2.99 KB
2.1 PostgreSQL Documentation on DROP DATABASE.html	HTML	118 B
2.2 PostgreSQL Documentation on dropdb.html	HTML	116 B
2.3 44_DROP DATABASE.sql.sql	SQL	107 B

32. Backups and Recovery

1. Basic ImportExport With Copy.mp4	MP4	28.07 MB
1. Basic ImportExport With Copy.vtt	VTT	8.2 KB
1.1 146_Basic import export with copy.txt.txt	TXT	562 B
1.2 PostgreSQL Documentation on COPY.html	HTML	114 B
2. Basic pg_dump And Restore.mp4	MP4	20.21 MB
2. Basic pg_dump And Restore.vtt	VTT	3.89 KB
2.1 PostgreSQL Documentation on pg_dump.html	HTML	116 B
2.2 147_Basic pg_dump and restore.txt.txt	TXT	375 B
3. Custom Format Dumps.mp4	MP4	34.43 MB
3. Custom Format Dumps.vtt	VTT	6.46 KB
3.1 PostgreSQL Documentation on pg_restore.html	HTML	119 B
3.2 148_Custom Format Dumps.txt.txt	TXT	408 B

33. Introduction To PostGIS

1. Install PostGIS on Ubuntu (Not needed for WindowsMac).mp4	MP4	13.02 MB
1. Install PostGIS on Ubuntu (Not needed for WindowsMac).vtt	VTT	1.21 KB
1.1 143_Install PostGIS on Ubuntu.txt.txt	TXT	48 B
2. Converting Airport Data.mp4	MP4	64.75 MB
2. Converting Airport Data.vtt	VTT	8.75 KB
2.1 144_Converting Airport Data.sql.sql	SQL	1.13 KB
2.2 PostGIS Documentation on ST_SetSRID.html	HTML	101 B
2.3 PostGIS Documentation on AddGeometryColumn.html	HTML	108 B
2.4 PostGIS Documentation on ST_MakePoint.html	HTML	103 B
3. Your First Geographical Query.mp4	MP4	64.66 MB
3. Your First Geographical Query.vtt	VTT	8.16 KB
3.1 145_Your First Geographical Query.sql.sql	SQL	560 B
3.2 PostGIS Documentation on ST_DWithin.html	HTML	101 B

34. Thanks and Good Luck

1. Thank You.mp4	MP4	734.98 KB
1. Thank You.vtt	VTT	606 B
ReadMe.txt	TXT	538 B
Visit Coursedrive.org.url	URL	124 B

4. Using WHERE to Select Records

1. WHERE Selection for Text Fields.mp4	MP4	16.89 MB
1. WHERE Selection for Text Fields.vtt	VTT	2.6 KB
1.1 09_Where with text fields.sql.sql	SQL	126 B
10. Practice What You've Learned.html	HTML	1.99 KB
10.1 02_Using where to select records.sql.sql	SQL	1.14 KB
2. WHERE Selection for Numeric Fields.mp4	MP4	7.31 MB
2. WHERE Selection for Numeric Fields.vtt	VTT	2.47 KB
2.1 10_Where with Numeric Fields.sql.sql	SQL	152 B
3. WHERE with Date Fields.mp4	MP4	10.45 MB
3. WHERE with Date Fields.vtt	VTT	1.58 KB
3.1 11_WHERE with Date fields.sql.sql	SQL	124 B
4. WHERE Using Logical AND Operator.mp4	MP4	7.79 MB
4. WHERE Using Logical AND Operator.vtt	VTT	2.74 KB
5. WHERE Using Logical OR Operator.mp4	MP4	8.62 MB
5. WHERE Using Logical OR Operator.vtt	VTT	2.71 KB
5.1 13_WHERE using OR.sql.sql	SQL	253 B
6. WHERE Using Logical NOT Operator.mp4	MP4	4.07 MB
6. WHERE Using Logical NOT Operator.vtt	VTT	1.42 KB
6.1 14_WHERE Using NOT.sql.sql	SQL	116 B
7. WHERE Combining AND, OR, and NOT.mp4	MP4	6.3 MB
7. WHERE Combining AND, OR, and NOT.vtt	VTT	2.53 KB
7.1 15_WHERE Combining AND OR NOT.sql.sql	SQL	202 B
8. Using BETWEEN.mp4	MP4	5.62 MB
8. Using BETWEEN.vtt	VTT	1.58 KB
8.1 16_Using BETWEEN.sql.sql	SQL	156 B
9. Using IN.mp4	MP4	9.58 MB
9. Using IN.vtt	VTT	1.77 KB
9.1 16_Using BETWEEN.sql.sql	SQL	156 B

5. Schemas

1. Schema Basics.mp4	MP4	23.83 MB
1. Schema Basics.vtt	VTT	3.61 KB
1.1 124_Schema basics.sql.sql	SQL	173 B
ReadMe.txt	TXT	538 B
Visit Coursedrive.org.url	URL	124 B

6. Intermediate SELECT Statements

1. ORDER BY.mp4	MP4	10.17 MB
1. ORDER BY.vtt	VTT	3.33 KB
1.1 PostgreSQL Documentation on Sorting Rows.html	HTML	119 B
1.2 18_ORDER BY.sql.sql	SQL	330 B
2. Using MIN and MAX Functions.mp4	MP4	6.42 MB
2. Using MIN and MAX Functions.vtt	VTT	2.42 KB
2.1 19_Using MIN and MAX.sql.sql	SQL	201 B
3. Using AVG and SUM.mp4	MP4	6.66 MB
3. Using AVG and SUM.vtt	VTT	2.13 KB
3.1 20_Using AVG and SUM.sql.sql	SQL	182 B
4. LIKE to Match Patterns.mp4	MP4	10.85 MB
4. LIKE to Match Patterns.vtt	VTT	4.28 KB
4.1 21_LIKE to Match Patterns.sql.sql	SQL	206 B
4.2 PostgreSQL Documentation on LIKE.html	HTML	125 B
5. Renaming Columns With Alias.mp4	MP4	22.4 MB
5. Renaming Columns With Alias.vtt	VTT	3.46 KB
5.1 22_Renaming Column With Alias.sql.sql	SQL	358 B
6. LIMIT to Control Number of Records Returned.mp4	MP4	27.64 MB
6. LIMIT to Control Number of Records Returned.vtt	VTT	3.23 KB
6.1 23_LIMIT to Control.sql.sql	SQL	213 B
6.2 PostgreSQL Documentation on LIMIT.html	HTML	115 B
7. NULL Values.mp4	MP4	6.98 MB
7. NULL Values.vtt	VTT	2.42 KB
7.1 24_NULL Values.sql.sql	SQL	166 B
8. Practice What You've Learned.html	HTML	1.95 KB
8.1 04_Intermediate Select Statements.sql.sql	SQL	1.1 KB

7. Joining multiple tables together

1. Diagramming Table Relationships.mp4	MP4	6.59 MB
1. Diagramming Table Relationships.vtt	VTT	3.77 KB
1.1 01 Northwind_A4_size_for_Print.png.png	PNG	86.65 KB
10. Practice What You've Learned.html	HTML	1.73 KB
10.1 05_Joining multiple tables together.sql.sql	SQL	1.54 KB
2. Inner Join for Two Tables.mp4	MP4	50.31 MB
2. Inner Join for Two Tables.vtt	VTT	6.21 KB
2.1 26_Inner Join for two tables.sql.sql	SQL	335 B
3. Inner Join for Multiple Tables.mp4	MP4	60.09 MB
3. Inner Join for Multiple Tables.vtt	VTT	6.33 KB
3.1 27_Inner Joins for multiple tables.sql.sql	SQL	1.19 KB
4. Left Joins.mp4	MP4	33.91 MB
4. Left Joins.vtt	VTT	3.64 KB
4.1 28_Left Joins.sql.sql	SQL	479 B
5. Right Joins.mp4	MP4	9.82 MB
5. Right Joins.vtt	VTT	3.5 KB
5.1 29_Right Joins.sql.sql	SQL	388 B
6. Full Joins.mp4	MP4	7.11 MB
6. Full Joins.vtt	VTT	2.49 KB
6.1 30_Full Joins.sql.sql	SQL	218 B
7. Self Joins.mp4	MP4	22.04 MB
7. Self Joins.vtt	VTT	3.27 KB
7.1 31_Self Join.sql.sql	SQL	379 B
8. USING To Reduce Typing.mp4	MP4	10.15 MB
8. USING To Reduce Typing.vtt	VTT	1.61 KB
8.1 69_USING to reduce typing.sql.sql	SQL	148 B
9. Even Less Typing With NATURAL.mp4	MP4	27.65 MB
9. Even Less Typing With NATURAL.vtt	VTT	4.29 KB
9.1 PostgreSQL Documentation on Joins.html	HTML	144 B
9.2 70_Even less typing with NATURAL.sql.sql	SQL	350 B

8. Grouping and Aggregation Functions

1. Group By.mp4	MP4	23.9 MB
1. Group By.vtt	VTT	6.46 KB
1.1 PostgreSQL Documentation on GROUP BY.html	HTML	145 B
1.2 32_Group By.sql.sql	SQL	794 B
2. Use HAVING to Filter Groups.mp4	MP4	38.97 MB
2. Use HAVING to Filter Groups.vtt	VTT	4.27 KB
2.1 PostgreSQL Documentation on HAVING.html	HTML	145 B
2.2 32_HAVING to filter Groups.sql.sql	SQL	763 B
3. Grouping Sets.mp4	MP4	53.97 MB
3. Grouping Sets.vtt	VTT	6.92 KB
3.1 PostgreSQL Documentation on GROUPING SETS.html	HTML	153 B
3.2 73_Grouping Sets.sql.sql	SQL	857 B
4. Rollup.mp4	MP4	50.08 MB
4. Rollup.vtt	VTT	4.68 KB
4.1 74_Rollup.sql.sql	SQL	661 B
4.2 PostgreSQL Documentation on GROUPING SETS.html	HTML	153 B
5. Cube - Rollup On Steroids.mp4	MP4	66.62 MB
5. Cube - Rollup On Steroids.vtt	VTT	4.9 KB
5.1 PostgreSQL Documentation on CUBE.html	HTML	153 B
5.2 75_Cube Rollup on steroids.sql.sql	SQL	576 B

9. Combining Queries

1. Union.mp4	MP4	10.17 MB
1. Union.vtt	VTT	3.59 KB
1.1 PostgreSQL Documentation on UNION.html	HTML	119 B
1.2 34_UNION.sql.sql	SQL	323 B
2. Intersect.mp4	MP4	22.37 MB
2. Intersect.vtt	VTT	3.58 KB
2.1 71_Intersect.sql.sql	SQL	376 B
2.2 PostgreSQL Documentation on INTERSECTION.html	HTML	119 B
3. Except.mp4	MP4	19.91 MB
3. Except.vtt	VTT	3.21 KB
3.1 PostgreSQL Documentation on EXCEPT.html	HTML	119 B
3.2 72_Except.sql.sql	SQL	431 B

ReadMe.txt

TXT

538 B

Visit Coursedrive.org.url

URL

124 B

Visit Coursedrive.org.url

URL

124 B

Description

Show full description

Related Torrents

TORRENT NAME	SIZE	FILES	AGE	SEED	LEECH	SOURCE
Udemy - SQL Server Triggers Part7- Advance Level Posted by freecoursewb in Other Posted in Other 4 1.3 GB 2 months ago freecoursewb	Size 1.3 GB	Files 11	Age 2 months ago	Seeds 4	Leechs 3	Source
Udemy - SQL Query Training For SAP Business One Posted by freecoursewb in Other Posted in Other 2 1.6 GB 7 months ago freecoursewb	Size 1.6 GB	Files 159	Age 7 months ago	Seeds 2	Leechs 1	Source
Udemy - SQL Server: Performance Tuning e Analisi Piani di Esecuzione (Update 01 2024) [Ita] Posted by JackieALF in Other Posted in Other 0 3.5 GB 1 year ago JackieALF	Size 3.5 GB	Files 118	Age 1 year ago	Seeds 0	Leechs 41	Source
Udemy - Oracle Application Development and PL - SQL for beginners Posted by freecoursewb in Other Posted in Other 2 1.4 GB 1 year ago freecoursewb	Size 1.4 GB	Files 83	Age 1 year ago	Seeds 2	Leechs 0	Source
Udemy - Database Technology - SQL Essentials for Database Building Posted by freecoursewb in Other Posted in Other 2 3.5 GB 1 year ago freecoursewb	Size 3.5 GB	Files 57	Age 1 year ago	Seeds 2	Leechs 2	Source

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

Torrent Contents Size: 5.72 GB

Description

Related Torrents

Location

Trackers

Latest News

Latest Searches

Sites In Our Index

Popular Tags

Tracker name
udp://tracker.leechers-paradise.org:6969/announce
udp://tracker.internetwarriors.net:1337/announce
udp://tracker.opentrackr.org:1337/announce
udp://tracker.coppersurfer.tk:6969/announce
udp://tracker.pirateparty.gr:6969/announce
udp://9.rarbg.to:2730/announce
udp://9.rarbg.to:2710/announce
udp://bt.xxx-tracker.com:2710/announce
udp://tracker.cyberia.is:6969/announce
udp://retracker.lanta-net.ru:2710/announce
udp://9.rarbg.to:2770/announce
udp://9.rarbg.me:2730/announce
udp://eddie4.nl:6969/announce
udp://tracker.mg64.net:6969/announce
udp://open.demonii.si:1337/announce
udp://tracker.zer0day.to:1337/announce
udp://tracker.tiny-vps.com:6969/announce
udp://ipv6.tracker.harry.lu:80/announce
udp://9.rarbg.me:2740/announce
udp://9.rarbg.me:2770/announce
udp://denis.stalker.upeer.me:6969/announce
udp://tracker.port443.xyz:6969/announce
udp://tracker.moeking.me:6969/announce
udp://exodus.desync.com:6969/announce
udp://9.rarbg.to:2740/announce
udp://9.rarbg.to:2720/announce
udp://tracker.justseed.it:1337/announce
udp://tracker.torrent.eu.org:451/announce
udp://ipv4.tracker.harry.lu:80/announce
udp://tracker.open-internet.nl:6969/announce
udp://torrentclub.tech:6969/announce
udp://open.stealth.si:80/announce
http://tracker.tfile.co:80/announce