Welcome to the Treehouse Library
This is a sample catalog of all the courses we offer. Browse by topic or difficulty. Sign up today and get access to our entire library. Treehouse students get access to workshops, bonus content, conferences, and more.
Ready to start learning?
Treehouse offers a 7 day free trial for new students. Get access to 1000s of hours of content. Learn to code, land your dream job.Start Your Free Trial
- All Topics
- • AI
- • Databases
- • Python
- • Design
- • React
- • HTML
- • CSS
- • Data Analysis
- • Java
- • C#
- • Android
- • Computer Science
- • PHP
- • Quality Assurance
- • APIs
- • Security
- • Digital Literacy
- • Development Tools
- • Business
- • 21st Century Skills
- • Ruby
- • Machine Learning
- • Learning Resources
- • Go Language
- • Equity, Diversity, and Inclusion (EDI)
Databases are a powerful tool for storing and retrieving information. They're used in nearly all businesses, websites, and applications. Understanding how databases work, how they are organized and how to communicate with them to store and retrieve data is a critical skill for developers, data analysts and anyone in business.
Creating and Modifying Database Tables
Learn how to create and modify your own database tables as we work through a real-life example! We'll talk about how to choose the right structure for a database and then see how we can implement that structure.
SQLite from the Command Line
Learn how to create and manage databases right from the command line on your own computer!Viewed
Common Table Expressions Using WITH
Common Tables Expressions, or CTEs, use the WITH keyword to make more readable, modular and easy to understand SQL queries.Viewed
SQL Reporting by Example
In this course you'll get lots of practice writing SQL queries in a realistic environment!
Practice Simple WHERE Clauses with SQL
In this workshop we'll practice simple WHERE clauses.Viewed
Practice Column Selection and Aliasing with SQL
In this practice session we'll cover selecting columns and aliasing them.Viewed
SQL Window Functions
Window functions are a powerful SQL feature that let you compare results against other results within a query. With them, you can you can compare one row to other rows in a query to calculate each row as a percent of the total, for example, or to add a moving average to a report.Viewed
Querying Relational Databases
Building off of previous SQL courses, this course will begin to introduce the student to more complex database concepts. Students will learn to think about data as sets and subsets and practice achieving desired query results via such operations as inner and outer joins, unions and except. They will also be introduced to the concepts of Set Theory and Database Normalization to aid in understanding good query practices.
Reporting with SQL
SQL can be used to generate reports and present information on websites. This course covers powerful SQL features in helping you answer more interesting questions about your data.
Modifying Data with SQL
At the heart of a dynamic application is a database. Whether the application is an eCommerce, sports team, social network, or productivity app on your phone, the data needs to change over time. In this course, we'll take a look at the underpinning SQL statements that are needed for every dynamic application.
In SQL Basics, we’ll take a look at what databases are and how you can retrieve information from them. Databases can store massive amounts of information to be retrieved at a later date. Databases act as the memory for dynamic web sites or mobile apps.
Whoops! Perhaps you can try a broader search.