6040-Bootcamp-SP26

# <a id="Bootcamp_Schedule"></a>Bootcamp Schedule for Spring 2026 Below is the schedule for the bootcamp sessions for the current semester. The sessions are conducted **live** for OMSA students, and the session recordings are made available for VMM students via Piazza. Recordings will be available 24-48 hours after the session and will be published in the Bootcamp Post on Piazza, for both OMSA and VMM sections. **Note**: Sections titled "Student Review Content" indicate content which students should watch but will not be covered live. **Schedule Updates**: Updates will be announced via Piazza and posted on the pinned bootcamp thread (although we don't anticipate many updates) ------------------------------------------------------------------------ #### **Session 1 -- Tuesday January 13 -- Introduction 6:30-8:30 PM ET** 1. Course Introduction by Professor Vuduc 1. Navigating the course web site, Piazza, and some important Canvas/edX module pages. 1. Common Student Questions on Exams and Homework Notebooks. 1. Introduction of Data Analysis in Python Bootcamp Series. [Presentation Slides](https://github.com/gt-cse-6040/bootcamp/blob/main/presentation_materials/Course_and_Bootcamp_Introduction_FA25_v2.pdf) -- Note that there is a "More Pages" link at the bottom of the page, and you may need to click it several times, to see all 14 slides. ------------------------------------------------------------------------ ## **Sessions to prepare for Midterm 1** ------------------------------------------------------------------------ **\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*** **Student Review Content-- Watch these two videos before the next session -- Will not be covered live in the Bootcamp** [Bootcamp History and Ground Rules Video](https://mediaspace.gatech.edu/media/Bootcamp%20Introduction%2C%20History%2C%20Ground%20Rules%2020240826/1_1jatjagd) (10 minutes) -- [Bootcamp Ground Rules Slide](https://github.com/gt-cse-6040/bootcamp/blob/main/presentation_materials/Bootcamp_Ground_Rules_v2.pdf) [Bootcamp Introduction to Google Colab Video](https://mediaspace.gatech.edu/media/Bootcamp%20Introduction%20to%20Google%20Colab%2020240826/1_ot2m2czm) (7 minutes) -- [Colab for Bootcamp Presentation Slides](https://github.com/gt-cse-6040/bootcamp/blob/main/presentation_materials/colab_for_bootcamp.pdf) **\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*** ------------------------------------------------------------------------ #### **Session 2 -- Tuesday January 20 6:30-8:30 PM ET** (Monday January 19 is USA Holiday) 1. Dictionaries Part 1 [Colab Notebook](https://colab.research.google.com/github/gt-cse-6040/bootcamp/blob/main/Module%200/Session%204/s1nb1intro_dictionaries_1_FA25_v2.ipynb) 2. Dictionaries Part 2 [Colab Notebook](https://colab.research.google.com/github/gt-cse-6040/bootcamp/blob/main/Module%200/Session%204/s1nb2intro_dictionaries_2_FA25_v2.ipynb) ###### Students wanting practice in working with dictionaries should see the More Python Exercises in Vocareum, in Module 0 Topic 1, Problems 5, 6, and 8. ###### This Codewars problem is a good one for dictionary manipulation. [Data Type Scramble](https://www.codewars.com/kata/5e5acfe31b1c240012717a78) ###### This "w3resource" site contains a number of practice problems in working with dictionaries. The page includes an editor, so that students can work the problems right on the page itself. [w3resources Dictionaries Practice](https://www.w3resource.com/python-exercises/dictionary/) ------------------------------------------------------------------------ #### **Session 3 -- Wednesday January 21 6:30-8:30 PM ET** 1. List and Dictionary Comprehensions [Colab Notebook](https://colab.research.google.com/github/gt-cse-6040/bootcamp/blob/main/Module%200/Session%206/s6nb_comprehensions_FA25.ipynb) ###### Students wanting practice in working with comprehensions should see the More Python Exercises in Vocareum, in Module 0 Topic 1, Problems 3 and 9. ------------------------------------------------------------------------ #### **Session 4 -- Thursday January 22 6:30-8:30 PM ET** 1. Helper Functions [Colab Notebook](https://colab.research.google.com/github/gt-cse-6040/bootcamp/blob/main/Module%200/Session%206/m0s6nb02_helper_functions.ipynb) 2. Math is Code with Examples [Colab Notebook](https://colab.research.google.com/github/gt-cse-6040/bootcamp/blob/main/Module%201/Session%202/MathAsCode_FA25.ipynb) 3. Zip and Enumerate [Colab Notebook](https://colab.research.google.com/github/gt-cse-6040/bootcamp/blob/main/Module%200/Session%209/m0s9nb1_zip_enumerate.ipynb) ###### This Codewars collection presents 3 (with a 4th problem in beta testing) problems with good examples of working Math as Code exercises. [Math Challenges](https://www.codewars.com/collections/math-challenges-1) ###### This "w3resource" site provides lots of math as code practice problems. The page includes an editor, so that students can work the problems right on the page itself. [w3resources Math as Code Practice](https://www.w3resource.com/python-exercises/math/index.php) ------------------------------------------------------------------------ #### **Session 5 -- Monday January 26 6:30-8:30 PM ET** 1. Nested Data [Colab Notebook](https://colab.research.google.com/github/gt-cse-6040/bootcamp/blob/main/Module%200/Session%206/s6nb1_nested_data_SP25.ipynb) 2. Nested Data examples [Colab Notebook](https://colab.research.google.com/github/gt-cse-6040/bootcamp/blob/main/Module%200/Session%206/s6nb2_nested_data_exercises_FA25.ipynb) ###### Two Codewars problems that work with nested data in a simple manner are below. They are similar in structure/content, and they provide good straightforward practice in working with nested data. ###### [Sum of Nested List -- Simple](https://www.codewars.com/kata/5a15a4db06d5b6d33c000018) ###### [Sum of Nested List -- Complex](https://www.codewars.com/kata/5845e6a7ae92e294f4000315) ------------------------------------------------------------------------ **\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*** **Student Review Content on Lambda Functions and Sorting-- Watch these two videos on your own -- Will not be covered live in the Bootcamp** These videos are of live Bootcamp sessions from the Fall 2025 semester, introducing the two topics. Because the material is fairly straightforward, we have moved them into videos for the students to watch as they see fit, and no longer teach the sessions live. 1. Lambda Functions [Lambda Functions Video](https://mediaspace.gatech.edu/media/CSE-6040-OAN_Fall_2025_lambda_functions_20250903/1_mncm41u0) (17 minutes) [Colab Notebook](https://colab.research.google.com/github/gt-cse-6040/bootcamp/blob/main/Module%200/Session%207/s7nb1_lambda_functions_SP25.ipynb) 2. Sorting [Sorting Video](https://mediaspace.gatech.edu/media/CSE-6040-OAN_Fall_2025_Sorting_20250903/1_fc4ddc6r) (51 minutes) [Colab Notebook](https://colab.research.google.com/github/gt-cse-6040/bootcamp/blob/main/Module%200/Session%207/s7nb2_sorting_FA25.ipynb) ###### Students wanting practice in working with sorting and lambda functions should see the More Python Exercises in Vocareum, in Module 0 Topic 1, Problem 7. ###### This Codewars problem involves converting a lambda function to a regular function. It is a good exercise for students in ensuring that they understand the syntax and format of lambda functions. [Convert Lambda to Def](https://www.codewars.com/kata/605d25f4f24c030033da9afb) ###### Here is a "w3resource" site with good practice problems for writing lambda functions. The page includes an editor, so that students can work the problems right on the page itself. [w3resources Lambda Function Practice](https://www.w3resource.com/python-exercises/lambda/index.php) ###### The following Codewars problems are all focused on sorting in some way, and they are good practice problems for doing sorting. ###### [Sort Rectangles and Circles by Area](https://www.codewars.com/kata/5a1ebc2480171f29cf0000e5) -- Small bit of Math as Code also in this one. ###### [Sort the Gift Code](https://www.codewars.com/kata/52aeb2f3ad0e952f560005d3) -- String sorting ###### [Sort the Comments](https://www.codewars.com/kata/58a0f18091e53d2ad1000039) -- Sort a list of strings **\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*** **Student Review Content on the Bootcamp Problem Solving Method-- Watch these videos on your own -- Will not be covered live in the Bootcamp** These 5 video are of live a Bootcamp session from the Fall 2025 semester, introducing the topic. Because the material is fairly straightforward, we have moved it into videos for the students to watch as they see fit, and we no longer teach the session live. The session presents a sample methodology that students can use when working through the exercises in the course. It is not a required method, but we present it here for students to understand and potentially contemplate for using when writing their own solutions. For the five videos, the first video introduces the method, and the 4 subsequent videos show example notebooks that use the method to solve the exercises in each notebook. The example notebooks are Colab copies of some the notebooks in the More Python Exercises course assignment (abbreviated MPE below). 1. Bootcamp Problem Solving Method Introduction * [Bootcamp Problem Solving Method Video](https://mediaspace.gatech.edu/media/CSE-6040-OAN_Fall_2025_Intro_Problem_Solving_Method_20250908/1_mwdmc3vf) (45 minutes) * [Colab Notebook](https://colab.research.google.com/github/gt-cse-6040/bootcamp/blob/main/Module%200/Session%208/s8nb1_problem_solving_methodology_FA25.ipynb) * [PDF Explanation of the Method](https://cse6040.gatech.edu/active/img/Bootcamp_Problem_Solving_Method.pdf) 2. Coding exercises that show Problem Solving Method * [TA Walkthrough of MPE 3](https://mediaspace.gatech.edu/media/CSE-6040-OAN_Fall_2025_Problem_Solving_Method__Example_MPE3_20250908/1_5auxlrer) (7 minutes) [Colab Notebook for MPE 3](https://colab.research.google.com/github/gt-cse-6040/bootcamp/blob/main/Module%200/Session%203/m0s3nb4_mpe_3.ipynb) * [TA Walkthrough of MPE 6](https://mediaspace.gatech.edu/media/CSE-6040-OAN_Fall_2025_Problem_Solving_Method__Example_MPE6_20250908/1_vss7so1s) (28 minutes) [Colab Notebook for MPE 6](https://colab.research.google.com/github/gt-cse-6040/bootcamp/blob/main/Module%200/Session%202/m0s2nb3_MPE6.ipynb) * [TA Walkthrough of MPE 7](https://mediaspace.gatech.edu/media/CSE-6040-OAN_Fall_2025_Problem_Solving_Method__Example_MPE7_20250908/1_2u8cbv65) (20 minutes) [Colab Notebook for MPE 7](https://colab.research.google.com/github/gt-cse-6040/bootcamp/blob/main/Module%200/Session%202/m0s2nb4_MPE7.ipynb) * [TA Walkthrough of MPE 9](https://mediaspace.gatech.edu/media/CSE-6040-OAN_Fall_2025_Problem_Solving_Method__Example_MPE9_20250908/1_hixtx9xb) (11 minutes) [Colab Notebook for MPE 9](https://colab.research.google.com/github/gt-cse-6040/bootcamp/blob/main/Module%200/Session%203/m0s3nb5_mpe_9.ipynb) ###### Problems 0 and 10, in the More Python Exercises in Vocareum, in Module 0 Topic 1, provide two good examples of complex problem solving exercises for students. ###### The emphasis in these two notebooks is on constructing the algorithm required. As such, they place a premium on the student's thought process in solving the exercise. ###### The two notebooks are very good ones for students who would like to practice implementing the Bootcamp Problem Solving Method, as taught in this session. ###### One method of solving this Codewars problem involves creating a Helper Function to convert a time (in mm:ss format) to the number of seconds in that time, as students need to compare time lengths. This is a bit of a complex exercise, and we present it here for students to practice a problem that requires a more expansive problem-solving approach. [Radio DJ Helper Function](https://www.codewars.com/kata/561bbcb0fbbfb0f5010000ee) ------------------------------------------------------------------------ ### The next live 5 sessions will cover working through a series of notebook parts on Vocareum that are set up to mimic what the students will see on the first midterm exam. ### The notebook parts work through a data analysis, including exploratory data exploration, data cleaning, data filtering, and analysis. #### Each session will be a TA Walkthrough of the exercises, with the discussion focusing on the TA's problem solving approach, and how students can learn from the Walkthrough to apply the concepts for themselves. #### The notebooks are posted on Vocareum, in a non-graded assignment called "Coffee Problems (Set 1)". #### Students can access the assignment from within Canvas/edX. The section titled "Bootcamp Notebooks for Exam Practice" contains the Vocareum link, accessed in the same manner as the homework notebooks: * The bottom of the Modules page in Canvas (for OMSA). * The bottom of the Course page in edX (for VMM). #### There are 4 notebooks, Parts 0-3, with a total of 11 exercises. Each exercise is assigned (within Vocareum) with a nominal value of 1 point, however they are designed to show the students the types of requirements for 1, 2, and 3-point exercises on the exam. #### The exercises are organized as follows: * Part 0: Data Discovery and Cleaning: 3 exercises, with each representing a typical 1-point exam exercise. * Part 1: Data Cleaning: 2 exercises, with each representing a more difficult 1-point or easier 2-point exercise. * Part 2: Basic Analysis: 2 exercises, with each representing a 2-point exercise. * Part 3: Advanced/Complex Analysis: 4 exercises, with each representing a 3-point exercise. ------------------------------------------------------------------------ ### Students are welcome to access the assignment on Vocareum and work on the exercises at their convenience. * As these assignment notebooks are not graded, we encourage students to collaborate on their thought processes and solutions. ------------------------------------------------------------------------ ### The analysis is adapted from an article written on the site [pooding.cool](https://pudding.cool), titled "What Makes an Album the Greatest of All Time". * Here is the article: [What Makes an Album the Greatest of All Time](https://pudding.cool/2024/03/greatest-music/) #### Within Vocareum, students can access a "description" notebook, which provides details of the data sets for the analysis. The content within this description notebook would normally be contained in the first few paragraphs in the exam, to introduce the student to the data sets that they will use on the exam. * To access the description notebook, open any Part, click on the Jupyter logo in the top left, then open the notebook "description.ipynb". * To get back to the working notebook from the description notebook, click on the Jupyter logo in the top left, then open the notebook "main.ipynb". ------------------------------------------------------------------------ #### **Session 6 -- Tuesday January 27 6:30-8:30 PM ET** * Discussion and TA Walkthrough of Part 0, exercises 0/1/2. * Session 1 of 5 for the Bootcamp Practice Exam. ------------------------------------------------------------------------ #### **Session 7 -- Wednesday January 28 6:30-8:30 PM ET** * Discussion and TA Walkthrough of Part 1, exercises 0/1. * Session 2 of 5 for the Bootcamp Practice Exam. ------------------------------------------------------------------------ #### **Session 8 -- Thursday January 29 6:30-8:30 PM ET** * Discussion and TA Walkthrough of Part 2, exercises 0/1. * Session 3 of 5 for the Bootcamp Practice Exam. ------------------------------------------------------------------------ #### **Session 9 -- Monday February 2 6:30-8:30 PM ET** * Discussion and TA Walkthrough of Part 3, exercises 0/1. * Session 4 of 5 for the Bootcamp Practice Exam. ------------------------------------------------------------------------ #### **Session 10 -- Tuesday February 3 6:30-8:30 PM ET** * Discussion and TA Walkthrough of Part 3, exercises 2/3. * Session 5 of 5 for the Bootcamp Practice Exam. ------------------------------------------------------------------------ #### **Session 11 -- Wednesday February 4 6:30-8:30 PM ET** String Manipulation with Regex * [Colab Notebook for Intro](https://colab.research.google.com/github/gt-cse-6040/bootcamp/blob/main/Module%200/Session%208/m0s3nb1_regex_intro.ipynb) * [Colab Notebook for Example 1](https://colab.research.google.com/github/gt-cse-6040/bootcamp/blob/main/Module%200/Session%208/m0s3nb2_mpe_21.ipynb) * [Colab Notebook for Example 2](https://colab.research.google.com/github/gt-cse-6040/bootcamp/blob/main/Module%200/Session%208/m0s3nb3_mpe_2_FA25.ipynb) ###### For students wanting some practice writing REGEX, this site presents 20 "challenges" to formulate the correct regex string for the requirement. Test cases are listed, for the student to see which they are passing or failing. [Regex Tuesday Site](https://callumacrae.github.io/regex-tuesday/) ###### This "w3resource" site has a number of excellent REGEX practice problems. The page includes an editor, so that students can work the problems right on the page itself. [w3resources Regex Practice](https://www.w3resource.com/python-exercises/re/index.php) ------------------------------------------------------------------------ #### **Session 12 -- Monday February 9 6:30-8:30 PM ET** 1. MT1 Prep Discussion Introduction -- [PDF Slides](https://cse6040.gatech.edu/active/img/MT1_Prep_Discussion.pdf) 2. TA Walkthrough of Fall 2025 Midterm 1 -- PMT1-FA25 ------------------------------------------------------------------------ #### **Session 13 -- Wednesday February 11 6:30-8:30 PM ET** 1. TA Walkthrough of Spring 2025 Midterm 1 -- PMT1-SP25 2. Exam Prep Q&A Final -- PDF to be posted in the Bootcamp Piazza thread ------------------------------------------------------------------------ #### **Session 14 -- Monday February 16 6:30-8:30 PM ET** 1. TA Walkthrough of Fall 2024 Midterm 1 -- PMT1-FA24 ------------------------------------------------------------------------ #### **Session 15 -- Wednesday February 18 6:30-8:30 PM ET** 1. TA Walkthrough of Spring 2024 Midterm 1 -- PMT1-SP24 ------------------------------------------------------------------------ ### **■ Midterm 1 is February 20 - February 25** ------------------------------------------------------------------------ #### **Session 16 -- Thursday February 26 6:30-8:30 PM ET** 1. Prof Vuduc exam results review 2. TA Walkthrough of exam solution ------------------------------------------------------------------------ ## **Sessions to prepare for Midterm 2** ------------------------------------------------------------------------ #### **Session 17 -- Monday March 2 6:30-8:30 PM ET** 1. Selection on Pandas Data Frames with .loc[] and .iloc[] [Colab Notebook](https://colab.research.google.com/github/gt-cse-6040/bootcamp/blob/main/Module%201/Session%201/s16nb1_pandas_loc_iloc_SP25.ipynb) 2. Additional Pandas functions: index, concat, merge [Colab Notebook](https://colab.research.google.com/github/gt-cse-6040/bootcamp/blob/main/Module%201/Session%201/s16nb2_pandas_functions_SP25.ipynb) ------------------------------------------------------------------------ #### **Session 18 -- Tuesday March 3 6:30-8:30 PM ET** 1. Pandas groupby and aggregation – [Colab Notebook](https://colab.research.google.com/github/gt-cse-6040/bootcamp/blob/main/Module%201/Session%202/m1s2nb1_pandas_groupby_aggregation_FA25.ipynb) 2. Pandas groupby with apply, summary functions, Boolean Masks [Colab Notebook](https://colab.research.google.com/github/gt-cse-6040/bootcamp/blob/main/Module%201/Session%202/m1s2nb2_groupby_apply_nlargest_boolean_mask_FA25.ipynb) ###### We encourage students looking to practice working with Pandas to check out this "w3resource" page of Pandas exercises. [w3resources Pandas Exercise Set 1](https://www.w3resource.com/python-exercises/pandas/practice-set1/index.php) ------------------------------------------------------------------------ **\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*** **Student Review Content on SQL-- Watch these three videos on your own -- Will not be covered live in the Bootcamp** These videos are from the Spring 2025 Midterm 2 Post Exam Review Session, and they show a TA Walkthrough of the exam solution, for the SQL exercises. The videos are here for two reasons: First, because they show the paradigm of how SQL exercises are done in this class. Students write the query into a string variable, and the code for connecting to the database and returning the results is provided. The query results are returned in a pandas dataframe, which students use to verify their query and troubleshoot their results. This paradigm is formally introduced in Homework Notebook 9. And second, because they show a very good methodology for solving SQL exercises in this class. For students wanting to understand how to approach and solve SQL exercises for the class, these videos show one way to do this, and we recommend that students consider using such an approach. The videos also show some of the common SQL concepts that are tested on exams. The HTML file of the TA Solution, to follow along with the video, is in the Attachments tab of each video's page. [SQL Intro](https://mediaspace.gatech.edu/media/SP_25_MT2_TA_Walkthrough_1_SQL_Intro/1_thmczhig) (3 minutes) -- The video introduces the Helper Functions which are typically included in exams with SQL content. These Helper Functions return the table, column, and foreign key information, for the tables in the exam database. [Exercises 1-3](https://mediaspace.gatech.edu/media/SP_25_MT2_TA_Walkthrough_2_Ex_1_3/1_verncx07) (23 minutes) -- The video covers Exercises 1-3, which are the 1 and 2 point SQL exercises on the exam. Key concepts in each exercise are as follows: 1. UNION ALL 2. GROUP BY 3. COALESCE, LEFT JOIN, GROUP BY, ORDER BY [Exercises 4-5](https://mediaspace.gatech.edu/media/SP_25_MT2_TA_Walkthrough_3_Ex_4_5/1_a4lynju3) (28 minutes) -- The video covers Exercises 4 and 5, which are the 3 point SQL exercises on the exam. Key concepts in each exercise are as follows: 4. Subquery, LEFT JOIN, Filter in WHERE clause 5. MAX CASE **\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*** **Bootcamp SQL Syllabus** [Colab Notebook](https://colab.research.google.com/github/gt-cse-6040/bootcamp/blob/main/SQL/syllabus/SQL1nb0_SQL_syllabus_FA25.ipynb) ###### A very good site for SQL practice is SQLZoo, and the SQL Tutorial page there has an excellent series of SQL exercises to practice with. [SQLZoo Exercises](https://sqlzoo.net/wiki/SQL_Tutorial) ###### Students looking for additional SQL practice should also check out this "w3resources" page, with a good selection of basic SQLite exercises.[w3resources SQLite Exercises](https://www.w3resource.com/sqlite-exercises/) ------------------------------------------------------------------------ #### **Session 19 -- Wednesday March 4 6:30-8:30 PM ET** 1. SQL Exam Format [Colab Notebook](https://colab.research.google.com/github/gt-cse-6040/bootcamp/blob/main/SQL/syllabus/SQL1nb1_SQL_exam_format_FA25.ipynb) 2. SQL Database Information Discovery [Colab Notebook](https://colab.research.google.com/github/gt-cse-6040/bootcamp/blob/main/SQL/syllabus/SQL1nb2_SQL_info_discovery_FA25.ipynb) 3. SQL Aggregate Functions [Colab Notebook](https://colab.research.google.com/github/gt-cse-6040/bootcamp/blob/main/SQL/syllabus/SQL1nb3_SQL_aggregate_FA25.ipynb) 4. NULLS in SQL [Colab Notebook](https://colab.research.google.com/github/gt-cse-6040/bootcamp/blob/main/SQL/syllabus/SQL1nb4_SQL_NULLs_FA25.ipynb) ------------------------------------------------------------------------ ------------------------------------------------------------------------ #### **Session 20 -- Thursday March 5 6:30-8:30 PM ET** 1. SQL String Functions [Colab Notebook](https://colab.research.google.com/github/gt-cse-6040/bootcamp/blob/main/SQL/syllabus/SQL2nb0_SQL_string_functions_FA25.ipynb) 2. SQL CASE Function [Colab Notebook](https://colab.research.google.com/github/gt-cse-6040/bootcamp/blob/main/SQL/syllabus/SQL2nb1_SQL_case_functions_FA25.ipynb) 3. Dates in SQLite [Colab Notebook](https://colab.research.google.com/github/gt-cse-6040/bootcamp/blob/main/SQL/syllabus/SQL2nb2_SQL_dates_FA25.ipynb) 4. SQL Example with Strings and CASE [Colab Notebook](https://colab.research.google.com/github/gt-cse-6040/bootcamp/blob/main/SQL/syllabus/SQL2nb3_SQL_string_case_exercise_FA25.ipynb) -- May not be covered live, depending on time. ------------------------------------------------------------------------ ------------------------------------------------------------------------ #### **Session 21 -- Monday March 9 6:30-8:30 PM ET** 1. Intro to Subqueries, Common Table Expressions, and Temp Tables [Colab Notebook](https://colab.research.google.com/github/gt-cse-6040/bootcamp/blob/main/SQL/syllabus/SQL3nb1_SQL_SUBQ_CTE_TT_FA25.ipynb) 2. Subqueries [Colab Notebook](https://colab.research.google.com/github/gt-cse-6040/bootcamp/blob/main/SQL/syllabus/SQL3nb2_SQL_SUBQUERIES_FA25.ipynb) 3. Common Table Expressions -- CTEs [Colab Notebook](https://colab.research.google.com/github/gt-cse-6040/bootcamp/blob/main/SQL/syllabus/SQL3nb3_SQL_CTEs_FA25.ipynb) 4. Temp Tables [Colab Notebook](https://colab.research.google.com/github/gt-cse-6040/bootcamp/blob/main/SQL/syllabus/SQL3nb4_SQL_TempTables_FA25.ipynb) ------------------------------------------------------------------------ ------------------------------------------------------------------------ #### **Session 22 -- Tuesday March 10 6:30-8:30 PM ET** 1. Intro to the University database [Colab Notebook](https://colab.research.google.com/github/gt-cse-6040/bootcamp/blob/main/SQL/syllabus/SQL4nb0_SQL_Intro_to_university_database_FA25.ipynb) 2. Order of Operations, Window Functions (RANK/DENSERANK) [Colab Notebook](https://colab.research.google.com/github/gt-cse-6040/bootcamp/blob/main/SQL/syllabus/SQL4nb1_SQL_OrderOfOps_Window_Functions_Rank_FA25.ipynb) 3. Window Functions (SUM/LEAD/LAG) [Colab Notebook](https://colab.research.google.com/github/gt-cse-6040/bootcamp/blob/main/SQL/syllabus/SQL4nb2_SQL_Window_Functions%20-%20Sum_Lead_Lag_FA25_v2.ipynb) ------------------------------------------------------------------------ **\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*** **Student Review Content on numpy, will not be covered live in the Bootcamp.** **Notebook to introduce numpy, does not have an accompanying video.** [Introduction to numpy Colab Notebook](https://colab.research.google.com/github/gt-cse-6040/bootcamp/blob/main/Module%201/Session%205/m1s5nb1_intro_to_numpy.ipynb) [Numpy functions and modules video](https://mediaspace.gatech.edu/media/Numpy%20functions%20and%20modules/1_wlqzu77r) (30 minutes) -- [Colab Notebook](https://colab.research.google.com/github/gt-cse-6040/bootcamp/blob/main/Module%201/Session%206/m1s6nb2_numpy_additional_functionality.ipynb) **\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*** ------------------------------------------------------------------------ #### **Session 23 -- Wednesday March 11 6:30-8:30 PM ET** 1. Numpy array shapes [Colab Notebook](https://colab.research.google.com/github/gt-cse-6040/bootcamp/blob/main/Module%201/Session%2023/s23nb0_intro_to_array_shapes_FA25.ipynb) 2. Numpy Boolean masks [Colab Notebook](https://colab.research.google.com/github/gt-cse-6040/bootcamp/blob/main/Module%201/Session%2023/s23nb1_numpy_boolean_mask_FA25.ipynb) 3. Numpy Boolean argsort and sort [Colab Notebook](https://colab.research.google.com/github/gt-cse-6040/bootcamp/blob/main/Module%201/Session%2023/s23nb2_numpy_argsort_sort_FA25.ipynb) ------------------------------------------------------------------------ #### **Session 24 -- Thursday March 12 6:30-8:30 PM ET** The content in this session relies heavily on Linear Algebra principles, and we are teaching how Numpy is applying them in code. The lesson is on Numpy's code application of these principles. For students who are not strong in Linear Algebra, we **HIGHLY RECOMMEND** watching the 3Blue1Brown videos on this topic. If students have Linear Algebra questions during the session, we are going to refer them to watch the videos. [3Blue1Brown Videos on Linear Algebra](https://www.3blue1brown.com/topics/linear-algebra) We also recommend that students watch Prof. Vuduc's Supplemental Classroom Video in Topic 11, titled "Supplemental Classroom Video -- Numpy Neural Networks, Linear Algebra", on Canvas and edX. In this video, he has an excellent discussion for students on when to use transformations, matrix multiplication, and other functions in Numpy. 1. Numpy multiply and matrix multiplication, dot product [Colab Notebook](https://colab.research.google.com/github/gt-cse-6040/bootcamp/blob/main/Module%201/Session%2024/s24nb0_numpy_multiply_dot_matrix_multiplication_FA25.ipynb) 2. Broadcasting [Colab Notebook](https://colab.research.google.com/github/gt-cse-6040/bootcamp/blob/main/Module%201/Session%2024/s24nb1_Broadcasting_FA25.ipynb) ------------------------------------------------------------------------ #### **Session 25 -- Monday March 16 6:30-8:30 PM ET** 1. TA Walkthrough of Fall 2025 Midterm 2 -- PMT2-FA25 2. MT2 Exam Prep Topics Discussion -- PDF to be posted in the Bootcamp Piazza thread ------------------------------------------------------------------------ #### **Session 26 -- Wednesday March 18 6:30-8:30 PM ET** 1. TA Walkthrough of Spring 2025 Midterm 2 -- PMT2-SP25 ------------------------------------------------------------------------ #### **No Live Sessions week of March 23-27, Georgia Tech Spring Break** ------------------------------------------------------------------------ #### **Session 27 -- Monday March 30 6:30-8:30 PM ET** 1. TA Walkthrough of Fall 2024 Midterm 2 -- PMT2-FA24 ------------------------------------------------------------------------ #### **Session 28 -- Wednesday April 1 6:30-8:30 PM ET** 1. TA Walkthrough of Spring 2024 Midterm 2 -- PMT2-SP24 ------------------------------------------------------------------------ ### **■ Midterm 2 is April 3 - April 8** ------------------------------------------------------------------------ #### **Session 29 -- Thursday April 9 6:30-8:30 PM ET** 1. Prof Vuduc exam results review 2. TA Walkthrough of exam solution ------------------------------------------------------------------------ ## **Sessions to prepare for the Final Exam** ------------------------------------------------------------------------ #### **Session 30 -- Monday April 13 6:30-8:30 PM ET** 1. CSE6040 In the Real World, Panel discussion with course/program alumni -- OMSA only, details to be posted on Piazza ------------------------------------------------------------------------ #### **Session 31 -- Monday April 20 6:30-8:30 PM ET** 1. TA Walkthrough of Fall 2025 Final Exam -- PFX-FA25 2. Final Exam Prep Topics Discussion -- PDF to be posted in the Bootcamp Piazza thread ------------------------------------------------------------------------ #### **Session 32 -- Wednesday April 22 6:30-8:30 PM ET** 1. TA Walkthrough of Spring 2025 Final Exam -- PFX-SP25 ------------------------------------------------------------------------ #### **Session 33 -- Monday April 27 6:30-8:30 PM ET** 1. TA Walkthrough of Fall 2024 Final Exam -- PFX-FA24 ------------------------------------------------------------------------ #### **Session 34 -- Wednesday April 29 6:30-8:30 PM ET** 1. TA Walkthrough of Spring 2024 Final Exam -- PFX-SP24 ------------------------------------------------------------------------ ### **■ Final Exam is May 1 - May 6** ------------------------------------------------------------------------ #### **Session 35 -- Thursday May 7 6:30-8:30 PM ET** 1. Prof Vuduc exam results review 2. TA Walkthrough of exam solution ------------------------------------------------------------------------

Syntax	Example	Reference
# Header	Header	基本排版
- Unordered List	Unordered List
1. Ordered List	Ordered List
- [ ] Todo List	Todo List
> Blockquote	Blockquote
Bold font	Bold font
Italics font	Italics font
~~Strikethrough~~	~~Strikethrough~~
19^th^	19^th
H~2~O	H₂O
++Inserted text++	Inserted text
==Marked text==	Marked text
[link text](https:// "title")	Link
![image alt](https:// "title")	Image
`Code`	`Code`	在筆記中貼入程式碼
```javascript var i = 0; ```	`var i = 0;`
:smile:		Emoji list
{%youtube youtube_id %}	Externals
$L^aT_eX$	L^aT_eX
:::info This is a alert area. :::	This is a alert area.