uCertify

SQL Queries for Mere Mortals Labs

(SQL-MM.AB1.0L0)
Lab
Get A Free Trial

Skills You’ll Get

Download Course Outline

1

Creating a Simple Query

  • Using the SELECT Statement
  • Using the DISTINCT Keyword
  • Using the ORDER BY Clause
2

Getting More Than Simple Columns

  • Using the CAST Function
  • Using a Literal
  • Using the Concatenation Expression
  • Using the NULL Values
  • Naming an Expression
  • Finding Null Values in a Column
3

Filtering Your Data

  • Using the LIKE Predicate
  • Using the IN Predicate
  • Using the BETWEEN Predicate
  • Using Comparison Predicates
  • Using the WHERE Clause
  • Using the NOT Operator
  • Using the ESCAPE Option
  • Using the Order of Precedence
  • Using AND and OR Operators
  • Using the NOT IN Operator
4

Thinking in Sets

  • Using the UNION Operator
  • Using the EXCEPT Operator
  • Using the INTERSECT Operator
5

INNER JOINs

  • Using an INNER JOIN
  • Using a Subquery with the IN Predicate
6

OUTER JOINs

  • Using the FULL OUTER JOIN
  • Using the RIGHT OUTER JOIN
  • Using the LEFT OUTER JOIN
7

UNIONs

  • Sorting with UNION
8

Subqueries

  • Using Subqueries
  • Using the COUNT Function
  • Using the SOME Predicate
  • Using the ALL predicate
  • Using the ANY Predicate
9

Simple Totals

  • Using the MIN and MAX Functions
  • Using the SUM and AVG Functions
10

Grouping Data

  • Using the GROUP BY Clause
11

Filtering Grouped Data

  • Using the HAVING Clause
12

Updating Sets of Data

  • Using the UPDATE Statement
13

Inserting Sets of Data

  • Using the INSERT Statement
14

Deleting Sets of Data

  • Using the DELETE Statement
15

“NOT” and “AND” Problems

  • Using the NOT EXISTS Command
16

Condition Testing

  • Using the CASE Statement
17

Performing Complex Calculations on Groups

  • Using ROLLUP
  • Using the CUBE clause
18

Partitioning Data into Windows

  • Using the RANK Function

Related Courses

All Courses