Index of /~sibel/dbs_notes/fall2020_lecture_notes

[ICO]NameLast modifiedSizeDescription
[PARENTDIR]Parent Directory  -  
[TXT]lecture1_1_introduction.txt2020-09-03 16:28 1.3K 
[TXT]lecture1_2_relational_model.txt2020-09-03 16:28 2.6K 
[TXT]lecture1_3_inclassnotes.txt2020-09-03 16:28 1.2K 
[TXT]lecture1_3_inclassnotes_2.txt2020-09-03 16:28 1.7K 
[TXT]lecture2_1_relationalalgebra.txt2020-09-03 16:28 1.4K 
[TXT]lecture2_2_relationalalgebra.txt2020-09-03 16:28 3.4K 
[TXT]lecture2_3_relationalalgebra.txt2020-09-03 16:28 3.8K 
[TXT]lecture2_example_data_model.txt2020-09-03 16:28 1.1K 
[TXT]lecture2_4_relationalalgebra.txt2020-09-03 17:00 3.8K 
[TXT]lecture3_2_relationalalgebra.txt2020-09-06 16:30 219  
[TXT]lecture3_3_normalization_part1.txt2020-09-06 17:44 3.9K 
[TXT]lecture3_1_relationalalgebra.txt2020-09-06 20:13 2.4K 
[TXT]lecture4_1_normalization_normal_forms.txt2020-09-07 13:15 4.3K 
[TXT]lecture4_2_normalization_minimal_basis.txt2020-09-07 13:51 2.0K 
[TXT]lecture3_4_inclass.txt2020-09-08 16:32 3.9K 
[TXT]lecture4_3_inclass.txt2020-09-10 16:32 4.4K 
[TXT]lecture5_1_decompositions.txt2020-09-13 16:48 4.1K 
[TXT]lecture5_2_decompositions.txt2020-09-13 17:11 2.1K 
[TXT]lecture5_3_3NFdecompositions.txt2020-09-13 17:39 1.0K 
[TXT]lecture5_4_BCNFdecompositions.txt2020-09-13 18:28 1.7K 
[TXT]lecture5_5_inclass.txt2020-09-14 16:31 3.8K 
[TXT]lecture6_1_fourthnormalform.txt2020-09-16 16:58 728  
[TXT]lecture6_2_EntityRelationshipDiagrams.txt2020-09-16 17:58 1.7K 
[TXT]lecture6_2_and_3_EntityRelationshipDiagrams.txt2020-09-16 18:08 1.7K 
[ ]lecture6_2_3_entity_relationship_diagrams.pdf2020-09-16 18:18 211K 
[TXT]lecture6_4_inclass.txt2020-09-17 16:19 1.2K 
[ ]lecture6_4_inclass_er.pdf2020-09-17 16:38 91K 
[TXT]lecture7_1_er.txt2020-09-19 15:41 1.4K 
[TXT]lecture7_2_er.txt2020-09-19 16:02 1.0K 
[TXT]lecture8_1_entities_revisited.txt2020-09-20 17:08 1.3K 
[TXT]lecture8_2_hierarchies.txt2020-09-20 18:17 2.4K 
[ ]lecture8_1_entity_relationship_diagrams_weakEntities.pdf2020-09-20 18:23 614K 
[ ]lecture7_1_2_entity_relationship_diagrams.pdf2020-09-20 18:23 671K 
[ ]lecture8_2_entity_relationship_diagrams_gierarchies.pdf2020-09-20 18:23 607K 
[ ]lecture7_3_inclass.pdf2020-09-21 18:49 431K 
[TXT]lecture7_3_inclass.txt2020-09-21 18:50 2.6K 
[TXT]lecture8_3_inclass.txt2020-09-24 16:29 1.3K 
[ ]lecture8_3_in_class.pdf2020-09-24 16:42 314K 
[ ]lecture9_review_session.pdf2020-09-28 16:44 529K 
[TXT]lecture9_exam1_review.txt2020-09-29 19:29 10K 
[TXT]lecture10_sql_intro.txt2020-10-05 16:18 5.5K 
[TXT]lecture11_1_sql_intro.txt2020-10-07 18:36 3.0K 
[TXT]lecture11_2_sql_from.txt2020-10-07 19:17 1.3K 
[TXT]lecture11_3_sql_setbagoperations.txt2020-10-07 21:11 1.8K 
[TXT]lecture11_4_sql_groupbyhaving.txt2020-10-07 21:37 1.7K 
[TXT]lecture11_3_inclass.txt2020-10-08 16:33 6.0K 
[TXT]lecture12_1_sql_leftouterjoin.txt2020-10-14 15:19 1.3K 
[TXT]lecture12_2_sql_scalar_queries.txt2020-10-14 16:14 2.1K 
[TXT]lecture12_3_sql_setcomparisons.txt2020-10-14 16:37 2.0K 
[TXT]lecture12_4_inclass.txt2020-10-15 16:43 3.7K 
[TXT]lecture13_1_sqlsubqueries_correlated.txt2020-10-18 21:20 2.5K 
[TXT]lecture13_2_transactionsinsert.txt2020-10-18 21:40 1.6K 
[TXT]lecture13_3_updatedelete.txt2020-10-18 22:06 1.8K 
[TXT]lecture13_4_inclass.txt2020-10-19 16:30 4.2K 
[TXT]lecture14_1_example_sql.txt2020-10-21 16:26 4.6K 
[TXT]lecture14_1_constraints.txt2020-10-21 16:52 1.4K 
[TXT]lecture14_2_isolation.txt2020-10-21 17:14 874  
[TXT]lecture14_3_procedural_programming.txt2020-10-21 18:07 1.5K 
[TXT]lecture14_4_inclass_example_py.txt2020-10-22 15:13 284  
[TXT]lecture14_4_inclass.txt2020-10-22 15:56 1.9K 
[TXT]lecture15_2_triggers.txt2020-10-25 14:51 2.8K 
[TXT]lecture15_1_plpgsql.txt2020-10-26 15:14 6.4K 
[TXT]lecture15_3_inclass.txt2020-10-26 17:41 9.7K 
[TXT]lecture16_1_views_access_rights.txt2020-10-28 17:43 2.2K 
[TXT]lecture16_2_advancedsql_features.txt2020-10-28 18:05 1.4K 
[TXT]lecture16_3_inclass.txt2020-10-29 16:15 916  
[TXT]lecture17_1_or_extensions.txt2020-10-30 18:34 606  
[TXT]lecture17_inclass_review.txt2020-11-02 16:21 5.3K 
[TXT]lecture18_1_inclass.txt2020-11-09 16:30 3.5K 
[TXT]lecture19_1_indexing_types.txt2020-11-11 18:33 1.1K 
[TXT]lecture19_2_btrees.txt2020-11-11 21:13 417  
[ ]lecture19_2_3.pdf2020-11-11 22:55 1.5M 
[TXT]lecture19_4_inclass.txt2020-11-12 16:26 1.4K 
[TXT]lecture20_1_btree_extensions.txt2020-11-15 17:44 525  
[TXT]lecture20_2_otherindex_types.txt2020-11-15 18:47 1.9K 
[ ]lecture20_btree_examples.pdf2020-11-15 22:19 919K 
[TXT]lecture20_3_inclass.txt2020-11-16 16:23 2.4K 
[TXT]lecture21_1_query_execution.txt2020-11-18 19:07 776  
[TXT]lecture21_3_block_nested_loop_join.txt2020-11-18 20:02 514  
[TXT]lecture21_4_inclass.txt2020-11-19 16:25 2.9K 
[TXT]lecture22_1_external_sort.txt2020-11-21 18:23 1.0K 
[TXT]lecture22_3_qopt_intro.txt2020-11-21 21:33 1.0K 
[TXT]lecture22_5_size_estimation.txt2020-11-21 22:37 1.6K 
[TXT]lecture22_6_inclass.txt2020-11-23 15:52 1.3K 
[TXT]lecture23_1_concurrency_introduction.txt2020-11-28 17:50 1.3K 
[TXT]lecture24_1_two_phase_locking.txt2020-11-28 19:05 1.0K 
[TXT]lecture24_2_locking_granularity.txt2020-11-28 19:06 0  
[TXT]lecture24_2_lock_management.txt2020-11-30 18:23 927  
[TXT]lecture24_3_durability_intro.txt2020-11-30 19:02 487  
[TXT]lecture21_2_index_scan.txt2020-11-30 20:58 2.4K 
[ ]Lecture24_inclass .pdf2020-12-03 16:32 808K 
[TXT]lecture25_1_logging.txt2020-12-05 16:28 922  
[TXT]lecture25_2_force_steal.txt2020-12-05 16:49 934  
[TXT]lecture25_3_ARIES_recovery_algorithm.txt2020-12-05 18:24 1.0K 
[ ]lecture25_1_3_durability.pdf2020-12-05 18:52 1.5M 
[TXT]lecture25_4_inclass.txt2020-12-07 15:45 1.5K 
[ ]Lecture25_inclass.pdf2020-12-07 16:30 2.0M 
[TXT]lecture23_2_checking_serializability.txt2020-12-07 20:39 1.0K 
[TXT]lecture23_3_inclass.txt2020-12-07 20:40 3.6K 
[TXT]lecture26.txt2020-12-10 15:50 4.1K