


Learn the basics of sql using TeamSQL, including writing simple and complex queries, joins, and aggregate functions, while managing tables and data across relational databases.
Sign in to TeamSQL, connect to servers, and run your first query; export data in JSON, CSV, or tab-delimited formats for sharing with teammates.
Master basic SQL commands in TeamSQL by using select to retrieve data, specify columns, and filter with where, like, and between; handle NULL values correctly.
Learn to combine data from multiple tables using SQL joins, linking users and their favorite books by a common user_id, with inner, left, right, and full joins.
Explore complex sql queries using set operations such as union, intersect, and except, with subqueries and inner queries. Utilize aggregate functions like min, max, sum, average, and count.
Learn how to create and manage sql tables by using create table, insert, update, delete, and table alterations like alter, drop, and rename, with practical staff table examples.
Master snippets, intellisense, and datagrid filtering to write queries faster, preview table structure, and share or export data with secure links.
Conclude the sequel crash course by mastering basic data retrieval, multi-table queries, and aggregate functions, while exploring team sequel features like snippets, datagrid filtering, and data sharing.
In this course, we will cover the basics of working with SQL using TeamSQL. After a quick intro on how to use TeamSQL, which is the data management tool we'll use for this course, we will cover basic queries, including how to return and filter data, SQL joins, and writing complex queries (including operators and subqueries). We will also cover the basics of data table management. We end this course with coverage of TeamSQL's features that are designed to help manage your data. These features include working with snippets, data grid filtering, table structure previews, and exporting data from TeamSQL.