Microsoft SQL Server – An Introduction
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:
- SQL Server Management Studio (SSMS, which allows you to learn T-SQL and DBA)
- SQL Server Integration Services (SSIS), which automates the conversion of data.
- SQL Server Analysis Services (SSAS), which allows the creation of cubes, and
- 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
Welcome to this course. I'll briefly introduce what we are going to cover.
There are many different types of SQL Server - which version should you install?
Downloading and Installing 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.
Here I will talk you step by step through the process of installing SQL server.
Opening SQL Server
We find out which program we have to open, and then start SQL Server.
We'll create a database, create a table, add some data, and then retrieve that data.
Let's practice what you have just learnt.
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
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.
We'll see what training books and videos are available that can help us learn SQL Server.
The end...?
I review how I would learn T-SQL by looking at the official Microsoft requirements, and how to organise your learning.
Congratulations for completing this course. How can you develop your skills?
A quick recap on what we have learnt.
This is the end of this video series.. Thank you for watching.
Installing SQL Server 2016 Developer Edition
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.
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).
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.
You've now installed SQL Server 2016 Developer Edition - what's next?
