- [Scott] In this course we've seen how to use SQL to work with an existing database. Depending on what your goal is, your next steps for learning can take a few different paths. If you're interested in learning how to create databases and how to administer them, take a look at our courses on database management systems like SQL Server, MySQL, Oracle, and others. If you're interested in digging deeper into SQL itself, check out our courses on more advanced SQL. Before you do that though, you may want to brush up on one of the database management systems those courses use, either SQL Server or MySQL, in order to be able to better follow along.
Or if you're looking to build an application that uses SQL in it, have a look at our courses about using SQL with popular languages like PHP, Java, and others. Whichever path you take, have fun learning, and good luck. See you next time.
- 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.