Writing Advanced Queries Using SQL
The two-day course aims to acquaint students with SQL. Its content is a description of advanced language syntax, definition of data structures, queries, and data manipulation. It follows the course SQL language.
Code
SQL-Jazyk 2
Course length
3
days
(8:30 – 16:00)
Form
In our classroom or online
- Dates
- This course is intended for
- Syllabus
- Students will be able to
- Course requirements
- Hardware
- Literature
Dates
This course is intended for
- Database administrators, developers, IT architects
- Users who will use SQL to query, report and analyze
Syllabus
Module 1: Joining tables
- JOIN
- SET operators
Module 2: Grouping data
- GROUP BY, HAVING
- ROLLUP, CUBE, GROUPING SETS
Module 3: Subqueries
- Scalar
- Multi-valued
- Corelated
- Derived tables
Module 4: Window functions
- OVER
- Offset, aggregated, ranking, distributed functions
Module 5: CTE
- CTE
- Recursive queries
Module 6: DML, DDL
- INSERT
- UPDATE
- DELETE
- CREATE
- ALTER
- DROP
- MERGE
Module 7: Triggers
- DML Triggers
- DDL Triggers
Module 8: Transactions, locks, hints
- Transactions
- Locks
- Hints
Module 9: FullText
- Setup FullText
- FullText functions
Module 10: Special data types and functions
- Data types
- Functions
Students will be able to
- Create and use advanced queries in SQL and manipulate with data.
- Define and work with advanced database objects.
Course requirements
- Refresh, master, and learn new SQL knowledge
Hardware
Classrooms are equipped with high-performance computers with Internet access and the possibility of wireless connection.
Literature
All participants will get internal materials.
Prices do not include VAT. OKsystem a.s. reserves the right to change dates and prices of courses.
Similar courses
Take a look at some similar courses from our wide range.
Installing, Administering and Maintaining a Microsoft SQL Server and Database Infrastructure DB-ADM
Performance Tuning and Optimizing SQL Databases DB-TUNING
Microsoft Access MACCESS
Need some advice?
Do not hesitate to contact us. We are at your disposal and will be happy to help you.
