Filename Size 01-course-introduction/001-introduction.mp4 8.5 MB 01-course-introduction/002-course-curriculum-overview.mp4 8.6 MB 01-course-introduction/003-overview-of-databases.mp4 18.7 MB 01-course-introduction/006-setting-up-with-pgadmin-4.mp4 46.1 MB 01-course-introduction/attached_files/004-course-faqs/PostgreSQL-Sample-Database.png 163.6 KB 01-course-introduction/attached_files/004-course-faqs/SQLNotes.pdf 292.1 KB 01-course-introduction/attached_files/006-setting-up-with-pgadmin-4/dvdrental.tar 644.4 KB 01-course-introduction/captions/006-setting-up-with-pgadmin-4-EN.srt 23.4 KB 02-postgresql-installation-mac-os/009-mac-os-installation.mp4 10.1 MB 02-postgresql-installation-mac-os/011-mac-database-setup.mp4 33.7 MB 02-postgresql-installation-mac-os/attached_files/009-mac-os-installation/dvdrental.zip 538.5 KB 02-postgresql-installation-mac-os/attached_files/010-mac-sample-database-download/Database-Schema.png 190.8 KB 02-postgresql-installation-mac-os/attached_files/010-mac-sample-database-download/dvdrental.zip 538.5 KB 02-postgresql-installation-mac-os/captions/011-mac-database-setup-EN.srt 14.2 KB 03-postgresql-installation-windows/014-windows-installation.mp4 15.8 MB 03-postgresql-installation-windows/016-windows-command-line-installation-lecture.mp4 64.3 MB 03-postgresql-installation-windows/attached_files/014-windows-installation/Database-Schema.png 190.8 KB 03-postgresql-installation-windows/attached_files/014-windows-installation/dvdrental.zip 538.5 KB 03-postgresql-installation-windows/attached_files/015-sample-database-download/Database-Schema.png 190.8 KB 03-postgresql-installation-windows/attached_files/015-sample-database-download/dvdrental.zip 538.5 KB 03-postgresql-installation-windows/captions/016-windows-command-line-installation-lecture-EN.srt 25.4 KB 04-databases-and-tables/017-databases-and-tables-overview.mp4 1.6 MB 04-databases-and-tables/018-creating-and-restoring-a-database.mp4 13.6 MB 04-databases-and-tables/019-overview-of-challenges.mp4 2.2 MB 04-databases-and-tables/020-challenge-restore-a-database.mp4 821 KB 04-databases-and-tables/021-restoring-a-table-schema.mp4 13.2 MB 04-databases-and-tables/022-challenge-restore-a-table-schema.mp4 924.1 KB 05-sql-statement-fundamentals/025-sql-statement-fundamentals.mp4 972.2 KB 05-sql-statement-fundamentals/026-select-statement.mp4 23.2 MB 05-sql-statement-fundamentals/027-challenge-select-task..mp4 3.1 MB 05-sql-statement-fundamentals/028-select-distinct.mp4 15.4 MB 05-sql-statement-fundamentals/029-challenge-select-distinct.mp4 2.4 MB 05-sql-statement-fundamentals/030-select-where.mp4 34.5 MB 05-sql-statement-fundamentals/031-challenge-select-where.mp4 4.9 MB 05-sql-statement-fundamentals/032-count.mp4 8.2 MB 05-sql-statement-fundamentals/033-limit.mp4 8 MB 05-sql-statement-fundamentals/034-order-by.mp4 19.6 MB 05-sql-statement-fundamentals/035-challenge-order-by.mp4 4 MB 05-sql-statement-fundamentals/036-between.mp4 14.2 MB 05-sql-statement-fundamentals/037-in.mp4 13.6 MB 05-sql-statement-fundamentals/038-like.mp4 16 MB 05-sql-statement-fundamentals/039-general-challenge-1.mp4 10.9 MB 05-sql-statement-fundamentals/attached_files/024-sql-cheat-sheet/Screen-Shot-2016-04-17-at-12.22.49-PM.png 1 MB 05-sql-statement-fundamentals/attached_files/039-general-challenge-1/general-challenge-1.pptx 53.1 KB 05-sql-statement-fundamentals/captions/026-select-statement-EN.srt 15.5 KB 05-sql-statement-fundamentals/captions/030-select-where-EN.srt 18.6 KB 05-sql-statement-fundamentals/captions/034-order-by-EN.srt 12.6 KB 05-sql-statement-fundamentals/captions/038-like-EN.srt 13.5 KB 05-sql-statement-fundamentals/captions/039-general-challenge-1-EN.srt 14.2 KB 06-group-by-statements/040-min-max-sum-and-avg.mp4 16.4 MB 06-group-by-statements/041-group-by.mp4 39.6 MB 06-group-by-statements/042-challengegroup-by.mp4 24.6 MB 06-group-by-statements/043-having.mp4 14.7 MB 06-group-by-statements/045-challengehaving.mp4 7 MB 06-group-by-statements/captions/041-group-by-EN.srt 23.1 KB 06-group-by-statements/captions/042-challengegroup-by-EN.srt 17.7 KB 06-group-by-statements/captions/043-having-EN.srt 13.4 KB 07-assessment-test-1/046-overview-of-assessment-test-1.mp4 1.3 MB 08-joins/050-as-statement.mp4 5.9 MB 08-joins/051-overview-of-inner-join.mp4 35.7 MB 08-joins/052-examples-of-inner-joins.mp4 27.2 MB 08-joins/053-overview-of-join-types.mp4 26.1 MB 08-joins/054-example-of-outer-joins.mp4 29 MB 08-joins/055-union.mp4 12.9 MB 08-joins/attached_files/053-overview-of-join-types/JOINS-Overview-2.pptx 440.9 KB 08-joins/captions/051-overview-of-inner-join-EN.srt 24.9 KB 08-joins/captions/052-examples-of-inner-joins-EN.srt 20.4 KB 08-joins/captions/053-overview-of-join-types-EN.srt 17.3 KB 08-joins/captions/054-example-of-outer-joins-EN.srt 15.1 KB 09-advanced-sql-commands/058-timestamps-and-extract.mp4 30.2 MB 09-advanced-sql-commands/059-mathematical-functions.mp4 25.1 MB 09-advanced-sql-commands/060-string-function-and-operators.mp4 38.1 MB 09-advanced-sql-commands/061-subquery.mp4 33.1 MB 09-advanced-sql-commands/062-selfjoin.mp4 32 MB 09-advanced-sql-commands/captions/061-subquery-EN.srt 18.1 KB 09-advanced-sql-commands/captions/062-selfjoin-EN.srt 18.6 KB 10-assessment-test-2/063-assessment-test-2-overview.mp4 18 MB 10-assessment-test-2/attached_files/063-assessment-test-2-overview/exercises.tar 32.9 KB 10-assessment-test-2/attached_files/063-assessment-test-2-overview/exercises.zip 26.5 KB 11-creating-databases-and-tables/066-overview-of-section.mp4 6.9 MB 11-creating-databases-and-tables/067-data-types.mp4 15.9 MB 11-creating-databases-and-tables/068-primary-keys-and-foreign-keys.mp4 19.5 MB 11-creating-databases-and-tables/071-create-table.mp4 44.5 MB 11-creating-databases-and-tables/073-challenge-create-table-solution.mp4 11.7 MB 11-creating-databases-and-tables/074-insert.mp4 31.7 MB 11-creating-databases-and-tables/075-update.mp4 21.7 MB 11-creating-databases-and-tables/076-delete.mp4 9.2 MB 11-creating-databases-and-tables/077-alter-table.mp4 13.2 MB 11-creating-databases-and-tables/078-drop-table.mp4 10.6 MB 11-creating-databases-and-tables/079-check-constraint.mp4 20.2 MB 11-creating-databases-and-tables/080-not-null-constraint.mp4 12.2 MB 11-creating-databases-and-tables/081-unique-constraint.mp4 9.9 MB 11-creating-databases-and-tables/captions/068-primary-keys-and-foreign-keys-EN.srt 13.2 KB 11-creating-databases-and-tables/captions/071-create-table-EN.srt 27 KB 11-creating-databases-and-tables/captions/074-insert-EN.srt 19.7 KB 11-creating-databases-and-tables/captions/075-update-EN.srt 13.1 KB 13-extra-views/084-views.mp4 20.8 MB 14-extra-postgresql-with-python/086-psycopg2-example-usage.mp4 24.7 MB 14-extra-postgresql-with-python/captions/086-psycopg2-example-usage-EN.srt 12.9 KB