SQL Fundamentals of Querying by qsr20347


									ExecuTrain Course Outline
SQL: Fundamentals of Querying
1 Day

Students will learn what SQL is and how it can help them query a database to answer business questions.

Windows 95: Introduction, or Windows 98: Introduction or equivalent knowledge.

Students enrolling in this course should be familiar with the components that make up the PC, including input,
output, and storage devices. They should also be familiar with concepts related to database structure and

What's next
SQL: Fundamentals of Querying is the first course in this series. Students who want to learn more advanced
features of the language can take SQL: Advanced.

Performance-based objectives
Lesson objectives help students become comfortable with the course, and also provide a means to evaluate
learning. Upon successful completion of this course, students will be able to:
             Define what a relational database is and identify some uses for the SQL language.
             Recognize proper syntax for an SQL statement.
             Use aggregate functions, column aliases, and mathematical expressions in a query statement.
             Use the WHERE clause to select specific rows of information from a database.
             Search for specific character strings or numeric data in a database.
             Write queries that return both aggregate and non-aggregate information simultaneously.
             Write queries that select information from two tables simultaneously.
             Generate a query and its report using Access 97.

Page 1 of 2                                                                           #EKE077420v1.0 Rev. May, 10
Introduction to databases and SQL
    Database concepts
    Understanding SQL concepts
Introduction to the SELECT statement
    An overview of the SELECT statement
    Syntax rules you’ll want to know
Calculating data
    Aggregate functions
    Column aliases
    Performing calculations
    Date functions
Selecting specific rows
    The WHERE clause
    The ORDER BY clause
Working with other operators
    Searching for text
    Logical operators
Grouping data
    The GROUP BY clause
    The HAVING clause
    Comparing the WHERE and HAVING clauses
Multi-table queries
    Joining tables
    Outer joins
Querying a database using Access 97
    Connecting to a database
    Querying a database
    Generating a report of the data

Page 2 of 2                                  #EKE077420v1.0 Rev. May, 10

To top