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!
You may also like
- Top 10 Video Editing Courses to Learn in November 2024
- Top 10 Music Production Courses to Learn in November 2024
- Top 10 Animation Courses to Learn in November 2024
- Top 10 Digital Illustration Courses to Learn in November 2024
- Top 10 Renewable Energy Courses to Learn in November 2024
- Top 10 Sustainable Living Courses to Learn in November 2024
- Top 10 Ethical AI Courses to Learn in November 2024
- Top 10 Cybersecurity Fundamentals Courses to Learn in November 2024
- Top 10 Smart Home Technology Courses to Learn in November 2024
- Top 10 Holistic Health Courses to Learn in November 2024
- Top 10 Nutrition And Diet Planning Courses to Learn in November 2024
- Top 10 Yoga Instruction Courses to Learn in November 2024
- Top 10 Stress Management Courses to Learn in November 2024
- Top 10 Mindfulness Meditation Courses to Learn in November 2024
- Top 10 Life Coaching Courses to Learn in November 2024
- Top 10 Career Development Courses to Learn in November 2024
- Top 10 Relationship Building Courses to Learn in November 2024
- Top 10 Parenting Skills Courses to Learn in November 2024
- Top 10 Home Improvement Courses to Learn in November 2024
- Top 10 Gardening Courses to Learn in November 2024