• Analysts, programmer, business user or anyone interesting in getting started with SQL

• Basic understanding of Databases

Course Outline:

The course includes presentations, demonstrations, and hands-on labs.

• SQL Terminology & Elements of Relational Databases
• Types of data
• SELECT statement
• Install SQLite
• Orientation of the SQLite environment
• Queries — comments, structure of a basic query, syntax and using the ORDER BY clause
• Comparison, logical and arithmetic operators
• Use the WHERE, LIKE, DATE(), AND, OR and CASE statements
• Understand Joins and how they interact with Relational Database Structure
• Use a Left Outer Join in SQLite
• Types of functions in SQL and add calculations
• Aggregate functions and nesting functions — Use the ROUND() functions with GROUP BY, WHERE, and HAVING clauses

Training material provided:

Yes (Digital format)