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 (676 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.
16,384 students enrolled
Free
Start Learning Now
  • Lectures 18
  • Length 1.5 hours
  • Skill Level Beginner Level
  • Languages English
  • Includes Lifetime access
    30 day money back guarantee!
    Available on iOS and Android
    Certificate of Completion
Wishlisted Wishlist

How taking a course works

Discover

Find online courses made by experts from around the world.

Learn

Take your courses with you and learn anywhere, anytime.

Master

Learn and practice real-world skills and achieve your goals.

About This Course

Published 7/2015 English

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

What are the 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.

What am I going to get from this course?

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

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

What you get with this course?

Not for you? No problem.
30 day money back guarantee.

Forever yours.
Lifetime access.

Learn on the go.
Desktop, iOS and Android.

Get rewarded.
Certificate of completion.

Curriculum

Section 1: Introduction
01:06

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

Article

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

Section 2: Downloading and Installing SQL Server
07:22

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.

07:07

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

Section 3: Opening SQL Server
03:01

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

07:01

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

Article

Let's practice what you have just learnt.

09:36

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.

Section 4: Learning more
05:41

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.

11:05

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

Section 5: The end...?
03:11

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

05:55

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

00:55

A quick recap on what we have learnt.

Article

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

Section 6: Installing SQL Server 2016 Developer Edition
07:50

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.

13:49

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

12:34

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.

Article

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

Students Who Viewed This Course Also Viewed

  • Loading
  • Loading
  • Loading

Instructor Biography

Phillip Burton, SQLIntro.com

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.

Ready to start learning?
Start Learning Now