Find online courses made by experts from around the world.
Take your courses with you and learn anywhere, anytime.
Learn and practice real-world skills and achieve your goals.
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:
Not for you? No problem.
30 day money back guarantee.
Learn on the go.
Desktop, iOS and Android.
Certificate of completion.
|Section 1: Introduction To Some Basic Database Concepts|
What is T-SQLPreview
What is a Database
|Section 2: Setting Up T-SQL Development Test Environment|
Microsoft SQL Server 2014 Express System Requirements
Download Microsoft SQL Server 2014 Express Edition
Install Microsoft SQL Server 2014 Express Edition
Download Sample Database
Install Sample Database
Install SQL Server Management Studio (SSMS)
|Section 3: Retrieving Data with T-SQL|
Querying Data Using SELECT and FROM Keywords
Using Case Expressions
Creating and Reading Data From A View
|Section 4: T-SQL COMMANDS|
T-SQL TOP Command
T-SQL USE COMMAND
SQL DISTINCT AND TOP COMMAND
|Section 5: Using T-SQL To Query Multiple Tables|
Why is Table Joins Necessary
LEFT Outer Join
RIGHT Outer Join
|Section 6: Filtering Records from a Table with T-SQL|
Filtering Records Using Basic Equality Filters
Filtering Records Using Basic Comparisons
Filtering Records Using Logical Comparisons
Filtering Records Using String Comparisons
Filtering Records Using NULL Comparisons
|Section 7: Sorting Returned Records|
ORDER BY Clause
Sorting by Ascending
Sorting By Descending
Sorting By multiple columns
|Section 8: Using Aggregate Functions with T-SQL Query|
COUNT () Aggregate Function
AVG() Aggregate Function
MAX() Aggregate Function
MIN() Aggregate Function
SUM() Aggregate Function
Using Multiple Aggregate Functions in A Single T-SQL Query
|Section 9: Modifying Data|
Adding New Records Into A Database
Updating Records In A Database
Removing Records From A Database
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.