SQL Mastery From Zero to Superstar

/27. Triggers/

2. Statement Triggers.mp4

1. Build Your First Trigger.mp4

1. Build Your First Trigger.vtt

1.1 PostgreSQL Documentation on Trigger Functions.html

1.2 118_Building Your First Trigger.sql.sql

2. Statement Triggers.vtt

2.1 122_Statement_triggers.sql.sql

/

Visit Coursedrive.org.url

Course Downloaded from coursedrive.org.txt

/SQL Mastery From Zero to Superstar/

ReadMe.txt

Visit Coursedrive.org.url

/1. Introduction/

1. Introduction.mp4

1. Introduction.vtt

Must Read.txt

Visit Coursedrive.org.url

/.../2. Installing PostgreSQL and pgAdmin/

1. Installing PostgreSQL on Mac and Windows.mp4

1. Installing PostgreSQL on Mac and Windows.vtt

2. Installing PostgreSQL on Ubuntu.mp4

2. Installing PostgreSQL on Ubuntu.vtt

2.1 135_Installing Postgres on Ubuntu.txt.txt

3. Install Northwind Database.mp4

3. Install Northwind Database.vtt

3.1 northwind.sql.sql

3.2 northwind.tar.tar

4. Install some additional databases..html

4.1 usda.tar.tar

4.2 AdventureWorks.tar.tar

4.3 pagila.tar.tar

/.../3. Simple Selection of All Records/

1. Selecting All Data From a Table.mp4

1. Selecting All Data From a Table.vtt

1.1 04_Selecting All Data From a Table.sql.sql

2. Selecting Specific Fields.mp4

2. Selecting Specific Fields.mp4.jpg

2. Selecting Specific Fields.txt

2. Selecting Specific Fields.vtt

2.1 05_Selecting Specific Fields.sql.sql

3. Selecting Distinct Values.mp4

3. Selecting Distinct Values.vtt

3.1 06_Selecting Distinct Values.sql.sql

4. Counting Results.mp4

4. Counting Results.vtt

4.1 07_Counting Results.sql.sql

5. Combining Fields in SELECT.mp4

5. Combining Fields in SELECT.vtt

5.1 08_Combining fields in SELECT.sql.sql

6. Practice What You've Learned.html

6.1 01_Simple Selection of all records.sql.sql

/.../4. Using WHERE to Select Records/

1. WHERE Selection for Text Fields.mp4

1. WHERE Selection for Text Fields.vtt

1.1 09_Where with text fields.sql.sql

2. WHERE Selection for Numeric Fields.mp4

2. WHERE Selection for Numeric Fields.vtt

2.1 10_Where with Numeric Fields.sql.sql

3. WHERE with Date Fields.mp4

3. WHERE with Date Fields.vtt

3.1 11_WHERE with Date fields.sql.sql

4. WHERE Using Logical AND Operator.mp4

4. WHERE Using Logical AND Operator.vtt

5. WHERE Using Logical OR Operator.mp4

5. WHERE Using Logical OR Operator.vtt

5.1 13_WHERE using OR.sql.sql

6. WHERE Using Logical NOT Operator.mp4

6. WHERE Using Logical NOT Operator.vtt

6.1 14_WHERE Using NOT.sql.sql

7. WHERE Combining AND, OR, and NOT.mp4

7. WHERE Combining AND, OR, and NOT.vtt

7.1 15_WHERE Combining AND OR NOT.sql.sql

8. Using BETWEEN.mp4

8. Using BETWEEN.vtt

8.1 16_Using BETWEEN.sql.sql

9. Using IN.mp4

9. Using IN.vtt

9.1 16_Using BETWEEN.sql.sql

10. Practice What You've Learned.html

10.1 02_Using where to select records.sql.sql

/5. Schemas/

1. Schema Basics.mp4

1. Schema Basics.vtt

1.1 124_Schema basics.sql.sql

ReadMe.txt

Visit Coursedrive.org.url

/.../6. Intermediate SELECT Statements/

1. ORDER BY.mp4

1. ORDER BY.vtt

1.1 PostgreSQL Documentation on Sorting Rows.html

1.2 18_ORDER BY.sql.sql

2. Using MIN and MAX Functions.mp4

2. Using MIN and MAX Functions.vtt

2.1 19_Using MIN and MAX.sql.sql

3. Using AVG and SUM.mp4

3. Using AVG and SUM.vtt

3.1 20_Using AVG and SUM.sql.sql

4. LIKE to Match Patterns.mp4

4. LIKE to Match Patterns.vtt

4.1 21_LIKE to Match Patterns.sql.sql

4.2 PostgreSQL Documentation on LIKE.html

5. Renaming Columns With Alias.mp4

5. Renaming Columns With Alias.vtt

5.1 22_Renaming Column With Alias.sql.sql

6. LIMIT to Control Number of Records Returned.mp4

6. LIMIT to Control Number of Records Returned.vtt

6.1 23_LIMIT to Control.sql.sql

6.2 PostgreSQL Documentation on LIMIT.html

7. NULL Values.mp4

7. NULL Values.vtt

7.1 24_NULL Values.sql.sql

8. Practice What You've Learned.html

8.1 04_Intermediate Select Statements.sql.sql

/.../7. Joining multiple tables together/

1. Diagramming Table Relationships.mp4

1. Diagramming Table Relationships.vtt

1.1 01 Northwind_A4_size_for_Print.png.png

2. Inner Join for Two Tables.mp4

2. Inner Join for Two Tables.vtt

2.1 26_Inner Join for two tables.sql.sql

3. Inner Join for Multiple Tables.mp4

3. Inner Join for Multiple Tables.vtt

3.1 27_Inner Joins for multiple tables.sql.sql

4. Left Joins.mp4

4. Left Joins.vtt

4.1 28_Left Joins.sql.sql

5. Right Joins.mp4

5. Right Joins.vtt

5.1 29_Right Joins.sql.sql

6. Full Joins.mp4

6. Full Joins.vtt

6.1 30_Full Joins.sql.sql

7. Self Joins.mp4

7. Self Joins.vtt

7.1 31_Self Join.sql.sql

8. USING To Reduce Typing.mp4

8. USING To Reduce Typing.vtt

8.1 69_USING to reduce typing.sql.sql

9. Even Less Typing With NATURAL.mp4

9. Even Less Typing With NATURAL.vtt

9.1 PostgreSQL Documentation on Joins.html

9.2 70_Even less typing with NATURAL.sql.sql

10. Practice What You've Learned.html

10.1 05_Joining multiple tables together.sql.sql

/.../8. Grouping and Aggregation Functions/

1. Group By.mp4

1. Group By.vtt

1.1 PostgreSQL Documentation on GROUP BY.html

1.2 32_Group By.sql.sql

2. Use HAVING to Filter Groups.mp4

2. Use HAVING to Filter Groups.vtt

2.1 PostgreSQL Documentation on HAVING.html

2.2 32_HAVING to filter Groups.sql.sql

3. Grouping Sets.mp4

3. Grouping Sets.vtt

3.1 PostgreSQL Documentation on GROUPING SETS.html

3.2 73_Grouping Sets.sql.sql

4. Rollup.mp4

4. Rollup.vtt

4.1 74_Rollup.sql.sql

4.2 PostgreSQL Documentation on GROUPING SETS.html

5. Cube - Rollup On Steroids.mp4

5. Cube - Rollup On Steroids.vtt

5.1 PostgreSQL Documentation on CUBE.html

5.2 75_Cube Rollup on steroids.sql.sql

/9. Combining Queries/

1. Union.mp4

1. Union.vtt

1.1 PostgreSQL Documentation on UNION.html

1.2 34_UNION.sql.sql

2. Intersect.mp4

2. Intersect.vtt

2.1 71_Intersect.sql.sql

2.2 PostgreSQL Documentation on INTERSECTION.html

3. Except.mp4

3. Except.vtt

3.1 PostgreSQL Documentation on EXCEPT.html

3.2 72_Except.sql.sql

/10. Subqueries/

1. Subquery Using EXISTS.mp4

1. Subquery Using EXISTS.vtt

1.1 PostgreSQL Documentation on EXISTS.html

1.2 35_Subquery Using EXISTS.sql.sql

2. Subquery Using ANY and ALL.mp4

2. Subquery Using ANY and ALL.vtt

2.1 PostgreSQL Documentation on ANY.html

2.2 PostgreSQL Documentation on ALL.html

2.3 36_Subquery Using ANY and ALL.sql.sql

3. IN Using Subquery.mp4

3. IN Using Subquery.vtt

3.1 PostgreSQL Documentation on IN subquery.html

3.2 37_IN Using Subquery.sql.sql

ReadMe.txt

Visit Coursedrive.org.url

/.../11. Modifying Data In Tables INSERT, UPDATE and DELETE/

1. INSERT INTO.mp4

1. INSERT INTO.vtt

1.1 PostgreSQL Documentation on Inserting Data.html

1.2 38_INSERT INTO.sql.sql

2. UPDATE.mp4

2. UPDATE.vtt

2.1 PostgreSQL Documentation on Updating Data.html

2.2 39_UPDATE.sql.sql

3. DELETE.mp4

3. DELETE.vtt

3.1 PostgreSQL Documentation on Deleting Data.html

3.2 40_DELETE.sql.sql

4. SELECT INTO.mp4

4. SELECT INTO.vtt

4.1 PostgreSQL Documentation on SELECT INTO.html

4.2 41_SELECT INTO.sql.sql

5. INSERT INTO SELECT.mp4

5. INSERT INTO SELECT.vtt

5.1 42_INSERT INTO SELECT.sql.sql

6. Returning Data From Update, Delete, and Insert.mp4

6. Returning Data From Update, Delete, and Insert.vtt

6.1 82_Returning Data from update delete and insert.sql.sql

6.2 PostgreSQL Documentation on Returning Data From Rows.html

/.../12. Indexes and Performance Tuning/

1. CREATE INDEX.mp4

1. CREATE INDEX.vtt

1.1 49_CREATE INDEX.sql.sql

1.2 PostgreSQL Documentation on CREATE INDEX.html

2. DROP INDEX.mp4

2. DROP INDEX.vtt

2.1 PostgreSQL Documentation on DROP INDEX.html

2.2 50_DROP INDEX.sql.sql

3. Using Explain To See Query Plan.mp4

3. Using Explain To See Query Plan.vtt

3.1 136_Using Explain To See Performance of Queries.sql.sql

3.2 PostgreSQL Documentation on Using Explain.html

4. Use Analyze To Update Table Statistics.mp4

4. Use Analyze To Update Table Statistics.vtt

4.1 137_Use Analyze To Update Table Statistics.sql.sql

4.2 PostgreSQL Documentation on ANALYZE.html

4.3 PostgreSQL Documentation on Explain.html

5. How Is Query Plan Cost Calculated.mp4

5. How Is Query Plan Cost Calculated.vtt

5.1 138_How is query plan cost calculated.sql.sql

6. Using Indexes On More Than One Field.mp4

6. Using Indexes On More Than One Field.vtt

6.1 139_Using Indexes On More Than One Field.sql.sql

7. Expression Indexes.mp4

7. Expression Indexes.vtt

7.1 PostgreSQL Documentation on Indexes On Expressions.html

7.2 142_ Expression indexes.sql.sql

8. Types Of Indexes.mp4

8. Types Of Indexes.vtt

8.1 PostgreSQL Documentation on Index Types.html

9. Speeding Up Text Matching.mp4

9. Speeding Up Text Matching.vtt

9.1 PostgreSQL Documentation on pg_trm.html

9.2 141_Speeding Up Text Matching.sql.sql

/.../13. Database Design and Normalization/

1. Design Process Overview.mp4

1. Design Process Overview.vtt

2. Database Terminology.mp4

2. Database Terminology.vtt

2.1 Wikipedia Article On OLTP.html

2.2 Wikipedia Article On OLAP.html

2.3 Wikipedia Article On Tuples.html

2.4 Wikipedia Article On Relational Database.html

2.5 Wikipedia Article On Attribute.html

2.6 Wikipedia Article On Views.html

2.7 Wikipedia Article On Primary Keys.html

2.8 Wikipedia Article On Data Integrity.html

2.9 Wikipedia Article On Entity Integrity.html

2.10 Wikipedia Article On Foreign Keys.html

2.11 Wikipedia Article On Referential Integrity.html

2.12 Wikipedia Article On Relations.html

3. A Design Process.mp4

3. A Design Process.vtt

4. Finding Mission Statement And Ojectives.mp4

4. Finding Mission Statement And Ojectives.vtt

5. Analyzing Current Systems.mp4

5. Analyzing Current Systems.vtt

6. Create Table Structure.mp4

7. Establishing Keys.mp4

8. Specifying Fields.mp4

8.1 Anatomy of a Field Specification.html

9. Relationships Between Tables.mp4

/.../14. Creating and Modifying Tables/

1. CREATE TABLE.mp4

1. CREATE TABLE.vtt

1.1 PostgreSQL Documentation on Table Basics.html

1.2 PostgreSQL Documentation on CREATE TABLE.html

1.3 45_CREATE_TABLE.sql.sql

2. ALTER TABLE - Part One.mp4

2. ALTER TABLE - Part One.vtt

2.1 PostgreSQL Documentation on Renaming a Table.html

2.2 PostgreSQL Documentation on Renaming a Column.html

2.3 46_ALTER TABLE Part One.sql.sql

3. ALTER TABLE - Part Two.mp4

3. ALTER TABLE - Part Two.vtt

3.1 PostgreSQL Documentation on Removing a Column.html

3.2 PostgreSQL Documentation on Adding a Column.html

3.3 47_ALTER TABLE Part 2.sql.sql

4. ALTER TABLE - Part Three.mp4

4. ALTER TABLE - Part Three.vtt

4.1 48_ALTER TABLE Part 3.sql.sql

4.2 PostgreSQL Documentation on Changing a Column's Data Type.html

5. DROP TABLE.mp4

5. DROP TABLE.vtt

5.1 PostgreSQL Documentation on DROP TABLE.html

5.2 51_DROP TABLE.sql.sql

/.../15. Table Constraints/

1. NOT NULL Constraint.mp4

1. NOT NULL Constraint.vtt

1.1 PostgreSQL Documentation on Not-Null Constraint.html

1.2 52_NOT NULL Constraint.sql.sql

2. UNIQUE Constraint.mp4

2. UNIQUE Constraint.vtt

2.1 53_UNIQUE Constraint.sql.sql

3. PRIMARY KEY Constraint.mp4

3. PRIMARY KEY Constraint.vtt

3.1 PostgreSQL Documentation on Unique Constraints.html

3.2 54_PRIMARY KEY Constraint.sql.sql

4. FOREIGN KEY Constraint.mp4

4. FOREIGN KEY Constraint.vtt

4.1 55_FOREIGN KEY Constraint.sql.sql

4.2 PostgreSQL Documentation on Foreign Keys.html

5. CHECK Constraint.mp4

5. CHECK Constraint.vtt

5.1 54_CHECK Constraint.sql.sql

5.2 PostgreSQL Documentation on Check Constraints.html

6. DEFAULT Values.mp4

6. DEFAULT Values.vtt

6.1 57_Default constraint.sql.sql

6.2 PostgreSQL Documentation on Default Values.html

7. Changing a Column's Default Value.mp4

7. Changing a Column's Default Value.vtt

7.1 81_Changing_Column_Default_Value.sql.sql

7.2 PostgreSQL Documentation on Changing a Column's Default Value.html

8. Adding and Removing a Column's Constraint.mp4

8. Adding and Removing a Column's Constraint.vtt

8.1 PostgreSQL Documentation on Adding and Removing Constraints.html

8.2 84_Adding and removing column constraints.sql.sql

ReadMe.txt

Visit Coursedrive.org.url

/16. Sequences/

1. Create A Sequence.mp4

1. Create A Sequence.vtt

1.1 PostgreSQL Documentation On CREATE SEQUENCE.html

1.2 76_Create a Sequence.sql.sql

1.3 PostgreSQL Documentation On sequence manipulation functions.html

2. Alter and Delete Sequences.mp4

2. Alter and Delete Sequences.vtt

2.1 PostgreSQL Documentation on ALTER SEQUENCE.html

2.2 76_Alter and delete squences.sql.sql

2.3 PostgreSQL Documentation on DROP SEQUENCE.html

3. Using Serial Datatypes.mp4

3. Using Serial Datatypes.vtt

3.1 PostgreSQL Documentation on SERIAL datatypes.html

3.2 78_Using Serial Datatypes.sql.sql

/.../17. CTE - Common Table Expressions/

1. WITH Queries.mp4

1. WITH Queries.vtt

1.1 PostgreSQL Documentation on WITH Queries.html

1.2 74_With Queries.sql.sql

2. Creating Hierarchical Data To Use For Recursive WITH Queries.mp4

2. Creating Hierarchical Data To Use For Recursive WITH Queries.vtt

2.1 78_AddEmployees.sql.sql

3. Using Recursion in CTEs.mp4

3. Using Recursion in CTEs.vtt

3.1 79_Using Recursions.sql.sql

3.2 PostgreSQL Documentation on WITH RECURSIVE.html

/18. Views/

1. Views - How To Create.mp4

1. Views - How To Create.vtt

1.1 PostgreSQL Documentation on CREATE VIEW.html

1.2 64_Views how to create.sql.sql

2. Views - How To Modify.mp4

2. Views - How To Modify.vtt

2.1 65_Views how to modify.sql.sql

2.2 PostgreSQL Documentation on ALTER VIEW.html

3. Creating Updatable Views.mp4

3. Creating Updatable Views.vtt

3.1 67_CreatingUpdateableViews.sql.sql

4. With Check Option.mp4

4. With Check Option.vtt

4.1 68_WithCheckOption.sql.sql

5. Deleting Views.mp4

5. Deleting Views.vtt

5.1 PostgreSQL Documentation on DROP VIEW.html

5.2 66_DeletingViews.sql.sql

/.../19. Conditional Expressions/

1. CASE WHEN.mp4

1. CASE WHEN.vtt

1.1 PostgreSQL Documentation on CASE WHEN.html

1.2 61_CaseWhen.sql.sql

2. COALESCE.mp4

2. COALESCE.vtt

2.1 PostgreSQL Documentation on COALESCE.html

2.2 62_Coalesce.sql.sql

3. NULLIF.mp4

3. NULLIF.vtt

3.1 PostgreSQL Documentation on NULLIF.html

3.2 63_NULLIF.sql.sql

/.../20. Using DateTime In PostgreSQL/

1. Date, Time, and Timestamp Data Types.mp4

1. Date, Time, and Timestamp Data Types.vtt

1.1 PostgreSQL Documentation on DateTime Input and Output.html

1.2 83_Date Time Input and Output.sql.sql

2. Time Zones.mp4

2. Time Zones.vtt

2.1 PostgreSQL Documentation on Time Zones.html

2.2 84_Time Zones.sql.sql

3. Interval Data Type.mp4

3. Interval Data Type.vtt

3.1 PostgreSQL Documentation on Interval Data Type.html

3.2 87_Interval Data Type.sql.sql

4. Date Arithmetic.mp4

4. Date Arithmetic.vtt

4.1 PostgreSQL Documentation on DateTime Functions.html

4.2 88_Date Arithmetic.sql.sql

5. Pulling Out Parts of Dates and Times.mp4

5. Pulling Out Parts of Dates and Times.vtt

5.1 PostgreSQL Documentation on EXTRACT, date_part.html

5.2 100_Pulling Out Parts of Dates and Times.sql.sql

6. Converting One Data Type Into Another.mp4

6. Converting One Data Type Into Another.vtt

6.1 PostgreSQL Documentation on Type Casts.html

6.2 101_Converting One Data Type Into Another.sql.sql

ReadMe.txt

Visit Coursedrive.org.url

/.../21. Window Functions/

1. Basic Window Function Example.mp4

1. Basic Window Function Example.vtt

1.1 59_Basic Window Examples.sql.sql

2. Using Window Functions With Subqueries.mp4

2. Using Window Functions With Subqueries.vtt

2.1 60_Using Window Functions With Subqueries.sql.sql

3. Using Rank() To Find The First N Records In Join.mp4

3. Using Rank() To Find The First N Records In Join.vtt

3.1 125_Using Rank to find first N records.sql.sql

/.../22. Composite Types/

1. Composite Type Basics.mp4

1. Composite Type Basics.vtt

1.1 PostgreSQL Documentation on Declaration of Composite Type.html

1.2 PostgreSQL Documentation on DROP TYPE.html

1.3 89_Composite Type Basics.sql.sql

2. Using Composite Types.mp4

2. Using Composite Types.vtt

2.1 PostgreSQL Documentation on Accessing Composite Types.html

2.2 PostgreSQL Documentation on Modifying Composite Types.html

2.3 PostgreSQL Documentation on Constructing Composite Types.html

2.4 90_Using Composite Types.sql.sql

/.../23. SQL Functions and Procedures/

1. Write Your First Function.mp4

1. Write Your First Function.vtt

1.1 91_Write Your First Function.sql.sql

2. Write A Function That Returns A Single Value.mp4

2. Write A Function That Returns A Single Value.vtt

2.1 92_Write a function that returns a single value.sql.sql

3. Functions With Parameters.mp4

3. Functions With Parameters.vtt

3.1 93_Functions with parameters.sql.sql

4. Functions That Have Composite Parameters.mp4

4. Functions That Have Composite Parameters.vtt

4.1 94_Functions that have composite parameters.sql.sql

4.2 PostgreSQL Documentation on SQL Functions On Composite Types.html

5. Functions That Return A Composite.mp4

5. Functions That Return A Composite.vtt

5.1 PostgreSQL Documentation on SQL Functions On Composite Types.html

5.2 95_Functions That Return A Composite.sql.sql

6. Functions With Output Parameters.mp4

6. Functions With Output Parameters.vtt

6.1 96_Functions With Output Parameters.sql.sql

6.2 PostgreSQL Documentation on SQL Functions with Output Parameters.html

7. Functions With Default Values.mp4

7. Functions With Default Values.vtt

7.1 97_Functions With Default Values.sql.sql

7.2 PostgreSQL Documentation on SQL Functions with Default Values For Arguments.html

8. Using Functions as Table Source.mp4

8. Using Functions as Table Source.vtt

8.1 PostgreSQL Documentation on SQL Functions as Table Sources.html

8.2 98_Using Functions as Table Source.sql.sql

9. Functions That Return More Than One Row.mp4

9. Functions That Return More Than One Row.vtt

9.1 PostgreSQL Documentation on SQL Functions Returning Sets.html

9.2 99_Functions that return more than one row.sql.sql

10. Procedures - Functions That Don't Return Anything.mp4

10. Procedures - Functions That Don't Return Anything.vtt

10.1 PostgreSQL Documentation on CREATE PROCEDURE.html

10.2 PostgreSQL Documentation on User-defined Procedures.html

10.3 102_Procedures.sql.sql

/.../24. Transactions And Concurrency Control/

1. ACID Transactions.mp4

1. ACID Transactions.vtt

2. Simple Transaction Control.mp4

2. Simple Transaction Control.vtt

2.1 104_Simple Transaction Control.sql.sql

2.2 PostgreSQL Documentation on Transactions.html

2.3 PostgreSQL Documentation on BEGIN.html

2.4 PostgreSQL Documentation on START TRANSACTION.html

2.5 PostgreSQL Documentation on COMMIT.html

2.6 PostgreSQL Documentation on END TRANSACTION.html

3. Rollbacks & Savepoints.mp4

3. Rollbacks & Savepoints.vtt

3.1 PostgreSQL Documentation on ROLLBACK.html

3.2 105_Rollbacks savepoints.sql.sql

3.3 PostgreSQL Documentation on SAVEPOINT.html

3.4 PostgreSQL Documentation on ROLLBACK TO SAVEPOINT.html

4. SQL Transaction Isolation.mp4

4. SQL Transaction Isolation.vtt

4.1 Wikipedia article on database isolation.html

5. PostgreSQL Transaction Isolation.mp4

5. PostgreSQL Transaction Isolation.vtt

5.1 PostgreSQL Documentation on Transaction Isolation.html

5.2 PostgreSQL Documentation on SET TRANSACTION.html

5.3 PostgreSQL Documentation on START TRANSACTION.html

5.4 Wikipedia article on MVCC - multiversion concurrency control.html

ReadMe.txt

Visit Coursedrive.org.url

/.../25. Array Data Type/

1. Declaring Arrays.mp4

1. Declaring Arrays.vtt

1.1 108_Declaring Arrays.sql.sql

1.2 PostgreSQL Documentation on Declaration of Array Types.html

2. Inputting Array Values.mp4

2. Inputting Array Values.vtt

2.1 PostgreSQL Documentation on Array Value Input.html

2.2 109_Inputting Array Values.sql.sql

3. Accessing Arrays.mp4

3. Accessing Arrays.vtt

3.1 PostgreSQL Documentation on Accessing Arrays.html

3.2 110_Accessing Arrays.sql.sql

4. Modifying Arrays.mp4

4. Modifying Arrays.vtt

4.1 PostgreSQL Documentation on Modifying Arrays.html

4.2 111_Modifying Arrays.sql.sql

5. Searching Arrays.mp4

5. Searching Arrays.vtt

5.1 PostgreSQL Documentation on Searching In Arrays.html

5.2 112_Searching Arrays.sql.sql

6. Array Operators.mp4

6. Array Operators.vtt

6.1 PostgreSQL Documentation on Array Operators.html

6.2 113_Array Operators.sql.sql

/.../26. PLpgSQL - SQL Procedural Language/

1. Build Your First PLpgSQL Function.mp4

1. Build Your First PLpgSQL Function.vtt

1.1 PostgreSQL Documentation on Stucture of PLpgSQL.html

1.2 PostgreSQL Documentation on Returning From a Function.html

1.3 114_Build first pgpsql function.sql.sql

2. Handling Functions With Output Variables.mp4

2. Handling Functions With Output Variables.vtt

2.1 115_Handling functions with output variables.sql.sql

2.2 PostgreSQL Documentation on Assignment.html

3. Returning Query Results.mp4

3. Returning Query Results.vtt

3.1 116_Returning Query Results.sql.sql

3.2 PostgreSQL Documentation on Returning From a Function.html

4. Declaring Variables.mp4

4. Declaring Variables.vtt

4.1 PostgreSQL Documentation on Declarations.html

4.2 117_Declaring variables.sql.sql

5. Looping Through Query Results.mp4

5. Looping Through Query Results.vtt

5.1 119_Looping Through Query results.sql.sql

5.2 PostgreSQL Documentation on Looping Through Query Results.html

6. Using If-Then Statements.mp4

6. Using If-Then Statements.vtt

6.1 PostgreSQL Documentation on Conditionals.html

6.2 120_Using If-then statements.sql.sql

7. Returning Query Results Continued.mp4

7. Returning Query Results Continued.vtt

7.1 121_Returning Query Results Continued.cmproj.zip.zip

7.2 PostgreSQL Documentation on RETURN NEXT and RETURN QUERY.html

8. Loop and While Loops.mp4

8. Loop and While Loops.vtt

8.1 123_Loop and while loop.sql.sql

8.2 PostgreSQL Documentation on Simple Loops.html

9. Looping Over Array Elements.mp4

9. Looping Over Array Elements.vtt

9.1 PostgreSQL Documentation on Looping Through Arrays.html

9.2 126_Looping Over Array Elements.sql.sql

/.../28. Using psql To Connect To Postgres/

1. Connecting With psql.mp4

1. Connecting With psql.vtt

1.1 127_Connecting With psql.sql.sql

1.2 PostgreSQL Documentation on psql.html

2. Eliminate Typing Connection Parameters.mp4

2. Eliminate Typing Connection Parameters.vtt

2.1 149_Eliminate Typing Connection Parameters.txt.txt

2.2 PostgreSQL Documentation on Environment Variables.html

2.3 PostgreSQL Documentation on The Password File.html

2.4 PostgreSQL Documentation on the Service File.html

/.../29. Importing CSV/

1. Import CSV File.mp4

1. Import CSV File.vtt

1.1 128_Import CSV files.sql.sql

1.2 PostgreSQL Documentation on COPY.html

1.3 Our Airports link to get the CSV files..html

2. Practice What You've Learned.html

2.1 03_Importing CSV.sql.sql

/.../30. JSON and JSONB Data Types/

1. What Is JSON And How To Store In Database.mp4

1. What Is JSON And How To Store In Database.vtt

1.1 PostgreSQL Documentation on JSON Types.html

1.2 128_What is JSON and how to store.sql.sql

2. Create JSON From Tables.mp4

2. Create JSON From Tables.vtt

2.1 129_Create JSON from tables.sql.sql

3. Aggregating JSON Fields.mp4

3. Aggregating JSON Fields.vtt

3.1 130_Aggregating JSON fields.sql.sql

4. Building airports_json Table.mp4

4. Building airports_json Table.vtt

5. Selecting Information Out of JSON Fields.mp4

5. Selecting Information Out of JSON Fields.vtt

5.1 133_Selecting Information Out of JSON fields.sql.sql

6. Searching JSON Data.mp4

6. Searching JSON Data.vtt

6.1 132_Searching JSON data.sql.sql

7. Updating And Deleting Information Inside JSON Fields.mp4

7. Updating And Deleting Information Inside JSON Fields.vtt

7.1 134_Updating and deleting information inside JSON fields.sql.sql

ReadMe.txt

Visit Coursedrive.org.url

/.../31. Managing Databases/

1. CREATE DATABASE.mp4

1. CREATE DATABASE.vtt

1.1 PostgreSQL Documentation on CREATE DATABASE.html

1.2 43_CREATE DATABASE.sql.sql

1.3 PostgreSQL Documentation on createdb.html

2. DROP DATABASE.mp4

2. DROP DATABASE.mp4.jpg

2. DROP DATABASE.txt

2. DROP DATABASE.vtt

2.1 PostgreSQL Documentation on DROP DATABASE.html

2.2 PostgreSQL Documentation on dropdb.html

2.3 44_DROP DATABASE.sql.sql

/.../32. Backups and Recovery/

1. Basic ImportExport With Copy.mp4

1. Basic ImportExport With Copy.vtt

1.1 146_Basic import export with copy.txt.txt

1.2 PostgreSQL Documentation on COPY.html

2. Basic pg_dump And Restore.mp4

2. Basic pg_dump And Restore.vtt

2.1 PostgreSQL Documentation on pg_dump.html

2.2 147_Basic pg_dump and restore.txt.txt

3. Custom Format Dumps.mp4

3. Custom Format Dumps.vtt

3.1 PostgreSQL Documentation on pg_restore.html

3.2 148_Custom Format Dumps.txt.txt

/.../33. Introduction To PostGIS/

1. Install PostGIS on Ubuntu (Not needed for WindowsMac).mp4

1. Install PostGIS on Ubuntu (Not needed for WindowsMac).vtt

1.1 143_Install PostGIS on Ubuntu.txt.txt

2. Converting Airport Data.mp4

2. Converting Airport Data.vtt

2.1 144_Converting Airport Data.sql.sql

2.2 PostGIS Documentation on ST_SetSRID.html

2.3 PostGIS Documentation on AddGeometryColumn.html

2.4 PostGIS Documentation on ST_MakePoint.html

3. Your First Geographical Query.mp4

3. Your First Geographical Query.vtt

3.1 145_Your First Geographical Query.sql.sql

3.2 PostGIS Documentation on ST_DWithin.html

/.../34. Thanks and Good Luck/

1. Thank You.mp4

1. Thank You.vtt

ReadMe.txt

Visit Coursedrive.org.url

Total files 631