This course is available to download from your regional Amazon website as a Kindle eBook.
I have created this extensive MS SQL querying course for those who want to:
- discover why and how SQL and relational databases come about
- how tables and columns work
- find out what relationships between tables are and how they maintain the meaning of your data
- learn what data constraints are and what they do to retain your data's validity
- learn how to use SQL Management Studio (SSMS) effectively
- find out how to write SQL scripts to store and repeat long queries
- get to grips with SQL batches and what they do
- use SSMS's Solutions to manage a library of frequently used SQL scripts
- understand what SQL's data types can do
- See how to create and use variables
- use the SELECT statement to write practical joins, perform grouping, do subquerying,
use common table expressions (CTEs) and make use of the powerful OVER data partitioning statement
- see what the set operators (UNION, insert and EXCEPT) can do for you
- write commands to insert, update and delete data
- find out how to copy an entire table or transfer selected rows from one table to another
- understand and then perform the basics of transaction management
- get to grips with controlling essential locking
- implement an error control strategy in your scripts to regulate how failures in your code are handled and logged
This course is a full self-study course
I offer this course with optional live video training as if you were in a classroom.
Home Page
