Courses

Coding Foundations

course

Coding Foundations

Master all the coding skills you need to create websites, write programs, and tap into databases. You'll learn to create websites from scratch in HTML, get certified in SQL, the international standard language for databases, and specialize in Python, the world's fastest growing programming language. No previous coding experience needed.

Angular hero

What you'll learn

Basic HTML structure
Learn the basic structure of a webpage and discover how you can help a web browser understand your content
Headings, paragraphs
Make your document easy to read and SEO-friendly by adding headings and paragraphs
Text formatting
Add some style to your content with text formatting options like bold, italics, strikethrough, colors, etc.
Elements and attributes
Discover some of the most useful elements and attributes. Use them to create different formats for information
Images
A picture's worth a thousand words. Learn how to add images to your pages
Lists and tables
Display more complicated data using lists and tables
Forms and frames
Use forms to capture user information
Audio and video elements
Bring your pages to life using audio and video elements
Canvas
Make your own artwork by using Canvas to render 2D shapes and patterns
Database structures
Before you learn more about SQL we?ll help you understand how data is stored in a database.
SQL queries
Select, sort and identify data from a database using SQL queries.
Where command and logical conditions
Use where command and logical conditions to filter data.
Aggregation functions
Group data with aggregation functions.
Tables
Create tables by adding, updating and removing data.
Foundational concepts
Master foundational concepts of coding with Python. These are the building blocks for everything else
Strings
Understand how to work with strings to store text data and handle special characters
User inputs
Make your programs interactive by taking and working with user inputs
Variables
Use variables to help your program store data
"If" and "Else" statements
Start shaping the flow and purpose of your program with "if" and "else" conditional statements
Lists
Create and operate with lists to store multiple items into a single variable. This means you can handle more types of data
Functions
Keep your code efficient and manageable using built-in functions and your own custom functions
illustration
Coding Foundations
Coding Foundations
Master all the coding skills you need to create websites, write programs, and tap into databases. You’ll learn to create websites from scratch in HTML, get certified in SQL, the international standard language for databases, and specialize in Python, the world’s fastest growing programming language. No previous coding experience needed.

Getting Started with HTML

widgetImg
Lesson
The Core Web Technology
widgetImg
Lesson
HTML Code
widgetImg
Lesson
Headings
widgetImg
Lesson
Images
widgetImg
Lesson
Landing Page Project
widgetImg
Quiz
Module 1 Quiz

Going Deeper with HTML

widgetImg
Lesson
Commenting Code
widgetImg
Lesson
Standards & Best Practices
widgetImg
Lesson
Text Formatting
widgetImg
Lesson
HyperText
widgetImg
Lesson
Lists
widgetImg
Lesson
Landing Page Project
widgetImg
Quiz
Module 2 Quiz

Using Attributes

widgetImg
Lesson
Attributes
widgetImg
Lesson
Website Navigation
widgetImg
Lesson
Forms
widgetImg
Lesson
Form Data
widgetImg
Lesson
Drop-Down Menu
widgetImg
Lesson
Landing Page Project
widgetImg
Quiz
Module 3 Quiz

Mastering HTML

widgetImg
Lesson
Videos
widgetImg
Lesson
Audio Media
widgetImg
Lesson
Page Layout
widgetImg
Lesson
More on Layout
widgetImg
Lesson
The Style Attribute
widgetImg
Lesson
Inline and Block Elements
widgetImg
Lesson
Content Division
widgetImg
Lesson
Tables
widgetImg
Lesson
Introduction to JavaScript
widgetImg
Lesson
Landing Page Project
widgetImg
Quiz
Module 4 Quiz

Getting Started with SQL

widgetImg
Lesson
Working with Data
widgetImg
Lesson
Running SQL Queries
widgetImg
Lesson
Relational Databases
widgetImg
Lesson
Debugging
widgetImg
Practice
Box Office
widgetImg
Practice
Store Inventory
widgetImg
Quiz
Module 5 Quiz

Going Deeper with SQL

widgetImg
Lesson
Standards & Best Practices
widgetImg
Lesson
Sorting Data
widgetImg
Practice
Employee Salary
widgetImg
Practice
Student Grade
widgetImg
Lesson
Limiting Data
widgetImg
Practice
Menu
widgetImg
Practice
Giveaway!
widgetImg
Lesson
Data Types
widgetImg
Practice
Tennis Tournament
widgetImg
Lesson
Filtering Data
widgetImg
Practice
Online Bookstore
widgetImg
Practice
Movie Ratings
widgetImg
Quiz
Module 6 Quiz

Query Techniques

widgetImg
Lesson
Pattern Matching
widgetImg
Practice
Chocolate!
widgetImg
Lesson
Advanced Pattern Matching
widgetImg
Practice
Music and Love!
widgetImg
Lesson
SQL Conditions
widgetImg
Practice
Select your Car
widgetImg
Practice
Grocery Store
widgetImg
Lesson
Data Aggregation
widgetImg
Lesson
Mixing Things Up
widgetImg
Quiz
Module 7 Quiz

Data Analysis

widgetImg
Lesson
Analyzing Data
widgetImg
Lesson
Grouping
widgetImg
Practice
Social Media Posts
widgetImg
Lesson
Grouping and Filtering
widgetImg
Practice
Sports League
widgetImg
Lesson
Cleaning Data
widgetImg
Practice
Teacher Data
widgetImg
Lesson
Fixing Data Types
widgetImg
Lesson
Making Sense of Data
widgetImg
Practice
Theater Management
widgetImg
Quiz
Module 8 Quiz

Getting started with Python

widgetImg
Lesson
Writing Code
widgetImg
Lesson
Memory & Variables
widgetImg
Lesson
Text Data
widgetImg
Lesson
Numerical Data
widgetImg
Practice
Game Messages
widgetImg
Lesson
Working with Variables
widgetImg
Practice
Shopping Prices
widgetImg
Practice
The Semester Grade
widgetImg
Quiz
Module 9 Quiz

Going Deeper with Python

widgetImg
Lesson
Debugging
widgetImg
Practice
And the Winner is …
widgetImg
Lesson
Standards and Best Practices
widgetImg
Practice
Flight Tracker
widgetImg
Practice
Snowflake
widgetImg
Lesson
Applying Best Practices
widgetImg
Practice
It’s Payday!
widgetImg
Lesson
Inputs and Outputs
widgetImg
Practice
Chatbot v1.0
widgetImg
Practice
Messaging App
widgetImg
Lesson
Data Types
widgetImg
Practice
Chatbot v1.1
widgetImg
Quiz
Module 10 Quiz

Working with Data

widgetImg
Lesson
Data Type Checking
widgetImg
Lesson
Data Conversion
widgetImg
Practice
Finance App
widgetImg
Practice
Chess Tournament
widgetImg
Lesson
Fixing Data Types
widgetImg
Lesson
Comparison Operations
widgetImg
Practice
Level Up!
widgetImg
Lesson
Logical Operations
widgetImg
Lesson
Combining Comparison and Logical Operations
widgetImg
Practice
Fitness Goals!
widgetImg
Practice
Houston, we've had a problem.
widgetImg
Quiz
Module 11 Quiz

Control Flow

widgetImg
Lesson
Control Flow
widgetImg
Lesson
For Loops
widgetImg
Practice
Fasten your Seat Belt
widgetImg
Lesson
While Loops
widgetImg
Practice
Time's Up!
widgetImg
Practice
Cell Growth
widgetImg
Lesson
More on Iteration
widgetImg
Lesson
Conditional Statements
widgetImg
Practice
Smart Parking Lot
widgetImg
Lesson
More on Conditional Statements
widgetImg
Practice
Medical Software
widgetImg
Quiz
Module 12 Quiz

Working with Lists

widgetImg
Lesson
Lists
widgetImg
Lesson
Indexing
widgetImg
Practice
Game Machine
widgetImg
Lesson
Using Indexing
widgetImg
Practice
Pancakes
widgetImg
Lesson
Slicing
widgetImg
Practice
Relay Race
widgetImg
Lesson
Using Slicing
widgetImg
Lesson
Advanced Slicing and Indexing
widgetImg
Practice
Step Counter
widgetImg
Quiz
Module 13 Quiz

Functions

widgetImg
Lesson
Functions
widgetImg
Lesson
Function Arguments
widgetImg
Lesson
String Functions
widgetImg
Practice
Survey Data Format
widgetImg
Lesson
List Functions
widgetImg
Practice
Queue Management
widgetImg
Lesson
Custom Functions
widgetImg
Practice
Shipping cost
widgetImg
Lesson
More on Custom Functions
widgetImg
Practice
Hashtag Generator
widgetImg
Quiz
Module 14 Quiz
certificate

Your Certificate is close

You are doing great! Keep learning to unlock your certificate!

Blog

blog
CHEAT SHEET: How To Comment In HTML
By properly employing HTML comments, you can explain the choices you made to a colleague reviewing your code and make necessary adjustments or bugs that need fixing easier for others to see. This is an essential 'best practice' among experienced HTML programmers and one that you'll need to master to work as part of a team or bring people on board your own projects. So how do you do it? Let's walk through the basics and essential steps you will need.
Continue reading on our blog
blog
What Is SQL Used For?
SQL is the commonly used acronym for Structured Query Language, the standard language for relational database management systems. SQL traces its origins all the way back to 1973, when it was initially created by a team at IBM to manipulate and retrieve the data stored in their system at the time.
Continue reading on our blog
blog
10 Reasons To Learn Python Right Now
From a beginner language just a few years ago to one of the most popular and versatile languages in the world today, Python is everywhere. Long...
Continue reading on our blog