Learning Microsoft Transact - SQL

Creating, querying, and programming with SQL databases using the Microsoft of Sybase extension language.
4.6 (49 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.
574 students enrolled
$19
$50
62% off
Take This Course
  • Lectures 93
  • Length 7 hours
  • Skill Level Beginner Level
  • Languages English
  • Includes Lifetime access
    30 day money back guarantee!
    Available on iOS and Android
    Certificate of Completion
Wishlisted Wishlist

How taking a course works

Discover

Find online courses made by experts from around the world.

Learn

Take your courses with you and learn anywhere, anytime.

Master

Learn and practice real-world skills and achieve your goals.

About This Course

Published 12/2014 English

Course 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.

What are the requirements?

  • no prior database or programming knowledge required

What am I going to get from this course?

  • 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.

What is the target audience?

  • anyone wanting to learn more about SQL database design and Microsoft's extension language
  • developers and IT professionals interested in Microsoft certification

What you get with this course?

Not for you? No problem.
30 day money back guarantee.

Forever yours.
Lifetime access.

Learn on the go.
Desktop, iOS and Android.

Get rewarded.
Certificate of completion.

Curriculum

Section 1: Introduction
Important - Download These First - Working Files
Preview
Article
Introduction To Transact-SQL
Preview
01:18
Course Overview
Preview
02:52
What Is Transact SQL?
Preview
06:11
Why Should I Learn T-SQL?
05:26
Certifications
05:54
How To Access Your Working Files
03:22
Section 2: Understanding Databases
History Of Databases
06:16
What Is A Database?
06:08
Database Structures And Purposes
05:49
Terminology And Acronyms
06:18
Section 3: Microsoft SQL Server
SQL Server Editions
04:54
Getting SQL Server Express
04:06
Installing SQL Server Express - Part 1
05:23
Installing SQL Server Express - Part 2
04:47
SSMS On Windows 7
06:03
SSMS On Windows 8
02:46
The Query Analyzer
06:12
Attaching The Sample Database
04:55
Section 4: T-SQL Foundations
The Nature Of SQL
05:36
SQL Books Online
05:29
DDL And DML
03:44
The Four Horsemen Of T-SQL
05:02
How Queries Are Executed
06:27
Working With Queries And Scripts
05:40
Section 5: Creating A Database With T-SQL
Creating A Database - Part 1
05:13
Creating A Database - Part 2
06:16
Understanding Filegroups
05:25
Understanding Tables
04:37
T-SQL Character Datatypes
06:13
Understanding Unicode Data Types
04:51
T-SQL Numeric Datatypes
06:14
T-SQL Data Type Synonyms
05:12
Creating A Table
05:15
Understanding Primary Keys
05:35
Adding A Primary Key
05:01
Schema Basics
05:06
Working With Schemas
05:07
Using Synonyms - Part 1
03:34
Using Synonyms - Part 2
03:32
Section 6: Querying With T-SQL
Understanding SELECT
06:01
Column Aliasing
05:20
Ordering Results
04:34
Using JOIN - Part 1
06:22
Using JOIN - Part 2
05:39
Inner And Outer And Cross Joins - Part 1
05:49
Inner And Outer And Cross Joins - Part 2
05:39
Refreshing Intellisense
02:14
Aggregate Functions
05:22
Grouping Data
05:06
Group By Example
04:34
The HAVING Clause
04:17
HAVING And WHERE
04:46
Select Into
04:34
Multipart Naming
04:50
Using Graphical Tools
05:47
Section 7: Modifying Data With T-SQL
The INSERT Statement
05:49
Inserting Multiple Rows
01:47
INSERT SELECT
04:52
The UPDATE Statement - Part 1
04:51
The UPDATE Statement - Part 2
03:41
The DELETE Statement
04:22
SELECT Then DELETE
03:07
Section 8: T-SQL Programming Basics
Delimiters
06:03
Concatenation
03:49
Comments
02:32
T-SQL Variables
05:10
SET And SELECT
05:28
Operators And Expressions
05:18
Batches
04:10
Using EXECUTE - Part 1
04:50
Using EXECUTE - Part 2
02:19
Section 9: Control-Of-Flow Language Elements
IF Statements
04:23
GOTO
04:00
TRY CATCH
05:25
WHILE
03:02
CASE Statements
04:58
Section 10: Programming Objects
Understanding Views
05:36
Stored Procedures
04:05
Creating A Stored Procedure
02:56
Input Parameters
03:47
User-Defined Functions
01:52
Creating A Function
05:14
Section 11: Indexing
Index Basics
05:52
Creating And Dropping Indexes
05:27
Index Considerations
03:52
Section 12: Understanding Normalization
Normalization
03:51
Normalization Example
03:19

Students Who Viewed This Course Also Viewed

  • Loading
  • Loading
  • Loading

Instructor Biography

Infinite Skills, High Quality Training

Infinite Skills is a Canadian based company who offer a huge and ever growing range of high quality eLearning solutions that teach using studio quality narrated videos backed-up with practical hands-on examples and comprehensive working files. All courses are created by trained educators and experts in video based education.

The emphasis is on teaching real life skills that are essential for progressing in today's commercial environment.

Ready to start learning?
Take This Course