• 9 min
  Workshop

  SQL to Sequelize with ChatGPT

  Learn how to leverage ChatGPT to effortlessly transform raw SQL queries into Sequelize queries.

  Viewed
  • AI
  • Beginner
• • 1
  • 2
  • 3

  100 min
  Course

  Using SQL ORMs with Node.js

  | 2901 students

  In this course, you'll learn how to use the Sequelize ORM to leverage the power of SQL within your Node.js applications.

  • JavaScript
  • Intermediate
• • 1
  • 2
  • 3

  2 hours
  Course

  SQL Basics

  | 51752 students

  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.

  • Databases
  • Beginner
• 19 min
  Workshop

  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
  • AI
  • Beginner
• 44 min
  Workshop

  Using SQL and Node.js with Sequelize

  In this workshop we'll use SQL and Node.js together with the popular ORM Sequelize.

  Viewed
  • Courses Plus
  • JavaScript
  • Intermediate
• 27 min
  Workshop

  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
  • Courses Plus
  • Databases
  • Advanced
• • 1
  • 2
  • 3
  • 4

  2 hours
  Course

  Reporting with SQL

  | 20465 students

  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.

  • Databases
  • Beginner
• • 1
  • 2
  • 3
  • 4

  64 min
  Course

  SQL Reporting by Example

  | 7160 students

  In this course you'll get lots of practice writing SQL queries in a realistic environment!

  • Databases
  • Intermediate
• • 1
  • 2
  • 3
  • 4

  79 min
  Course

  Modifying Data with SQL

  | 25025 students

  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.

  • Databases
  • Beginner
• • 1
  • 2
  • 3
  • 4
  • 5
  • 6

  2 hours
  Course

  Querying Relational Databases

  | 14842 students

  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.

  • Databases
  • Intermediate
• 8 min
  Workshop

  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
  • JavaScript
  • Beginner
• 6 min
  Practice

  Practice Simple WHERE Clauses with SQL

  In this workshop we'll practice simple WHERE clauses.

  Viewed
  • Databases
  • Beginner
• 4 min
  Practice

  Practice Column Selection and Aliasing with SQL

  In this practice session we'll cover selecting columns and aliasing them.

  Viewed
  • Databases
  • Beginner
• • 1
  • 2

  3 hours
  Course

  SQLAlchemy Basics

  | 1094 students

  Creating a SQL database including model creation and CRUD using SQLAlchemy.

  • Python
  • Intermediate
• 37 min
  Workshop

  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
  • JavaScript
  • Intermediate
• 18 min
  Workshop

  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
  • Databases
  • Intermediate
• • 1
  • 2
  • 3
  • 4

  92 min
  Course

  Data Relationships with SQL and Sequelize

  | 791 students

  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.

  • JavaScript
  • Intermediate
• • 1
  • 2
  • 3

  2 hours
  Course

  Hibernate Basics

  | 4983 students

  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.

  • Java
  • Intermediate
• • 1
  • 2
  • 3
  • 4
  • 5

  4 hours
  Course

  Integrating PHP with Databases

  | 9724 students

  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.

  • PHP
  • Intermediate
• 30 hours
  Bonus 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
  • HTML

Whoops! Perhaps you can try a broader search.

Reset all filters