Autoplay
Autocomplete
Previous Lesson
Complete and Continue
2024-2: Java, SQL, React
Installation
Course Welcome
Activity: Terminal Refresh
Lesson: Java and the JDK
(Windows-only) Activity: Install OpenJDK
(Mac-only) Activity: Install OpenJDK
Lesson: Development Tools
Lesson: Git Background
Activity: Install and Configure Git
Activity: Dev10 Set Up
Data Types and Common Statements
Introduction
Lesson: Common Syntax Elements
Exercise: Common Syntax Elements
Lesson: Data Types and Variables
Lesson: Strings
Lesson: Git Basic Workflow
Activity: Create a Dev10 Classwork Repository
Exercise: Variables and Types
Lesson: Console Input and Output
Lesson: Decisions
Exercise: Decisions
Lesson: Repetition
Exercise: Repetition
Lab: Text Adventure
Lesson: Debugging
Lesson: Methods
Exercise: Methods
Lesson: Arrays
Exercise: Arrays
Lesson: Milestone Wrap-up
Lesson: Git Intermediate Workflows
Assessment: Capsule Hotel
Object-Oriented Programming
Introduction
Lesson: Object-Oriented Programming
Lesson: Creating a Class
Lesson: Multiple Classes
Exercise: Objects
Lab: Roguelike
Lesson: Inheritance
Lesson: Interfaces
Exercise: Interfaces
Lesson: Pillars
Lesson: Packages
Lesson: Maven
Lesson: JUnit
Exercise: Stateless Unit Testing
Lesson: Stateful Unit Testing
Exercise: Stateful Unit Testing
Lesson: Lists
Exercise: Lists
Lesson: Hash-based Collections
Exercise: Hash-based Collections
Assessment: Gomoku
File I/O and Application Layers
Introduction
Lesson: Exceptions
Lesson: Enums
Exercise: Enums
Lesson: File I/O
Lab: File I/O
Lesson: Application Layers
Lesson: The Repository Pattern
Lesson: Testing the Repository
Exercise: Unexplained Encounters - Data Layer
Lesson: The Domain Layer
Lesson: Testing the Service
Exercise: Unexplained Encounters - Domain Layer
Lesson: The MVC Pattern
Lesson: Dependency Injection
Exercise: Unexplained Encounters - User Interface
Assessment: Solar Farm
Relational Databases and SQL
Introduction
Lesson: Databases
Lesson: Relational Database Management Systems
(Windows Only) Activity: Install MySQL and MySQL Workbench
(Mac Only) Activity: Install MySQL and MySQL Workbench
Lesson: SQL Data Types
Lesson: SQL Select
Lesson: SQL Sorting and Calculations
Exercise: Select
Lesson: SQL Joins
Exercise: Joins
Lesson: Aggregation
Exercise: Aggregation
Lesson: DDL
Exercise: DDL
Lesson: DML
Exercise: DML
Lesson: Normalization and Denormalization
Activity: Normalization Queries
Lab: Incremental Schema Design
Assessment: Tiny Theaters
JDBC, Functional Idioms
Introduction
Lesson: BigDecimal
Lesson: Temporal Types
Exercise: BigDecimal and Temporal Types
Lesson: Database-Driven Java
Lesson: JdbcTemplate
Lesson: JdbcTemplate Reads
Lesson: JdbcTemplate Object Graph Reads
Lesson: JdbcTemplate Create, Update, Delete
Exercise: Solar Farm Spring JDBC
Lesson: Lambdas
Lesson: Streams
Exercise: Student Streams
Assessment: Sustainable Foraging
Midterm
Introduction
Midterm Assessment: Don't Wreck My House
Spring APIs
Lesson: Internet and APIs
Lesson: HTTP, URLs, and JSON
Activity: Install VS Code REST Client Extension
Lesson: Spring
Lesson: Spring MVC and Spring Boot
Lesson: Spring MVC Annotation Dependency Injection
Lesson: Spring Controller Concepts
Exercise: Spring MVC Hodgepodge
Lab: Spring MVC Game
Lesson: Spring Boot, Spring MVC, and Spring JDBC
Lesson: @SpringBootTest, Mocking
Lesson: Spring MVC Global Error Handling
Lesson: Database Model Vs. Object Model, Transactions
Assessment: Field Agent API
Exercise: Solar Farm API
Front-end Development
Introduction
Lesson: JavaScript Tools
Lesson: JavaScript Variables, Types, Decisions, and Repetition
Exercise: JavaScript Variables, Types, Decisions, and Repetition
Lesson: JavaScript Functions
Exercise: JavaScript Functions
Lesson: JavaScript Debugging
Lesson: JavaScript Arrays
Exercise: JavaScript Arrays
Lesson: JavaScript Objects
Exercise: JavaScript Objects
Lesson: HTML and Web Accessibility
Lesson: HTML Media Elements
Lesson: HTML Table Elements
Lesson: HTML Forms
Exercise: HTML Tables and Forms
Lesson: Event-driven UIs
Lesson: JavaScript and the DOM
Lesson: JavaScript and HTML Forms
Exercise: JavaScript and the DOM
Lesson: Fetch API
Exercise: Fetch API
Lesson: CSS
Lesson: CSS Frameworks
Lesson: CSS and JavaScript
Lesson: Module Wrap-Up
Assessment: Web Field Agent Styles
React
Lesson: More JavaScript Tools
Lesson: npm
Exercise: Choose Your Own npm Adventure
Lesson: Intro to React, Vite, and JSX
Lesson: ES Modules
Lesson: Components and Props
Exercise: Components and JSX
Lesson: Bootstrap in React
Exercise: JSX, Components and Props
Lesson: React State and Conditional Rendering
Exercise: React State and UI Updates
Lab: React To-Dos
Lesson: React Router
Exercise: React Router and Multi-Page Functionality
Lesson: Forms in React
Exercise: Controlled Components and Lifting State
Lesson: `useEffect` and `fetch` Requests in React
Exercise: `useEffect` and `fetch` Requests
Lesson: Error Handling in React
Lesson: Debugging React Components
Lesson: Introduction to Testing React
Lesson: Testing React - Handling API Requests and User Interactions
Assessment: React Field Agent
Security
Introduction
Lesson: Web Application Security
Lesson: Spring Token-Based Security
Lesson: Database Driven Security
Exercise: Database Driven Security for Solar Farm Application
Lesson: React Context
Exercise: React Context for the Solar Farm Client
Lesson: React Security
Exercise: React Security
Lesson: Final Thoughts on Security
Lesson: Java Validation API
Exercise: Java Validation API
Assessment: Fans!
Intermediate SQL
Activity: Database Set Up
Lesson: Complex Joins and Aggregation
Lesson: Date Handling
Exercise: Date Handling
Lesson: Decisions
Exercise: Decisions
Lesson: Variables
Lesson: Subqueries
Exercise: Subqueries
Lesson: Set Operations
Exercise: Set Operations
Lesson: Common Table Expressions (CTEs)
Exercise: Common Table Expressions (CTEs)
Lesson: Window Functions
Exercise: Window Functions
Lesson: Views
Exercise: Views
Lesson: Stored Procedures
Exercise: Stored Procedures
Intermediate Python, Pandas
Activity: Python Basics Review
Lesson: Classes and Objects
Lesson: Special Methods and Attributes
Exercise: Objects
Lesson: Tuples
Exercise: Tuples
Lesson: Hash-Based Collections
Exercise: Hash-based Collections
Lesson: Comprehensions
Exercise: Comprehensions
Lesson: Lambda Expressions and Higher-Order Functions
Exercise: Lambdas
Lesson: Exceptions
Lesson: File I/O
Exercise: File I/O
Lesson: PyPI and `pip`
Lesson: Virtual Environments
Activity: Install Jupyter
Activity: Install "Lesson: Introduction to Pandas"
Exercise: Pandas Student Data
Lesson: ETL
Assessment: Montreal AirBnB Data Pipeline
Exercise: Common Table Expressions (CTEs)
Lesson content locked
If you're already enrolled,
you'll need to login
.
Enroll in Course to Unlock