T-SQL For Beginners: Learn to Query SQL Server Databases
- 4.5
-
![]()
![]()
![]()
![]()
![]()
Brief Introduction
Learn how to use Microsoft's version of SQL to Query Microsoft SQL Server DatabasesDescription
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.
Requirements
- 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
Knowledge
- 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
Bluelime Learning Solutions
4.5 Raiting
The Complete Google BiqQuery Masterclass: Beginner to Expert
- 3.9
-
![]()
![]()
![]()
![]()
![]()
Master Google BigQuery Analytics with SQL used in Big Query to analyze Real data for data scientists, Developers, etc. This is a complete Google google bigquery training"...
Develop Full iOS Twitter Clone App in Swift & Custom Backend
- 4.6
-
![]()
![]()
![]()
![]()
![]()
Best Swift, PHP, HTML Course Ever | Build Full Twitter Clone | All Features & Functionalities | Build iOS Social Network Create App to make you rich and popular?...
Microsoft SQL from scratch - Beginner to Expert
- 3.7
-
![]()
![]()
![]()
![]()
![]()
Practical Hands-on Real World SQL Skills Data is everywhere and growing at a rapid rate. Most Software application we interact with daily deals with stored data ....
Azure SQL Data Warehouse Synapse Analytics Service
- 4.6
-
![]()
![]()
![]()
![]()
![]()
Cloud Data Warehouse in Azure Synapse Analytics Service (formerly Azure SQL Data Warehouse). [Covered: DP-200, DP-201] Why Azure Synapse Analytics Service (formerly Azure SQL Data Warehouse)...
