Codecademy
Free Trial Available
English
Certificate Available
8 hours worth of material
selfpaced
Overview
Learn to communicate with databases using SQL, the standard data management language.
### Why Learn SQL?
We live in a data-driven world: people search through data to find insights to inform strategy, marketing, operations, and a plethora of other categories. There are a ton of businesses that use large, relational databases, which makes a basic understanding of SQL a great employable skill not only for data scientists, but for almost everyone.
### Take-Away Skills:
In this course, you'll learn how to communicate with relational databases through SQL. You'll learn—and practice with 4 projects—how to manipulate data and build queries that communicate with more than one table.
### Why Learn SQL?
We live in a data-driven world: people search through data to find insights to inform strategy, marketing, operations, and a plethora of other categories. There are a ton of businesses that use large, relational databases, which makes a basic understanding of SQL a great employable skill not only for data scientists, but for almost everyone.
### Take-Away Skills:
In this course, you'll learn how to communicate with relational databases through SQL. You'll learn—and practice with 4 projects—how to manipulate data and build queries that communicate with more than one table.
Syllabus
- Manipulation: Learn how to use SQL to access, create, and update data stored in a database.
- Manipulation
- Manipulation
- Create a Table
- What is SQLite?
- Queries: Perform more complex queries by learning essential query keywords and functionality
- Queries
- Queries
- New York Restaurants
- Aggregate Functions: Learn powerful functions for performing complex database operations with ease.
- Aggregate Functions
- Aggregate Functions
- Trends in Startups
- How to Hack Hacker News
- Multiple Tables: Expand your SQL skills by creating and manipulating databases with multiple related tables
- Multiple Tables
- Lyft Trip Data
- Multiple Tables
