Introduction to Transact SQL

Introduction to Transact SQL, available at Free, has an average rating of 4.4, with 50 lectures, based on 185 reviews, and has 11349 subscribers.

You will learn about SQL Dialects ASCII vs Unicode Data Types Case-Sensitive Collation Filtering Records with the Where Clause Sorting Result Sets This course is ideal for individuals who are Database Administrators or Database Developers or Database Professionals or SQL Specialists It is particularly useful for Database Administrators or Database Developers or Database Professionals or SQL Specialists.

Enroll now: Introduction to Transact SQL

Summary

Title: Introduction to Transact SQL

Price: Free

Average Rating: 4.4

Number of Lectures: 50

Number of Published Lectures: 50

Number of Curriculum Items: 50

Number of Published Curriculum Objects: 50

Original Price: Free

Quality Status: approved

Status: Live

What You Will Learn

SQL Dialects
ASCII vs Unicode
Data Types
Case-Sensitive Collation
Filtering Records with the Where Clause
Sorting Result Sets

Who Should Attend

Database Administrators
Database Developers
Database Professionals
SQL Specialists

Target Audiences

Database Administrators
Database Developers
Database Professionals
SQL Specialists

This free course is only an introduction of Transact SQL, to give you an idea about how Transact SQL database queries are performed in Visual Studio. This course is not intended to make you an expert in Transact-SQL, instead the course is designed to give you a basic idea to help you plan your future learning and project.

Transact SQL or T-SQL is a standardized computer language for querying, altering and defining relational databases, using declarative statements. While this course is specifically focused on Microsoft product, most of what you learn will be applicable to any SQL based database including Oracle, DB2, MySQL etc.

This course does not assume that you have any prior knowledge of T-SQL. If you understand relational database concepts it will be a benefit, however it is not a prerequisite.

Course Curriculum

Chapter 1: Introduction

Lecture 1: Introduction

Chapter 2: Module 1: T-SQL Querying Concepts

Lecture 1: T-SQL Querying Concepts

Chapter 3: Lesson 1: SQL Dialects

Lecture 1: Lesson 1: SQL Dialects

Chapter 4: Lesson 2: Formatting

Lecture 1: Formatting

Lecture 2: Formatting the Query

Lecture 3: Formatting Query Output

Lecture 4: Statistics

Lecture 5: Semi Colon

Lecture 6: Print

Chapter 5: Lesson 3: ASCII vs Unicode

Lecture 1: ASCII vs Unicode

Lecture 2: ASCII vs Unicode

Lecture 3: Using LEN

Lecture 4: Concatinate

Chapter 6: Lesson 4: Data Types

Lecture 1: Data Types

Lecture 2: Creating a Variable

Lecture 3: Understanding Batches

Lecture 4: Character Strings

Lecture 5: Using Character Strings

Lecture 6: Integers

Lecture 7: Using Integers

Lecture 8: Date & Time

Lecture 9: Date & Time Functions: Get Date

Lecture 10: Date & Time Functions: Date Name

Lecture 11: Date & Time Functions: EOM

Lecture 12: Table Data Type

Chapter 7: Lesson 5: NULL

Lecture 1: NULL

Lecture 2: Condition for Null

Lecture 3: Comparing Null

Chapter 8: Module Summary

Lecture 1: Module Summary

Chapter 9: Module 2: Select, From, Where and Order By Clauses

Lecture 1: Select, From, Where and Order By Clauses

Chapter 10: Lesson 1: Getting Started

Lecture 1: Sequal Server Management Studio

Lecture 2: Focusing a Database, with Use Statement

Lecture 3: Reading data from table, using Select Statement

Lecture 4: Using Intelli Sense

Lecture 5: Using Expressions

Lecture 6: Using Comments

Lecture 7: Formatting Tips

Chapter 11: Lesson 2: Case-Sensitive Collation

Lecture 1: Case-Sensitive Collation

Lecture 2: Case-Sensitive Collation

Chapter 12: Lesson 3: Aliasing Columns and Tables

Lecture 1: Aliasing Columns and Tables

Lecture 2: Aliasing Columns and Tables

Chapter 13: Lesson 4: Filtering Records with the Where Clause

Lecture 1: Filtering Records

Lecture 2: Filtering Records with the Where Clause

Lecture 3: Filtering Records Using Like Clause

Lecture 4: Filtering Records Using Wild Card

Lecture 5: Filtering Records Using In & Between

Chapter 14: Lesson 5: Sorting Result Sets

Lecture 1: Sorting Result Sets

Lecture 2: Indexing

Lecture 3: Using OrderBy

Chapter 15: Module Summary