Learn T-SQL basics and query Microsoft SQL Server databases with this comprehensive course, featuring hands-on examples and practical skills for data manipulation.
This T-SQL course is all about mastering Microsoft’s SQL for querying databases. You’ll start with the basics and slowly dive into advanced features using SQL Server Express. By the end, you’ll feel totally at home with T-SQL and ready to create your own queries! Yay!
Learn how to use Microsoft's version of SQL to Query Microsoft SQL Server Databases
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
Query Multiple Database Tables
Change query output column names using case expressions
Perform Various table joins
9 Lectures
6 Lectures
6 Lectures
7 Lectures
6 Lectures
9 Lectures
Welcome to the vibrant learning hub of Bluelime Learning Solutions! Based in the UK, we are dedicated to crafting high-quality, easily digestible eLearning experiences. With a robust following of over 776,000 students and backed by more than 43,000 reviews, we take pride in delivering educational content that not only enlightens but also empowers.At Bluelime Learning Solutions, our approach is simple:...
Yes it is very good course
There was lot of repetition of the same thing, lecture after lecture. In at least 30 lectures, in the beginning the instructor is repeating the same thing to open the Management Studio and select AdventureWorks2014 db, so that part was boring.
Very good explanations, easy to follow steps when practicing along to the videos.
Great beginner course, although there was about 1-2 min of every video explaining the same thing every time such as explaining what database we are using and that he is using Microsoft SQL Server Management Studio.
The course is extremely explanatory
The Instructor was thorough and specific. However, the adventure works database is no longer available for download please, advise.
i am currently taking this course at a college and using Udemy as my review. I have found this course to be better taught than the $1000 course at the school.
When downloading sql server, I noticed there was a 2017 version available. Perhaps that would be better for those of us wanting to use the newest resource. 2014 was used in this course.
It seems there was some issue with the installation as I could not find ssms when the course called for it.
Additionally, suggested resources are not linked, you must search them to find the downloads, putting your computer at risk for malicious software if you choose the wrong page.
Finally, issues with the sample database included: a link that pointed to an out-of-date site, recommended zip software not required, unclear instructions on what you were doing.
Would not recommend this course if you are beginner. Not very user-friendly and not kept up with.
This was an excellent match for me.
Your email address will not be published. Required fields are marked *
Fabian W.
Der Kurs ist für mich leider nichts gewesen. Er ist für absolute Anfänger, die noch absolut nie in ihrem Leben Daten, Tabellen oder ähnliches gesehen haben. Auch ist mir trotz des ganzen Kurses nicht klar was T-SQL von SQL oder PL-SQL unterscheidet.
Didaktisch war mir der Kurs auch zu langsam und es wurde vieles zu oft wiederholt. Hätte man auch in weniger Zeit erledigen können.