Data Warehousing
Websites to Learn and Practice SQL for Free
You can practise SQL live online for Free. Here are a list of some websites in no particular order. Oracle
November 23, 2016
No Comments
Using Subqueries To Join 2 More Tables Which Do Not Have Unique Primary and Foreign Keys
Using Subqueries to join 2 more tables which do not have distinct values in a column We want to find
November 12, 2016
No Comments
Rank a Place Visited By a Customer- Microsoft SQL Server – T-Transact
This is a short guide to getting ranking or rating from Microsoft Sql Server customers. Ranking is taken by checking
November 9, 2016
No Comments
Splitting Values in one Column to Multiple Columns using CASE Expression Statement SQL Server
Sometimes, you would want to split values in a column into separate rows in SQL server. This is a simple
November 3, 2016
No Comments
Get Numbers and Percentages from Tables – Microsoft Sql Server
Sometimes you want to get some numbers and also percentages for quick analysis. This is a quick simple way to
October 2, 2016
No Comments
SQL
Great Quick Transact-SQL Server Tutorials – Quick Revision and General Understanding
I receive a lot of emails about where to get quick and excellent resources for explaining most of the concepts
August 7, 2016
No Comments
Data Science
FREE Mock Data Generating Website for Data Science and other Data Analysis projects
Sometimes, you need some mock or test data to either test your program or for your analysis or to
July 20, 2016
No Comments
Visual Explanation illustration and presentation of SQL JOINS query statements
SQL Joins can sometimes be a bit confusing, particularly if you a newbie. I have below 2 visual representations which
May 19, 2016
No Comments
How to Manually Start Stop and Restart MySql Server on Windows PC
When installing MySql server package, you can instruct the installation to configure MySql server to start automatically on each windows
May 18, 2016
No Comments
MySQL – Summarizing Data – SUM COUNT -MIN -MAX – AVG – DOGNITION Database
Summarizing Data This week we are looking at five most common aggregate functions used to summarize information stored in tables:
May 12, 2016
No Comments
DataPandas LTS
An experienced DevOps and Cloud Training Company to meet your DevOps and Cloud needs