Курсове и сертификати > Съдържание на курса

Querying Data with Microsoft SQL Server

In this course, students will gain a good understanding of the Transact-SQL language. They will be able to create queries, sort, filter the data, execute procedures with T-SQL.

Skip to Available Dates

Learning Objectives

Upon successful completion of this course, students will be able to run Queries and retrieve results, perform conditional searches, and retrieve data from multiple tables.

  • Before starting this course, make sure you meet at least one of the following prerequisites:
  • Basic knowledge of the Microsoft Windows operating system and its core functionality.
  • Basic working knowledge of Relational Databases.

     

    Course Details

    Course Outline

    1 - Course Outline
  • 1.Introduction to Microsoft SQL Server
  • 2.Introduction to T-SQL Querying
  • 3.Writing SELECT Queries
  • 4.Querying Multiple Tables
  • 5.Sorting and Filtering Data
  • 6.Working with SQL Server Data Types
  • 7.Using DML to Modify Data
  • 8.Using Built-In Functions
  • 9.Grouping and Aggregating Data
  • 10.Using Subqueries
  • 11.Using Table Expressions
  • 12.Using Set Operators
  • 13.Using Windows Ranking, Offset, and Aggregate Functions
  • 14.Pivoting and Grouping Sets
  • 15.Executing Stored Procedures
  • 16.Programming with T-SQL

    • Actual course outline may vary depending on offering center. Contact your sales representative for more information.

    Who is it For?

    Target Audience

    This course is intended for Database Administrators, Database Developers, BI professionals, and Business reporting users.

    Querying Data with Microsoft SQL Server

    €1,095
    Course Length : 5 Days
     

    1. Choose a Date | 2. Click Enroll Now

     PDF Outline With Dates     PDF Outline

    Need Help Picking the Right Course? Give us a call! +359 2 421 0040