SQL
What is SQL?
SQL is a coding language that actively interacts with databases. This coding langauge gives you options to create and modify databses to meet you or your organizations needs.
Why Learn SQL?
Familarize Yourself with boolean logic.
Develop Data Analysis skills that are broadly applicable
Learn to Work with databases, something that will be useful in many careers.
Resources for Learning SQL
In addition to these guides, there are many CSU courses and free resources available for learning SQL.
View CSU Course Tree
Topic
Prerequisite Group
Course
Here are some of the free resources available organized by category.
Online Coures / Structured Learning Paths
| Resource | Author / Provider | Best for (goal) | Level |
|---|---|---|---|
| Analyze Data with SQL | Code Academy | Analyzing large datsets with SQL as well as preparation for technical interviews | Intermediate |
| Codefinity: Introduction to SQL | Codefinity | Understanding the basics of SQL | Beginner |
| Codez Up: SQL for big data: Handling Large Scale Datasets | Codez up | Applying basic coding languages to large scale SQL datasets | Intermediate |
| Colorado State University: Business Database Systems (Prereqs & Paywall) | Aaron Baird | Developing database management and modeling skills | Advanced |
| Colorado State University: Database Systems | Evan Anspach | Analyzing Databases, Developing modeling skills for databases | Advanced |
| Colorado State University: Principles: Quantitative Data Analysis | Kari Dockendorff | Applying Quantitative Analysis skills to social sciences | Beginner |
| Colorado State University: Personal Computing | Logan Seabolt | Getting foundational knowledge in computer management and data | New to Programming |
| Colorado State University: Data Wrangling | Vidya Gaddy | Getting foundational knowledge related to data cleaning and management | New to Programming |
| Intro to SQL | Code Academy | Learning basic SQL Skills | Beginner |
| Learn SQL | Code Academy | Learning introductory SQL Concepts and Skills | Beginner |
| Learn SQL: Aggregate Functions | Code Academy | Applying SQL Functions to perform calculations | Intermediate |
| Learn SQL: Multiple Tables | Code Academy | Joining and working with multlipe different tables in SQL | Beginner |
Books / eBooks
| Resource | Author / Provider | Best for (goal) | Level |
|---|---|---|---|
| Medium: Top 15 SQL Query Techniques for Big Datasets | Medium | Understanding Best Practcies for SQL Coding | Intermediate |
Applied / Domain-Specific Resources
| Resource | Author / Provider | Best for (goal) | Level |
|---|---|---|---|
| Vidya Gaddy: Github | Vidya Gaddy | Practicing filtering large datasets for desired information | Beginner |