Beginning T-SQL for SQL Server Developer, Data Analyst DBA

Beginning T-SQL for SQL Server Developer, Data Analyst & DBA, available at $19.99, has an average rating of 4.5, with 48 lectures, based on 11 reviews, and has 73 subscribers.

You will learn about Creating Database , Tables and Performing DML Operations Basic T-SQL – SELECT , WHERE , GROUP BY ,HAVING, BETWEEN , LIKE etc Joins – Inner Left Right Full & Cross Schema SubQueries DataTypes Implicit and Explicit Conversion CASE Statements Joining more than two tables InBuilt Functions This course is ideal for individuals who are Beginner Developers, DBAs or Data Analysts curious about Microsoft SQL Server Database Engine It is particularly useful for Beginner Developers, DBAs or Data Analysts curious about Microsoft SQL Server Database Engine.

Enroll now: Beginning T-SQL for SQL Server Developer, Data Analyst & DBA

Summary

Title: Beginning T-SQL for SQL Server Developer, Data Analyst & DBA

Price: $19.99

Average Rating: 4.5

Number of Lectures: 48

Number of Published Lectures: 47

Number of Curriculum Items: 48

Number of Published Curriculum Objects: 47

Original Price: $39.99

Quality Status: approved

Status: Live

What You Will Learn

Creating Database , Tables and Performing DML Operations

Basic T-SQL – SELECT , WHERE , GROUP BY ,HAVING, BETWEEN , LIKE etc

Joins – Inner Left Right Full & Cross

Schema

SubQueries

DataTypes

Implicit and Explicit Conversion

CASE Statements

Joining more than two tables

InBuilt Functions

Who Should Attend

Beginner Developers, DBAs or Data Analysts curious about Microsoft SQL Server Database Engine

Target Audiences

Beginner Developers, DBAs or Data Analysts curious about Microsoft SQL Server Database Engine

This course starts from the beginning , no prior knowledge is needed and it is step By step Practical Training on Programming Transact SQL Query from basics on Microsoft SQL Server Database Engine

This course is must for all the Aspirants who want to become Microsoft SQL Server Database Developers , Microsoft Database Administrator, Web Developers such as .NET Developers,Database ANALYSTS , Report Developers such as SSRS or ETL Developers such as SSIS etc

Following are the course contents which are covered in this course T-SQL Online SQL Server Video Step By Step Training

Introduction

What is a Relational Database

What is Relational Database Management System

SSMS and SQL Server Database Engine

SQL Server and SSMS Installation

Basic T-SQL

Creating DB Tables & Inserting Data into the tables

Primary Key and Foreign Key

Basic Select Commands

Aggregate Functions with SELECT Command

Group By Clause using Single and Multiple Columns

Difference Between WHERE and HAVING Clause

Syntax of SELECT Command

T-SQL Joins to query SQL Server

Inner Join

T-SQL with Inner Join and Group By Together

Left Join

Right Join

Full Join

Cross Join

Self-Join

Union Operation

Union All Operation

Intersect Operation

Except Operation

Working with Schema

What is Schema and its Importance

Schema Creation & Transfer and Viewing the objects inside Schema using T-SQL

Subqueries

Getting Started with first Subquery Example

Common Interview Question on Subquery

Joins Group by Derived table Subquery combined TSQL

Subquery as a Column

Subquery using NOT Exists

ALL ANY SOME Keywords in Subquery

Correlated Subquery

Not Exists Keyword Scenario of Correlated Subquery to speed up query performance

Datatypes

Datatype Conversion

Implicit & Explicit Conversion (Type Casting)

DML Operations and Constraints

Many Different Options while performing insert update and delete operations

Primary Key, Foreign Key, Unique, Not NULL, Default, Check Constraints

Joining more than two tables

Joining three tables

Joining four Tables

One more example in joining four tables

Working with CASE Statements and Inbuilt Functions

Performing Select and Update operation using case statement

WHILE Loop

Inbuilt Functions – EOMONTH, IIF, CHOOSE, DatePart, String Functions etc.

Course Curriculum

Chapter 1: Introduction

Lecture 1: Course Contents Covered in this Course

Lecture 2: What is a Relational Database

Lecture 3: What is Relational Database Mananagement System

Lecture 4: SSMS and SQL Server Database Engine

Lecture 5: SQL Server 2022 and SSMS Installation

Chapter 2: Basic T-SQL

Lecture 1: Creating DB Tables & Inserting Data into the tables

Lecture 2: Primary Key and Foreign Key

Lecture 3: Demonstration Scripts

Lecture 4: Basic Select Commands

Lecture 5: Aggregate Functions with SELECT Command

Lecture 6: Group By Clause using Single and Multiple Columns

Lecture 7: Difference Between WHERE and HAVING Clause

Lecture 8: Practice Activity

Lecture 9: Syntax of SELECT Command

Chapter 3: T-SQL Joins to query SQL Server

Lecture 1: Inner Join

Lecture 2: T-SQL with Inner Join and Group By Together

Lecture 3: Practice Activity

Lecture 4: Demonstration Scripts

Lecture 5: Left Right Full Cross Joins

Lecture 6: Self Join

Lecture 7: Union UnionAll Intersect Except Operations

Chapter 4: Working with Schema

Lecture 1: What is Schema and its Importance

Lecture 2: Schema Creation & Transfer and Viewing the objects inside Schema using T-SQL

Chapter 5: SubQueries

Lecture 1: Demonstration Scripts

Lecture 2: Getting Started with first SubQuery Example

Lecture 3: Common Interview Question on SubQuery

Lecture 4: Joins Group by Derived table Subquery combined TSQL

Lecture 5: SubQuery as a Column

Lecture 6: SubQuery using NOT IN

Lecture 7: ALL ANY SOME Keywords in SubQuery

Lecture 8: Correlated SubQuery

Lecture 9: Not Exists Keyword Scenario of Correlated SubQuery to speed up query performance

Chapter 6: DataTypes

Lecture 1: Demonstration Scripts

Lecture 2: Datatypes

Lecture 3: Datatype Conversion Implicit & Explicit -Type Casting

Chapter 7: DML Operations and Contraints

Lecture 1: Demonstration Scripts

Lecture 2: Many Different Options while performing insert update and delete operations

Lecture 3: Primary Key, Foreign Key, Unique, Not NULL, Default, Check Constraints

Chapter 8: Joining more than two tables

Lecture 1: Demonstration Scripts

Lecture 2: Joining three tables

Lecture 3: Joining four Tables

Lecture 4: One more examples in joining four tables

Chapter 9: Working with CASE Statements and Inbuilt Functions

Lecture 1: Demonstration Scripts

Lecture 2: Performing Select and Update operation using case statement

Lecture 3: Explaining WHILE Loop in T-SQL

Lecture 4: InBuilt Functions – EOMONTH,IIF, CHOOSE,DatePart,String Functions etc

Lecture 5: Bonus Lecture

Instructors

Vikas Munjal
SQL Server | MSBI Microsoft Certified Trainer & Consultant

Rating Distribution

1 stars: 0 votes

2 stars: 1 votes

3 stars: 1 votes

4 stars: 2 votes

5 stars: 7 votes

Frequently Asked Questions

How long do I have access to the course materials?

You can view and review the lecture materials indefinitely, like an on-demand channel.

Can I take my courses with me wherever I go?

Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don’t have an internet connection, some instructors also let their students download course lectures. That’s up to the instructor though, so make sure you get on their good side!