microsoft partner logo color
8379  Reviews star_rate star_rate star_rate star_rate star_half

Introduction to T-SQL for SQL Server for Report Writers

Skills Gained Understand how SQL Server works Learn to use SQL to output reports with SQL Server Learn to modify SQL Server data with SQL Learn how to write stored procedures for SQL Server...

Read More
By Request
Contact Us For Pricing
Duration 2 days
Course Code SQL-140
Available Formats Classroom

Overview

Skills Gained

  • Understand how SQL Server works
  • Learn to use SQL to output reports with SQL Server
  • Learn to modify SQL Server data with SQL
  • Learn how to write stored procedures for SQL Server

Prerequisites

This course can be adapted to any level of prior SQL Server and relational database experience.

Course Details

Training Materials

All SQL Server training students receive comprehensive courseware.

Software Requirements

Attendees will not need to install any software on their computers for this class. The class will be conducted in a remote environment that Ascendient Learning will provide; students will only need a local computer with a web browser and a stable Internet connection. Any recent version of Microsoft Edge, Mozilla Firefox, or Google Chrome will work well.

Outline

  • Relational Database Basics
    • Brief History of SQL
    • Relational Databases [may be compressed due to attendee experience]
      • Tables
      • Rows
      • Columns
      • Relationships
      • Datatypes
      • Primary Keys
      • Foreign Keys
      • Relational Database Management System
    • SQL Server Objects
      • Valid Object References
    • SQL Statements
      • Database Manipulation Language (DML)
      • Database Definition Language (DDL)
      • Database Control Language (DCL)
  • Simple SELECTs with SQL Server
    • Introduction to the Northwind Database
    • Some Basics
      • Comments
      • Whitespace and Semi-colons
      • Case Sensitivity
    • SELECTing All Columns in All Rows
    • Exploring the Tables
    • SELECTing Specific Columns
    • Sorting Records
      • Sorting By a Single Column
      • Sorting By Multiple Columns
      • Sorting By Column Position
      • Ascending and Descending Sorts
    • The WHERE Clause and Operator Symbols
      • Checking for Equality
      • Checking for Inequality
      • Checking for Greater or Less Than
      • Checking for NULL
      • WHERE and ORDER BY
    • The WHERE Clause and Operator Words
      • The BETWEEN Operator
      • The IN Operator
      • The LIKE Operator
      • The NOT Operator
    • Checking Multiple Conditions
      • AND
      • OR
      • Order of Evaluation
    • Writing SELECTs with Multiple Conditions
  • Advanced SELECTs with SQL Server
    • Calculated Fields
      • Concatenation
      • Mathematical Calculations
      • Aliases
    • Aggregate Functions and Grouping
      • Aggregate Functions
      • Grouping Data
    • Built-in Data Manipulation Functions
      • Common Math Functions
      • Common String Functions
      • Common Date Functions
  • Subqueries, Joins, and Unions with SQL Server
    • Subqueries
    • Joins
      • Table Aliases
      • Multi-table Joins
    • Outer Joins
    • Unions
      • UNION ALL
      • UNION Rules
  • Inserting, Updating and Deleting Records with SQL Server
    • INSERT
    • UPDATE
    • DELETE
  • Creating and Modifying Tables with SQL Server
    • Creating Tables
    • Datatypes
    • Altering Tables
      • Adding a Column
      • Dropping a Column
    • Renaming Tables
    • Dropping Tables
  • Views and Stored Procedures in SQL Server
    • Creating Views
    • Dropping Views
    • Creating Stored Procedures
      • Designing a stored procedure
      • Specifying input parameters
      • Returning a recordset
      • Returning output parameters
    • Testing stored procedures
  • Conclusion
Read Less

Schedule

Upcoming Course Dates

There are currently no scheduled dates for this course. If you are interested in this course, contact us with the form below.

Contact Information

FAQ

How do I get a Microsoft exam voucher?

Pearson Vue Exam vouchers can be requested and ordered with your course purchase or can be ordered separately by clicking here.

  • Vouchers are non-refundable and non-returnable. Vouchers expire 12 months from the date they are issued unless otherwise specified in the terms and conditions.
  • Voucher expiration dates cannot be extended. The exam must be taken by the expiration date printed on the voucher.

Do Microsoft courses come with post lab access?

Most Microsoft official courses will include post-lab access ranging from 30 to 180 calendar days after instructor led course delivery. A lab training key in class will be provided that can be leveraged to continue connecting to a remote lab environment for the individual course attendee.

Does the course schedule include a Lunchbreak?

Lunch is normally an hour-long after 3-3.5 hours of the class day.

What languages are used to deliver training?

Microsoft courses are conducted in English unless otherwise specified.

Reviews

Great training it covered the most importan topics if GitHub copilot with good explanation and good labs.

The instructor was thorough and they also provided hands-on demonstrations with labs.

The format of the class was concise. I learned new skills to use at my workplace.

Simply great training provider that I can go for updating/acquiring my skill sets.

I was very satisfied about how the course was organized. Sean Did a very good work