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