Writing Queries Using SQL

• Database administrators, developers, IT architects
• Users who will use SQL to query, report and analyze

Module 1: Introduction to SQL

• SQL language
• DDL, DML, DCL statements
• Expressions, operators, variables

Module 2: SELECT

• Syntax
• DISTINCT
• Aliases

Module 3: Querying multiple tables

• Joining tables
• JOIN

Module 4: Sorting and filtering data

• ORDER BY
• WHERE

Module 5: Data types and built-in functions

• Data types
• Built-in functions
• Data conversions

Module 6: Grouping and aggregating data

• Aggregating functions
• GROUP BY

Module 7: Subqueries

• Scalar subqueries
• Multi-valued subqueries
• Corelated subqueries

Module 8: Database objects

• Views
• Functions
• Procedures

Module 9: Set operators

• UNION
• INTERSECT
• EXCEPT
• APPLY

Module 10: Pivoting

• PIVOT
• UNPIVOT

Module 11: DML, DDL

• INSERT
• UPDATE
• DELETE

Module 12: Transactions

• Using transactions
• START/BEGIN
• COMMIT
• ROLLBACK

Module 13: Query performance

• Queries
• Indexies
• Statistics
• Performance

• Create and use queries in SQL
• Manipulate with data
• Define and work with database objects

• Refresh, master, and learn new SQL knowledge

Classrooms are equipped with high-performance computers with Internet access and the possibility of wireless connection.

All participants will get internal materials.