Trabajo
[ ] | List the capabilities of SQL SELECT statements |
[ ] | Execute a basic SELECT statement |
Restricting and Sorting Data |
[ ] | Limitthe rows that are retrieved by a query |
[ ] | Sort the rows that are retrieved by a query |
[ ] | Use ampersand substitution to restrict and sort output at runtime |
Using Single-Row Functions toCustomize Output |
[ ] | Describe various types of functions available in SQL |
[ ] | Use character, number, and date functions in SELECT statements |
Using Conversion Functions andConditional Expressions |
[ ] | Describe various types of conversion functions that are available in SQL |
[ ] | Use the TO_CHAR, TO_NUMBER, and TO_DATE conversion functions |
[ ] | Apply conditionalexpressions in a SELECT statement |
| Reporting Aggregated Data Using the Group Functions |
[ ] | Identify the available group functions |
[ ] | Describe the use of group functions |
[ ] | Groupdata by using the GROUP BY clause |
[ ] | Include or exclude grouped rows by using the HAVING clause |
Displaying Data from Multiple Tables |
[ ] | Write SELECT statements to access data frommore than one table using equijoins and nonequijoins |
[ ] | Join a table to itself by using a self-join |
[ ] | View data that generally does not meet a join condition by using outer joins |
[] | Generate a Cartesian product of all rows from two or more tables |
Using Subqueries to Solve Queries |
[ ] | Define subqueries |
[ ] | Describe the types of problems that the subqueries cansolve |
[ ] | List the types of subqueries |
[ ] | Write single-row and multiple-row subqueries |
Using the Set Operators |
[ ] | Describe set operators |
[ ] | Use a set operator tocombine multiple queries into a single query |
[ ] | Control the order of rows returned |
| Manipulating Data |
[ ] | Describe each data manipulation language (DML) statement |
[ ] | Insert...
Regístrate para leer el documento completo.