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:
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.
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?
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.
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.
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.
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. Let me offer you a small present.
A quick recap on what we have learnt.
This is the end of this video series.. Thank you for watching.
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?
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.