The U.S. job growth faced a slow growth according to statistics from the Bureau of Labor Statistics. According to the numbers, there was a job growth of 179,000 jobs in May 2017 and the unemployment rate was at 4.3%. Lets face it job growth has been stagnant for the past 5 years. However, under a … Continue reading US Job Growth in 2017; Slow but Steady Battle
If you haven't taken a look at your performance on your website, you could be missing out on potential sales and customers everyday. Lets face it everyone has a website for their business. If you don't then it's time to get one. According to statistics, nearly 46% of small businesses in the United States do … Continue reading Got Web Analytics?
Check out @Bigdatasmall's Tweet: https://twitter.com/Bigdatasmall/status/869973112749563906?s=09
If you think you were supposed to see a nerdy guy with glassses think again. Data science has taken a turn for the new hot career and it's not just guys are getting involved. Girls like me are taking the data science wave and riding it all the way to the bank. I love mathematics, … Continue reading Modern Day Data Scientist
This challenge of when to blog has been puzzling me for the last 3-6 months. I've yet to experiment about the perfect time to post an article for everyone to see and most of all pay attention to. I've come across some really good advice this morning while watching some videos on Youtube. What better … Continue reading To Blog or Not to Blog?
I can't seem to pinpoint a single project to get started on. I have so much ideas for a project and keep jungling all of them in my mind. How can I focus on one idea? I've read blogs about ideas, sample projects and read countless forums. The world is full of stuff, such as … Continue reading How Do I Choose a Project?
SQL: Using JOINS in SQL Server JOINS Introduction What is a JOIN? JOINS in SQL Server are used to retrieve data from two of more related tables. Tables are generally related by foreign key restraints. We will discuss the different types of JOINS: INNER JOIN OUTER JOIN FULL JOIN CROSS JOIN OUTER JOINS are … Continue reading SQL: Using JOINS in SQL Server
SQL: Using the LIKE Operator LIKE Introduction LIKE is a special operator just for strings LIKE will match strings with a pattern Wildcard Character % Introduction You can use the % Wildcard character with LIKE % Wildcard character can go anywhere in the string The percent sign % wildcard character matches any sequence … Continue reading SQL: Using the LIKE Operator
SQL: Using the BETWEEN Operator BETWEEN Introduction BETWEEN is an operator that acts on a column and two values If a row’s column value is “between” these two values, the expression evaluates to TRUE BETWEEN is inclusive, it includes the two values in the calculation of what is “between” Example: Who are all … Continue reading SQL: Using BETWEEN
AND Introduction AND means that two expressions by AND must evaluate to TRUE Example: Who are all the people in my contact list that have the first name Jon and have a birthday later than 1965? SELECT p.person_first_name FROM person p WHERE p.person_first_name = ‘Jon’ AND p.birthday > 12/31/1965; OR Introduction … Continue reading SQL: Using AND and OR