Level up your query skills (advanced T-SQL queries) with SQL Server consultants

Making SQL even more SQL-like! ✨
We develop advanced query skills that are applicable to practical work.

query issues,
Can you solve it well?

Below are some important query issues that are common in practice.

When looking at queries developed by various companies for DB consulting, technical support, lectures, etc., we often see queries that were written inappropriately due to a lack of understanding of the characteristics or concepts of the SQL language, queries that were written with difficulty due to an ignorance of simple and convenient advanced queries, and cases where the various functions provided by SQL Server were not known and implemented with limited methods.

I want to help you take these querying skills to the next level through training.

SQL Server Consultant's
SQL Advanced Query Secrets!

A defining characteristic of the SQL language is that it allows for dozens of different implementations to achieve the same result. This course explores the more specialized SQL features offered by SQL Server, introducing various application methods and examples for leveraging them, and providing assignments.

Specifically, this course covers key query issues and misused methods commonly encountered in practice , along with various solutions . This will help you implement the complex and diverse business queries required in the field and enhance the productivity needed to quickly process business requirements.

Additionally, it helps you better utilize the upgraded system and SQL Server by learning new syntax, functions, and commands provided in the latest version of SQL Server.

Who would benefit from listening?

Anyone who is a SQL Server-based practitioner or user can listen.

_{SQL Server based
Beginner to intermediate level developer}

_{SQL Server based
Solution Developer}

_{SQL Server based
Beginner to intermediate DB administrator}

_{data engineer ,
data analyst}

If you have any concerns like these, pay attention!

One level higher
For writing SQL queries.

_{Important query writing content and
Learn various implementation methods}

_{Suitable for SQL
Understanding for writing queries}

_{For query tuning
Up to advanced query techniques}

• You'll learn how to write core queries commonly required in practice and various implementation methods. This will help you select the best method for your specific environment and goals.
• By understanding the characteristics of SQL and the fundamental concepts of set and relational operations, you can write queries suitable for SQL.
• You can learn advanced query techniques required as a prerequisite for SQL query tuning.

The following content
I'm learning.

1. SELECT Advanced Functions

It covers important properties used in the select-list clause, Row-to-Col, Format, NULL, TOP, CASE statement, and how to handle random data.

2. Utilizing advanced DML (Data Manipulation Language) features

Covers table-value constructors, advanced use of the UPDATE SET clause, the OUTPUT clause, use of Composable DML, the MERGE statement, examples of renumbering code, understanding the SEQUENCE object, understanding the characteristics of temporary tables and table variables, tips for using dynamic SQL and sp_executesql, and various ways to pass array (or table structure) values to procedures.

3. Advanced use of set and relational operations (joins and subqueries)

It covers the background and purpose of joins, utilizing row replication techniques using CROSS JOIN, understanding and utilizing intersection/union/difference and SQL, the characteristics of nested and subqueries, utilizing derived tables, and utilizing CTEs and recursive query calls.

4. Advanced use of aggregation, statistics, analytical functions, row and column permutations, subtotals, and grand totals

Understanding the characteristics of aggregate functions, understanding the expanded functionality of aggregate functions using OVER(), utilizing advanced aggregate operations through understanding Window and Frame, utilizing various statistical operations using the analytical functions positional functions and distribution/quantile functions, row and column permutations using PIVOT/UNPIVOT, and various utilization functions for subtotals and grand totals are covered.

Introduction of knowledge sharers

Kim Jeong-seon

Expected Questions Q&A