Writing Queries Using SQL
The three-day course aims to acquaint students with the basics of SQL. Its content is a description of language syntax, definition of data structures, queries, and data manipulation.
Accredited course for Continuing Education of Pedagogical Staff
Course length: 3 days (8:30 - 16:00)
Dates
-
Students will be able to
- Create and use queries in SQL
- Manipulate with data
- Define and work with database objects
-
Course requirements
- Refresh, master, and learn new SQL knowledge
-
This course is intended for
- Database administrators, developers, IT architects
- Users who will use SQL to query, report and analyze
-
Literature
All participants will get internal materials.
-
Hardware
Classrooms are equipped with high-performance computers with Internet access and the possibility of wireless connection.
-
Syllabus
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
Prices do not include VAT. OKsystem a.s. reserves the right to change dates and prices of courses.