Course Outline
Introduction to SQL for Government
- What is SQL?
- Understanding Relational Databases
- Database Engines and Tools
Basic Data Retrieval for Government
- SELECT Statements
- Filtering with WHERE
- Sorting with ORDER BY
Working with Columns and Rows for Government
- Using DISTINCT
- Column Aliases
- Limiting Results
Filtering and Comparison for Government
- Comparison Operators
- BETWEEN, IN, LIKE
- Logical Operators (AND, OR, NOT)
Aggregating and Grouping Data for Government
- COUNT, SUM, AVG, MIN, MAX
- GROUP BY Clause
- HAVING Clause
Table Joins Basics for Government
- Understanding Primary and Foreign Keys
- INNER JOIN
- LEFT JOIN and RIGHT JOIN
Using Subqueries for Government
- Introduction to Subqueries
- Subqueries in SELECT
- Subqueries in WHERE
Summary and Next Steps for Government
Requirements
- An understanding of fundamental computer operations
- Familiarity with using spreadsheets or tabular data
- No previous programming experience required
Audience for Government
- Business analysts
- Data entry professionals
- Individuals new to working with databases
Testimonials (5)
It was very interactive and it kept us interested.
Raluca Alexandra PUNGA
Course - SQL Fundamentals
Gunnar created a great rapport with the audience and was quick to identify our needs. He was engaging and highly knowledgeable throughout and we enjoyed his humour.
Kurt - Complete Coherence
Course - SQL For Data Science and Data Analysis
Philip was very kind, his style of explaining SQL concepts is outstanding. I liked that he give us information and answered to questions which were not part of this course.
Stefan
Course - SQL in SQL Server
analytical functions
khusboo dassani - Tech Northwest Skillnet
Course - SQL Advanced
The training materials.
