Microsoft SQL Server - An Introduction
4.2 (1,100 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
22,877 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Microsoft SQL Server - An Introduction to your Wishlist.

Add to Wishlist

Microsoft SQL Server - An Introduction

A quick tour of the various programs of SQL Server (T-SQL, DBA, SSIS, SSAS and SSRS), and how to learn them.
4.2 (1,100 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
22,877 students enrolled
Created by Phillip Burton
Last updated 5/2017
English
Price: Free
Includes:
  • 1.5 hours on-demand video
  • 4 Articles
  • 1 Supplemental Resource
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I Learn?
  • Either Download and Install SQL Server Express on your computer - for free
  • or Download and Install SQL Server Developer, which used to cost US$100, for free - a full version for personal use only.
  • Log in and create a database.
  • Create a table, insert and delete data, and delete the table.
  • Retrieve the data contained in your table.
  • Learn about the different programs contained in SQL Server.
  • Find the best resources for learning about them.
View Curriculum
Requirements
  • No knowledge of SQL Server at all is needed.
  • You need to know how to use a computer, and ideally how to open a spreadsheet.
  • This is a free course - you have nothing to lose!
  • Why not have a look at the curriculum below and see what you can learn? If you already know this information, then please see my other courses.
Description

This course is a brief presentation of SQL Server.

We will install SQL Server Express for free, install it, and create a database and table.

We'll also add some data and retrieve it.

We'll then look at all the various programs that you can use:

  1. SQL Server Management Studio (SSMS, which allows you to learn T-SQL and DBA)
  2. SQL Server Integration Services (SSIS), which automates the conversion of data.
  3. SQL Server Analysis Services (SSAS), which allows the creation of cubes, and
  4. SQL Server Reporting Services (SSRS), which allows for the creation of reports.

We'll also look at some resources for learning these.

No prior knowledge is required - just a willingness to learn.

See you on the course.

Who is the target audience?
  • This beginner's course is for you if you want to learn about SQL Server and the various programs.
  • If you have already heard about SQL Server, and wish to learn more about T-SQL, then please have a look at my courses.
Students Who Viewed This Course Also Viewed
Curriculum For This Course
18 Lectures
01:37:48
+
Introduction
2 Lectures 01:49

Welcome to this course. I'll briefly introduce what we are going to cover.

Introduction
01:06

There are many different types of SQL Server - which version should you install?

Which version to install?
00:43
+
Downloading and Installing SQL Server
2 Lectures 14:29

Here we will find SQL Server, and download it - for free! Don't worry - you don't need a server; your own computer will do.

We'll also find out a little bit about the history of SQL Server.

Downloading SQL Server
07:22

Here I will talk you step by step through the process of installing SQL server.

Installing SQL Server
07:07
+
Opening SQL Server
4 Lectures 20:19

We find out which program we have to open, and then start SQL Server.

Opening SQL Server Management Studios
03:01

We'll create a database, create a table, add some data, and then retrieve that data.

Playing with SSMS
07:01

Let's practice what you have just learnt.

Practice Activity
00:41

In this bonus lecture, we'll look at the process for creating SQL Server Reporting Services (SSRS) reports, and all of the different varieties of reports you can do, including charts and maps.

SQL Server Reporting Services
09:36
+
Learning more
2 Lectures 16:46

We'll look at the various different components of SQL Server, and see how the web pages containing the exams can help us focus on what we should learn.

Syllabus
05:41

We'll see what training books and videos are available that can help us learn SQL Server.

Books and Videos
11:05
+
The end...?
4 Lectures 10:08

I review how I would learn T-SQL by looking at the official Microsoft requirements, and how to organise your learning.

How would I learn T-SQL?
03:11

Congratulations for completing this course. Let me offer you a small present.

Bonus Lecture
05:53

A quick recap on what we have learnt.

Thank you for watching.
00:55

This is the end of this video series.. Thank you for watching.

The end
00:09
+
Installing SQL Server 2016 Developer Edition
4 Lectures 34:18

It used to be that we had to install a cut-down version of SQL Server. Instead, let's now install a version with the full functionality of the Enterprise edition - for personal use only, though.

Downloading SQL Server back engine - the Developer edition - for free!
07:50

Now let's go through the process of installing SQL Server.  I'll also go through the various editions of SQL Server (e.g. 2008, 2012).

Installing SQL Server back engine
13:49

Now that's the back engine has been installed, we've got to install SSMS (SQL Server Management Studio), Visual Studio, and SSDL (SQL Server Data Tools). It takes around 30 minutes, but here's the edited version.

Installing SQL Server Front Engine
12:34

You've now installed SQL Server 2016 Developer Edition - what's next?

The next step
00:05
About the Instructor
Phillip Burton
4.4 Average rating
2,739 Reviews
40,173 Students
25 Courses
Over 40,000 students so far

Phillip is a Computing Consultant providing expert services in the development of computer systems and data analysis. He is a Microsoft Certified Technology Specialist. He has also been certified as a Microsoft Certified Solutions Expert for Business Intelligence, Microsoft Office 2010 Master, and as a Microsoft Project 2013 Specialist.

He enjoys investigating data, which allows me to maintain up to date and pro-active systems to help control and monitor day-to-day activities. As part of the above, he also developed and maintained a Correspondence Database in Microsoft Access and SQL Server, for viewing job-related correspondence (110,000 pdfs in one job) by multiple consultants and solicitors.

He has also developed expertise and programmes to catalogue and process and control electronic data, large quantities of paper or electronic data for structured analysis and investigation.

He is one of 9 award winning Experts for Experts Exchange's 11th Annual Expert Awards and was one of Expert Exchange's top 10 experts for the first quarter of year 2015.

His interests are working with data, including Microsoft Excel, Access and SQL Server.