T-SQL For Beginners: Learn to Query SQL Server Databases

Learn how to use Microsoft's version of SQL to Query Microsoft SQL Server Databases
3.6 (13 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.
406 students enrolled
$19
$175
89% off
Take This Course
  • Lectures 57
  • Length 6 hours
  • Skill Level Beginner Level
  • Languages English
  • Includes Lifetime access
    30 day money back guarantee!
    Available on iOS and Android
    Certificate of Completion
Wishlisted Wishlist

How taking a course works

Discover

Find online courses made by experts from around the world.

Learn

Take your courses with you and learn anywhere, anytime.

Master

Learn and practice real-world skills and achieve your goals.

About This Course

Published 1/2016 English

Course Description

Welcome everyone to the T-SQL course. T-SQL is also popularly referefered to as T-Sequel .In this course you will learn all the basics of T-SQL. We will discuss the T-SQL features step by step. We will be using SQL Server Express 2014 (which is a free download). As a sample, we will use AdventureWorks 2014 as our database. Along the way, we will be creating our own t-SQL queries to get data into a database and also out of a database. But AdventureWorks 2014 will be our main focus. As far as T-SQL, we will start with the simple select statements and add new features as we go. I will introduce you to the data types available so you can make the appropriate selection when creating a column. Then, we will talk about joins, functions, tables, procedures, triggers, indexes, and much more. By the time you are done with this course, you will be very comfortable using T-SQL.
This course will provide you with the basic knowledge and skills to create queries using Transact-SQL. It will teach you how to select, filter and sort data from multiple tables and how to use views and stored procedures. You will also be familiar with SQL Server Management Studio 2014 also known in the tech industry as SSMS. This is the tool you will use to write and see the output of your T-SQL queries.

What You Will Learn in this course includes:

  • Query Multiple Database Tables
  • Change query output column names using case expressions
  • Perform Various table joins
  • Filter records and remove duplicates
  • Write basic T-SQL Statements
  • Understand T-SQL TOP Command
  • Understand Normalisation
  • Know how to use SSMS
  • Create Views
  • Create Stored Procedures
  • Understand NULL Values
  • Data Types
  • Functions

This is a video based course of about hours with lots of practical hands on examples to follow along.

What are the requirements?

  • Download and Intall Sample SQL Server 2014 Server Express edition.We'll cover this in the course
  • Download and install SQL Server Management Studio 2014.We'll cover this in the course
  • Download and install Adventureworks2014 sample database.We'll cover this in the course

What am I going to get from this course?

  • Query Multiple Database Tables
  • Change query output column names using case expressions
  • Perform Various table joins
  • Filter records and remove duplicates
  • Write basic T-SQL Statements
  • Understand T-SQL TOP Command
  • Understand Normalisation
  • Know how to use SSMS
  • Create Views
  • Create Stored Procedures
  • Understand NULL Values

What is the target audience?

  • This Course is suitable for those with basic knowledge of relational databases and SQL

What you get with this course?

Not for you? No problem.
30 day money back guarantee.

Forever yours.
Lifetime access.

Learn on the go.
Desktop, iOS and Android.

Get rewarded.
Certificate of completion.

Curriculum

Section 1: Introduction To Some Basic Database Concepts
Introduction
Preview
02:54
What is T-SQL
Preview
10:27
What is a Database
08:20
Primary Key
04:50
Foreign Key
04:39
Section 2: Setting Up T-SQL Development Test Environment
Microsoft SQL Server 2014 Express System Requirements
04:52
Download Microsoft SQL Server 2014 Express Edition
04:04
Install Microsoft SQL Server 2014 Express Edition
04:55
Download Sample Database
04:58
Install Sample Database
06:06
Install SQL Server Management Studio (SSMS)
04:40
SSMS
08:21
Intellisense
07:52
Normalisation
14:13
Section 3: Retrieving Data with T-SQL
Querying Data Using SELECT and FROM Keywords
12:53
Using Aliases
07:12
Using Case Expressions
12:15
Creating and Reading Data From A View
09:10
T-SQL Comments
06:07
Stored Procedures
11:59
Section 4: T-SQL COMMANDS
T-SQL TOP Command
06:09
T-SQL USE COMMAND
07:37
GO Command
05:07
SQL DISTINCT AND TOP COMMAND
06:42
Section 5: Using T-SQL To Query Multiple Tables
Introduction
00:27
Why is Table Joins Necessary
00:49
INNER JOIN
10:36
LEFT Outer Join
12:26
RIGHT Outer Join
09:30
Conclusion
01:53
Section 6: Filtering Records from a Table with T-SQL
Introduction
02:16
Filtering Records Using Basic Equality Filters
13:35
Filtering Records Using Basic Comparisons
06:07
Filtering Records Using Logical Comparisons
14:08
Filtering Records Using String Comparisons
11:22
Filtering Records Using NULL Comparisons
04:35
Summary
01:51
Section 7: Sorting Returned Records
Introduction
00:31
ORDER BY Clause
03:02
Sorting by Ascending
04:34
Sorting By Descending
05:03
Sorting By multiple columns
05:09
Summary
00:49
Section 8: Using Aggregate Functions with T-SQL Query
Introduction
02:12
COUNT () Aggregate Function
09:24
AVG() Aggregate Function
07:52
MAX() Aggregate Function
06:49
MIN() Aggregate Function
06:50
SUM() Aggregate Function
07:17
Using Multiple Aggregate Functions in A Single T-SQL Query
05:09
Grouping Data
08:10
Summary
02:06
Section 9: Modifying Data
Introduction
01:40
Adding New Records Into A Database
10:34
Updating Records In A Database
09:18
Removing Records From A Database
07:53
Summary
01:35

Students Who Viewed This Course Also Viewed

  • Loading
  • Loading
  • Loading

Instructor Biography

Bluelime Learning Solutions, Learning made simple

Bluelime is UK based and creates quality easy to understand eLearning solutions .All our courses are 100% video based. We teach hands –on- examples that teach real life skills .

Bluelime has engaged in various types of projects for fortune 500 companies and understands what is required to prepare students with the relevant skills they need.

Ready to start learning?
Take This Course