Learn Mandarin Chinese Online

1.379 Billion Chinese according to this search on Google: https://www.google.com/search?q=china+population.  Would you like to be able to talk to this group of people in business or in life?  Imagine getting to know this customer for your product development or business.

Let me tell you my Chinese learning journey:

I had a friend in high school who was an exchange student from Hong Kong.  We met and became friends after a simple conversation on the school bus.  We hung out in high school, took the same junior year classes, and when he went back home to Hong Kong, I visited him and some of my extended family for the first time before starting my first year at the University of Washington.

Hong Kong at that time was an exciting place for me as it was fast paced, foreign, and materially flashy.  I spoke some elementary Cantonese Chinese, but could not read nor write Chinese.  From this travel experience, I decided to take some courses in Mandarin at the University.  When I graduated, I had taken up to 3 years of Mandarin courses, and spent a school summer session at Peking University, in Beijing China, and an internship in Taipei, Taiwan.

As with any language, it takes practice, usage, and repetition to learn.  It also helps to immerse or travel and make use of that language.  But what if you live here in the USA, and want to study a language?  What options do you have?

Looking at Edx.org, we can do a simple search and read the summary of some great courses:

https://www.edx.org/course?search_query=mandarin

This is a pretty fun Chinese History and Cultural Series, called ChinaX, by Harvard University:

https://www.edx.org/xseries/china-modern-world

If you are looking for more advanced Chinese learning, I was using this site for a while for intermediate to advance courses a while back.  Chinese Pod allows you to consume the content on your own schedule.  Then follow up with an instructor using video follow-up with teachers:

https://chinesepod.com/

They have a fun blog here: https://chinesepod.com/blog/

Try Edx.org for free, then if you are still excited and need more content go to ChinesePod.com and subscribe to a paid account.  Before you do you can try their free sampler lessons: https://chinesepod.com/library/courses/free-chinesepod-playlist/6.

Go ahead, learn some survival Chinese!  Learn to order food or say hello to your loved one!  How do you learn a language?

Then find a conversation partner nearby via Craigslist, Meetup.com, or the University of Washington Language Exchange Program.

Tell me if these links and resources are helpful.  Let me know if I overlooked some even better ones!

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

Setup Git on Windows

Capture Dev237x

This class offered by Edx.org & Microsoft, Intro to Front End Development, has a pretty good starter on setting up Git on your Windows machine:  https://courses.edx.org/courses/course-v1:Microsoft+DEV237x+1T2017/info

Install Git on windows: http://git-scm.com/download/win

Setup environment specifics such as your name, email, and preferred editor: https://git-scm.com/book/en/v2/Getting-Started-First-Time-Git-Setup

Git Tutorials here: https://git-scm.com/book/en/v2/Git-Basics-Getting-a-Git-Repository

Notepad++: https://notepad-plus-plus.org/

Visual Studio Code: https://code.visualstudio.com/

CodePen: https://codepen.io/

Sublime Editor for Mac: https://www.sublimetext.com/