4.26 out of 5
4.26
2414 reviews on Udemy

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.
Instructor:
Phillip Burton
42,552 students enrolled
English [Auto-generated]
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.

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.

Introduction

1
Introduction

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

2
Introduction to Udemy
3
Which version to install?

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

Downloading and Installing SQL Server

1
Downloading SQL Server

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.

2
Installing SQL Server

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

Opening SQL Server

1
Opening SQL Server Management Studios

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

2
Playing with SSMS

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

3
Practice Activity

Let's practice what you have just learnt.

4
SQL Server Reporting Services

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.

Learning more

1
Syllabus

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.

2
Books and Videos

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

The end...?

1
How would I learn T-SQL?

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

2
Bonus Lecture

Congratulations for completing this course. How can you develop your skills?

3
Thank you for watching.

A quick recap on what we have learnt.

4
The end

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

Installing SQL Server 2016 Developer Edition

1
Downloading SQL Server back engine - the Developer edition - for free!

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.

2
Installing SQL Server back engine

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).

3
Installing SQL Server Front Engine

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.

4
The next step

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

You can view and review the lecture materials indefinitely, like an on-demand channel.
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!
4.3
4.3 out of 5
2414 Ratings

Detailed Rating

Stars 5
989
Stars 4
842
Stars 3
395
Stars 2
117
Stars 1
71
e05d5acb277f0867dce016899229c98d
30-Day Money-Back Guarantee

Includes

2 hours on-demand video
4 articles
Full lifetime access
Access on mobile and TV
Certificate of Completion