Learn to Program with T- SQL
4.5 (5 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.
434 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Learn to Program with T- SQL to your Wishlist.

Add to Wishlist

Learn to Program with T- SQL

Practical SQL Programming To Manipulate Databases
4.5 (5 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.
434 students enrolled
Created by Skill Tree
Last updated 8/2017
English
Curiosity Sale
Current price: $10 Original price: $125 Discount: 92% off
30-Day Money-Back Guarantee
Includes:
  • 5.5 hours on-demand video
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I Learn?
  • Install SQL Server
  • Download and attach a database
  • Write basic T-SQL queries
  • Retrieve Data using SELECT Statement
  • Sorting Data output using ORDER BY Statement
  • Filtering Data using various filters
  • Modifying data: Add , Update, Delete
  • Implement a stored procedure
  • Combine data from multiple tables
  • Use Aggregate functions to compute single value output
View Curriculum
Requirements
  • You should be comfortable using a computer
  • You should be comfortable navigating the internet.
Description

SQL (Structured Query Language) is a common tool for retrieving data from relational databases such as SQL Server,Oracle, MySQL, MariaDB, and PostgreSQL. SQL skills is in the Top 3 of requested IT Skills by recruiters and companies all over the world.

T-SQL is also popularly referred 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. 

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.

 This beginner  course provides an introduction to this core  programming language.
  Learn how to:
  Request data from a server,
  Limit  and sort the  data responses
  Get single output value using aggregate functions
  Combine data from multiple tables with joins
  Modify data: Add, Update and Delete
  Filter records and remove duplicates
  Write basic T-SQL Statements
  Understand T-SQL TOP Command
  Understand Normalisation

Who is the target audience?
  • Beginner SQL Programmers
  • Beginner Database Administrators
  • Beginner Data Analyst
  • Beginner Data warehouse analyst
  • Anyone working with data
Students Who Viewed This Course Also Viewed
Curriculum For This Course
49 Lectures
05:32:22
+
Basic Database Concepts
5 Lectures 31:10


What is a Database
08:20

What is a Primary Key
04:50

What is a Foreign Key
04:39
+
SQL Server and Database Setup
12 Lectures 01:19:02
System Requirements
02:49

Download SQL Server Express Edition 2014
04:07

Install SQL Server Express 2014
06:47

Download Sample Database
05:06

Attach Sample Database to SQL Server 2014
04:14

Exploring SSMS
08:21

What is Intellisense
07:52

Using SQL USE Command
07:37

What is Normalization
14:13

Using T-SQL GO Command
05:07

Using SQL DISTINCT and TOP Command
06:42

Using Comments
06:07
+
How to Get Data from a Database
6 Lectures 53:56
Using SELECT Statement
12:53

Using Aliases
07:12

Using Case Expressions
12:15

Sort data in Ascending Order
04:34

Sorting Data in Descending Order
05:03

Using Stored Procedures
11:59
+
Combining Data from multiple Database Tables
6 Lectures 35:41
Introduction to Table Joins
00:27

Why are Table joins important?
00:49

Getting Data with INNER Join
10:36

Getting Data with LEFT -OUTER Join
12:26

Getting Data with RIGHT -OUTER Join
09:30

Summary
01:53
+
Returning Single Value Data with Aggregate Functions
8 Lectures 47:39
Introduction
02:12

COUNT Function
09:24

SUM function
07:17

MAX function
06:49

MIN function
06:50

AVG function
07:52

Querying Data Using Multiple Aggregate Functions
05:09

Summary
02:06
+
Inserting and Modifying Data
5 Lectures 31:00
Introduction
01:40

Adding Records
10:34

Deleting Records
07:53

Updating records
09:18

Summary
01:35
+
How To Filter Data From a Database
7 Lectures 53:54
Introdution
02:16

Using Basic Comparison Filters
06:07

Using Equality Filters
13:35

Using Logical Filters
14:08

Using String Comparison filters
11:22

Using NULL as filters
04:35

Summary
01:51
About the Instructor
Skill Tree
4.3 Average rating
291 Reviews
7,691 Students
19 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.