Home / Courses / Microsoft Technology / SQL Querying - Level 1

SQL

SQL Querying - Level 1

Course content

Lesson 1: Introduction to databases and SQL
Database concepts
Understanding SQL concepts

Lesson 2: Introduction to the SELECT statement
An overview of the SELECT statement
Syntax rules you’ll want to know

Lesson 3: Calculating data
Aggregate functions
Column aliases
Performing calculations
Date functions

Lesson 4: Selecting specific rows
The WHERE clause
The ORDER BY clause

Lesson 5: Working with other operators
Searching for text
Logical operators
NULLs

Lesson 6: Grouping data
The GROUP BY clause
The HAVING clause
Comparing the WHERE and HAVING clauses

Lesson 7: Multi-table queries
Joins
Joining tables
Outer joins

Lesson 8: Querying a database using Access 97
Connecting to a database
Querying a database
Generating a report of the data
 

Course Registration

 

1 day
$575.00

 

Course Outline

 

Request