T-SQL For Beginners: Learn to Query SQL Server Databases
4.2 (25 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.
482 students enrolled
Wishlisted Wishlist

Please confirm that you want to add T-SQL For Beginners: Learn to Query SQL Server Databases to your Wishlist.

Add to Wishlist

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
4.2 (25 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.
482 students enrolled
Last updated 2/2016
English
Current price: $10 Original price: $175 Discount: 94% off
5 hours left at this price!
30-Day Money-Back Guarantee
Includes:
  • 6 hours on-demand video
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I Learn?
  • 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
View Curriculum
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
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.
Who is the target audience?
  • This Course is suitable for those with basic knowledge of relational databases and SQL
Students Who Viewed This Course Also Viewed
Curriculum For This Course
57 Lectures
06:11:54
+
Introduction To Some Basic Database Concepts
5 Lectures 31:10


What is a Database
08:20

Primary Key
04:50

Foreign Key
04:39
+
Setting Up T-SQL Development Test Environment
9 Lectures 01:00:01
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
+
Retrieving Data with T-SQL
6 Lectures 59:36
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
+
T-SQL COMMANDS
4 Lectures 25:35
T-SQL TOP Command
06:09

T-SQL USE COMMAND
07:37

GO Command
05:07

SQL DISTINCT AND TOP COMMAND
06:42
+
Using T-SQL To Query Multiple Tables
6 Lectures 35:41
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
+
Filtering Records from a Table with T-SQL
7 Lectures 53:54
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
+
Sorting Returned Records
6 Lectures 19:08
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
+
Using Aggregate Functions with T-SQL Query
9 Lectures 55:49
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
+
Modifying Data
5 Lectures 31:00
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
About the Instructor
Bluelime Learning Solutions
4.0 Average rating
1,391 Reviews
33,508 Students
81 Courses
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.