educative.io

An Introductory Guide to SQL (DataJek)


Practice & Prep - Quiz 10 Have questions about Quiz 10? Go for it! View the lesson [here](https://www.educative.io/courses/introductory-guide-to-sql/7nDOAkxq9Rr). Basic SQL - LIMIT This lesson discusses how to use the LIMIT clause. View the lesson [here](https://www.educative.io/courses/introductory-guide-to-sql/qAVpzEKg45k). Basic SQL - ORDER BY This lesson discusses how to use the ORDER BY clause. View the lesson [here](https://www.educative.io/courses/introductory-guide-to-sql/xoKDKokX3Bz). Basic SQL - Deleting Data This lesson discusses how to delete data in MySQL. View the lesson [here](https://www.educative.io/courses/introductory-guide-to-sql/qVXoo3Gv9Wy). Basic SQL - ... continued This lesson continues the discussion on indexes. View the lesson [here](https://www.educative.io/courses/introductory-guide-to-sql/qVj136lBgR3). Basic SQL - Create Table This lesson explains how to create a table in MySQL. View the lesson [here](https://www.educative.io/courses/introductory-guide-to-sql/xVAZKJ7m1Wn). Basic SQL - Temporary Table This lesson teaches you how to work with temporary tables in MySQL. View the lesson [here](https://www.educative.io/courses/introductory-guide-to-sql/3YxlQEJZgy9). Basic SQL - Collations & Character Sets This lesson is a brief introduction of collations and character sets. View the lesson [here](https://www.educative.io/courses/introductory-guide-to-sql/BnyxJkvW6Qo). Practice & Prep - Quiz 15 Have questions about Quiz 15? Go for it! View the lesson [here](https://www.educative.io/courses/introductory-guide-to-sql/JPqJPk7wO6v). Basic SQL - Inserting Data This lesson teaches the various ways of inserting data in MySQL. View the lesson [here](https://www.educative.io/courses/introductory-guide-to-sql/qZyGkL5wPkR). Practice & Prep - Quiz 16 Have questions about Quiz 16? Go for it! View the lesson [here](https://www.educative.io/courses/introductory-guide-to-sql/xlBRp9w9q6J). Practice & Prep - Practice Set 3 Have questions about Practice Set 3? Go for it! View the lesson [here](https://www.educative.io/courses/introductory-guide-to-sql/xoAmDomlKWn). Basic SQL - Querying Data This lesson teaches how to query for data in MySQL. View the lesson [here](https://www.educative.io/courses/introductory-guide-to-sql/RMWE2X5v3MO). Practice & Prep - Practice Set 4 Have questions about Practice Set 4? Go for it! View the lesson [here](https://www.educative.io/courses/introductory-guide-to-sql/RMXM2XNGLZw). Basic SQL - Combining Conditions This lesson discusses how to combine multiple conditions in a MySQL query. View the lesson [here](https://www.educative.io/courses/introductory-guide-to-sql/qVm252ArXPk). Practice & Prep - Solution Practice Set 4 Have questions about Solution Practice Set 4? Go for it! View the lesson [here](https://www.educative.io/courses/introductory-guide-to-sql/mEBA0MJ4Kyp). Practice & Prep - Cheat Sheet Have questions about Cheat Sheet? Go for it! View the lesson [here](https://www.educative.io/courses/introductory-guide-to-sql/xo3qA0vPVyn). Epilogue - Feedback Have questions about Feedback? Go for it! View the lesson [here](https://www.educative.io/courses/introductory-guide-to-sql/B8gg34MBPjY). Basic SQL - Alterations In this lesson we discuss how to modify various database structures once they are created. View the lesson [here](https://www.educative.io/courses/introductory-guide-to-sql/g7NR86zyyO6). Joins - Union This lesson demonstrates how to combine results from several queries. View the lesson [here](https://www.educative.io/courses/introductory-guide-to-sql/RMkr26DM1Ez). Joins - Left and Right Joins This lesson discusses left and right joins. View the lesson [here](https://www.educative.io/courses/introductory-guide-to-sql/397zBV2kQAR). Multi Table Operations - Multi-Table Update This lesson shows how we can update several tables at the same time. View the lesson [here](https://www.educative.io/courses/introductory-guide-to-sql/mylMK50Y490). Multi Table Operations - SELECT and INSERT This lesson discusses inserting data into a table using SELECT and INSERT in a single query. View the lesson [here](https://www.educative.io/courses/introductory-guide-to-sql/N0Qzl7YMVnp). Basic SQL - Data Types This lesson talks about the various data types available in MySQL. View the lesson [here](https://www.educative.io/courses/introductory-guide-to-sql/RLX8nLNrwJw). Introduction - Introduction The introductory lesson explains what folks can expect from this course and who the intended audience is. View the lesson [here](https://www.educative.io/courses/introductory-guide-to-sql/x1mYnwgqOwl). Basic SQL - Alias This lesson explains the concept of using an alias for a table. View the lesson [here](https://www.educative.io/courses/introductory-guide-to-sql/mERPnWnqOMp). Basic SQL - HAVING This lesson demonstrates how to use the HAVING clause. View the lesson [here](https://www.educative.io/courses/introductory-guide-to-sql/gkkoVmW9lZD). Basic SQL - TRUNCATE This lesson discusses how to delete all the rows of a table using the TRUNCATE clause. View the lesson [here](https://www.educative.io/courses/introductory-guide-to-sql/mEW8BWzqqWr). Basic SQL - Exploring MySQL This lesson is a gentle exploration of MySQL. View the lesson [here](https://www.educative.io/courses/introductory-guide-to-sql/g7DZKnvAOxZ). Basic SQL - Primary Key and Indexes This lesson explains the concept of an index and its utility in databases. View the lesson [here](https://www.educative.io/courses/introductory-guide-to-sql/qZyxnLzmYvy). Basic SQL - ... continue This lesson continues the discussion on creating tables and how to add restrictions when defining them. View the lesson [here](https://www.educative.io/courses/introductory-guide-to-sql/B8X5ylMl9jY). Practice & Prep - Quiz 13 Have questions about Quiz 13? Go for it! View the lesson [here](https://www.educative.io/courses/introductory-guide-to-sql/NEkRG6n5R5p). Introduction - MySQL History & Architecture In this lesson, we describe the overall architecture of MySQL RDBMS. View the lesson [here](https://www.educative.io/courses/introductory-guide-to-sql/RLrWxKWzK9R). Introduction - Relational vs Non-Relational This lesson talks about the database landscape as it exists today in the industry. View the lesson [here](https://www.educative.io/courses/introductory-guide-to-sql/BnkmpgAnzr2). Basic SQL - Create Database This lesson demonstrates how to create a database in MySQL. View the lesson [here](https://www.educative.io/courses/introductory-guide-to-sql/JYoZB7zm6Xg). Basic SQL - Alter Index In this lesson we discuss how to modify an index. View the lesson [here](https://www.educative.io/courses/introductory-guide-to-sql/qZLR1xXvr47). Practice & Prep - Quiz 7 Have questions about Quiz 7? Go for it! View the lesson [here](https://www.educative.io/courses/introductory-guide-to-sql/JEMl53jOnAP). Basic SQL - GROUP BY This lesson demonstrates using the GROUP BY clause. View the lesson [here](https://www.educative.io/courses/introductory-guide-to-sql/R8ABZOWYMXO). Triggers - UPDATE Triggers This lesson shows how to create triggers associated with the UPDATE statement. View the lesson [here](https://www.educative.io/courses/introductory-guide-to-sql/xVokx2py8Pz). Practice & Prep - Quiz 12 Have questions about Quiz 12? Go for it! View the lesson [here](https://www.educative.io/courses/introductory-guide-to-sql/JQKGjqwOAoo). Practice & Prep - Quiz 5 Have questions about Quiz 5? Go for it! View the lesson [here](https://www.educative.io/courses/introductory-guide-to-sql/NEqn34NmyrN). Practice & Prep - Practice Set 2 Have questions about Practice Set 2? Go for it! View the lesson [here](https://www.educative.io/courses/introductory-guide-to-sql/my8GYnXmBXp). Practice & Prep - Solution Practice Set 2 Have questions about Solution Practice Set 2? Go for it! View the lesson [here](https://www.educative.io/courses/introductory-guide-to-sql/39AJRqy9w7Q). Multi Table Operations - REPLACE This lesson discusses the REPLACE clause. View the lesson [here](https://www.educative.io/courses/introductory-guide-to-sql/g7EBAVgG2vZ). Views - Drop, Show, & Rename Views This lesson explains how to list, rename, and delete views. View the lesson [here](https://www.educative.io/courses/introductory-guide-to-sql/m2ON3wQr2J9). Basic SQL - More on Alter This lesson continues the discussion on altering various structures in a database. View the lesson [here](https://www.educative.io/courses/introductory-guide-to-sql/JQormQO4yzy). Basic SQL - DISTINCT This lesson demonstrates how to remove duplicates from a result set using the DISTINCT clause. View the lesson [here](https://www.educative.io/courses/introductory-guide-to-sql/qVjgD2pKZXD). Joins - Types of Joins This lesson discusses the different types of joins as specified by ANSI SQL. View the lesson [here](https://www.educative.io/courses/introductory-guide-to-sql/mEgNEBR0x4r). Joins - Self Inner Join This lesson discusses how to join a table with itself. View the lesson [here](https://www.educative.io/courses/introductory-guide-to-sql/7n4p7Z16x4A). Basic SQL - Aggregate Methods This lesson discusses MySQL aggregate functions. View the lesson [here](https://www.educative.io/courses/introductory-guide-to-sql/m2pyJx53NBn). Basic SQL - LIKE Operator This lesson discusses how to use the LIKE operator for filtering rows. View the lesson [here](https://www.educative.io/courses/introductory-guide-to-sql/gx4RxokZJ0j). Nested Queries - EXISTS Operator This lesson discusses the EXISTS operator. View the lesson [here](https://www.educative.io/courses/introductory-guide-to-sql/7A79YNxGl2j). Basic SQL - Updating Data This lesson discusses how to use the Update clause in MySQL. View the lesson [here](https://www.educative.io/courses/introductory-guide-to-sql/3jL740KVVq4). Triggers - What are Triggers? This lesson provides an introduction to triggers and discusses the benefits and trade-offs of using them. View the lesson [here](https://www.educative.io/courses/introductory-guide-to-sql/qVBYLlZ0rq0). Views - Creating a View In this lesson we will learn about three different ways of creating views. View the lesson [here](https://www.educative.io/courses/introductory-guide-to-sql/g73R9OEAyK9). Views - Updateable Views In this lesson we will learn how to modify the data in a view. View the lesson [here](https://www.educative.io/courses/introductory-guide-to-sql/mEgWAPAX9LE). Multi Table Operations - Multi-Table Delete This lesson demonstrates how to delete data from multiple tables. View the lesson [here](https://www.educative.io/courses/introductory-guide-to-sql/qAxQWnoWkOD). Practice & Prep - Quiz 4 Have questions about Quiz 4? Go for it! View the lesson [here](https://www.educative.io/courses/introductory-guide-to-sql/YQD8YLZ5DWp). Nested Queries - Nested Column Queries This lesson discusses nested queries that return a column of values. View the lesson [here](https://www.educative.io/courses/introductory-guide-to-sql/xo6PpLM022r). Miscellaneous - Foreign Keys This lesson discusses foreign keys. View the lesson [here](https://www.educative.io/courses/introductory-guide-to-sql/B8rwKnXwwgY). Nested Queries - Nested Row Queries This lesson discusses nested queries that return a set of rows. View the lesson [here](https://www.educative.io/courses/introductory-guide-to-sql/q2xxJrxq8BG). Nested Queries - Nested Scalar Queries This lesson discusses nested queries that result in a single value. View the lesson [here](https://www.educative.io/courses/introductory-guide-to-sql/N0VOQv31pG2). Practice & Prep - Quiz 3 Have questions about Quiz 3? Go for it! View the lesson [here](https://www.educative.io/courses/introductory-guide-to-sql/m7m0pOpBxDO). Miscellaneous - EXPLAIN This lesson demonstrates the usage of the EXPLAIN statement. View the lesson [here](https://www.educative.io/courses/introductory-guide-to-sql/xl22QVjl9r3). Practice & Prep - Quiz 1 Have questions about Quiz 1? Go for it! View the lesson [here](https://www.educative.io/courses/introductory-guide-to-sql/B8ywAWKR6Jo). Triggers - Multiple Triggers In this lesson, we will see how to write multiple triggers for a table which have the same action time and event. View the lesson [here](https://www.educative.io/courses/introductory-guide-to-sql/m22v0EQlxJE). Practice & Prep - Quiz 6 Have questions about Quiz 6? Go for it! View the lesson [here](https://www.educative.io/courses/introductory-guide-to-sql/xVkVnRy07Wn). Practice & Prep - Quiz 9 Have questions about Quiz 9? Go for it! View the lesson [here](https://www.educative.io/courses/introductory-guide-to-sql/m7M1QZ9LAJA). Practice & Prep - Quiz 11 Have questions about Quiz 11? Go for it! View the lesson [here](https://www.educative.io/courses/introductory-guide-to-sql/YQxYJm7O8QW). Practice & Prep - Quiz 14 Have questions about Quiz 14? Go for it! View the lesson [here](https://www.educative.io/courses/introductory-guide-to-sql/YMNvY8oMEnp). Practice & Prep - Practice Set 1 Have questions about Practice Set 1? Go for it! View the lesson [here](https://www.educative.io/courses/introductory-guide-to-sql/qAxrm2KlD9y). Practice & Prep - Solution Practice Set 1 Have questions about Solution Practice Set 1? Go for it! View the lesson [here](https://www.educative.io/courses/introductory-guide-to-sql/N7v0Gw6PRM2). Views - Local & Cascaded Check This lesson looks at the two types of rule checking that can be used with the CHECK option clause. View the lesson [here](https://www.educative.io/courses/introductory-guide-to-sql/qVVzKpgA1Rp). Nested Queries - Correlated Queries This lesson discusses the correlated queries. View the lesson [here](https://www.educative.io/courses/introductory-guide-to-sql/m7ZP74YB3yG). Practice & Prep - Quiz 2 Have questions about Quiz 2? Go for it! View the lesson [here](https://www.educative.io/courses/introductory-guide-to-sql/7no5RMylN0r). Practice & Prep - Quiz 8 Have questions about Quiz 8? Go for it! View the lesson [here](https://www.educative.io/courses/introductory-guide-to-sql/m7kjzRkL2nR). Triggers - INSERT Triggers This lesson demonstrates how to create triggers that are associated with the INSERT statement. View the lesson [here](https://www.educative.io/courses/introductory-guide-to-sql/qZg95jXWQjk). Miscellaneous - Transaction This lesson defines and explains the concept of a transaction in the context of relational databases. View the lesson [here](https://www.educative.io/courses/introductory-guide-to-sql/mEDxqPwYP1A). Triggers - Create and Delete a Trigger This lesson shows how a trigger is created and demonstrates how it automatically updates an event log. We also show how to drop a trigger in this lesson. View the lesson [here](https://www.educative.io/courses/introductory-guide-to-sql/xlEMExyYR79). Joins - Inner Join This lesson demonstrates how to perform an inner join. View the lesson [here](https://www.educative.io/courses/introductory-guide-to-sql/m2OKgzoxDOR). Joins - Natural Join This lesson explains the natural join. View the lesson [here](https://www.educative.io/courses/introductory-guide-to-sql/3Yx5xNW8kqx). Views - With Check Option In this lesson we will learn how to use the WITH CHECK OPTION clause to ensure consistency of data. View the lesson [here](https://www.educative.io/courses/introductory-guide-to-sql/7nEv8njvJMQ). Triggers - DELETE Triggers In this lesson we will learn how to create triggers associated with the DELETE statement. View the lesson [here](https://www.educative.io/courses/introductory-guide-to-sql/my06w7wnz8r). Practice & Prep - Solution Practice Set 3 Have questions about Solution Practice Set 3? Go for it! View the lesson [here](https://www.educative.io/courses/introductory-guide-to-sql/NEWr4wDO0np).
About the An Introductory Guide to SQL (DataJek) category [An Introductory Guide to SQL (DataJek)] (1)
The % symbol a wildcard that matches zero to all characters - strings [Basic SQL - LIKE Operator] (3)
What is a root? [Basic SQL - LIKE Operator] (1)