A beginners guide to T-SQL ( Transact-SQL)
3.8 (3 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.
147 students enrolled
Wishlisted Wishlist

Please confirm that you want to add A beginners guide to T-SQL ( Transact-SQL) to your Wishlist.

Add to Wishlist

A beginners guide to T-SQL ( Transact-SQL)

Learn Microsoft's own version of the standard SQL language
3.8 (3 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.
147 students enrolled
Created by 247 Learning
Last updated 1/2017
English
Current price: $10 Original price: $125 Discount: 92% off
5 hours left at this price!
30-Day Money-Back Guarantee
Includes:
  • 5 hours on-demand video
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I Learn?
  • create queries using Transact-SQL
  • Select, filter and sort data from multiple tables
  • Use T-SQL Commands
  • Modify data
  • Use aggregate functions
  • Use Aliases with T-SQL
  • Use case expressions
View Curriculum
Requirements
  • Basic computer knowledge
  • Desire to learn
Description

T-SQL (Transact-SQL) also referred to as T-sequel is Microsoft's implementation of the SQL standard language.
This course is intended for users who are new to writing SQL statements for SQL Server database and
 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.
Transact-SQL is an essential skill for data professionals and developers working with SQL databases

T -SQL requires an SQL Server database i will walk you through downloading and installing SQL Server Express 2014 and also downloading and installing a sample database.

You will be introduced to 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.

   Target Audience:

  •  Novice SQL developers
  •  Novice Database administrators
  •  Aspiring data analyst
  •  Aspiring data warehouse professionals
  •  IT Professionals who want to learn T-SQL


What you'll learn how to:
 
   •  Create Transact-SQL SELECT queries
   •  Work with data types and NULL
   •  Query multiple tables with JOIN
   •  Use Aggregate data
   •  Use table expressions
   •  Group sets and pivot data
   •  Modify data
   •  Filter rows of data
   •  Use basic equality filters
   •  Use logical and comparison filters
   •  Use stored procedures
   •  Aliases
   •  Case expressions


After completing this course you should be confident to write your T-SQL statements and run them against SQL Server Database.

Looking forward to you joining the course :-)



Who is the target audience?
  • IT Professionals who will be writing queries for use with Microsoft SQL Server 2005, 2008, 2012, 2014 and 2016.
  • Aspiring Data Analyst
  • Aspiring database professionals
  • Aspiring Data Warehouse Professionals
  • Aspiring SQL developers
Compare to Other T-SQL Courses
Curriculum For This Course
45 Lectures
05:02:26
+
Database Download and Install
7 Lectures 38:16


Hardware and Software Requirements for SQL Server Express 2014
02:49

Download SQL Server Express2014
04:07

Install SQL Server Express 2014
06:47

Download sample database
05:06

Install Sample Database
06:06
+
Useful T-SQL Commands
5 Lectures 31:42
TOP
06:09

USE
07:37

GO
05:07

DISTINCT and TOP
06:42

Using T-SQL Comments
06:07
+
Retrieving and Sorting Data with T-SQL
7 Lectures 57:04
Using SELECT Statements
12:53

Aliases
07:12

Using ORDER BY clause
03:02

Sort by ascending order
04:34

Sort by multiple columns
05:09

Case Expressions
12:15

Using Stored Procedures
11:59
+
How to query multiple tables with T-SQL
6 Lectures 35:41
Introduction to Table Joins
00:27

Why are table joins relevant
00:49

INNER Table Join
10:36

Left Outer Table Join
12:26

Right Outer Table Join
09:30

Conclusion
01:53
+
Filtering Rows of data with T-SQL
7 Lectures 52:52
Introduction
02:16

Using basic equality filters
13:35

Using basic comparison
06:07

Using logical comparisons
14:08

Using String Comparison
11:22

Using Null Comparison
04:35

Summary
00:49
+
Using T-SQL to modify data
5 Lectures 31:00
Introduction
01:40

Add new records to a database
10:34

Update existing data in the database
09:18

Delete data from a database
07:53

Summary
01:35
+
How to use T-SQL with Aggregate functions
8 Lectures 55:51
Introduction
02:12

COUNT Function
09:24

AVG Function
07:52

MAX Function
06:49

MIN Function
06:50

SUM function
07:17

Grouping Data
08:10

Summary
07:17
About the Instructor
247 Learning
4.7 Average rating
46 Reviews
2,176 Students
7 Courses
An investment in knowledge pays the best interest

Hello and welcome to 247 Learning.

We are a small company from the united kingdom that create and teach designs.Our teaching style is designed to be simple and step by step.

We have taught courses like Adobe Photoshop, Adobe Illustrator,Adobe Indesign as well as web design related courses .
Our very first Udemy course was "How to create resume /cv for profit" which has over 500 students.
We will continue to add more courses on the Udemy platform.
Our tutors have  over 7 years of a wide range of industry experience and understand how to teach in a way that students can understand.