Filename Size 01-course-introduction/004-course-faqs.html 3 KB 01-course-introduction/005-time-to-get-your-computer-setup.html 5.5 KB 01-course-introduction/007-installation-notes.html 1.2 KB 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/captions/001-introduction-EN.srt 3.3 KB 01-course-introduction/captions/002-course-curriculum-overview-EN.srt 2.4 KB 01-course-introduction/captions/003-overview-of-databases-EN.srt 10.6 KB 01-course-introduction/captions/006-setting-up-with-pgadmin-4-EN.srt 23.4 KB 02-postgresql-installation-mac-os/008-mac-os-x-quick-note.html 1016 B 02-postgresql-installation-mac-os/010-mac-sample-database-download.html 2 KB 02-postgresql-installation-mac-os/012-review-of-setup.html 1.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/captions/009-mac-os-installation-EN.srt 8.1 KB 02-postgresql-installation-mac-os/captions/011-mac-database-setup-EN.srt 14.2 KB 03-postgresql-installation-windows/013-windows-quick-note.html 1.2 KB 03-postgresql-installation-windows/015-sample-database-download.html 1.2 KB 03-postgresql-installation-windows/attached_files/014-windows-installation/Database-Schema.png 190.8 KB 03-postgresql-installation-windows/attached_files/015-sample-database-download/Database-Schema.png 190.8 KB 03-postgresql-installation-windows/captions/014-windows-installation-EN.srt 5.8 KB 03-postgresql-installation-windows/captions/016-windows-command-line-installation-lecture-EN.srt 25.4 KB 04-databases-and-tables/023-review-of-section.html 1009 B 04-databases-and-tables/captions/017-databases-and-tables-overview-EN.srt 1.6 KB 04-databases-and-tables/captions/018-creating-and-restoring-a-database-EN.srt 8 KB 04-databases-and-tables/captions/019-overview-of-challenges-EN.srt 2.5 KB 04-databases-and-tables/captions/020-challenge-restore-a-database-EN.srt 1 KB 04-databases-and-tables/captions/021-restoring-a-table-schema-EN.srt 8.1 KB 04-databases-and-tables/captions/022-challenge-restore-a-table-schema-EN.srt 996 B 05-sql-statement-fundamentals/024-sql-cheat-sheet.html 725 B 05-sql-statement-fundamentals/attached_files/039-general-challenge-1/general-challenge-1.pptx 53.1 KB 05-sql-statement-fundamentals/captions/025-sql-statement-fundamentals-EN.srt 1 KB 05-sql-statement-fundamentals/captions/026-select-statement-EN.srt 15.5 KB 05-sql-statement-fundamentals/captions/027-challenge-select-task.-EN.srt 4 KB 05-sql-statement-fundamentals/captions/028-select-distinct-EN.srt 7.2 KB 05-sql-statement-fundamentals/captions/029-challenge-select-distinct-EN.srt 3.1 KB 05-sql-statement-fundamentals/captions/030-select-where-EN.srt 18.6 KB 05-sql-statement-fundamentals/captions/031-challenge-select-where-EN.srt 5.7 KB 05-sql-statement-fundamentals/captions/032-count-EN.srt 6.5 KB 05-sql-statement-fundamentals/captions/033-limit-EN.srt 4.3 KB 05-sql-statement-fundamentals/captions/034-order-by-EN.srt 12.6 KB 05-sql-statement-fundamentals/captions/035-challenge-order-by-EN.srt 5.1 KB 05-sql-statement-fundamentals/captions/036-between-EN.srt 11.4 KB 05-sql-statement-fundamentals/captions/037-in-EN.srt 10.2 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/044-quick-note.html 593 B 06-group-by-statements/captions/040-min-max-sum-and-avg-EN.srt 11.1 KB 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 06-group-by-statements/captions/045-challengehaving-EN.srt 5.4 KB 07-assessment-test-1/047-assessment-test-1.html 977 B 07-assessment-test-1/048-solutions-to-assessment-test-1.html 951 B 07-assessment-test-1/captions/046-overview-of-assessment-test-1-EN.srt 1.8 KB 08-joins/049-overview-of-joins.html 1.1 KB 08-joins/056-join-challenges.html 837 B 08-joins/captions/050-as-statement-EN.srt 5 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 08-joins/captions/055-union-EN.srt 9.2 KB 09-advanced-sql-commands/057-overview-of-advanced-sql-commands.html 1.2 KB 09-advanced-sql-commands/captions/058-timestamps-and-extract-EN.srt 12 KB 09-advanced-sql-commands/captions/059-mathematical-functions-EN.srt 9 KB 09-advanced-sql-commands/captions/060-string-function-and-operators-EN.srt 10.3 KB 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/064-assessment-test-2.html 3.2 KB 10-assessment-test-2/065-solutions-to-assessment-test-2.html 2 KB 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 10-assessment-test-2/captions/063-assessment-test-2-overview-EN.srt 8.9 KB 11-creating-databases-and-tables/069-resource-for-create-table-code.html 1.7 KB 11-creating-databases-and-tables/070-note-on-constraints.html 860 B 11-creating-databases-and-tables/072-challenge-create-table.html 945 B 11-creating-databases-and-tables/captions/066-overview-of-section-EN.srt 4.9 KB 11-creating-databases-and-tables/captions/067-data-types-EN.srt 10.2 KB 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/073-challenge-create-table-solution-EN.srt 8.5 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 11-creating-databases-and-tables/captions/076-delete-EN.srt 5.7 KB 11-creating-databases-and-tables/captions/077-alter-table-EN.srt 8.5 KB 11-creating-databases-and-tables/captions/078-drop-table-EN.srt 7.4 KB 11-creating-databases-and-tables/captions/079-check-constraint-EN.srt 11.8 KB 11-creating-databases-and-tables/captions/080-not-null-constraint-EN.srt 8.6 KB 11-creating-databases-and-tables/captions/081-unique-constraint-EN.srt 6.5 KB 12-assessment-test-3/082-assessment-test-3.html 2.3 KB 12-assessment-test-3/083-solutions-to-assessment-test-3.html 1.6 KB 13-extra-views/captions/084-views-EN.srt 10.8 KB 14-extra-postgresql-with-python/085-overview-of-python-and-postgresql.html 1.3 KB 14-extra-postgresql-with-python/087-psycopg2-resources.html 661 B 14-extra-postgresql-with-python/attached_files/085-overview-of-python-and-postgresql/Pgsql-with-Python.py 5.4 KB 14-extra-postgresql-with-python/attached_files/086-psycopg2-example-usage/Pgsql-with-Python.py 5.4 KB 14-extra-postgresql-with-python/attached_files/087-psycopg2-resources/Pgsql-with-Python.py 5.4 KB 14-extra-postgresql-with-python/captions/086-psycopg2-example-usage-EN.srt 12.9 KB 15-bonus-offers/088-bonus-offers.html 1.2 KB