- Open Terminal
- Update package list: sudo apt update
- Install MySQL Server: sudo apt install mysql-server
- During installation, set a root password when prompted
- Install MySQL Workbench: sudo snap install mysql-workbench-community
- Open MySQL Workbench from your applications menu
- Click “Local instance” and enter your root password to connect
- Development Platforms
- Design 1,Web and Communications Technology,HTML and CSS,Project Methodology,Programming Foundations,JavaScript 1,Interaction Design,Content Management Systems,CSS Frameworks,JavaScript 2,Workflow,Industry Knowledge,Development Platforms
-
Module 1
- Overview
-
Lesson 1
- Introduction to Backend Development
- Understanding APIs
- Data Storage Overview
- Practical Networking Concepts
- Introduction to Node.js
- TypeScript
- Basic Types
- Interfaces
- Function Typing
- Type Aliases and Unions
- API Response Patterns
- Async/Await
- Generics
- Converting JavaScript to TypeScript
- TypeScript Approach in This Course
- Lesson Tasks
- Lesson 2
- Lesson 3
-
Lesson 4
- Building on Previous Lessons
- HTTP Methods Summary
- Setting Up Our User API
- A Note on Validation and Security
- POST - Creating New Resources
- Debugging
- Adding Authentication to Write Operations
- PUT - Replacing Entire Resources
- PATCH - Updating Parts of Resources
- DELETE - Removing Resources
- HTTP Status Codes Summary
- Key Takeaways
- Lesson Tasks
- Module 1 Study Task
-
Module 2
- Overview
-
Lesson 1
- What is a Database?
- SQL vs NoSQL
- Installing MySQL and Workbench
- Installing MySQL and Workbench on Windows
- Installing MySQL and Workbench on Mac
- Installing MySQL and Workbench on Linux
- Connecting to MySQL from Workbench
- Create Your First Database
- Create a Table
- Viewing Data with SELECT
- Adding Data with INSERT
- Modifying Data with UPDATE
- Removing Data with DELETE
- What Does “Relational” Mean?
- What Is a Schema?
- Advanced SELECT - Filtering, Sorting, and Limiting
- Modifying Tables with ALTER TABLE
- Destructive Commands - DROP TABLE and DROP DATABASE
- Exporting a Database
- Lesson Tasks
- Lesson 2
- Lesson 3
- Lesson 4
- Module 2 Study Task
- Module 3
- Course Assignment