Beginner's Introduction to SQL and Databases

In the course introduction, I summarize what the course contents consist of and who the target audience is. Check out this video to determine if this course is for you!

In this section, we choose a software to connect to our database. This software selected works across Linux, Mac and Windows systems!

In this video, we walk through connecting to our database, by entering the host and credentials for the database we are connecting to.

Taking a brief moment to ensure you have the database connection properties down for future use.

In this video we take a look at what database tables are and draw some comparison between Excel worksheets and tables.

In this video, we go through the process of creating a database table.

In this lecture, we look at one of the ways we load data into a table.

Let's practice inserting records

This video takes a looks at what data types are and why they matter in when creating tables.

So, this video should of taken place prior to the create table video, but if you haven't already figured it out, you cannot have 2 tables by the same name. So, this is where dropping a table comes into play!

We're ready to see the contents of our table. Now we'll begin to use the most commonly used SQL statement, the SELECT statement.

Figuring out how many records exists in our table and FAST!

With the same connection you established, you will find that you have access to another database with a different set of tables! These are the tables that we will be using the remainder of the course!

We don't always need to see all our records, previewing a sample of the records is the norm and you achieve that using the LIMIT keyword. Check it out.

We're going to filter for records based on certain conditions and revisit data types.

We'll start using other operators

We answer the question, "What if we want to filter for records within a range?".

Here, we combine our new filtering concepts to our earlier count function.

Data doesn't always have to meet all conditions as seen with "AND", it can also meet one condition or another, as we see with "OR"

We learn how to sort our data so we can visually process and digest our information

Nifty shortcut for ordering columns

Let's find records based on matching criteria

Now we want to exclude records based on matching criteria

Here we take a look at filtering based on a set of hard coded values in an efficient manner

MIN function helps us know what the smallest value and MAX the largest value for any given field

Let's do some fun calculations and rounding, because, at the end of the day, the computer should do the work!

Thank you for watching. I do have to keep my content short, but I will be back with a sequel (pun intended) to finish introducing us to other concepts of SQL such as JOINS.