Course Outline
Review of SQL Basics for Government
- Recap of SELECT, WHERE, and GROUP BY clauses
- Quick review of JOIN types for government data integration
- Understanding the query execution order for efficient data retrieval
Data Manipulation Statements for Government
- INSERT INTO for adding new records to databases
- UPDATE and DELETE statements for managing existing data
- Transaction control (BEGIN, COMMIT, ROLLBACK) for ensuring data integrity
Advanced Joins and Set Operations for Government
- FULL OUTER JOIN for comprehensive data consolidation
- UNION, INTERSECT, and EXCEPT operations for set manipulation
- SELF JOIN for relating a table to itself in complex queries
Subqueries and Derived Tables for Government
- Correlated vs. non-correlated subqueries for precise data filtering
- Using subqueries in the FROM clause for advanced data selection
- CTEs (Common Table Expressions) for simplifying complex queries
Window Functions for Government
- ROW_NUMBER, RANK, and DENSE_RANK functions for ranking data
- PARTITION BY and ORDER BY clauses for segmenting and ordering results
- LEAD and LAG functions for accessing previous or next rows in a result set
Data Types and Functions for Government
- String and date functions for manipulating text and temporal data
- CASE and IF statements for conditional logic in queries
- Type conversions and null handling for robust data management
Query Optimization for Government
- Understanding indexes for enhancing query performance
- Using EXPLAIN to analyze query execution plans
- Best practices for writing efficient queries to optimize resource use
Summary and Next Steps for Government
Requirements
- Basic knowledge of SQL SELECT statements for government applications
- Experience with filtering, sorting, and simple joins in database queries
- Understanding of relational database concepts and their application in data management
Audience
- Data analysts responsible for government datasets
- Developers working with SQL databases for government projects
- Business intelligence professionals supporting government agencies
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.
