Learning Microsoft Transact - SQL

Creating, querying, and programming with SQL databases using the Microsoft of Sybase extension language.

4.60 (413 reviews)
Udemy
platform
English
language
Other
category
instructor
Learning Microsoft Transact - SQL
1,679
students
7 hours
content
Jan 2017
last update
$59.99
regular price

What you will learn

create new databases and tables using Transact SQL.

query and modify data within a T-SQL database.

perform basic programming and optimization tasks within an SQL database.

Description

If you're eager to learn how to create SQL databases or more specifically work with Microsoft's T-SQL extension language, this course is for you. The tutorials are designed for the absolute beginner, meaning no previous experience with Transact is required.

You will start by learning about databases, then jump into learning about the Microsoft SQL server. From there, Mark will teach you about the T-SQL foundations, how to create a database with T-SQL, and querying with T-SQL. This video tutorial also covers how to modify data with T-SQL, as well as T-SQL programming basics, such as comments, set and select, and batches. You will also learn how to program objects and create and drop indexes. Finally, you will learn to understand normalization and transactions. Once you have completed this computer based training course, you will be fully capable of using Transact-SQL to create your own databases and tables to select, insert, and manage data.

Content

Introduction

Important - Download These First - Working Files
Introduction To Transact-SQL
Course Overview
What Is Transact SQL?
Why Should I Learn T-SQL?
Certifications
How To Access Your Working Files

Understanding Databases

History Of Databases
What Is A Database?
Database Structures And Purposes
Terminology And Acronyms

Microsoft SQL Server

SQL Server Editions
Getting SQL Server Express
Installing SQL Server Express - Part 1
Installing SQL Server Express - Part 2
SSMS On Windows 7
SSMS On Windows 8
The Query Analyzer
Attaching The Sample Database

T-SQL Foundations

The Nature Of SQL
SQL Books Online
DDL And DML
The Four Horsemen Of T-SQL
How Queries Are Executed
Working With Queries And Scripts

Creating A Database With T-SQL

Creating A Database - Part 1
Creating A Database - Part 2
Understanding Filegroups
Understanding Tables
T-SQL Character Datatypes
Understanding Unicode Data Types
T-SQL Numeric Datatypes
T-SQL Data Type Synonyms
Creating A Table
Understanding Primary Keys
Adding A Primary Key
Schema Basics
Working With Schemas
Using Synonyms - Part 1
Using Synonyms - Part 2

Querying With T-SQL

Understanding SELECT
Column Aliasing
Ordering Results
Using JOIN - Part 1
Using JOIN - Part 2
Inner And Outer And Cross Joins - Part 1
Inner And Outer And Cross Joins - Part 2
Refreshing Intellisense
Aggregate Functions
Grouping Data
Group By Example
The HAVING Clause
HAVING And WHERE
Select Into
Multipart Naming
Using Graphical Tools

Modifying Data With T-SQL

The INSERT Statement
Inserting Multiple Rows
INSERT SELECT
The UPDATE Statement - Part 1
The UPDATE Statement - Part 2
The DELETE Statement
SELECT Then DELETE

T-SQL Programming Basics

Delimiters
Concatenation
Comments
T-SQL Variables
SET And SELECT
Operators And Expressions
Batches
Using EXECUTE - Part 1
Using EXECUTE - Part 2

Control-Of-Flow Language Elements

IF Statements
GOTO
TRY CATCH
WHILE
CASE Statements

Programming Objects

Understanding Views
Stored Procedures
Creating A Stored Procedure
Input Parameters
User-Defined Functions
Creating A Function

Indexing

Index Basics
Creating And Dropping Indexes
Index Considerations

Understanding Normalization

Normalization
Normalization Example
Normalization And Data Usage

Understanding Transactions

Understanding Transactions
Explicit Transactions
Transactions And Locking

Conclusion

Wrap Up

Reviews

Adiv
October 12, 2022
The instructor explains each concept regarding the construction of queries and their usage in very clear and direct terms, followed by one or more practical examples that help solidify the student's understanding. I attempt to replicate the code and techniques in each example presented by the instructor and observe whether or not my results match those shown in the lesson. As the instructor stated early on in the course, learning by doing is the most effective way to master the material. I am enjoying this series of lectures and feel that I am learning a great deal of very useful and practical information that will prove invaluable in my professional career.
James
May 14, 2021
Perfect and to the point explanation.. also got freebies on Indexing & Normalization ! More value for the money.
Mr
January 29, 2021
The course was too basic for me. Sections 8, 9 and 10 were the only relevant parts. The course title should be changed to Learn SQL and basic T-SQL.
Mirko
November 3, 2016
Great class on T-SQL. The instructor really knows the subject and gives some great history to the program too. A++
Charles
September 27, 2016
Great course ... enjoyed the instructor's style and wit and feel that I got a solid foundation in T-SQL Query writing --- Thank You. I just need to go back and practice all the lessons and exercises from this course and I am sure I will pass 70-461 Exam. Charles.
Louis
August 7, 2016
very good course he seems to be traveling at a speed that is very easy to learn and maintaining a good amount of absorbtion
Juraj
February 25, 2016
My first exposure to SQL. It is a good course that gave me a good ,but quite basic overview. Especially the last couple of chapters are to let you know what is 'out there' in SQL, but it is up to you to find resources and learn that if you need it. Since SELECT seems to be the most important command in SQL I would have welcomed deeper exposure to it, more examples and more tricks how to use it. Otherwise, I am happy that I took this intro course. My next step will be build on these foundations and to find some very hands-on course.
Kuna
January 20, 2016
Literally walks you by hand from start to finish. Easy to understand and covers major points for having a solid understanding of this technology.
Christopher
January 4, 2016
Covers all material well. I found it an excellent resource. Would have benefited from more practical exercises. You'll need to take some initiative and come up with your own ways to practice to get full value.
Tobias
December 16, 2015
I took this T-SQL course alongside of my T-SQL course in school. My course in school was problem based which means we got a T-SQL problem to solve first before getting the theory behind it. I found that using the material in this Udemy T-SQL was great to fill in the gaps for me and to ellaborate a bit more indepth on each topic covered. I can definitely recommend this course to any beginner looking to learn T-SQL.
Rob
December 1, 2015
Love this course, lots of in depth stuff that covers what I've missed teaching myself. Highly Recommended
Anatoly
November 1, 2015
Good Course, Users need to have a solid understanding and hands on experience before looking at this course to understand the syntax be spoken to
Jason
July 30, 2015
I enjoyed this course and only fell asleep once (that says a lot about the course). I found the content very useful and was able to use some of what was learning in the real world from day one at my current place of employment
Edward
June 20, 2015
Broad introduction to T-SQL, which I been using through self-instruction as a support person. The instructor's presentation is clean and easy to follow. Learned a lot.
Maneesh
March 17, 2015
Whether you need a refresher, or are starting out, this is a well organized, back to the basics course that covers key features of T-SQL. The course is well structured, and has a good pace, with sample database to work with.

Charts

Price

Learning Microsoft Transact - SQL - Price chart

Rating

Learning Microsoft Transact - SQL - Ratings chart

Enrollment distribution

Learning Microsoft Transact - SQL - Distribution chart

Related Topics

365968
udemy ID
12/9/2014
course created date
10/15/2020
course indexed date
Bot
course submited by