« Back to Class Listing

SQL Level 1: Introduction

Description

SQL is a ‘must know’ technology for anyone in the IT industry! Use SQL to create queries that extract and manipulate information from relational databases. Learn to create expressions that calculate and summarize information and search, filter and sort your data. SQL can be used with almost all relational databases such as Microsoft Access, Microsoft SQL Server and Oracle, as well as business applications such as Crystal Reports, Business Objects and many more.

In this fun and informative class you will learn how to use over 30 different SQL clauses and functions and leave with a good working knowledge and understanding of the SQL language.

CLICK HERE FOR REQUIRED BOOK

Upon completion of this course, students will be able to:

  1. Understand database and SQL fundamentals
  2. Work with SQL script files and coding standards
  3. Return and organize data from a single table
  4. Code Derived Columns and use built functions
  5. Use basic WHERE Clauses to filter data
  6. Use Advanced WHERE Clauses to filter data
  7. Understand relational database theory and data diagrams
  8. Plan and write simple multi table queries
  9. Understand different join types and what they do
  10. Summarize and filter data with aggregate functions
  11. Understand and use action queries and their best practices
  12. Use and debug sub-queries and know when to use them

Section: SQL-LVL1 (07DEC17)
Dates: Dec 07, 2017 - Dec 08, 2017 Time: 9:00 AM
Tuition: $725.00 Instructor: Sarje Page Register
Course Outline
1. Database and SQL Fundamentals
  • Setting up the class databases
  • Fundamentals of SQL and data types
2. Working with SQL Script Files
  • Creating/Saving/Opening Script Files
  • SQL Basics, Terminologies, and Standards
3. Returning Data from a Single Table
  • Returning columns with SELECT and renaming with AS
  • Removing duplicate records with DISTINCT
  • Sorting the output with ORDER BY
4. Using SQL Expressions and Built-in Functions
  • Performing calculations and order of evaluation
  • Adding a derived column to query
5. Filtering Records with the WHERE Clause
  • Formatting criteria based on field data type
  • Using AND, OR and NOT in a WHERE clause
6. Advanced Filtering Techniques using WHERE
  • Using LIKE for matching and BETWEEN with ranges
  • Using IN and NOT IN with criteria lists
  • Filtering NULL values
7. Relational Database Theory and Terminologies
  • Create a multi-table data diagram
  • Identify primary keys, foreign keys, and relationship types
8. Writing Multi-Table JOIN Clauses
  • Planning a multi-table query and qualifying field names
  • Coding an INNER JOIN step-by-step
9. Understanding Different JOIN Types
  • INNER JOIN and matching data
  • OUTER JOIN and non-matching data
  • Explain what CROSS JOIN and SELF JOIN are
10. Summarizing Data with GROUP BY
  • Working with aggregate functions
  • Grouping with GROUP BY and filtering with HAVING
11. Using Action Queries
  • Action queries, database permissions, and best practices
  • Code a SELECT INTO to copy a data table
12. Working with Sub-Queries and Best Practices
  • Understanding sub-queries and their uses
  • Coding and debugging a sub-query

Class Schedule

Date Times Meeting Type Location
12/07/2017 9:00 AM - 4:30 PM Classroom Executive Park
12/08/2017 9:00 AM - 4:30 PM Classroom Executive Park

Additional Information

Final Enrollment:
 
Clock Hours: 13.0