This week is Thanksgiving Week. We are planning to visit our “hometown”, where we lived for past 6 years. My good friend there said that her family will be out of town and we could stay in her house during our visit. Yeah!!! Imaging the whole house with everything we need and we can use anything as our wish, I am really thankful for that.
Now that we have a computer and a database installed all by Microsoft, (or by yourself as we mentioned in this post), grab a cup of tea, let’s sit down to taste the sweetness of SQL.
This is a perfect course on Lynda.com for learning SQL:
In one of my previous post, I mentioned the benefits of having a computer with SQL server installed in the cloud (a virtual machine). But, I stopped everyone by telling you how costly it is (about $150 per month). I promised to show you another way. Here it comes.
I have a friend, who wants to find a job data field. We discussed about her background. She did marketing strategy and implement for several years. So, I come up with this path for her.
“I hear and I forget. I see and I remember. I do and I understand.” ——Confucius
Watching video and reading articles about SQL Server and business intelligence are not enough. I find that the most effective way of learning is doing. For this reason, I have found these several projects to practice and internalize all the concepts.
After your installation of SQL Server, it is time to get some sample database.
The most common sample database is Adventure Works and Adventure Works DW (AdventureWorks Data Warehouse) provided by Microsoft. Majority of books and videos use these sample databases.
It is never easy to make a career transition. I have had many rejections from the outside world, along with many doubts coming from a self-critical me. However, reading positive, inspirational articles and books gives me information and support to continue. I will share some of them with you.
Even though learning through on-line resources is convenient and easily accessible, I strongly recommend you to attend local user group meetings and SQL Saturday events.
I came across this series of 5 articles, titled 5 Steps To Transitions Your Career to Analytics, written by Piyanka Jain, published in early 2015 on Forbes.com. I like them so much that I recommend it to everyone intending to have a career transition.
At the end of my last post, I mentioned a faster way to have a SQL Server running. That way is: to use SQL Server in the Cloud. The Pros of getting a SQL server virtual machine (VM) in the Cloud are: