~Get Your Files Here !

  1 - Introduction

   1 -Course Overview and Tips for Success.mp4

   2 -Database Fundamentals.mp4

   3 -Download the PostgreSQL installer.url

   3 -Installing PostgreSQL on Windows.mp4

   4 -Installing PostgreSQL on Mac.en_US.vtt

   5 -Download pgAdmin.url

   5 -Installation and Brief Overview of pgAdmin.mp4

  10 - Conclusion

  2 - Quick Start with SQL Part I

   1 -What is SQL.mp4

   10 -DELETE.mp4

   2 -Overview of SQL Syntax and Database Creation.en_US.vtt

   2 -create_and_drop_database.sql

   3 -CREATE TABLE.mp4

   4 -INSERT.en_US.vtt

   4 -insert_into.sql

   5 -Adding data from Excel via pgAdmin.mp4

   6 -SELECT.mp4

   7 -JOIN.en_US.vtt

   7 -join.sql

   8 -GROUP BY.mp4

   9 -UPDATE.en_US.vtt

   9 -update.sql

  3 - Quick Start with SQL Part II

   1 -Primary and Foreign Keys.mp4

   2 -Indexes.en_US.vtt

   2 -indexes.sql

   3 -Transactions.mp4

  4 - Intermediate Assessment

   1 -Conclusion of the First Part.mp4

  5 - Data Definition Language (DDL)

   1 -Creating and Deleting Tables.mp4

   2 -Default Values.en_US.vtt

   2 -default_values.sql

   3 -Check Constraints.mp4

   4 -NOT NULL Constraint.en_US.vtt

   4 -not_null.sql

   5 -UNIQUE Constraint.mp4

   6 -Primary Key.en_US.vtt

   6 -primary_key.sql

   7 -Foreign Key.mp4

   8 -Modifying Existing Tables – ALTER TABLE.en_US.vtt

   8 -alter_table.sql

  6 - Data Manipulation Language (DML)

   1 -Inserting Data – INSERT.mp4

   2 -Updating Data – UPDATE.en_US.vtt

   2 -dml_update.sql

   3 -Deleting Data – DELETE.mp4

   4 -Retrieving Data from Modified Rows – RETURNING.en_US.vtt

   4 -dml_returning.sql

  7 - Data Query Language (DQL)

   1 -Retrieving Data – SELECT.mp4

   10 -VALUES Lists.en_US.vtt

   10 -dql_values.sql

   11 -Common Table Expressions – WITH.mp4

   2 -FROM Clause.en_US.vtt

   2 -dql_from.sql

   3 -Joining Tables – JOIN.mp4

   4 -Filtering Data – WHERE.en_US.vtt

   4 -dql_where.sql

   5 -Grouping and Post-Filtering – GROUP BY and HAVING.mp4

   6 -Window Functions.en_US.vtt

   6 -dql_window.sql

   7 -Combining Queries – UNION, INTERSECT, EXCEPT.mp4

   8 -Sorting – ORDER BY.en_US.vtt

   8 -dql_order_by.sql

   9 -LIMIT and OFFSET.mp4

  8 - Data Types

   1 -Introduction.mp4

   2 -Numeric types.en_US.vtt

   2 -types_numeric.sql

   3 -Character types.mp4

   4 -Date and time.en_US.vtt

   4 -types_date_and_time.sql

   5 -Boolean type.mp4

  9 - Functions and Operators

   1 -Introduction.mp4

   2 -Logical operators.mp4

   3 -Comparison Operators.mp4

   4 -Mathematical Functions and Operators.en_US.vtt

   4 -math_operators.sql

   5 -String Functions and Operators.mp4

   6 -Date and Time Functions and Operators.en_US.vtt

   6 -functions_date_time.sql