Highest Rated
Microsoft SQL Server – An Introduction (2018 edition)
A quick tour of T-SQL, DBA and SSRS (all part of Microsoft SQL Server)
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 a version of 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 the SELECT statement with its 6 main clauses (SELECT, FROM, WHERE, GROUP BY, HAVING and ORDER BY).
Following this, we’ll create SQL Views and Procedures, connect it to Excel, and have a brief look at SSRS (SQL Server Reporting Services) and backup and restore a database.
No prior knowledge is required – just a willingness to learn.
See you on the course.
Who this course is for:
- 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.