Introduction

Your First Python Program

How Long It Takes To Learn Python

Receiving Input

Type Conversion

Formatted Strings

Arithmetic Operations

Math Functions

Logical Operators

Weight Converter Program

Building a Guessing Game

For Loops

Lists

My Complete Python Course

Tuples

Dictionaries

Functions

Keyword Arguments

Creating a Reusable Function

Comments

Constructors

Modules

Generating Random Values

Pypi and Pip

Project 3: Building a Website with Django

Introduction

What is SQL?

Installing MySQL on Mac

Installing MySQL on Windows

The SELECT Statement

The WHERE Clause

The AND, OR, and NOT Operators

The BETWEEN Operator

The REGEXP Operator

The IS NULL Operator

The LIMIT Operator

Inner Joins

Self Joins

Compound Join Conditions

Implicit Join Syntax

Outer Join Between Multiple Tables

The USING Clause

Natural Joins

Unions

Column Attributes

Inserting Multiple Rows

Creating a Copy of a Table

Updating a Single Row

Using Subqueries in Updates

Restoring Course Databases

Introduction

Installing Python & PyCharm

Setup & Hello World

Variables & Data Types

Working With Strings

Getting Input From Users

Building a Basic Calculator

Mad Libs Game

List Functions

Tuples

Return Statement

If Statements

Building a better Calculator

Dictionaries

While Loop

For Loops

Exponent Function

Building a Translator

Comments

Try / Except

Writing to Files

Modules & Pip

Building a Multiple Choice Quiz

Object Functions

Python Interpreter

Start

Introduction

Overview

Customizing the Interface

Navigation

Creating New Documents

Overview of the Pages Panel

Creating Posters

Working with Images (Part 1)

Working with Images (Part 2)

Creating an Image Grid

Aligning Objects

Working with Links

Image Effects and Eyedropper

Object Styles

Placing Text from Word

Text Threads and Hidden Characters

Paragraph Styles

Bullets, Numbering, and Paragraph Styles

Character Styles

Working with Color and Swatches

Working Gradients

Master Pages

Preferences, Spellcheck, and Display Performance

Conclusion

Introduction

What is SQL?

Installing MySQL on Mac

Installing MySQL on Windows

The SELECT Statement

The WHERE Clause

The AND, OR, and NOT Operators

The BETWEEN Operator

The REGEXP Operator

The IS NULL Operator

The LIMIT Operator

Inner Joins

Self Joins

Compound Join Conditions

Implicit Join Syntax

Outer Join Between Multiple Tables

The USING Clause

Natural Joins

Unions

Column Attributes

Inserting Multiple Rows

Creating a Copy of a Table

Updating a Single Row

Using Subqueries in Updates

Restoring Course Databases

Start

Opening a Sample Database

The Database Objects

Introducing Tables

Simple Data Entry

Introducing Queries

Introducing Forms

Data Entry Into Forms

Introducing Reports

Finding Data in Tables

Filtering

Adding Total Rows

Creating Tables in Design View

Entering Your First Record

Using Quick Starts to Create Tables

Summary

Introduction

Looking at the First Draft of a Database

The Relationships Window

Relating by Dragging Field Names

Dragging to Create 1-to-1 Relationships

Limit-To-List Properties

Enforced Referential Integrity

Seeing the Referential Integrity Being Enforced

More Field Properties

Intro

Chapter 1 - Getting Started

Chapter 2 - Head Element

Chapter 3 - Text Basics

Chapter 4 - List Types

Chapter 5 - Add Links

Chapter 6 - Add Images

Chapter 7 - Semantic Tags

Chapter 8 - Create Tables

Chapter 9 - Forms & Inputs

Chapter 10 - HTML Project

Introduction

Windows Setup

Mac Setup

Hello World

Drawing a Shape

Data Types

Printf

Working With Numbers

Comments

Constants

Building a Basic Calculator

Building a Mad Libs Game

Arrays

Functions

Return Statement

Building a Better Calculator

Switch Statements

Structs

While Loops

Building a Guessing Game

2D Arrays & Nested Loops

Memory Addresses

Pointers

Dereferencing Pointers

Reading Files

Introduction

Installation & Setup

Drawing a Shape

Variables

Working With Strings

Working With Numbers

Getting User Input

Building a Calculator

Arrays

Methods

Return Statement

If Statements

Building a Better Calculator

Switch Statements

While Loops

Building a Guessing Game

Building an Exponent Method

2d Arrays

Comments

Exception Handling

Constructors

Object Methods

Getters & Setters

Static Class Attributes

Inheritance

Intro

Chapter 1: Start Here

Chapter 2: Selectors

Chapter 3: Colors

Chapter 4: Units & Sizes

Chapter 5: Box Model

Chapter 6: Typography

Chapter 7: Styling Links

Chapter 8: List Styles

Chapter 9: Mini Project

Chapter 10: Display

Chapter 11: Floats

Chapter 12: Columns

Chapter 13: Position

Chapter 14: Flexbox

Chapter 15: Grid Layout

Chapter 16: Images

Chapter 17: Media Queries

Chapter 18: Card Project

Chapter 19: Pseudo

Chapter 20: Variables

Chapter 21: Functions

Chapter 22: Animations

Chapter 23: Organization

Chapter 24: Final Project