We have now covered VIEWs and how to ALTER database objects.
Download the class notes for day four and the tutorial importing flat file into SQL Server.
SQL
Intro to SQL (WS16SQL1001) – Day 3
So far, we have covered how to query tables (SELECT [field(s)] FROM [table(s)]), JOIN them, CREATE them, TRUNCATE them and even DROP them. Now we can really start having fun!
Download the class notes for day three.
Intro to SQL (WS16SQL1001) – Day 2
Download the class notes for day two.
Intro to SQL (WS16SQL1001) – Day 1
We start learning SQL with the most of basic structures — selecting one or more fields from one or more tables.
Download the class notes for day one.
Large collection of Free Microsoft eBooks for you
Large collection of Free Microsoft eBooks for you, including: SharePoint, Visual Studio, Windows Phone, Windows 8, Office 365, Office 2010, SQL Server 2012, Azure, and more.
https://blogs.msdn.microsoft.com/mssmallbiz/2012/07/27/large-collection-of-free-microsoft-ebooks-for-you-including-sharepoint-visual-studio-windows-phone-windows-8-office-365-office-2010-sql-server-2012-azure-and-more/
Another large collection of Free Microsoft eBooks and Resource Kits for you, including: SharePoint 2013, Office 2013, Office 365, Duet 2.0, Azure, Cloud, Windows Phone, Lync, Dynamics CRM, and more.
https://blogs.msdn.microsoft.com/mssmallbiz/2012/07/30/another-large-collection-of-free-microsoft-ebooks-and-resource-kits-for-you-including-sharepoint-2013-office-2013-office-365-duet-2-0-azure-cloud-windows-phone-lync-dynamics-crm-and-more/
Intro to SQL
Textbook References:
Textbook: Beginning Microsoft SQL Server 2012 Programming
ISBN: 978-1-1181-0228-2
Authors: Paul Atkinson, Robert Vieira
Software Requirements:
SQL Server Express Edition 2014 (free)
https://www.microsoft.com/en-us/server-cloud/products/sql-server-editions/sql-server-express.aspx
AdventureWorks Sample Databases and Scripts for SQL Server 2016 CTP3 (free)
http://msftdbprodsamples.codeplex.com/
