[homeles_ot-l] Training: SQL Query Essentials March 27-28

Sql Server Query Training bsmith at ioscodingcamp.com
Thu Mar 14 23:03:01 EDT 2019


Learn SQL Server Querying
>From The Experts


SQL Query Essentials March 27-28
Special Pricing $495



Learn "the essentials" of SQL Queries from the experts with 20+ years of experience.

This TWO-DAY, no-nonsense, hands-on, class is just what you need to get started with querying SQL Server and other database platforms.


Our hands-on approach teaches you the skills necessary for report writing and data extraction using T-SQL.


The main purpose of the course is to give students a good understanding of the Transact-SQL language which is used by all SQL Server-related disciplines; namely, Database Administration, Database Development and Business Intelligence



    Introduction to T-SQL Querying
    Executing basic SELECT statements
    Executing queries that filter data using predicates
    Executing queries that sort data using ORDER BY
 



    Writing Simple SELECT Statements
    Eliminating duplicates using DISTINCT
    Using column and table aliases
    Using a simple CASE expression
 

  

    Querying Multiple Tables
    Understanding joins
    Querying with inner joins
    Querying with outer joins
    Queries that use multiple-table inner joins
    Querying with cross joins and self joins
 


    Sorting and Filtering Data
    Sorting data
    Filtering data with predicates
    Filtering data with TOP and OFFSET-FETCH
    Working with unknown values
 



    Using Built-In Functions
    Writing queries with built-in functions
    Using conversion functions
    Using logical functions
    Using functions to work with NULL
 


    Grouping and aggregating data
    Using aggregate functions
    Distinct aggregate functions
    Using the GROUP BY clause
    Filtering groups with HAVING
 


    Using Subqueries
    Writing self-contained subqueries
    Writing correlated subqueries
    Using the EXISTS predicate with subqueries
 


    Using Windows Ranking, Offset, and Aggregate Functions
    Write queries that use the OVER clause, with partitioning, ordering, and framing to define windows
    Write queries that use window aggregate functions.
    Write queries that use window ranking functions.
    Write queries that use window offset functions
 



Find Out More

Unsubscribe
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://list.web.net/pipermail/homeles_ot-l/attachments/20190314/8db4da5a/attachment.html>


More information about the homeles_ot-l mailing list