SQL flavors
Introduction to SQL
Jasmin Ludolf
Senior Data Science Content Developer, DataCamp
SQL flavors
- Both free and paid
- All used with relational databases
- Vast majority of keywords are the same
- All must follow universal standards
- Only the additions on top of these standards make flavors different
1 Table flatlay photo created by freepik www.freepik.com
Two popular SQL flavors
PostgreSQL
- Free and open-source relational database system
- Created at the University of California, Berkeley
- "PostgreSQL" refers to both the PostgreSQL database system and its associated SQL flavor
SQL Server
- Has free and paid versions
- Created by Microsoft
- T-SQL is Microsoft's SQL flavor, used with SQL Server databases
Comparing PostgreSQL and SQL Server
- Like dialects of the same language
PostgreSQL:
SELECT id, name
FROM employees
LIMIT 2;
| id | name |
|-------|--------|
| 54378 | Darius |
| 94722 | Raven |
- Example: limiting number of results
SQL Server:
SELECT TOP(2) id, name
FROM employees;
| id | name |
|-------|--------|
| 54378 | Darius |
| 94722 | Raven |
Choosing a flavor
Just like with ice cream, any flavor is probably a good choice!
Let's practice!
Introduction to SQL
