Instructor-led 4-days

Course Description 

This 4-day course introduces learners to four widely-used programming languages—R, Python, SQL, and Java—each with unique strengths for data analysis, general-purpose development, database manipulation, and application programming. Participants will explore the syntax, structures, and typical use cases for each language. Each day includes hands-on labs that reinforce core skills through real-world coding exercises. 

Key Takeaways 

• Develop foundational coding skills across four essential programming languages 

• Identify when to use R, Python, SQL, or Java based on the task and environment 

• Write basic programs and queries, perform data analysis, and handle input/output operations 

• Gain experience with control flow, data structures, and file manipulation in each language 

• Understand best practices in writing, testing, and maintaining code across languages 

• Apply hands-on exercises to simulate real-world scenarios 

Prerequisites 

• No prior programming experience required 

• Comfort with using a computer and basic logic or math concepts 

• Optional: basic familiarity with spreadsheet software or databases 

Module 1: Python – General-Purpose Programming and Scripting 

• Introduction to Python: Philosophy, Use Cases, and Syntax 

• Variables, Data Types, and Operators 

• Lists, Dictionaries, Sets, and Tuples 

• Control Flow: if, for, while 

• Functions and Modules 

• File I/O and Working with CSV 

• Hands-On Exercises: 

• Write a script that parses a CSV file and summarizes key statistics 

• Build a calculator that supports user input and simple arithmetic operations 

Module 2: R – Data Analysis and Visualization 

• Introduction to R: Statistical and Analytical Focus 

• Vectors, Lists, Data Frames, and Matrices 

• Data Import and Cleaning with readr and dplyr 

• Visualization with ggplot2 

• Writing Functions and Using R Scripts 

• Hands-On Exercises: 

• Load a dataset, perform summary statistics, and create a bar chart 

• Use dplyr to filter, group, and summarize a dataset 

Module 3: SQL – Querying and Managing Relational Databases 

• Introduction to SQL: Relational Databases and Use Cases 

• SELECT, FROM, WHERE, GROUP BY, ORDER BY 

• JOINs: INNER, LEFT, RIGHT, and FULL 

• Subqueries and Aggregations 

• Table Creation and Data Insertion 

• Hands-On Exercises: 

• Query a sample database to find customer trends 

• Write a JOIN to combine order and product information 

• Create and populate a small table from scratch 

Module 4: Java – Object-Oriented Programming and Applications 

• Introduction to Java and the JVM 

• Syntax, Variables, Data Types, and Operators 

• Classes, Objects, and Methods 

• Loops and Conditionals 

• Exception Handling and File I/O 

• Compiling and Running Java Programs 

• Hands-On Exercises: 

• Create a class for a basic employee management system 

• Write a program that reads from a file and calculates basic metrics