Loved by learners at thousands of companies
Much of the world's raw data—from electronic medical records to customer transaction histories—lives in organized collections of tables called relational databases. Being able to wrangle and extract data from these databases using SQL is an essential skill within the data industry and in increasing demand.
This course will teach you:
✓ How relational databases are structured
✓ Simple SQL commands to start your analysis
✓ The differences between SQL databases such as PostgreSQL and SQL Server
In just a few hours, you'll get to know the theory and the practice through bite-sized videos and interactive exercises where you can put your new-found SQL skills to the test.
Before writing any SQL queries, it’s important to understand the underlying data. In this chapter, we’ll discover the role of SQL in creating and querying relational databases. Using a database for a local library, we will explore database and table organization, data types and storage, and best practices for database construction.
Learn your first SQL keywords for selecting relevant data from database tables! After practicing querying skills in a database of books, you’ll customize query results using aliasing and save them as views so they can be shared. Finally, you’ll explore the differences between SQL flavors and databases such as PostgreSQL and SQL Server.
Curriculum Manager, DataCamp
Izzy is a Curriculum Manager at DataCamp. She discovered a love for data during her seven years as an accounting professor at the University of Washington. She holds a masters degree in taxation and is a Certified Public Accountant. Her passion is making learning technical topics fun for students.
What do other learners have to say?
I've used other sites—Coursera, Udacity, things like that—but DataCamp's been the one that I've stuck with.
Devon Edwards Joseph
Lloyds Banking Group
DataCamp is the top resource I recommend for learning data science.
Harvard Business School
DataCamp is by far my favorite website to learn from.
Decision Science Analytics, USAA