Advanced search

SQL-Jazyk 2 Writing Advanced Queries Using SQL Print

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: 2 days

Dates

DatePlaceLanguagePrice (without VAT)Availability
03/19/2020 - 03/20/2020 Prague cs 11 800 CZK Free date
05/21/2020 - 05/22/2020 Prague cs 11 800 CZK Free date
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
  • Dependencies

    SQL Server

    SQL Server

    Databases

    Databases
OKsystem a.s.
We use cookies to optimize site functionality and deliver best results based on your interests. More info