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- Newest
-
All Topics
- All Topics
- • AI
- • JavaScript
- • 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)
-
9 minWorkshop
SQL to Sequelize with ChatGPT
Learn how to leverage ChatGPT to effortlessly transform raw SQL queries into Sequelize queries.
Viewed -
19 minWorkshop
SQL Commands with ChatGPT
Join us for an engaging code-along workshop where we'll explore the fascinating world of natural language processing using ChatGPT. In this hands-on session, we'll demonstrate how to quickly generate SQL commands from everyday language. Using the terminal and sqlite3, we'll showcase the practical applications of this powerful capability.
Viewed -
8 minWorkshop
Full Stack JavaScript Techdegree Portfolio Overview
Here at Treehouse, we have many Techdegrees to get you job ready no matter your skill level. The Full Stack JavaScript Techdegree is one of the most popular. Come take a look at all the professional-quality projects you'll build in this Techdegree!
Start your free trial today! (https://trhou.se/3I1UNT3)
Projects Random Quote Generator (https://teamtreehouse.com/library/introducing-the-random-quote-generator-2) Data Pagination and Filtering (https://teamtreehouse.com/library/introducing-the-data-pagination-and-filtering-project-2) Interactive Form (https://teamtreehouse.com/library/introducing-the-interactive-form-project-2) OOP Game Show App (https://teamtreehouse.com/library/introducing-the-oop-game-show-app-2) Public API Requests (https://teamtreehouse.com/library/introducing-the-api-requests-project-2) Static Node.js and Express Site (https://teamtreehouse.com/library/introducing-the-static-nodejs-and-express-site-project-2) React Gallery App (https://teamtreehouse.com/library/introducing-the-react-gallery-app-project-2) SQL Library Manager (https://teamtreehouse.com/library/introducing-the-sql-library-manager-project-2) REST API (https://teamtreehouse.com/library/introducing-the-rest-api-project-2) Full Stack App with React and a REST API (https://teamtreehouse.com/library/introducing-the-full-stack-app-with-react-and-a-rest-api-project-2)Viewed -
- 1
- 2
SQLAlchemy Basics
Creating a SQL database including model creation and CRUD using SQLAlchemy.
-
- 1
- 2
- 3
- 4
Data Relationships with SQL and Sequelize
As you follow along in this course, you'll define data relationships for a simple Node application that creates and retrieves movie data. You'll define data relationships in Sequelize models, and create related data (like Movie and Person records) using those models. Then you'll retrieve related data with Sequelize queries.
-
37 minWorkshop
Using Sequelize ORM With Express
In this workshop, you will use the Sequelize ORM and Express to build a simple CRUD application that's connected to a SQL database.
Viewed -
- 1
- 2
- 3
Using SQL ORMs with Node.js
In this course, you'll learn how to use the Sequelize ORM to leverage the power of SQL within your Node.js applications.
-
18 minWorkshop
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 -
- 1
- 2
- 3
- 4
SQL Reporting by Example
In this course you'll get lots of practice writing SQL queries in a realistic environment!
-
6 minPractice
Practice Simple WHERE Clauses with SQL
In this workshop we'll practice simple WHERE clauses.
Viewed -
4 minPractice
Practice Column Selection and Aliasing with SQL
In this practice session we'll cover selecting columns and aliasing them.
Viewed -
27 minWorkshop
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 -
- 1
- 2
- 3
- 4
- 5
- 6
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.
-
- 1
- 2
- 3
- 4
- 5
Integrating PHP with Databases
Building a PHP-driven page is the first step in mastering PHP. The true power of PHP shines when you connect it to a data source like an API or a Database. To introduce you to databases, we'll use an example project -- a Personal Media Library application. We'll refactor this project by replacing an associative array with a database to provide a more robust and scalable tool to store the data in the media library. In the process, you'll learn how to use PDO -- a PHP extension to communicate with a database. You'll also learn about relational databases including how to search for data across multiple tables, as well as how to add common web site features like search forms and pagination.
-
44 minWorkshop
Using SQL and Node.js with Sequelize
In this workshop we'll use SQL and Node.js together with the popular ORM Sequelize.
Viewed -
- 1
- 2
- 3
Hibernate Basics
Most meaningful applications you will write will have a database associated with it. Knowing how to connect with and incorporate this data is critical to success as a Java developer. In this course, we'll cover how to connect a Java application to a database using what's called JDBC, or Java Database Connectivity. Then, we'll use the convenient approach of including an ORM, or Object Relational Mapper. This will allow us to interact with our data using object-oriented techniques instead of exclusively relying on hard-coded SQL. The ORM we will use is called Hibernate, and is one of the most popular ORMs available.
-
- 1
- 2
- 3
- 4
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.
-
- 1
- 2
- 3
- 4
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.
-
- 1
- 2
- 3
SQL Basics
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.
-
30 hoursBonus Series
The Treehouse Show (2012 - 2015)
The Treehouse Show is your weekly dose of web design and web development news, hosted by Nick Pettit and Jason Seifer.
Viewed
Whoops! Perhaps you can try a broader search.
Upcoming Releases
The following items are scheduled to be released soon. You can also visit our content roadmap for more info.
-
Introduction to NLP
Explore the magic of Natural Language Processing (NLP)! Ever wonder how Siri or Google Translate function? Jump into NLP, the AI field that bridges the gap between humans and computers. This course covers everything from the technical fundamentals to real-world applications and ethical considerations. Don't miss out on this linguistic adventure!
-
22 minWorkshop
AI Tools Treehouse Developers Love
Join us for a quick-paced, fun exploration of AI tools transforming the daily workflow of the team at Treehouse. Get insights into how tools like Arc, Coda, GitHub Copilot, and ChatGPT are being used to supercharge productivity in coding, project management, and creative processes. This video is a compact yet comprehensive guide to the AI tools reshaping the tech landscape at Treehouse.
Viewed -
21 minWorkshop
Mastering AI-Assisted Design with ChatGPT
Get ready to dive into the future of design. Whether you're a student, a design pro, or just super into AI, this workshop is for you. You'll see how ChatGPT can give you spot-on feedback, help you write killer copy, suss out the competition, and even whip up basic web prototypes. It's hands-on, it's mind-blowing, and it's all about unleashing your creativity. Don't miss out on this chance to kick off your AI-powered design journey in style!
Viewed -
Supercharge Your Figma Workflow with AI Plugins
Dive into the world of Figma and AI plugins as we introduce five transformative AI tools designed to revolutionize your design process. Learn how to enhance your Figma experience with AI-driven solutions that enable rapid wireframing, insightful design feedback, and impactful UX copy creation. Each plugin brings its own unique set of capabilities, and we're here to explore them all!