Microsoft Excel 2016 Beginner Level Course
Duration: 1h 42m | .MP4 1280x720, 30 fps(r) | AAC, 44100 Hz, 2ch | 0.99 GB
Genre: eLearning | Language: English
Duration: 1h 42m | .MP4 1280x720, 30 fps(r) | AAC, 44100 Hz, 2ch | 0.99 GB
Genre: eLearning | Language: English
A quick tour of T-SQL, DBA and SSRS (all part of Microsoft SQL Server)
What you'll learn
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 and insert data
Retrieve the data contained in your table.
Learn about the SELECT, FROM, WHERE, GROUP BY, HAVING and ORDER BY clauses.
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.
SQL Server Express is the back engine, which does all of the work.
It also includes SQL Server Management Studio (SSMS) which is the front engine, which allows you to send queries and see the results.
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).
The SELECT clause says what fields you want to retrieve.
The FROM clause shows the data source.
The WHERE clause filters it down, based on criteria you choose.
The GROUP BY clause aggregates (sums, count, min, max) it together, creating a summary.
The HAVING clause can summarise it further.
The ORDER BY clause then orders the results.
Following this, we'll create SQL Views and Procedures, connect it to Excel (so you have your data in SQL Server, but still use it in 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.
More Info