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
Introduction to DatabasesMeta via Coursera Intro to Relational Databases
Udacity Fundamentals of database systems
Indian Institute of Technology Kanpur via Swayam Capstone: Photo Tourist Web Application
Johns Hopkins University via Coursera Web Application Development: Basic Concepts
University of New Mexico via Coursera