Introduction to SQL
| Course Details | ||||||||
|---|---|---|---|---|---|---|---|---|
|
||||||||
| Languages | ||||||||
|
||||||||
| Outcomes | ||||||||
|
||||||||
| Price & Terms | ||||||||
|
||||||||
| Technical | ||||||||
|
||||||||
| Specification | ||||||||
|
||||||||
Learn how relational databases organize data and write your first SQL queries with SELECT, DISTINCT and aliasing, then compare PostgreSQL and SQL Server.
Much of the world’s data, including medical records and customer transaction histories, sits in tables inside relational databases, and SQL is the language for working with it. This beginner course first explains how a relational database is organized, using a library database: tables, fields, records, unique IDs and data types. It then turns to writing queries against a books table, customizing and saving the results, and comparing PostgreSQL with SQL Server.
What You Will Achieve
- Explain how relational databases organize and store structured data
- Identify tables, fields, records and data types within a database schema
- Write basic queries with SELECT, FROM, DISTINCT, AS and LIMIT
- Compare SQL flavors such as PostgreSQL and SQL Server and translate between them
Program Overview
Relational Databases
The role of SQL in creating and querying relational databases, explored through a local library’s database.
- Tables and unique IDs
- Table and field naming
- Data types
- Servers
Querying
First SQL keywords on a books database, aliasing and saving results as views, and the differences between SQL flavors.
- SELECT and DISTINCT
- Aliasing
- Views
- SQL flavors
Certificate Awarded (Paid)
Complete the course to earn it.
Job Outlook
SQL is used in data analysis, data science, software engineering and finance, wherever data lives in relational databases.
Good for: Complete beginners who need to pull data out of relational databases, whether for analysis, reporting or a first step into data work.
Keep in mind: It is a short course, and the querying chapter stays with basic keywords such as SELECT, DISTINCT and LIMIT. The chapters here follow DataCamp’s Classic format; its AI Tutor format has a different outline.
Bottom line: A clear, quick first look at relational databases and basic SQL queries.
Frequently Asked Questions
Which SQL flavors does the course compare?
PostgreSQL and SQL Server, two of the most popular flavors. The last lessons look at their differences, benefits and uses, and practice translating a query between them.
What practice data does the course use?
A database for a local library in the first chapter, and a books table in the second, where you write queries, alias columns and save results as views.
Can I save my query results?
Yes. The second chapter shows how to customize results with aliasing and save a query as a view so that it can be shared with others.
User Reviews
Write your review
You must be logged in to post a review.
Reviews can only be posted by registered learners. Log in or create a free account, then you will return here to post.
There are no reviews yet.