|
|
001 About SQL Strings.mp4
|
MP4
|
5.6 MB
|
|
|
001 About SQL Strings_en.vtt
|
VTT
|
2 KB
|
|
|
001 About SQL.mp4
|
MP4
|
9.9 MB
|
|
|
001 About SQL_en.vtt
|
VTT
|
4.5 KB
|
|
|
001 Automating Data With Triggers.mp4
|
MP4
|
38.6 MB
|
|
|
001 Automating Data With Triggers_en.vtt
|
VTT
|
5 KB
|
|
|
001 B-tree indexes.mp4
|
MP4
|
13 MB
|
|
|
001 B-tree indexes_en.vtt
|
VTT
|
5 KB
|
|
|
001 Creating A Table.mp4
|
MP4
|
19.1 MB
|
|
|
001 Creating A Table_en.vtt
|
VTT
|
3.3 KB
|
|
|
001 Creating a Subselect.mp4
|
MP4
|
28 MB
|
|
|
001 Creating a Subselect_en.vtt
|
VTT
|
3.3 KB
|
|
|
001 Date and Times.mp4
|
MP4
|
6 MB
|
|
|
001 Date and Times_en.vtt
|
VTT
|
2.5 KB
|
|
|
001 EXPLAIN and ANALYZE commands.mp4
|
MP4
|
36.8 MB
|
|
|
001 EXPLAIN and ANALYZE commands_en.vtt
|
VTT
|
10.4 KB
|
|
|
001 Embedding SQL.mp4
|
MP4
|
42.4 MB
|
|
|
001 Embedding SQL_en.vtt
|
VTT
|
6.3 KB
|
|
|
001 Extending SQL with user-defined functions.mp4
|
MP4
|
13 MB
|
|
|
001 Extending SQL with user-defined functions_en.vtt
|
VTT
|
4.3 KB
|
|
|
001 Federated Queries.mp4
|
MP4
|
14.7 MB
|
|
|
001 Federated Queries_en.vtt
|
VTT
|
5.1 KB
|
|
|
001 Installing on Windows.mp4
|
MP4
|
49.2 MB
|
|
|
001 Installing on Windows_en.vtt
|
VTT
|
7.4 KB
|
|
|
001 Introduction.mp4
|
MP4
|
9.1 MB
|
|
|
001 Introduction_en.vtt
|
VTT
|
819.2 B
|
|
|
001 Make your queries faster.mp4
|
MP4
|
19.7 MB
|
|
|
001 Make your queries faster_en.vtt
|
VTT
|
2.1 KB
|
|
|
001 Numeric Types.mp4
|
MP4
|
8.2 MB
|
|
|
001 Numeric Types_en.vtt
|
VTT
|
3.7 KB
|
|
|
001 Overview.mp4
|
MP4
|
10.5 MB
|
|
|
001 Overview_en.vtt
|
VTT
|
1.1 KB
|
|
|
001 Retrieve data with SELECT.mp4
|
MP4
|
55.8 MB
|
|
|
001 Retrieve data with SELECT_en.vtt
|
VTT
|
6.2 KB
|
|
|
001 Rules of normalization.mp4
|
MP4
|
26.8 MB
|
|
|
001 Rules of normalization_en.vtt
|
VTT
|
8 KB
|
|
|
001 Understanding JOIN.mp4
|
MP4
|
9 MB
|
|
|
001 Understanding JOIN_en.vtt
|
VTT
|
2.8 KB
|
|
|
001 What are Aggregates.mp4
|
MP4
|
34.6 MB
|
|
|
001 What are Aggregates_en.vtt
|
VTT
|
5.4 KB
|
|
|
001 What are Transactions.mp4
|
MP4
|
6.6 MB
|
|
|
001 What are Transactions_en.vtt
|
VTT
|
2.4 KB
|
|
|
002 Accessing Related Tables.mp4
|
MP4
|
49.8 MB
|
|
|
002 Accessing Related Tables_en.vtt
|
VTT
|
7.3 KB
|
|
|
002 Bitmap indexes.mp4
|
MP4
|
15.1 MB
|
|
|
002 Bitmap indexes_en.vtt
|
VTT
|
3.6 KB
|
|
|
002 Bloom filters.mp4
|
MP4
|
18.1 MB
|
|
|
002 Bloom filters_en.vtt
|
VTT
|
5.6 KB
|
|
|
002 Data Integrity.mp4
|
MP4
|
34.6 MB
|
|
|
002 Data Integrity_en.vtt
|
VTT
|
4.5 KB
|
|
|
002 Database Organisation.mp4
|
MP4
|
15.2 MB
|
|
|
002 Database Organisation_en.vtt
|
VTT
|
3.3 KB
|
|
|
002 Date and Time Related Functions.mp4
|
MP4
|
15.6 MB
|
|
|
002 Date and Time Related Functions_en.vtt
|
VTT
|
2.5 KB
|
|
|
002 Deleting A Table.mp4
|
MP4
|
16.8 MB
|
|
|
002 Deleting A Table_en.vtt
|
VTT
|
2.5 KB
|
|
|
002 Denormalization.mp4
|
MP4
|
28.6 MB
|
|
|
002 Denormalization_en.vtt
|
VTT
|
9.2 KB
|
|
|
002 Filter results with WHERE clause.mp4
|
MP4
|
51.3 MB
|
|
|
002 Filter results with WHERE clause_en.vtt
|
VTT
|
5.8 KB
|
|
|
002 Finding The Length Of A String.mp4
|
MP4
|
13.2 MB
|
|
|
002 Finding The Length Of A String_en.vtt
|
VTT
|
2.1 KB
|
|
|
002 Generating data with generate_sequence.mp4
|
MP4
|
35.6 MB
|
|
|
002 Generating data with generate_sequence_en.vtt
|
VTT
|
5 KB
|
|
|
002 Get familiar with phpMyAdmin.mp4
|
MP4
|
41.7 MB
|
|
|
002 Get familiar with phpMyAdmin_en.vtt
|
VTT
|
4.7 KB
|
|
|
002 Installing on Mac.mp4
|
MP4
|
57.7 MB
|
|
|
002 Installing on Mac_en.vtt
|
VTT
|
9.2 KB
|
|
|
002 Merge data across tables with JOINS.mp4
|
MP4
|
47.6 MB
|
|
|
002 Merge data across tables with JOINS_en.vtt
|
VTT
|
5.6 KB
|
|
|
002 Preventing Updates.mp4
|
MP4
|
36 MB
|
|
|
002 Preventing Updates_en.vtt
|
VTT
|
4.7 KB
|
|
|
002 SQL query functions.mp4
|
MP4
|
43.8 MB
|
|
|
002 SQL query functions_en.vtt
|
VTT
|
10.9 KB
|
|
|
002 Searching Within A Result Set.mp4
|
MP4
|
26.2 MB
|
|
|
002 Searching Within A Result Set_en.vtt
|
VTT
|
3.3 KB
|
|
|
002 The SELECT Function.mp4
|
MP4
|
50.4 MB
|
|
|
002 The SELECT Function_en.vtt
|
VTT
|
7.1 KB
|
|
|
002 Understanding SQL.mp4
|
MP4
|
12.6 MB
|
|
|
002 Understanding SQL_en.vtt
|
VTT
|
1.3 KB
|
|
|
002 Using Aggregate Functions.mp4
|
MP4
|
11.5 MB
|
|
|
002 Using Aggregate Functions_en.vtt
|
VTT
|
1.5 KB
|
|
|
002 What Type is That Value.mp4
|
MP4
|
13.5 MB
|
|
|
002 What Type is That Value_en.vtt
|
VTT
|
2.7 KB
|
|
|
002 What you should know before watching this course.mp4
|
MP4
|
2.7 MB
|
|
|
002 What you should know before watching this course_en.vtt
|
VTT
|
1.5 KB
|
|
|
003 Aggregating DISTINCT Values.mp4
|
MP4
|
12.8 MB
|
|
|
003 Aggregating DISTINCT Values_en.vtt
|
VTT
|
2.1 KB
|
|
|
003 Analyzing a query with WHERE clauses and indexes.mp4
|
MP4
|
27.3 MB
|
|
|
003 Analyzing a query with WHERE clauses and indexes_en.vtt
|
VTT
|
3.3 KB
|
|
|
003 Creating a View.mp4
|
MP4
|
20.7 MB
|
|
|
003 Creating a View_en.vtt
|
VTT
|
2.4 KB
|
|
|
003 Example Timestamps.mp4
|
MP4
|
33.2 MB
|
|
|
003 Example Timestamps_en.vtt
|
VTT
|
3.9 KB
|
|
|
003 Function overloading.mp4
|
MP4
|
40 MB
|
|
|
003 Function overloading_en.vtt
|
VTT
|
6 KB
|
|
|
003 Hash indexes.mp4
|
MP4
|
5.5 MB
|
|
|
003 Hash indexes_en.vtt
|
VTT
|
1.7 KB
|
|
|
003 How to use the Exercise files.mp4
|
MP4
|
6.2 MB
|
|
|
003 How to use the Exercise files_en.vtt
|
VTT
|
1.1 KB
|
|
|
003 Hstore for key-value pairs.mp4
|
MP4
|
45.5 MB
|
|
|
003 Hstore for key-value pairs_en.vtt
|
VTT
|
7.1 KB
|
|
|
003 INSERT, UPDATE and DELETE Functions.mp4
|
MP4
|
27.6 MB
|
|
|
003 INSERT, UPDATE and DELETE Functions_en.vtt
|
VTT
|
4.3 KB
|
|
|
003 Inserting Rows.mp4
|
MP4
|
26.6 MB
|
|
|
003 Inserting Rows_en.vtt
|
VTT
|
3.5 KB
|
|
|
003 Integer Division.mp4
|
MP4
|
13.2 MB
|
|
|
003 Integer Division_en.vtt
|
VTT
|
2.3 KB
|
|
|
003 Partitioning data.mp4
|
MP4
|
54.4 MB
|
|
|
003 Partitioning data_en.vtt
|
VTT
|
9.5 KB
|
|
|
003 Performance.mp4
|
MP4
|
25.3 MB
|
|
|
003 Performance_en.vtt
|
VTT
|
3.2 KB
|
|
|
003 Relating Multiple Tables.mp4
|
MP4
|
47 MB
|
|
|
003 Relating Multiple Tables_en.vtt
|
VTT
|
5.6 KB
|
|
|
003 Selecting Part Of A String.mp4
|
MP4
|
23.8 MB
|
|
|
003 Selecting Part Of A String_en.vtt
|
VTT
|
3.8 KB
|
|
|
003 Sort SQL results with ORDER BY.mp4
|
MP4
|
17.9 MB
|
|
|
003 Sort SQL results with ORDER BY_en.vtt
|
VTT
|
2 KB
|
|
|
003 The SELECT Statement.mp4
|
MP4
|
39.9 MB
|
|
|
003 The SELECT Statement_en.vtt
|
VTT
|
6.4 KB
|
|
|
003 Understand the demo database.mp4
|
MP4
|
20.5 MB
|
|
|
003 Understand the demo database_en.vtt
|
VTT
|
1.8 KB
|
|
|
003 Using the exercise files.mp4
|
MP4
|
1.5 MB
|
|
|
003 Using the exercise files_en.vtt
|
VTT
|
921.6 B
|
|
|
004 Analyzing a query with a join.mp4
|
MP4
|
52.5 MB
|
|
|
004 Analyzing a query with a join_en.vtt
|
VTT
|
6.6 KB
|
|
|
004 Change report headings with alias.mp4
|
MP4
|
27.2 MB
|
|
|
004 Change report headings with alias_en.vtt
|
VTT
|
3 KB
|
|
|
004 Creating a Joined View.mp4
|
MP4
|
27.8 MB
|
|
|
004 Creating a Joined View_en.vtt
|
VTT
|
2.9 KB
|
|
|
004 Deleting Rows.mp4
|
MP4
|
16.2 MB
|
|
|
004 Deleting Rows_en.vtt
|
VTT
|
2.3 KB
|
|
|
004 Function volatility.mp4
|
MP4
|
15.5 MB
|
|
|
004 Function volatility_en.vtt
|
VTT
|
5.1 KB
|
|
|
004 GiST and SP-GiST indexes.mp4
|
MP4
|
7.7 MB
|
|
|
004 GiST and SP-GiST indexes_en.vtt
|
VTT
|
2.4 KB
|
|
|
004 JSON for semi-structured data.mp4
|
MP4
|
63.7 MB
|
|
|
004 JSON for semi-structured data_en.vtt
|
VTT
|
9.2 KB
|
|
|
004 Join tables.mp4
|
MP4
|
36.9 MB
|
|
|
004 Join tables_en.vtt
|
VTT
|
7.8 KB
|
|
|
004 Materialized views.mp4
|
MP4
|
48.9 MB
|
|
|
004 Materialized views_en.vtt
|
VTT
|
9.7 KB
|
|
|
004 Removing Spaces.mp4
|
MP4
|
10.3 MB
|
|
|
004 Removing Spaces_en.vtt
|
VTT
|
1.8 KB
|
|
|
004 Rounding Numbers.mp4
|
MP4
|
8.8 MB
|
|
|
004 Rounding Numbers_en.vtt
|
VTT
|
1.3 KB
|
|
|
004 Selecting Rows.mp4
|
MP4
|
23.5 MB
|
|
|
004 Selecting Rows_en.vtt
|
VTT
|
2.8 KB
|
|
|
005 Challenge Design a data model for analytics.mp4
|
MP4
|
6.8 MB
|
|
|
005 Challenge Design a data model for analytics_en.vtt
|
VTT
|
1.9 KB
|
|
|
005 Challenge Optimize a query using an explain plan.mp4
|
MP4
|
4.3 MB
|
|
|
005 Challenge Optimize a query using an explain plan_en.vtt
|
VTT
|
614.4 B
|
|
|
005 Filter data.mp4
|
MP4
|
47.7 MB
|
|
|
005 Filter data_en.vtt
|
VTT
|
7.6 KB
|
|
|
005 Folding Case.mp4
|
MP4
|
16.5 MB
|
|
|
005 Folding Case_en.vtt
|
VTT
|
2.7 KB
|
|
|
005 GIN and BRIN indexes.mp4
|
MP4
|
16.2 MB
|
|
|
005 GIN and BRIN indexes_en.vtt
|
VTT
|
5.5 KB
|
|
|
005 Hierarchical data and ltrees.mp4
|
MP4
|
91.9 MB
|
|
|
005 Hierarchical data and ltrees_en.vtt
|
VTT
|
13.5 KB
|
|
|
005 PLPython functions.mp4
|
MP4
|
14.5 MB
|
|
|
005 PLPython functions_en.vtt
|
VTT
|
5.2 KB
|
|
|
005 Selecting Columns.mp4
|
MP4
|
14.7 MB
|
|
|
005 Selecting Columns_en.vtt
|
VTT
|
1.6 KB
|
|
|
005 The NULL Value.mp4
|
MP4
|
43.1 MB
|
|
|
005 The NULL Value_en.vtt
|
VTT
|
5.6 KB
|
|
|
006 Aggregate data.mp4
|
MP4
|
52 MB
|
|
|
006 Aggregate data_en.vtt
|
VTT
|
8.6 KB
|
|
|
006 Challenge Choosing an optimal indexing strategy.mp4
|
MP4
|
5.5 MB
|
|
|
006 Challenge Choosing an optimal indexing strategy_en.vtt
|
VTT
|
819.2 B
|
|
|
006 Challenge Design a table to support unstructured data.mp4
|
MP4
|
4.1 MB
|
|
|
006 Challenge Design a table to support unstructured data_en.vtt
|
VTT
|
614.4 B
|
|
|
006 Constraining Columns.mp4
|
MP4
|
34.2 MB
|
|
|
006 Constraining Columns_en.vtt
|
VTT
|
5.1 KB
|
|
|
006 Counting Rows.mp4
|
MP4
|
13.8 MB
|
|
|
006 Counting Rows_en.vtt
|
VTT
|
2.1 KB
|
|
|
006 Solution Design a data model for analytics.mp4
|
MP4
|
12 MB
|
|
|
006 Solution Design a data model for analytics_en.vtt
|
VTT
|
3.2 KB
|
|
|
007 Changing A Schema.mp4
|
MP4
|
19.5 MB
|
|
|
007 Changing A Schema_en.vtt
|
VTT
|
2.8 KB
|
|
|
007 Inserting Data.mp4
|
MP4
|
15.6 MB
|
|
|
007 Inserting Data_en.vtt
|
VTT
|
1.9 KB
|
|
|
007 Solution Choosing an optimal indexing strategy.mp4
|
MP4
|
5.8 MB
|
|
|
007 Solution Choosing an optimal indexing strategy_en.vtt
|
VTT
|
1.8 KB
|
|
|
007 Solution Design a table to support unstructured data.mp4
|
MP4
|
14.9 MB
|
|
|
007 Solution Design a table to support unstructured data_en.vtt
|
VTT
|
2.7 KB
|
|
|
007 Window functions.mp4
|
MP4
|
13 MB
|
|
|
007 Window functions_en.vtt
|
VTT
|
2.7 KB
|
|
|
008 ID Columns.mp4
|
MP4
|
24.4 MB
|
|
|
008 ID Columns_en.vtt
|
VTT
|
3.9 KB
|
|
|
008 Subqueries.mp4
|
MP4
|
31.1 MB
|
|
|
008 Subqueries_en.vtt
|
VTT
|
6.1 KB
|
|
|
008 Updating Data.mp4
|
MP4
|
17.8 MB
|
|
|
008 Updating Data_en.vtt
|
VTT
|
2.3 KB
|
|
|
009 Deleting Data.mp4
|
MP4
|
9.4 MB
|
|
|
009 Deleting Data_en.vtt
|
VTT
|
1.3 KB
|
|
|
009 Filtering Data.mp4
|
MP4
|
61.2 MB
|
|
|
009 Filtering Data_en.vtt
|
VTT
|
7.1 KB
|
|
|
009 Rolling calculations.mp4
|
MP4
|
36.2 MB
|
|
|
009 Rolling calculations_en.vtt
|
VTT
|
6.6 KB
|
|
|
010 Analyze employee data.mp4
|
MP4
|
33.7 MB
|
|
|
010 Analyze employee data_en.vtt
|
VTT
|
6.1 KB
|
|
|
010 Removing Duplicates.mp4
|
MP4
|
26.3 MB
|
|
|
010 Removing Duplicates_en.vtt
|
VTT
|
3.3 KB
|
|
|
011 Date and time functions.mp4
|
MP4
|
39.6 MB
|
|
|
011 Date and time functions_en.vtt
|
VTT
|
7.6 KB
|
|
|
011 Ordering Output.mp4
|
MP4
|
29.4 MB
|
|
|
011 Ordering Output_en.vtt
|
VTT
|
3.8 KB
|
|
|
012 Conditional Expressions.mp4
|
MP4
|
19.8 MB
|
|
|
012 Conditional Expressions_en.vtt
|
VTT
|
2.9 KB
|
|
|
Bonus Resources.txt
|
TXT
|
409.6 B
|
|
|
Get Bonus Downloads Here.url
|
URL
|
204.8 B
|
