Writing Advanced Queries Using SQL

SQL-Jazyk 2

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.

Accredited course for Continuing Education of Pedagogical Staff

Course length: 3 days (8:30 - 16:00)

Dates

04/03/2024 - 04/05/2024 Prague cs Free date Guaranteed date
17 700 CZK Add to cart
05/27/2024 - 05/29/2024 Prague cs Free date
17 700 CZK Add to cart

PDF to download Expand allCollapse all

  • 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
  • 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: 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

Prices do not include VAT. OKsystem a.s. reserves the right to change dates and prices of courses.