CSE-6040 Bootcamp

Bootcamp Presentation Materials

• /presentation_materials/Bootcamp_Ground_Rules_v2.pdf
• /presentation_materials/Course_and_Bootcamp_Introduction_v2.pdf
• /presentation_materials/colab_for_bootcamp.pdf
• /presentation_materials/llms-4-learning.pdf

Self-Assessment

• /self_assessments/self_assessment.ipynb
• /self_assessments/self_assessment_with_solutions.ipynb

Foundation Knowledge

• /self_assessments/foundation_knowledge/lists.ipynb
• /self_assessments/foundation_knowledge/loops.ipynb
• /self_assessments/foundation_knowledge/python_data_types_functions.ipynb
• /self_assessments/foundation_knowledge/range.ipynb
• /self_assessments/foundation_knowledge/sets.ipynb
• /self_assessments/foundation_knowledge/tuples.ipynb
• /self_assessments/foundation_knowledge/variable_naming_comments_readability_error_handling.ipynb

Bootcamp Material Colab links

MPE

• /notebooks/MPE/MPE_3.ipynb
• /notebooks/MPE/MPE_6.ipynb
• /notebooks/MPE/MPE_7.ipynb
• /notebooks/MPE/MPE_9.ipynb

numpy

• /notebooks/numpy/intro_to_array_shapes.ipynb
• /notebooks/numpy/intro_to_numpy.ipynb
• /notebooks/numpy/numpy_additional_functionality.ipynb
• /notebooks/numpy/numpy_argsort_sort.ipynb
• /notebooks/numpy/numpy_boolean_mask.ipynb
• /notebooks/numpy/numpy_broadcasting.ipynb
• /notebooks/numpy/numpy_multiply_dot_matrix_multiplication.ipynb

pandas

• /notebooks/pandas/groupby_apply_nlargest_boolean_mask.ipynb
• /notebooks/pandas/pandas_functions.ipynb
• /notebooks/pandas/pandas_groupby_aggregation.ipynb
• /notebooks/pandas/pandas_loc_iloc.ipynb

python

• /notebooks/python/helper_functions.ipynb
• /notebooks/python/intro_dictionaries_1_v2.ipynb
• /notebooks/python/intro_dictionaries_2_v2.ipynb
• /notebooks/python/lambda_functions.ipynb
• /notebooks/python/list_and_dict_comprehensions.ipynb
• /notebooks/python/math_as_code.ipynb
• /notebooks/python/nested_data_exercises.ipynb
• /notebooks/python/nested_data.ipynb
• /notebooks/python/problem_solving_methodology.ipynb
• /notebooks/python/sorting.ipynb
• /notebooks/python/zip_enumerate.ipynb

regex

• /notebooks/regex/mpe_1.ipynb
• /notebooks/regex/mpe_2.ipynb
• /notebooks/regex/regex_intro.ipynb

sql

• /notebooks/sql/SQL1nb0_SQL_syllabus.ipynb
• /notebooks/sql/SQL1nb1_SQL_exam_format.ipynb
• /notebooks/sql/SQL1nb2_SQL_info_discovery.ipynb
• /notebooks/sql/SQL1nb2_DB_Browser.ipynb
• /notebooks/sql/SQL1nb3_Order_of_ops.ipynb
• /notebooks/sql/SQL1nb3_SQL_aggregate.ipynb
• /notebooks/sql/SQL1nb4_SQL_NULLs.ipynb
• /notebooks/sql/SQL2nb0_SQL_string_functions.ipynb
• /notebooks/sql/SQL2nb1_SQL_case_functions.ipynb
• /notebooks/sql/SQL2nb2_SQL_dates.ipynb
• /notebooks/sql/SQL2nb3_SQL_string_case_exercise.ipynb
• /notebooks/sql/SQL3nb1_SQL_SUBQ_CTE_TT.ipynb
• /notebooks/sql/SQL3nb2_SQL_SUBQUERIES.ipynb
• /notebooks/sql/SQL3nb3_SQL_CTEs.ipynb
• /notebooks/sql/SQL3nb4_SQL_TempTables.ipynb
• /notebooks/sql/SQL4nb0_SQL_Intro_to_university_database.ipynb
• /notebooks/sql/SQL4nb1_SQL_OrderOfOps_Window_Functions_Rank.ipynb
• /notebooks/sql/SQL4nb0_SQL_Window_Functions_Rank.ipynb
• /notebooks/sql/SQL4nb1_SQL_Window_Functions_Sum_Lead_Lag.ipynb
• /notebooks/sql/SQL4nb2_SQL_Window_Functions_Sum_Lead_Lag_v2.ipynb

troubleshooting

• /notebooks/troubleshooting/data_debugging_concepts_v2.ipynb
• /notebooks/troubleshooting/data_troubleshooting_example_v3.ipynb
• /notebooks/troubleshooting/test_case_vars_1.ipynb
• /notebooks/troubleshooting/test_case_vars_2.ipynb
• /notebooks/troubleshooting/test_case_vars_3.ipynb
• /notebooks/troubleshooting/test_case_vars_4.ipynb