Buying for a Team? Gift This Course
Wishlisted Wishlist

Please confirm that you want to add Querying Microsoft SQL Server Databases using T-SQL to your Wishlist.

Add to Wishlist

Querying Microsoft SQL Server Databases using T-SQL

Learn To Query Microsoft SQL Server Database using T-SQL
3.0 (2 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
32 students enrolled
Created by Skill Tree
Last updated 3/2016
$15 $85 82% off
30-Day Money-Back Guarantee
  • 3 hours on-demand video
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
Have a coupon?

Microsoft SQL Server is one of the most popular and widely used relational database management systems (RDBMS) in the world.
T-SQL is Microsoft’s own version of the standard SQL language used to query Microsoft SQL Server Databases.
Transact-SQL is integral to the power of SQL Server. Transact-SQL features allow developers to create scalable, distributed applications to meet the demanding requirements of modern organisations.
In this course you will Learn how to setup an SQL Sever environment as well as connect to and query the database using SQL Server Management Studio also known as SSMS. You will learn how to install the adventureworks2014 sample database which we will use for this course .You will learn to query one or many different tables using SELECT statements and also about Aliases and why they are used. You will learn about the various types of tables joins used to get data from multiple tables.
You will be able to Write SQL code based on ANSI/ISO standards to build Microsoft SQL Server or Oracle database structures , Update database content with SQL and transaction handling and Retrieve data with filter conditions and from multiple tables using various types of join

Lectures include:
Writing SELECT queries
Write Transact SQL Queries
Table Joins
Null Values
Query Multiple Tables

This is a hands-on practical course that is taught at a pace that you can follow along easily.
I look forward to welcoming you to the course.

Who is the target audience?
  • This Course is meant for anyone not familiar with Microsoft SQL Server and T-SQL
Students Who Viewed This Course Also Viewed
What Will I Learn?
Download and Install SQL Server
Connect to SQL Server Using SSMS
Know how to use SSMS Tool
Write Basic T-SQL Select Query
Create Aliases
Retrieve NuLL Values
Perform Table Joins
Get Data From Multiple Tables
View Curriculum
  • Download and Install SQL Server . This will be covered in this course.
Curriculum For This Course
Expand All 26 Lectures Collapse All 26 Lectures 03:08:16
Introduction and Lab Setup
5 Lectures 21:38

Hook up Sample Database

Download and Install SSMS
Quering SQL Dtabase Using T-SQL
14 Lectures 02:00:49
What is T-SQL

Basic SELECT Statement


Using NULL

Table Joins

Inner Join

Left Outer Join

Right Outer Join

Full Outer Join

The Use Command

Table Joins Conclusion

Database Normalisation

Case Expressions

Using Comments
Aggregate Functions
7 Lectures 45:49

AVG Function

SUM Function

MAX Function

MIN Function

COUNT Function

Using Multiple Aggregate Functions
About the Instructor
4.2 Average rating
161 Reviews
6,099 Students
15 Courses
Skill based learning

We are experienced company that provides quality video based training .
Our courses are easy to follow and understand and will take you from
an absolute beginner with no technical skills to being efficient and confident with various technical skill like SQL and databases.
We have worked with companies of various sizes and provided consultancy services at various levels.
Thank you for learning with us and we hope your experience will be pleasant.

Report Abuse