Learning SQL Programming
I was able to learn on Learning SQL Programming linkedin :
- Naming the predicate of the following statement: SELECT EyeColor, Age FROM Student WHERE FirstName = ‘Tim’ ORDER BY LastName ASC;
- Explaining 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.