Basic Database Concepts
Enroll
Learn without limits - start, switch, or advance your career!
UPI ID - deccansoft@hdfcbank
Note:Once the payment is completed,Please share screenshot to Mrs.Kashmira shah +91 8008327000
Learn querying and modifying data in SQL Server or Azure SQL to programming with Transact-SQL.
T-SQL Select Queries Overview
Watch Now
3 Mins
: 0
Understanding simple SELECT
Watch Now
24 Mins
: 0
Sorting Data
Watch Now
14 Mins
: 0
Filter using Predicates part-1
Watch Now
31 Mins
: 0
Filter using predicates PART-2
Watch Now
20 Mins
: 0
Filter using TOP, OFFSET, FETCH
Watch Now
20 Mins
: 0
Case Expression
Watch Now
10 Mins
: 0
Set Operation
Watch Now
16 Mins
: 0
Working with unknown value
Watch Now
10 Mins
: 0
Aggregate and Built-in Functions Overview
Watch Now
3 Mins
: 0
Aggregate Functions Introduction
Watch Now
20 Mins
: 0
Understanding GroupBy
Watch Now
20 Mins
: 0
Understanding Having Clause
Watch Now
34 Mins
: 0
Introduction To Built-in Functions
Watch Now
33 Mins
: 0
Logical Functions
Watch Now
17 Mins
: 0
Functions to work with NULL
Watch Now
17 Mins
: 0
Working with Date Functions
Watch Now
10 Mins
: 0
Date Comparision
Watch Now
11 Mins
: 0
String Functions
Watch Now
7 Mins
: 0
Format Function
Watch Now
13 Mins
: 0
System Functions
Watch Now
7 Mins
: 0
Understanding INSERT
Watch Now
20 Mins
: 0
Understanding UPDATE DELETE
Watch Now
19 Mins
: 0
Identity
Watch Now
8 Mins
: 0
Understanding GUIDs
Watch Now
6 Mins
: 0
Understanding Sequence
Watch Now
13 Mins
: 0
Understanding MERGE
Watch Now
12 Mins
: 0
Using OUTPUT
Watch Now
15 Mins
: 0
Grouping Sets
Watch Now
16 Mins
: 0
ROLLUP
Watch Now
9 Mins
: 0
CUBE
Watch Now
4 Mins
: 0
Distingushing NULLs in Result set
Watch Now
17 Mins
: 0
Introduction To Window Function
Watch Now
3 Mins
: 0
Window Aggregate Function
Watch Now
6 Mins
: 0
Ranking Function
Watch Now
14 Mins
: 0
Windows OFFSET Function
Watch Now
7 Mins
: 0
Framing
Watch Now
15 Mins
: 0
PIVOT UNPIVOT
Watch Now
21 Mins
: 0
Introduction to T SQL
Watch Now
4 Mins
: 0
Script and Batches
Watch Now
14 Mins
: 0
Variables and Statements
Watch Now
11 Mins
: 0
Table Variable
Watch Now
8 Mins
: 0
Global Variable and Keywords
Watch Now
7 Mins
: 0
Controlling Program Flow
Watch Now
14 Mins
: 0
T SQL Scripts Examples
Watch Now
24 Mins
: 0
Temporary Tables
Watch Now
10 Mins
: 0
Check Existence of Database Objects
Watch Now
6 Mins
: 0
Introduction To Error Handling
Watch Now
7 Mins
: 0
Understanding Rais Error Part-1
Watch Now
18 Mins
: 0
Understanding Rais Error Part-2
Watch Now
11 Mins
: 0
Using THROW
Watch Now
3 Mins
: 0
Using Error Final
Watch Now
7 Mins
: 0
Understanding TRY CATCH Part-1
Watch Now
12 Mins
: 0
Understanding TRY CATCH Part-2
Watch Now
9 Mins
: 0
FORMAT MESSAGE
Watch Now
4 Mins
: 0
Transactions
Watch Now
22 Mins
: 0
USING XACT ABORT
Watch Now
9 Mins
: 0
USING XACT STATE()
Watch Now
7 Mins
: 0
Got a question on video or have an insight to share ?
Join this discussion here and connect with your fellow learners and Subject experts.
Enroll
Overview
Microsoft SQL Server can be an intimidating system. In this course, instructor Vandan Soni provides a quick overview of how SQL Server works—which can go a long way to making you feel more comfortable as you start exploring its powerful capabilities. She goes over the most important features of SQL Server 2017, helping to familiarize you with how the server operates. She also introduces the main working environment—SQL Server Management Studio—and walks through how to start creating tables and manipulating data.
Tools that use T-SQL
The following are the tools that use T-SQL:
Who is this course for?
This exam is intended for SQL Server database administrators, system engineers, and developers with two or more years of experience who are seeking to validate their skills and knowledge in writing queries.
Skills Measured
Course Objectives
Mrs. Vandana Soni is a Microsoft Certified Trainer, Azure Data Engineer Associate, and a Software and Corporate Trainer. With 25 years of IT experience, she is adept Corporate Training, Live Training, and Online Webinars.
She has trained 50,000+ individuals all over the world and delivered 50+ Corporate Training all over India and abroad in the following technologies. She specializes in Data Analytics, SQL Server Training, and giving Certification Guidance to Corporates. As an Azure Data Engineer, she has the confidence in teaching from basics to advanced level topics, covering every aspect in detail.
Know more about Vandana Soni - https://www.bestitcourses.com/Vandanasoni
Follow her on LinkedIn -https://www.linkedin.com/in/vandana-soni-85a29475/
This course can be taken by any beginner who wants to build career in Information Technology. The subscriber needs to have working knowledge of Windows Operating System.
Please note that learning only SQL Server will not open lots of job opportunities unless you follow it up with MS.NET Programming or MSBI tools like SSIS, SSAS and SSRS.
Got a question or have an insight to share ?
Join this discussion here and connect with your fellow learners and Subject experts.
Mrs. Vandana Soni is a Microsoft Certified Trainer, Azure Data Engineer Associate, and a Software and Corporate Trainer. With 25 years of IT experience, she is adept Corporate Training, Live Training, and Online Webinars.
She has trained 50,000+ individuals all over the world and delivered 50+ Corporate Training all over India and abroad in the following technologies. She specializes in Data Analytics, SQL Server Training, and giving Certification Guidance to Corporates. As an Azure Data Engineer, she has the confidence in teaching from basics to advanced level topics, covering every aspect in detail.
Know more about Vandana Soni - https://www.bestitcourses.com/Vandanasoni
Follow her on LinkedIn -https://www.linkedin.com/in/vandana-soni-85a29475/
