Be an Analyst is weekly series which aimed to enhance skills beyond beginner level.These topics are composed of the most popular articles, as well as articles demonstrating new or updated features
1. What’s in a name? or rather, in the SSA Names data
I hope, this article will help you to take your SQL skills beyond beginner level. A practical approach on how to use SQL for Data Analysis.
2. How to add Primary key into a new or existing table in SQL Server
Here is the SQL query you can use to add the primary key into an existing table in SQL Server 2008, 2012 and other versions.
3. Show specific sheets in excel
In a workbook with lots of worksheets, you can have a hard time finding the sheets that you need, to do a specific task. Instead of scrolling through all the sheet tabs, or using the popup list of worksheets, use a drop down list to show specific sheets in Excel. Also, all other sheets are hidden, and you’ll be able to focus on what you need to do, and ignore everything else.
4. Sql for superusers date-vs.-date-time
this article is for those who are unsure whether to include the topic of dates and date times in SQL
5. Fetching first N rows
using FETCH FIRST n ROWS syntax to get a subset of the rows from what would normally be a larger resultset. for those who have experience in working with python pandas library. it is like head()