Digital Literacy at CBS

Course Progress

HTML & CSS — Cookie Monster Lesson

1. Party Tips! HTML is the Structure of your Page

Code along with me! I'll introduce you to some basic HTML and CSS concepts. And I'll kiss my arm.

2. Party Tips: CSS is the Style

Let's add some colors to our project

3. Party Tips! Learn more HTML!

Whats the difference between h1 and h2 tags? When do we use p tags? In this lesson you will learn some of the most important HTML elements.

4. Party Tips! Adding Images with HTML

Images are beautiful. Let's bring some into our website!

5. C is for Cookie Monster

Let's start building our portfolio site

6. First add your Text

Feeling overwhelmed when you start building a website from scratch? Try to use a template. And start with the HTML (text, and images) first. Let me show you how I do it!

7. HTML Links

In 1965, Ted Nelson coined the term hyperlink. That's almost 30 years before Tim Berners Lee invented HTML and the World Wide Web. I'm a New Media geek, ask me questions if you'd like to hear more about where the web came from!

8. How to Add images with HTML

In this lesson you will learn how to add images to you're HTML project using the <img> (image) tag. The image tag does not have a closing tag. When we add an image with HTML we add the "src" (source) attribute to tell the website where the image is located. And than we add the "alt" (alternative text) attribute to describe the image.

9. Write Better CSS with External Style Sheets

We want to separate each coding language into its own file. That will help keep us organized.

10. Understanding Digital Color

Let's add in some glorious color.

11. Finish the Cookie Monster Portfolio

Padding, border-radius, text-decoration, and adding images with CSS

12. Make Your Own Portfolio

Make an HTML portfolio site for yourself! Add a new background image (using CSS), embed a video from YouTube, choose your own color palette, and more.

SQL

1. Download Course Files

Please download all the course files and put them on your desktop. You're going to need these in order to follow along with the rest of the course.

2. How to IMPORT Data into a Database

This week, you’ll get hands-on experience writing and executing SQL commands. We’ll start the first lesson of the week by getting familiar with the phpMyAdmin user interface. We’ll then import some data into our database. Along the way, I’ll show you how to troubleshoot one of the most common errors that you’ll likely run into when importing data.

3. How to EXPORT Data from a Database

In the last lesson, we imported data into our database. In this lesson, I’ll show you how to export data from a MySQL database. Knowing how to export data is useful if you want to back up your database, or if you want to use the same SQL commands for different applications.

4. SQL SELECT Statements

There are four things that you can do with data: you can create new data, read existing data, update data, and delete data. These four operations are commonly referred to as CRUD (Create, Read, Update and Delete), or in SQL talk: INSERT, SELECT, UPDATE and DELETE. If that sounds confusing, don’t worry. In this lesson, I’ll help you become a CRUD pro. Let’s get started with the SELECT statement — which retrieves data from a database.

5. Using a SELECT Statement on Big Data

When dealing with big data (i.e., enormous data sets), you need an efficient way to navigate the data. SQL clauses like FROM, WHERE, ORDER BY, LIMIT, GROUP BY, HAVING, DISTINCT make the process of getting to the data that you need much more efficient. In the next few lessons, we’ll look at how to use some of these clauses to filter, sort, and limit the size of returned data.

6. SQL SELECT LIMIT

In this lesson, we’ll look at the LIMIT, OFFSET, and ORDER BY clauses. LIMIT is used to retrieve a portion of rows returned by a query. Use the LIMIT keyword to restrict the number of results that are returned. You can also use the OFFSET command to specify the number of rows that should be skipped in the returned results.

7. SQL WHERE

The WHERE clause is used to filter records according to certain conditions. Conditions are statements that are either true or false. The database evaluates the conditions across all the rows and returns only the rows that fulfill the conditions. Conditional statements use different operators to evaluate data. Examples of these are = (equality), <> (non-equality), != (non-equality), < (less than), <= (less than or equal), > (greater than), >= (greater than or equal), !> (not greater than), BETWEEN, IS NULL, AND, and OR.

8. SQL LIKE

The LIKE keyword is used in a WHERE clause to search for a specified pattern in a column. You can use wildcards (for example, a % represents unknown characters) to search through lots of data to find patterns, words that are close to or similar to those you are searching for.

9. AGGREGATE OPERATORS in SQL

In this lesson, we’ll look at SQL aggregate functions. Aggregate functions perform a calculation on a set of values and return a single value. Some commonly used SQL aggregate functions are: -AVG: calculates the average of a set of values -COUNT: counts rows in a specified table or view -MIN: gets the minimum value in a set of values -MAX: gets the maximum value in a set of values -SUM: calculates the sum of values

10. How PHP and Python Scripts Use SQL

Let’s take a brief pause from learning SQL commands to look at how these commands are used in a typical web application. In this lesson, we’ll go behind the scenes to look at a fully-formed web application that uses SQL on the backend to access the database.

11. SQL Code Quiz!

Time to test your knowledge of what we’ve covered so far! In this lesson, we’ll import some data into a database and try writing SQL commands that return a subset of data described in the presented quiz challenges. I strongly recommend you do the quiz before moving on to the next lesson. Practicing is the best way to retain what you’ve just learned. It also reveals gaps in your knowledge of a covered topic and shows you what lessons you might need to rewatch. If you get stuck on any of the quiz challenges, you’re free to use Google for help! If you are completely stuck, no worries, we go through the solutions in the next lesson.

12. Answers to the SQL Code Quiz

Let’s go through the solutions to the SQL quiz together. Here are the answers.

13. SQL INSERT INTO

The INSERT INTO statement is used to add new data to a database. An INSERT INTO statement can contain values for some or all of its columns. If you aren’t adding values for all the columns in a table, you have to specify the columns you want values to be added to. Let’s learn about SQL’s INSERT INTO command together.

14. SQL UPDATE Statement

The UPDATE statement is used to modify existing database records. You can use it to modify one or more records in a table. When you use UPDATE, you’ll always use the WHERE clause. If you forget to do this and omit the WHERE clause in an UPDATE statement, all records in the table will be updated! YIKES!!!

15. SQL DELETE Statement

The DELETE statement is used to remove records from a table permanently. It can be used to delete one or more records in a table. The WHERE clause can be used with the statement to target specific data for deletion. Let’s carefully delete “Florida” from our data.

16. CRUD Examples

In this lesson, we dive deeper into CRUD operations (Create, Read, Update, and Delete) and take a look at examples of these operations in use in a web application.

Getting Setup with MAMP

1. Why Do We Need a Server?

In this video, I'm going to show you why we need a server. MYSQL is the database we use in this class. Before you can use MYSQL, you’re going to have to install a server. A hosting service like Hostgator does this for you in the cloud. An application like MAMP runs a server (and a database) locally on your computer.

2. How to Install MAMP (Mac or Windows)

Would you prefer to use MAMP? In this video, I'll show you how to install and use MAMP on either your Mac or Windows machine. MAMP will give you the ability to run a database on your computer and serve up backend coding files like PHP.

3. MySQL with MAMP

If you installed MAMP correctly and you are at localhost:8.8.8.8, you are ready to set up MYSQL on your computer. Let me take you through the process of setting up a new database on your computer.

4. MAMP as a Server

With MAMP you are literally running a server on your computer (pretty cool, eh?). In this video, I'll show you a few more tips and tricks for getting the most out of your local MAMP server. Whether you're new to coding, or more advanced, it doesn't matter — this should be helpful for everyone.