microsoft partner logo color
8379  Reviews star_rate star_rate star_rate star_rate star_half

Introduction to SQL for Report Writers and Analysts

Skills Gained Understand database design concepts Query the database Work with different data types Join Multiple Tables Work with functions Perform subqueries Prerequisites In addition to their...

Read More
By Request
$1,313 USD
Duration 3 days
Course Code SQL-614
Available Formats Classroom

Overview

Skills Gained

  • Understand database design concepts
  • Query the database
  • Work with different data types
  • Join Multiple Tables
  • Work with functions
  • Perform subqueries

Prerequisites

In addition to their professional experience, students who attend this training should already have the following technical knowledge:

  • Basic knowledge of the Microsoft Windows operating system including the ability to easily open and save files in a variety of programs and the ability to launch new applications
  • Working knowledge of basic database concepts such as relational database design, normalization, and table structure would be helpful
  • Exposure to query writing or having experience with another programming background would be helpful

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

  • Introduction
    • Course Overview
    • Data Manipulation Verbs
    • Courseware Overview
    • Datasets Overview
  • Overview of SSMS and Query Writing
    • Working with SSMS
    • Using the SQL Editor
    • Creating SSMS Script Projects
    • Tips and Tricks with SSMS
    • Adding Comments to Queries
    • Understanding Batches and Scripts
  • Database Design Concepts
    • What is SQL
    • Database Diagrams
    • Database Terminology Overview
  • Basic SELECT Statements
    • The SELECT Statement
    • Execution Order of SELECT Statements
    • Ordering Results
    • Additional SELECT Options
  • Working with Data Types
    • Data Type Precedence
    • String Related Data Types
    • Numeric Data Types
    • Date and Time Data Types
    • Converting Between Data Types
    • How to Find Help on Functions
    • Understanding Data Type Conversion
  • Enhanced SELECT Statements
    • Expressions
    • Filtering Rows
    • Comparison Operators
    • Logical Operators
  • Handling NULL Data
    • NULL vs Blank
    • = vs IS NULL
    • ISNULL function
    • COALESCE
    • Concatenating NULL Data
  • Aggregating and Grouping Data
    • Aggregate Functions
    • GROUP BY
    • HAVING
    • HAVING vs WHERE
  • Joining Multiple Tables
    • JOINS
    • INNER JOIN
    • OUTER JOIN
    • CROSS JOIN
    • Joining Three or More Tables
    • Self-join
    • Alternate Syntax, Implicit Joins
    • Set Operations
    • Working with Multiple Set Operators
    • Viewing Graphical Execution Plans
  • Built-in Functions Overview
    • Working with Functions
    • Mathematical Function Overview
    • String Function Overview
    • Date Time Function Overview
    • Nesting Functions
  • Subqueries
    • Subqueries
    • Nested vs Correlated Subqueries
    • Subqueries in the SELECT Clause
    • Subqueries in the WHERE Clause
    • EXISTS
    • Subqueries in FROM Clause
    • Alternatives to Subqueries
  • 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

Some Labs are very good but some steps it ask to update but its already updated, but overall its very good training.

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

Great company -- easy to sign up and very organized. Loved my teacher and class overall.

Both course material and instructor demonstrated a sound foundation on Maximo material

Very good company. I've done technical trainings at their facility in downtown Montreal in the past and I'Ve always appreciated them.