I have a good friend who loves using excel. I want to encourage her to learn some SQL and database queries. In this post, I will share the most important bridge from my known/familiar territory to my new territory. My “secret” bridge is GOOGLE. With the correct google search term set (utilizing one’s known knowledge), google will give answers that applicable to the unfamiliar knowledge. Little by little, and piece by piece, the knowledge of unfamiliar field become familiar and known. Today, the known territory is “Excel”. The new territory is “SQL”.
Continue reading “Bridges between Excel and SQL”
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.
Continue reading “Buying My Own House, or Staying in a Friend’s House”
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.
Continue reading “Free, Fast way to use SQL Server Virtual Machine”
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.
Continue reading “Sample Databases Download and Installation”
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:
Continue reading “Install a SQL Server Virtual Machine in the Cloud”
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.
Continue reading “First Thing First, Let’s Build Our Lab”