Course Overview

This course provides students with the technical skills required to write basic Transact-SQL queries for Microsoft SQL Server. You will learn how to write queries that return data from tables as well as create, update, or delete data in a database.

sql 2019 querying sql server 300x200 1

Course objectives

These queries will allow filtering and sorting and effectively use the various data types provided by SQL Server. This course also covers the use of dynamic tables of various sorts which can allow a more sophisticated SQL user to hide implementation details from other end users accessing data from reporting tools. Finally, the course will provide details on the what and how of error handling and transaction management. 

0
Course Videos
0
Test Questions
0
E-BOOKS
0
Duration

Modules

Module 1: Query Tools

  • 1.1 Course Introduction
  • 1.2 Module 1 Introduction
  • 1.3 Intro to Management Studio
  • 1.4 Intro to command-line query tools

Module 2:  Introduction to T-SQL Querying

  • 2.1 Module 2 Introduction
  • 2.2 Introducing T-SQL
  • 2.3 Understanding Sets
  • 2.4 Understanding the Logical Order of Operations in SELECT statements

Module 3: Basic SELECT Queries

  • 3.1 Module 3 Introduction
  • 3.2 Writing Simple SELECT Statements
  • 3.3 Eliminate Duplicates with DISTINCT
  • 3.4 Using Column and Table Aliases
  • 3.5 Write Simple CASE Expressions

Module 4: Querying Multiple Tables

  • 4.1 Module 4 Introduction
  • 4.2 Understanding Joins
  • 4.3 Querying with Inner Joins
  • 4.4 Querying with Outer Joins
  • 4.5 Querying with Cross Joins and Self Joins

Module 5: Sorting and Filtering Data

  • 5.1 Module 5 Introduction
  • 5.2 Sorting Data
  • 5.3 Filtering Data with Predicates
  • 5.4 Filtering with the TOP and OFFSET-FETCH
  • 5.5 Working with Unknown Values

Module 6: Working with SQL Server Data Types

  • 6.1 Module 6 Introduction
  • 6.2 Writing Queries that return Date and Time Data
  • 6.3 Writing Queries that use Date and Time Functions
  • 6.4 Writing Queries that return Character Data
  • 6.5 Writing Queries that use Character Functions

Module 7: Using DML to Modify Data

  • 7.1 Module 7 Introduction
  • 7.2 Inserting Records with DML
  • 7.3 Updating Records Using DML
  • 7.4 Deleting Records Using DML

Module 8: Using Built-In Functions

  • 8.1 Module 8 Introduction
  • 8.2 Writing Queries with Built-In Functions
  • 8.3 Using Conversion Functions
  • 8.4 Using Logical Functions
  • 8.5 Using Functions to Work with NULL

Module 9: Grouping and Aggregating Data

  • 9.1 Module 9 Introduction
  • 9.2 Using Aggregate Functions
  • 9.3 Using the GROUP BY Clause
  • 9.4 Filtering Groups with HAVING

Module 10: Using Subqueries

  • 10.1 Module 10 Introduction
  • 10.2 Writing Self-Contained Subqueries
  • 10.3 Writing Correlated Subqueries
  • 10.4 Using the EXISTS Predicate with Subqueries

Module 11: Using Table Expressions

  • 11.1 Module 11 Introduction
  • 11.2 Using Views
  • 11.3 Using Inline Table-Valued Functions
  • 11.4 Using Derived Tables
  • 11.5 Using Common Table Expressions

Module 12: Using Set Operators

  • 12.1 Module 12 Introduction
  • 12.2 Writing Queries with the UNION operator
  • 12.3 Using EXCEPT and INTERSECT
  • 12.4 Using APPLY

Module 13: Using Window Ranking, Offset, and Aggregate Functions

  • 13.1 Module 13 Introduction
  • 13.2 Creating Windows with OVER
  • 13.3 Exploring Window Functions

Module 14: Pivoting and Grouping Sets

  • 14.1 Module 14 Introduction
  • 14.2 Writing Queries with PIVOT and UNPIVOT
  • 14.3 Working with Grouping Sets

Module 15: Implementing Error Handling

  • 15.1 Module Introduction
  • 15.2 Implementing T-SQL error handling
  • 15.3 Implementing structured exception handling

Module 16: Managing Transactions

  • 16.1 Module 16 Introduction
  • 16.2 Transactions and the Database Engine
  • 16.3 Controlling Transactions
  • 16.4 Course Wrap Up

Modes of Learning

Test yourself! Our academic experts have created quiz systems to ensure that you know what you know about your subject. Review quizzes will not only enhance your learning process but will also give you a perspective on the content.
The quizzes are characterized by our system of three distinct phases.
Pre-test: For you to know about your previous knowledge. It will allow us to give you a quiz based on what you already know. Thus, saving time, energy, and hassle.
Post-test: Just the way it is done in all academic systems. This sort of exam will test you based on what you were able to gain throughout the training session.
Final Test: Just like the way it is, your knowledge finally gets tested through a designed preparatory question.
Read it just right. When we say our training process is nothing but fun, this is what we mean. Edutainment has always been our way. Who could say that learning can not be fun? While for some IT training might be a source of fun, for others it might be boredom. That’s where our brain teaser games jump in. Get your hands on interesting learn-from-games like:
  • Flashcards: Remember the “read and guess” games we used to play back then? Here’s to enhance what you learned. How does it work? A statement will be written on a flashcard, and you’ll need to guess the answer. Then flip it over to see if you answered it correctly. The cards continue, each with a random statement from the course that you took previously.
  • Scatter: “Make Everything Disappear.” Turn the screen white and vanish it all but this time testing your knowledge and your time being monitored. Find the best match and click your way toward success. This brain teaser might give you a hard time! But education combined with games adds an element of fun to it.
  • Learn: Here’s another. Read and choose the right answer. A game designed on a Multiple-Choice pattern. This kind of exercise boosts your confidence. When one option seems to be correct, you choose the other only for it to be the right option. The right option will welcome another statement, but don’t sweat! You are still learning.
  • Speller: This fun-packed game is unique in its own way. Hear the term carefully and type it out on your screen. You think you are a pro at learning spellings of tricky terms. Test yourself out with this game. Could you hear it properly? If you could, were you able to write it?
And who doesn’t need the reward? After you have finally gained the maximum from all modules designed; own a “Recognition Certificate” to validate what you learned. The notable feature of this recognition certificate is your ability to literally flaunt your skills. Be it your professional social media handle or your first step toward your career choice (interview); just attach the certification and boom! You just became a pro at your skill.
We have found our students doing absolutely great by showcasing their certificates. Grab that certificate of yours before someone else does and get that recognition you deserve.

You best learn when you see it. Our easy-to-understand video content is in place for you. Watch the studying content and grasp all the concepts easily. With so many lectures and 3000+ hours of video content, find what suits your needs. These educational videos are designed to sharpen your experience with your training content. Our easy-to-understand video content is in place for you. Watch the studying content and grasp all the concepts easily.

In contrast to other e-learning services, our labs will let you exercise what you analyze in a real environment with a lot to choose from. This layout mirrors the traditional study room format which ensures you will recognize exactly the way to set up, manage and troubleshoot any environment.
Being a successful IT professional involves more than knowing key terms and concepts. You need to be able to “apply” your knowledge to real-world situations. At EZDA we quote, “Learn it to pertain to it.” So, why spend money buying the equipment when we got you all covered?

This package includes pdf workbooks, course outlines, course overview, and workbook. One of the most important features of our eBooks is their easy content. You don’t need to worry about a critical term. Meaning no matter what level of difficulty your IT training is, you will never have to decode it. We will have it done for you.