LMC 3403 - Interactive Instructional Guide

Introduction to SQL

Interactive Instructional Guide

GET STARTED!

Overview

Lesson Summary and Objectives

Imagine you have a database full of employee records, including job titles, salaries, and department assignments. How can you quickly find all employees in a specific department or filter for those earning above a certain salary? That's where SQL comes in - giving you the power to efficiently query, analyze, and organize data in just a few commands!

Overview

Lesson Summary and Objectives

Objectives

Understand what SQL is and why it is essential fordata managementWrite and execute simple SQL queriesExplore relationships in aggregated data to analyze trends and extract meaningful insightsPractice hands-on with a sample database to reinforce your learning

🔍 WHY SQL?

Overview

Lesson Summary and Objectives

Target Audience

If you're someone who...

🧠

Is new to programming or data anlysis and wants to learn how to work with databasesCurious to write and exeute queries to extract insights from data effectively

🧠

Prerequisites

You don't need any prior SQL experience to get started! However, it's useful if you...

Are comfortable with basic computer operationsHave a general understanding of how data is structured

💡

💡

Index

Getting Started

Set Up Your Environment

Sample Database

Working Example

Overview

Lesson Summary

Quiz

Test Your Knowledge

SQL Basics

Learn Simple Queries

Hands-On Exercise

Perform Queries

Getting Started

Set Up Your Environment

Getting Started

Set Up Your Environment

What is SQL?

Structured Query Language

SQL is the standard language used to store, retrieve, and manipulate data in relational databases. Think of it as a way to ask questions about your data and get meaningful answers fast!

💡 LEARN MORE

Getting Started

Set Up Your Environment

💡 Before writing SQL queries, let's set up your workspace!

Option 1: Use an Online SQL Editor

If you don't want to install anything, try an online SQL sandbox:

SQL Tutorial

SQL Fiddle

SQL Online Compiler

Option 2: Install a Local RDBMS

RECOMMENDED

Want a more hands-on experience? Choose a relational database management system (RDBMS):

MySQL Workbench

PostgreSQL

Sample Database

Get Familiar with a Working Example

Sample Database

Get Familiar with a Working Example

💡 To make learning SQL hands-on, we'll be working with a sample database!

Human Resources (HR)

Sample Database

The HR database tracks employees, their jobs, departments, and locations. You'll use SQL to explore relationships between them!

📈 VIEW SCHEMA

SQL Basics

Learn Simple SQL Queries

SQL Basics

Learn Simple SQL Queries

Selecting Data From a Table

When working with databases, you'll often need to retrieve specific information.

SELECT specifies which columns you want

FROM specifies which table to pull the data from

SQL Basics

Learn Simple SQL Queries

Filtering Results From a Table

Sometimes, you don't want all the data just the rows that match specific conditions.

WHERE specifies condition(s) to filter the results

SQL Basics

Learn Simple SQL Queries

Sorting and Limiting Results

Once we've filtered our data, we might want to sort it in a meaningful way or limit how many results we see.

ORDER BY lets you sort reslts in ascending or descending

LIMIT lets you restrict how many rows are returned

SQL Basics

Learn Simple SQL Queries

Filtering Aggregated Data

So far, we've learned how to filter individual rows, but we might want to group similar data together and apply calculations.

GROUP BY groups rows that have the same values in specified columns

HAVING lets you filter groups after aggregation

Hands-On Exercise

Let's Practice Some Queries!

Hands-On Exercise

Practice Queries

Task 3

Task 2

Task 1

Count the number of employees in each department

Find the highest-paid employee in the company

List all employees department 5, ordered by salary

✨ VIEW ANSWER

✨ VIEW ANSWER

✨ VIEW ANSWER

Quiz

Let's Test Your Knowledge!

Question 1/5

Select the correct answer.

Question 2/5

Select the correct answer.

Question 3/5

Select the correct answer.

Question 4/5

Select the correct answer.

Question 5/5

Select the correct answer.

Next Steps

Explore More Complex SQL Queries

Learn Stored Procedures

Learn Subqueries

Learn Joins

Lesson Completed!

Do you have an idea?

Let the communication flow!

With Genially templates you can includevisual resources to leave your audience amazed. You can also highlight a phrase or specific piece of information that will be engraved in your audience's memory and even embed external content that surprises: videos, photos, audios... Whatever you want! Need more reasons to create dynamic content? Well: 90% of the information we assimilate comes through the eyes, and we retain 42% more information when the content moves.

• Generate experiences with your content.
• It has a WOW effect. Very WOW.
• Make your audience remember the message.
• Activate and surprise your audience.

Why SQL? 🤔

Data is everywhere - whether it's tracking employee records, managing customer orders, or analyzing social media trends. SQL is the standard langague used to store, retrieve, and manipulate data in relational databases. Imagine you're managing an online store. You want to check which products are selling the most. With SQL, you can write simple yet powerful queries to answer such questions in seconds! Instead of manually sorting through spreadsheets, SQL helps you efficiently extract insights from massive datasets.