- Databases
- Beginner
About this Course
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
Data, Databases and SQL
We'll take a look at databases, the types of structures inside them, what data is and what SQL is.
6 stepsGetting 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.
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.
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
-
Need SQL Practice?
-
Finding the Data You Want Review
15 questions
Teacher
-
Andrew Chalkley
I'm an alien, I'm a legal alien, I'm an Englishman in Portland. All of my professional life I've worked with computers online. I'm a polyglot programmer and like using the right tools for the job. In my spare time I enjoy spending time with my family and when I get chance, sticking opponents in Halo 4.