Microsoft SQL Server And T-SQL Course For Beginners
4.5 (94 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
12,173 students enrolled

Microsoft SQL Server And T-SQL Course For Beginners

Learn benefits of SQL, how SQL Server stores data and how to use T-SQL in SQL Server Management Studio to query data.
Bestseller
4.5 (94 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
12,173 students enrolled
Created by Avetis Ghukasyan
Last updated 1/2020
English
English [Auto]
Current price: $139.99 Original price: $199.99 Discount: 30% off
5 hours left at this price!
30-Day Money-Back Guarantee
This course includes
  • 4.5 hours on-demand video
  • 1 article
  • 1 downloadable resource
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
Training 5 or more people?

Get your team access to 4,000+ top Udemy courses anytime, anywhere.

Try Udemy for Business
What you'll learn
  • You will be crystal clear on why there are so many kinds of SQLs and the difference between the query language and the databases
  • You will gain a wholistic understanding – starting from how data is stored within SQL Server then how to create your own database objects and finally how to write data into them and access them after
  • We will have real-life missions in the end which would require you to perform tasks similar to ones you would get at an actual company – this will take all that you have learned and push you to put it all into practice
Requirements
  • You would need a computer that could run SQL Server 2017+
  • You would need a computer that could run SQL Server Management Studio 18.3.1+
Description

I would like you to go ahead and type in "SQL developer salary" into Google - and the result that should come up is somewhere along 90K - 120k.

Knowing SQL is a pretty profitable skill - not just "these days" but today, tomorrow a year from now and even further down the road. It is a stable technology that has been around for 20 years. It has been tested and proven to store data securely and allow access effectively and efficiently.

Microsoft SQL Server also known as SQL Server is a mature technology which can be used not just by developers but by marketers, sales teams, product managers and much more - it is a query language that allows you to ask questions from securely stored data.

Think of it this way - any business on this planet makes money with data. The fancy user interfaces, cool animations are nice but that's not what makes the money. Think about it... when you go to Facebook or Instagram do you care about the fancy animations and user interface or do you care to see your friends, what they are up to, check out events and be part of the goings on of that entire digital ecosystem?

Of course it is the second choice... the fancy user interfaces are cool and make the experience pleasant but in the end you care about your friends and what they are up to, you care about being part of the ecosystem...

Now your friends, followers, events, what everyone is up to is data and as I mentioned before that is what makes companies money.

Microsoft SQL Server (SQL Server) is one of the most mature technologies that allows companies to handle data, store it securely, access it quickly and much more.

Now if you know about Microsoft SQL Server (SQL Server) and you know how to create database objects, how to normalize tables, how to retrieve data, prepare reports, insert and delete data safely and you know about best practices then you are an amazingly valuable asset to the company.

If you have a business that you are trying to grow and have data which you are trying to handle then Microsoft SQL Server (SQL Server) is a great choice which is another reason for you to learn this skill.

Now guess what? All of those things we will be learning in this course and MUCH more!

Take my advice and learn this valuable skill, you will not regret it. After dedicating only a few days and really focusing you can acquire this valuable skill and set a new course for your life.

Who this course is for:
  • Anyone who is fascinated by databases and wants to learn more by learning about SQL Server and T-SQL
  • Anyone who knows a little bit about T-SQL but feels frustrated because they feel like they are not fully competent
  • Anyone who might have worked with SQL before and might even be fully competent but wants to fill in any gaps in their knowledge
  • Anyone who wants to be and therefore be perceived as an intelligent and sharp professional at work or just for themselves as they are working on their own ventures
Course content
Expand all 44 lectures 04:41:13
+ Setting Up SQL Server & SSMS
5 lectures 06:47
Download SQL Server 2017
01:19
Install SQL Server 2017
02:56
Download SQL Server Management Studio 18.3.1
01:00
Install SQL Server Management Studio 18.3.1
00:50
Connect to SQL Server 2017
00:42
+ How Is Data Stored In SQL Server?
3 lectures 27:45
Simple Hierarchy & Structure
06:51
Why Relational?
10:19
Indexes
10:35
+ DDL In SQL Server
8 lectures 51:08
Data Definition Language Commands
01:24
How To Create?
18:08
How To Modify?
05:32
How To Truncate?
01:46
How To Drop?
04:08
Normalization
09:57
Download and Import Adventure Works Database
02:16
More On Index Creation
07:57
+ DML In SQL Server
11 lectures 01:46:49
Data Manipulation Language Commands
01:04
Begin With Retrieval
08:59
Scalar Functions
12:37
Sorting
03:53
Column & Row Logic
13:14
Joins
13:47
Distinct Data
03:08
Aggregate Functions
16:59
Subqueries
18:35
Set Operations
09:01
Manipulate Data
05:32
+ DCL in SQL Server
2 lectures 05:12
Data Control Language Commands
02:36
Grant & Revoke
02:36
+ Practical SQL Scenarios
9 lectures 01:11:14
Introduction Of Section
00:29
Problem 1: Get Every Value Except
04:41
Problem 2: Between A Time Range
07:51
Problem 3: Update With A Join
12:24
Problem 4: Summary With Custom Columns
06:52
Problem 5: Count Groups
14:30
Problem 6: One Exists In Another
05:34
Problem 7: Insert With A Select/Join
13:18
Problem 8: Delete With A Join
05:35
+ Farewell
2 lectures 01:28
Last Words
01:13
Download SQL Code Here
00:15