YoVDO

SQL Basics Course (How To)

Offered By: Treehouse

Tags

SQL Courses Relational Databases Courses Data Filtering Courses SELECT Statements Courses

Course Description

Overview

In SQL Basics, we’ll take a look at what databases are and how you can retrieve information from them. Databases can store massive amounts of information to be retrieved at a later date. Databases act as the memory for dynamic web sites or mobile apps.

What you'll learn

  • Write SELECT statement to query data from a relational database
  • Select specific columns
  • Searching tables using `WHERE`
  • Filter by comparing values

Syllabus

Data, Databases and SQL

We'll take a look at databases, the types of structures inside them, what data is and what SQL is.

Chevron 6 steps
  • Why This Course?

    1:08

  • Data is Everywhere

    3:21

  • Talking to Databases with SQL

    2:40

  • Organizing Data with Databases

    2:58

  • Types of Data

    2:45

  • Data, Databases and SQL Review

    8 questions

Getting Data from a Database

Reading information is the most common operation performed on a database. Whether you're a Business Analyst, Web Developer or Mobile App developer reading from databases is a must-have skill.

Chevron 9 steps
  • Tools We'll be Using

    3:57

  • Your First SQL Statement

    4:01

  • Selecting All Information From a Table

    5 objectives

  • Retrieving Specific Columns of Information

    2:53

  • Retrieving Specific Columns of Information

    5 objectives

  • Categorizing Your Output with 'AS'

    4:33

  • Categorizing Your Output with 'AS'

    4 objectives

  • Review & Practice with SQL Playgrounds

    1:50

  • Getting Data From a Database Review

    8 questions

Finding the Data You Want

Getting all the information back at once isn't always what you want. Finding the desired information by writing specialized SQL queries is the way to do it.

Chevron 19 steps
  • Searching Tables with 'WHERE'

    7:27

  • Searching Tables with 'WHERE'

    3 objectives

  • Filtering by Comparing Values

    3:58

  • Filtering by Comparing Values

    3 objectives

  • Filtering on More than One Condition

    2:51

  • Filtering on More than One Condition

    2 objectives

  • Filtering by Dates

    2:30

  • Filtering by Dates

    1 objective

  • Searching Within a Set of Values

    2:35

  • Searching Within a Set of Values

    2 objectives

  • Searching Within a Range of Values

    2:57

  • Searching Within a Range of Values

    2 objectives

  • Finding Data that Matches a Pattern

    2:43

  • Finding Data that Matches a Pattern

    2 objectives

  • Filtering Out or Finding Missing Information

    1:58

  • Filtering Out or Finding Missing Information

    2 objectives

  • Review & Practice with SQL Playgrounds

    3:50

  • instruction

    Need SQL Practice?

  • Finding the Data You Want Review

    15 questions


Related Courses

Database Administration and SQL Language Basics
A Cloud Guru
Creating Advanced Reports with SAS Visual Analytics
SAS via Coursera
Amazon DynamoDB Scans, Queries, and Indexes (Indonesian)
Amazon Web Services via AWS Skill Builder
Amazon DynamoDB Scans, Queries, and Indexes (Japanese)
Amazon Web Services via AWS Skill Builder
Amazon DynamoDB Scans, Queries, and Indexes (Portuguese)
Amazon Web Services via AWS Skill Builder