- Name the predicate of the following statement: SELECT EyeColor, Age FROM Student WHERE FirstName = 'Tim' ORDER BY LastName ASC;
- Explain what to use to enforce the order in which an expression must be evaluated if the WHERE clause contains multiple expressions to evaluate.
- Identify the best option to join two tables in a database to be able to display data from both.
- List a data type that is not numeric.
- Determine the result of running the following statement on a table containing columns col_1 and col_2:
- INSERT INTO Box (col_1, col_2) VALUES ('A', 'B'), ('A', 'B'), ('A', 'B'), ('A', 'B');
- Determine the best approach of deleting Jon Ramirez (ID 3452) from a Student table.
Skill Level Beginner
- [Scott] Our world is driven by data, and a lot of that data is stored in databases. In order to unlock the information and insights stored in databases, we need a way of asking for data. One common language for asking about and modifying data in databases is SQL. In this course, I'll explain what SQL is, and I'll take you through an introduction to the language. You'll see how to ask questions of databases in a structured way to get the information you need. We'll focus on the language itself, not any particular tool. And the amount of setup you'll need to do in order to get started is minimal. The goal of this course is to get you comfortable working with the basics of the language using a database that already exists. We'll look at how to get information from more than one database table, and I'll introduce some more features and functions of SQL. After that, we'll take a look at adding and modifying data in tables that already exist in a database. We'll end with a quick look at overcoming some common pitfalls in working with SQL. This course will help prepare you to work with SQL in programming, data science, or data reporting applications. And it will provide a foundation for deeper learning about database administration, advanced SQL, and developing with data. Let's go.