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:
I had worked in chemistry labs for years. When we talk about lab, we need a physical location, a lot of equipment (bench, hood, chemical cabinets, and etc.) and instruments (balance, NMR, HPLC and so on). It is impossible to get a free chemistry lab. For our SQL lab, it is completely a different story.