Learning Microsoft Transact - SQL
4.6 (129 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.
854 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Learning Microsoft Transact - SQL to your Wishlist.

Add to Wishlist

Learning Microsoft Transact - SQL

Creating, querying, and programming with SQL databases using the Microsoft of Sybase extension language.
Bestselling
4.6 (129 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.
854 students enrolled
Created by Infinite Skills
Last updated 1/2017
English
Current price: $10 Original price: $50 Discount: 80% off
5 hours left at this price!
30-Day Money-Back Guarantee
Includes:
  • 7 hours on-demand video
  • 1 Article
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I 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.
View Curriculum
Requirements
  • no prior database or programming knowledge required
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.

Who 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
Students Who Viewed This Course Also Viewed
Curriculum For This Course
93 Lectures
07:14:19
+
Introduction
7 Lectures 25:04




Why Should I Learn T-SQL?
05:26

Certifications
05:54

How To Access Your Working Files
03:22
+
Understanding Databases
4 Lectures 24:31
History Of Databases
06:16

What Is A Database?
06:08

Database Structures And Purposes
05:49

Terminology And Acronyms
06:18
+
Microsoft SQL Server
8 Lectures 39:06
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
+
T-SQL Foundations
6 Lectures 31:58
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
+
Creating A Database With T-SQL
15 Lectures 01:17:11
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
+
Querying With T-SQL
16 Lectures 01:20:54
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
+
Modifying Data With T-SQL
7 Lectures 28:29
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
+
T-SQL Programming Basics
9 Lectures 39:39
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
+
Control-Of-Flow Language Elements
5 Lectures 21:48
IF Statements
04:23

GOTO
04:00

TRY CATCH
05:25

WHILE
03:02

CASE Statements
04:58
+
Programming Objects
6 Lectures 23:30
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
4 More Sections
About the Instructor
Infinite Skills
4.4 Average rating
44,573 Reviews
723,819 Students
331 Courses
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.