Udemy - SQL and PostgreSQL - A Practical Course

Files:

• Get Bonus Downloads Here.url (0.2 KB)
~Get Your Files Here ! 1 - Introduction
• 1 -Course Overview and Tips for Success.en_US.vtt (2.8 KB)
• 1 -Course Overview and Tips for Success.mp4 (11.6 MB)
• 2 -Database Fundamentals.en_US.vtt (2.8 KB)
• 2 -Database Fundamentals.mp4 (11.7 MB)
• 2 -Introduction to Databases.pdf (3.3 MB)
• 3 -Download the PostgreSQL installer.url (0.1 KB)
• 3 -Installing PostgreSQL on Windows.en_US.vtt (3.2 KB)
• 3 -Installing PostgreSQL on Windows.mp4 (27.6 MB)
• 4 -Download Postgres.url (0.1 KB)
• 4 -Installing PostgreSQL on Mac.en_US.vtt (2.0 KB)
• 4 -Installing PostgreSQL on Mac.mp4 (22.4 MB)
• 5 -Download pgAdmin.url (0.1 KB)
• 5 -Installation and Brief Overview of pgAdmin.en_US.vtt (5.0 KB)
• 5 -Installation and Brief Overview of pgAdmin.mp4 (48.2 MB)
10 - Conclusion
• 1 - Summary and Next Steps.html (2.0 KB)
2 - Quick Start with SQL Part I
• 1 -What is SQL.en_US.vtt (1.0 KB)
• 1 -What is SQL.mp4 (5.6 MB)
• 10 -DELETE.en_US.vtt (1.2 KB)
• 10 -DELETE.mp4 (6.1 MB)
• 10 -delete.sql (0.2 KB)
• 2 -Overview of SQL Syntax and Database Creation.en_US.vtt (4.9 KB)
• 2 -Overview of SQL Syntax and Database Creation.mp4 (20.4 MB)
• 2 -create_and_drop_database.sql (0.1 KB)
• 3 -CREATE TABLE.en_US.vtt (3.6 KB)
• 3 -CREATE TABLE.mp4 (15.6 MB)
• 3 -create_table.sql (0.3 KB)
• 4 -INSERT.en_US.vtt (4.1 KB)
• 4 -INSERT.mp4 (26.2 MB)
• 4 -insert_into.sql (0.7 KB)
• 5 -Adding data from Excel via pgAdmin.en_US.vtt (6.4 KB)
• 5 -Adding data from Excel via pgAdmin.mp4 (53.4 MB)
• 6 -SELECT.en_US.vtt (4.7 KB)
• 6 -SELECT.mp4 (29.7 MB)
• 6 -select.sql (0.6 KB)
• 7 -JOIN.en_US.vtt (7.1 KB)
• 7 -JOIN.mp4 (43.2 MB)
• 7 -join.sql (0.6 KB)
• 8 -GROUP BY.en_US.vtt (4.3 KB)
• 8 -GROUP BY.mp4 (22.8 MB)
• 8 -group_by.sql (0.4 KB)
• 9 -UPDATE.en_US.vtt (1.4 KB)
• 9 -UPDATE.mp4 (9.5 MB)
• 9 -update.sql (0.1 KB)
3 - Quick Start with SQL Part II
• 1 -Primary and Foreign Keys.en_US.vtt (6.6 KB)
• 1 -Primary and Foreign Keys.mp4 (37.1 MB)
• 1 -primary_and_foreign_keys.sql (0.5 KB)
• 2 -Indexes.en_US.vtt (2.7 KB)
• 2 -Indexes.mp4 (12.6 MB)
• 2 -indexes.sql (0.2 KB)
• 3 -Transactions.en_US.vtt (5.7 KB)
• 3 -Transactions.mp4 (26.9 MB)
• 3 -transaction.sql (0.4 KB)
4 - Intermediate Assessment
• 1 -Conclusion of the First Part.en_US.vtt (0.5 KB)
• 1 -Conclusion of the First Part.mp4 (1.8 MB)
• 1 -PostgreSQL Documentation.url (0.1 KB)
5 - Data Definition Language (DDL)
• 1 -Creating and Deleting Tables.en_US.vtt (2.8 KB)
• 1 -Creating and Deleting Tables.mp4 (10.7 MB)
• 1 -create_and_drop_table_if_exists.sql (0.3 KB)
• 2 -Default Values.en_US.vtt (2.6 KB)
• 2 -Default Values.mp4 (10.0 MB)
• 2 -default_values.sql (0.3 KB)
• 3 -Check Constraints.en_US.vtt (2.9 KB)
• 3 -Check Constraints.mp4 (13.4 MB)
• 3 -checks.sql (0.5 KB)
• 4 -NOT NULL Constraint.en_US.vtt (0.4 KB)
• 4 -NOT NULL Constraint.mp4 (2.2 MB)
• 4 -not_null.sql (0.5 KB)
• 5 -UNIQUE Constraint.en_US.vtt (1.2 KB)
• 5 -UNIQUE Constraint.mp4 (7.1 MB)
• 5 -unique.sql (0.3 KB)
• 6 -Primary Key.en_US.vtt (1.8 KB)
• 6 -Primary Key.mp4 (10.6 MB)
• 6 -primary_key.sql (0.6 KB)
• 7 -Foreign Key.en_US.vtt (6.0 KB)
• 7 -Foreign Key.mp4 (46.5 MB)
• 7 -foreign_key.sql (1.6 KB)
• 8 -Modifying Existing Tables – ALTER TABLE.en_US.vtt (8.2 KB)
• 8 -Modifying Existing Tables – ALTER TABLE.mp4 (53.5 MB)
• 8 -alter_table.sql (1.1 KB)
6 - Data Manipulation Language (DML)
• 1 -Inserting Data – INSERT.en_US.vtt (3.8 KB)
• 1 -Inserting Data – INSERT.mp4 (19.4 MB)
• 1 -dml_insert.sql (0.4 KB)
• 2 -Updating Data – UPDATE.en_US.vtt (2.2 KB)
• 2 -Updating Data – UPDATE.mp4 (11.1 MB)
• 2 -dml_update.sql (0.2 KB)
• 3 -Deleting Data – DELETE.en_US.vtt (0.7 KB)
• 3 -Deleting Data – DELETE.mp4 (3.1 MB)
• 3 -dml_delete.sql (0.2 KB)
• 4 -Retrieving Data from Modified Rows – RETURNING.en_US.vtt (1.6 KB)
• 4 -Retrieving Data from Modified Rows – RETURNING.mp4 (7.6 MB)
• 4 -dml_returning.sql (0.3 KB)
7 - Data Query Language (DQL)
• 1 -Retrieving Data – SELECT.en_US.vtt (4.3 KB)
• 1 -Retrieving Data – SELECT.mp4 (18.7 MB)
• 1 -dql_select.sql (0.4 KB)
• 10 -VALUES Lists.en_US.vtt (1.4 KB)
• 10 -VALUES Lists.mp4 (5.5 MB)
• 10 -dql_values.sql (0.2 KB)
• 11 -Common Table Expressions – WITH.en_US.vtt (6.5 KB)
• 11 -Common Table Expressions – WITH.mp4 (39.8 MB)
• 11 -dql_with.sql (1.0 KB)
• 2 -FROM Clause.en_US.vtt (4.4 KB)
• 2 -FROM Clause.mp4 (21.9 MB)
• 2 -dql_from.sql (0.9 KB)
• 3 -Joining Tables – JOIN.en_US.vtt (9.7 KB)
• 3 -Joining Tables – JOIN.mp4 (44.9 MB)
• 3 -dql_join.sql (1.1 KB)
• 4 -Filtering Data – WHERE.en_US.vtt (2.2 KB)
• 4 -Filtering Data – WHERE.mp4 (9.1 MB)
• 4 -dql_where.sql (0.1 KB)
• 5 -Grouping and Post-Filtering – GROUP BY and HAVING.en_US.vtt (6.1 KB)
• 5 -Grouping and Post-Filtering – GROUP BY and HAVING.mp4 (33.1 MB)
• 5 -dql_group_by.sql (1.4 KB)
• 6 -Window Functions.en_US.vtt (5.8 KB)
• 6 -Window Functions.mp4 (30.4 MB)
• 6 -dql_window.sql (1.3 KB)
• 7 -Combining Queries – UNION, INTERSECT, EXCEPT.en_US.vtt (4.1 KB)
• 7 -Combining Queries – UNION, INTERSECT, EXCEPT.mp4 (17.7 MB)
• 7 -dql_union_intersect_select.sql (1.2 KB)
• 8 -Sorting – ORDER BY.en_US.vtt (2.9 KB)
• 8 -Sorting – ORDER BY.mp4 (14.2 MB)
• 8 -dql_order_by.sql (0.4 KB)
• 9 -LIMIT and OFFSET.en_US.vtt (1.5 KB)
• 9 -LIMIT and OFFSET.mp4 (8.4 MB)
• 9 -dql_limit_offset.sql (0.5 KB)
8 - Data Types
• 1 -Introduction.en_US.vtt (0.9 KB)
• 1 -Introduction.mp4 (4.5 MB)
• 1 -PostgreSQL Data Types.url (0.1 KB)
• 2 -Numeric types.en_US.vtt (2.8 KB)
• 2 -Numeric types.mp4 (10.4 MB)
• 2 -types_numeric.sql (0.5 KB)
• 3 -Character types.en_US.vtt (1.9 KB)
• 3 -Character types.mp4 (6.1 MB)
• 3 -types_char.sql (1.0 KB)
• 4 -Date and time.en_US.vtt (3.5 KB)
• 4 -Date and time.mp4 (11.2 MB)
• 4 -types_date_and_time.sql (1.8 KB)
• 5 -Boolean type.en_US.vtt (0.8 KB)
• 5 -Boolean type.mp4 (3.1 MB)
• 5 -types_bool.sql (0.6 KB)
9 - Functions and Operators
• 1 -Introduction.en_US.vtt (1.0 KB)
• 1 -Introduction.mp4 (3.4 MB)
• 2 -Logical operators.en_US.vtt (2.9 KB)
• 2 -Logical operators.mp4 (13.3 MB)
• 3 -Comparison Operators.en_US.vtt (3.9 KB)
• 3 -Comparison Operators.mp4 (20.2 MB)
• 3 -compare_operatos.sql (1.1 KB)
• 4 -Mathematical Functions and Operators.en_US.vtt (4.8 KB)
• 4 -Mathematical Functions and Operators.mp4 (24.4 MB)
• 4 -math_operators.sql (1.1 KB)
• 5 -String Functions and Operators.en_US.vtt (6.8 KB)
• 5 -String Functions and Operators.mp4 (32.9 MB)
• 5 -texts_functions.sql (1.3 KB)
• 6 -Date and Time Functions and Operators.en_US.vtt (5.5 KB)
• 6 -Date and Time Functions and Operators.mp4 (31.4 MB)
• 6 -functions_date_time.sql (1.5 KB)
• Bonus Resources.txt (0.1 KB)