Practical Sql - Microsoft Sql Server T-SQL for Beginners

by Mark O'Donovan

http://markodonovan.com



Practical Sql - Microsoft Sql Server T-SQL for Beginners




Learning how to develop using sql or even just performing basic queries on a sql database is becoming
an essential skill for many roles within the IT industry.



With Practical Sql you will stop being a novice when it comes to using the Microsoft Sql Server database and learn

a useful skill.



Practical Sql will provide a concise guide to sql server development with the main aim to prevent boredom.
Nobody really likes reading IT books they just want to know how to do X, Y or Z.



With Practical Sql you will learn:


How to Install Microsoft Sql Server.
How to Create Databases, Tables.
How to manage the data in tables.
Functions to changes field values.
Conditional Statements.
Creating checks on the data that goes into the table.
Database Design rules.
Using Triggers to create audit tables.
How to use Transactions and Exceptions.
Using and creating your own templates for faster development.
and more...




The examples within this book were created using Sql Server Express 2012.




For other books by this author see: http://markodonovan.com


Or search for "Practical QlikView" on Amazon.

215 pages, Kindle Edition

First published October 9, 2013

About the author

Mark O'Donovan has been working within the IT industry for over 16 years within IT support and developer roles.

For the last 5 years Mark has been focussed on Sql Server development and business intelligence applications such as Microsoft BI and QlikView.