Microsoft Transact SQL Reference

 

sql azure

Microsoft TSQL Reference Online:

https://docs.microsoft.com/en-us/sql/t-sql/language-reference

A little more official than just random search on web and stackoverflow.

Reminder to self on select usage in SQL:

https://docs.microsoft.com/en-us/sql/t-sql/queries/select-transact-sql

  1. SELECT statements are written with the following clauses: SELECT, FROM, WHERE, GROUP BY, HAVING, ORDER BY.
  2. The query engine processes the clauses in this order: FROM, WHERE, GROUP BY, HAVING, SELECT, ORDER BY.

Types:

https://docs.microsoft.com/en-us/sql/t-sql/data-types/data-types-transact-sql

Conversion Functions (cast, convert, parse):

https://msdn.microsoft.com/en-us/library/hh231076.aspx

Working with NULL:

https://docs.microsoft.com/en-us/sql/t-sql/functions/isnull-transact-sql

Expressions:

https://docs.microsoft.com/en-us/sql/t-sql/language-elements/expressions-transact-sql

I am doing an Edx & Microsft refresher on SQL here, so come join me in the learning journey:

https://courses.edx.org/courses/course-v1:Microsoft+DAT201x+2T2017

I figure this is a good idea, as I learned most of my SQL via trial and error on a work project.

Course Source Code on Github:

https://github.com/MicrosoftLearning/QueryingT-SQL

Tutorial: Intro To React

Capture React Tic Tac

React web walk-through here:

https://facebook.github.io/react/tutorial/tutorial.html

Final Result Demo on Codepen for a Tic-Tac-Toe game:

https://codepen.io/gaearon/pen/gWWZgR?editors=0010

More Examples:

https://github.com/facebook/react/wiki/examples

Medium article on the difference between React JS and React Native:

https://medium.com/@alexmngn/from-reactjs-to-react-native-what-are-the-main-differences-between-both-d6e8e88ebf24

When I catch up and learn more in this area, I will post and share.

🙂

Microsoft Project Web App Essential Training

Capture Lynda PWA

Here is some Lynda.com training around Project Web App:

https://www.lynda.com/Project-Server-tutorials/Microsoft-Project-Web-Application-2013/365310-2.html

You can use Project Web App to status your stakeholders using Power BI on web, and via the mobile app.

Some related training:

  1. Microsoft Project 2016 Essential Training: https://www.lynda.com/Project-tutorials/Microsoft-Project-2016-Essential-Training/368760-2.html
  2. SharePoint Online Essential Training: https://www.lynda.com/SharePoint-tutorials/SharePoint-Online-Essential-Training/466190-2.html
  3. Microsoft SharePoint 2013 Essential Training: https://www.lynda.com/Office-tutorials/SharePoint-Server-2013-Essential-Training/121679-2.html

If you are a Seattle resident, get your free access to Lynda.com via the Seattle Public Library:

https://seattle.bibliocommons.com/item/show/3132397030_lyndacom