Learn about SQL Server tables, SELECT statements (FROM, WHERE, GROUP BY etc), JOIN tables, and INSERT/DELETE/UPDATE data

This course is the foundation for the Microsoft Certificate 70-461: "Querying Microsoft SQL Server 2012".

Rather than present one huge course, this course takes some of the basics and then goes in depth.

In session 1 we learnt all about dates, strings and number data types and functions in some detail.

We'll CREATE TABLE IF NOT EXISTSs which use these, and then INSERT some data into them. Then we'll write queries which will retrieve and summary this data, using SELECT, FROM, WHERE, GROUP BY, HAVING and ORDER BY.

We'll then JOIN these tables together to find where we are missing data and where we have inconsistent data. We'll then UPDATE and DELETE data from the tables. This will allow up to fully complete objective number 1 from the 70-461 exam.

Download