Tags
Language
Tags
July 2025
Su Mo Tu We Th Fr Sa
29 30 1 2 3 4 5
6 7 8 9 10 11 12
13 14 15 16 17 18 19
20 21 22 23 24 25 26
27 28 29 30 31 1 2
    Attention❗ To save your time, in order to download anything on this site, you must be registered 👉 HERE. If you do not have a registration yet, it is better to do it right away. ✌

    ( • )( • ) ( ͡⚆ ͜ʖ ͡⚆ ) (‿ˠ‿)
    SpicyMags.xyz

    Learn Advanced Transact-SQL (T-SQL): Using SQL Server 2017

    Posted By: naag
    Learn Advanced Transact-SQL (T-SQL): Using SQL Server 2017

    Learn Advanced Transact-SQL (T-SQL): Using SQL Server 2017
    MP4 | Video: AVC 1280x720 | Audio: AAC 44KHz 2ch | Duration: 3.5 Hours | Lec: 47 | 264 MB
    Genre: eLearning | Language: English

    Practical Hands-on Advanced Transact-SQL (T-SQL)Queries .

    Transact-SQL is also popularly refereed to as T-Sequel .This is Microsoft's own implementation of the international Structural Query Language (SQL).
    This course assumes you have some basic knowledge of SQL or T-SQL and will provide you with more advanced knowledge of Transact-SQL (T-SQL). I will be using the latest free version of Microsoft SQL Server 2017 Express edition and a sample adventureworks 2014 database. We will be installing and using SQL Server Management Studio as part of the SQL Server Express edition 2017

    The course focuses on writing and advanced queries that can be used with T-SQL
    in SQL Server 2012, 2014 and 2016 and 2017.
    In this course you will learn the details and capabilities of using various types of functions
    like aggregate,analytic and ranking . You will also learn
    about stored procdures and how to create ,modify and delete them. I will also be showing you how to use SET operators.

    What You Will Learn in this course includes:


    Installing Microsoft SQL Server Express 2017
    Downloading and attaching sample database
    Using Convert function
    Using Substring function
    Using Cast function
    Using Round Function
    Using Case expression
    Aggregate Functions
    Analytic functions
    SET operators
    Stored Procedure
    Ranking functions

    Learn Advanced Transact-SQL (T-SQL): Using SQL Server 2017