SQL 101: Introduction to Database Queries

Mark Florian, Software Developer

Play Speed
  • 0.5x
  • 1x (Normal)
  • 1.25x
  • 1.5x
  • 2x
12 Videos (1h 29m)
    • Trailer

      0:55
    • What is SQL?

      6:27
    • Installing SQLite Manager and creating our database

      3:34
    • Creating tables and inserting data into tables

      Lesson3_CreateInsertData.txt
      6:01
    • Single Table Queries (Simple)

      Lesson4_Exercises_Simple.txt
      9:24
    • Solutions: Single Table Queries (Simple)

      Lesson4_Solutions_Simple.txt
      5:16
    • Single Table Queries (Advanced)

      Lesson5_Exercises.txt
      9:52
    • Solutions: Single Table Queries (Advanced)

      Lesson5_Solutions.txt
      7:08
    • Joins

      Lesson6_Examples.txt
      Lesson6_Exercises.txt
      13:38
    • Solutions: Joins

      Lesson6_Solutions.txt
      9:13
    • Subqueries

      Lesson7_Examples.txt
      Lesson7_Exercises.txt
      7:43
    • Solutions: Subqueries

      Lesson7_Solutions.txt
      10:09
24 students are watching this class

About This Class

SQL is the database language that allows you to understand the data behind almost every website and internet company.

I've been at a tech company for a couple years and have learned one universal truth: data rules all. The most common request I get as a software engineer is to "pull some data" from our database. What I've realized is that about 95% of these requests involve a very basic query that could be performed by any one of my colleagues.

With the information in this class, you'll be better able to understand, access, and measure your user data and behavior. Whether you are an entrepreneur, analyst, or marketer, SQL can help you execute smarter and faster! 

49f7375a

What You'll Learn

  • SQL Fundamentals. We will talk about relational databases and what SQL can do with a relational database.
  • Setting Up Our Environments. We will set up our environments so that we can run SQL commands together.
  • Creating Data. You will create your own table and populate it with data.
  • Single Table Queries. We will cover the basics that will allow you to pull any combination of information from a single table, including FROM, WHERE, GROUP BY, COUNT, SUM, HAVING, SELECT, and ORDER BY.
  • Joins. We will cover Joins and how they are important for defining relational data between tables.
  • Subqueries. You will convert Joins into equivalent subqueries.

The Project

  • Deliverable. Your final project will be to create a database and query it in SQL.
  • Guiding Questions. What kind of data will you create? How will you categorize this data? How will your data sets relate to each other? What is the correct way to retrieve data? 
  • Collaboration. Ask your fellow classmates for feedback on your data set. How could you create more precise data points? What retrieval methods work best for solving your queries from their perspective?

By the end of the course, you will have created your own query-searchable database using SQLite, and you'll be able to edit and query data on your own.

Let's get started! 

80 of 83 students recommendSee All

The Classes are very intuitive and really help to understand the basics of SQL. Plus the exercises will leave you with a good taste of what your capable of doing alone when you try to find diferent answers to what is asked. Just wished for some more advanced classes (but as the title says, its SQL 101) My advice is " You really should try this Lessons" just to know something more
Good intro class, easy to follow, and the exercises are very helpful. But there were a few things not covered, like deleting and updating entries.
I liked this class as an introduction to SQLite. While there are a few minor gaps between what Mark teaches in the videos and what he asks of the student in the homework, this had the result of challenging me to think outside the box a little and try different things. Other than the little gaps, Mark's explanations are clear for each step. The amount of information in each video is about the right size to be able to take some skills, apply them, and build with the next video, without being overwhelming. I am glad that this was the first video I watched to begin learning to query.

1,630

Students

2

Projects

Mark Florian

Software Developer

I am a full-stack engineer for a tech startup in New York. While I develop for more than just the data layer of an application, I find that database knowledge is the most valuable for someone in a non-technical or analytics role. I have taught dozens of students and colleagues the basics of SQL to enable them to work more efficiently, and I'm excited to share this knowledge with a wider audience.

See full profile

Technology Web Development Data Science