Course 20761C: Querying Data with Transact-SQL Training

This course is designed to introduce students to Transact-SQL. It is designed in such a way that the first three days can be taught as a course to students requiring the knowledge for other courses in the SQL Server curriculum. Days 4 & 5 teach the remaining skills required to take exam 70-761.

  • ✔ Course Duration : 40 hrs
  • ✔ Training Options : Live Online / Self-Paced / Classroom
  • ✔ Certification Pass : Guaranteed
OVERVIEW LEARNING OBJECTIVES PRE-REQUISITES CURRICULUM FAQ CERTIFICATE

Overview

This course is designed to introduce students to Transact-SQL. It is designed in such a way that the first three days can be taught as a course to students requiring the knowledge for other courses in the SQL Server curriculum. Days 4 & 5 teach the remaining skills required to take exam 70-761.

What you will Learn

  • Describe key capabilities and components of SQL Server.
  • Describe T-SQL, sets, and predicate logic.
  • Write a single table SELECT statement.
  • Write a multi-table SELECT statement.
  • Write SELECT statements with filtering and sorting.
  • Describe how SQL Server uses data types.
  • Write DML statements.
  • Write queries that use built-in functions.
  • Write queries that aggregate data.
  • Write subqueries.
  • Create and implement views and table-valued functions.
  • Use set operators to combine query results.
  • Write queries that use window ranking, offset, and aggregate functions.
  • Transform data by implementing pivot, unpivot, rollup and cube.
  • Create and implement stored procedures.
  • Add programming constructs such as variables, conditions, and loops to T-SQL code.

PREREQUISITES

  • Basic knowledge of the Microsoft Windows operating system and its core functionality.
  • Working knowledge of relational databases.

CURRICULUM

Learning Objectives:

  • The Basic Architecture of SQL Server
  • SQL Server Editions and Versions
  • Getting Started with SQL Server Management Studio
  • Learning Objectives:

  • Introducing T-SQL
  • Understanding Sets
  • Understanding Predicate Logic
  • Understanding the Logical Order of Operations in SELECT statements
  • Learning Objectives:

  • Writing Simple SELECT Statements
  • Eliminating Duplicates with DISTINCT
  • Using Column and Table Aliases
  • Writing Simple CASE Expressions
  • Learning Objectives:

  • Understanding Joins
  • Querying with Inner Joins
  • Querying with Outer Joins
  • Querying with Cross Joins and Self Joins
  • Learning Objectives:

  • Sorting Data
  • Filtering Data with Predicates
  • Filtering Data with TOP and OFFSET-FETCH
  • Working with Unknown Values
  • Learning Objectives:

  • Introducing SQL Server Data Types
  • Working with Character Data
  • Working with Date and Time Data
  • Learning Objectives:

  • Adding Data to Tables
  • Modifying and Removing Data
  • Generating automatic column values
  • Learning Objectives:

  • Writing Queries with Built-In Functions
  • Using Conversion Functions
  • Using Logical Functions
  • Using Functions to Work with NULL
  • Learning Objectives:

  • Using Aggregate Functions
  • Using the GROUP BY Clause
  • Filtering Groups with HAVING
  • Learning Objectives:

  • Writing Self-Contained Subqueries
  • Writing Correlated Subqueries
  • Using the EXISTS Predicate with Subqueries
  • Learning Objectives:

  • Using Views
  • Using Inline Table-Valued Functions
  • Using Derived Tables
  • Using Common Table Expressions
  • Learning Objectives:

  • Writing Queries with the UNION operator
  • Using EXCEPT and INTERSECT
  • Using APPLY
  • Learning Objectives:

  • Creating Windows with OVER
  • Exploring Window Functions
  • Learning Objectives:

  • Writing Queries with PIVOT and UNPIVOT
  • Working with Grouping Sets
  • Learning Objectives:

  • Querying Data with Stored Procedures
  • Passing Parameters to Stored procedures
  • Creating Simple Stored Procedures
  • Working with Dynamic SQL
  • Learning Objectives:

  • T-SQL Programming Elements
  • Controlling Program Flow
  • Learning Objectives:

  • Implementing T-SQL error handling
  • Implementing structured exception handling
  • Learning Objectives:

  • Transactions and the database engines
  • Controlling transactions
  • FAQs

    You can enroll for this classroom training online. Payments can be made using any of the following options and receipt of the same will be issued to the candidate automatically via email.
    1. Online ,By deposit the mildain bank account
    2. Pay by cash team training center location

    Highly qualified and certified instructors with 20+ years of experience deliver more than 200+ classroom training.

    Contact us using the form on the right of any page on the mildaintrainings website, or select the Live Chat link. Our customer service representatives will be able to give you more details.

    You will never miss a lecture at Mildaintrainigs! You can choose either of the two options: View the recorded session of the class available in your LMS. You can attend the missed session, in any other live batch.

    We have a limited number of participants in a live session to maintain the Quality Standards. So, unfortunately, participation in a live class without enrollment is not possible. However, you can go through the sample class recording and it would give you a clear insight about how are the classes conducted, quality of instructors and the level of interaction in a class.

    Yes, you can cancel your enrollment if necessary prior to 3rd session i.e first two sessions will be for your evaluation. We will refund the full amount without deducting any fee for more details check our Refund Policy

    Yes, the access to the course material will be available for lifetime once you have enrolled into the course.

    Just give us a CALL at +91 8447121833 OR email at [email protected]

    Call us At

    +91 8447121833

    Available 24x7 for your queries
    call
    Request More Information

    Training Features

    experiential.png
    Experiential Workshops

    Top-rated instructors imparting in-depth training, hands-on exercises with high energy workshop

    icon
    Certicate Exam Application Assistance

    The training program includes several lab assignments, developed as per real industry scenarios.

    icon
    Certificate Exam Success Formula

    Training begins taking a fresh approach from basic, unique modules, flexible, and enjoyable.

    icon
    Certificate Journey Support

    Basic to intermediate and eventually advanced practicing full hands-on lab exercises till you master.

    icon
    Free Refresh Course

    Refresh training for experts for mastering and enhancing the skills on the subjects with fresh course modules.

    icon
    Exclusive Post-Training Sessions

    Includes evaluation, feedback, and tips to handle critical issues in live setup after you are placed in a job.

    Mildain's Master Certificate

    Earn your certificate

    This certificate is proof that you have taken a big leap in mastering the domain comprehensively.

    Differentiate yourself with a Masters Certificate

    Now you are equipped with real-industry knowledge, required skills, and hands-on experience to stay ahead of the competition.

    Share your achievement

    Post the certificate on LinkedIn and job sites to boost your profile. Notify your friends and colleagues by sharing it on Twitter and Facebook.

    cert.png
    whatsapp arrow Corporate