Go over the following sections of the HTML5 Tutorial

• Introduction
• Editors
• Basic
• Elements
• Attributes
• Headings
• Paragraphs
• Styles
• Formatting
• Comments
• Links
• Images
• Forms
• Form Elements
• Input Types

Python

• Learn about Modules and Packages

Flask

• The Flask Mega-Tutorial introduces Flask development with step-by-step instructions for building a microblogging application using Python and Flask. For this week, you only need to go over the first 2 sections of the tutorial.
  • Part 1: Installation and "Hello World!" example
  • Part 2: Templates
• Read the following sections from the Flask Quickstart page:
  • Routing
  • Static Files
  • Rendering Templates
  • The Request Object
  • Cookies
  • Redirects and Errors
  • About Responses
  • Sessions

Install the following software:

• MySQL Community Server
• MySQL Workbench

• Chapter 2: Database Basics
• Chapter 27:Using MySQL Workbench to Execute SQL Queries and Create SQL Scripts
• Chapter 8: Creating Databases and Tables Using SQL Commands
• Chapter 10: Inserting Data into a MySQL Database
  Only sections:
  • 10.1: The Basics of Data Insertion
  • 10.2: Inserting a Complete Row
• Chapter 11:Updating and Deleting MySQL Data
• Chapter 12: Retrieving Data From a MySQL Database
  Only sections:
  • 12.1: Retrieving a Single Column
  • 12.2: Using SELECT to Retrieve Multiple Columns
• Chapter 14: Using WHERE to Filter MySQL Data
• Chapter 15: Advanced MySQL Data Filtering - AND, OR, NOT and IN
• Chapter 18: Joining Tables in MySQL
  Only sections:
  • 18.1: How Does a Join Work?
  • 18.2: Performing a Cross-Join
  • 18.3: Equi-Join (aka the Inner Join)

Python MySQL Connector

• Introduction
• Connecting to MySQL
• Querying Data
• Inserting Data