Learn SQL
Offered By: Codecademy
Course Description
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.
- Lesson: Manipulation
- Quiz: Manipulation
- Project: Create a Table
- Article: What is SQLite?
- Queries: Perform more complex queries by learning essential query keywords and functionality
- Lesson: Queries
- Quiz: Queries
- Project: New York Restaurants
- Aggregate Functions: Learn powerful functions for performing complex database operations with ease.
- Lesson: Aggregate Functions
- Quiz: Aggregate Functions
- Project: Trends in Startups
- Project: Analyze Hacker News Trends
- Multiple Tables: Expand your SQL skills by creating and manipulating databases with multiple related tables
- Lesson: Multiple Tables
- Project: Lyft Trip Data
- Quiz: Multiple Tables
Taught by
Nik Stern
Related Courses
Excel 2010Miríadax Intro to Data Science
Udacity Data Manipulation at Scale: Systems and Algorithms
University of Washington via Coursera Statistical Computing with R - a gentle introduction
University College London via Independent Introducción a Data Science: Programación Estadística con R
Universidad Nacional Autónoma de México via Coursera