Study

Certification
SQL Server
Study

NOTES | Grouping and Windowing

SQL Server can perform some data analysis operations. A data analysis function is a function applied to a set of rows, and it returns a single value. An example of such a function is the SUM aggregate function. A data analysis function can be either a group function or a window function. The two types […]

Read More
Certification
SQL Server
Study

NOTES | Combining Sets

Using Joins Often, data that you need to query is spread across multiple tables. The more normalized the environment is, the more tables you usually have. The tables are usually related through keys, such as a foreign key in one side and a primary key in the other. Then you can use joins to query […]

Read More
Certification
SQL Server
Study

NOTES | Filtering and Sorting Data

While the traditional way to filter data in T-SQL is based on predicates, it also supports filtering data based on a specified number of rows and ordering. To do so, use TOP and OFFSET. Filtering Data with Predicates ON, WHERE, and HAVING are the three query clauses which enable your filtering of data based on […]

Read More
Exam Preparation
Study
T-SQL

NOTES | Getting Started with the SELECT Statement

Using the FROM and SELECT Clauses The FROM and SELECT clauses are two principal clauses that appear in almost every query that retrieves data. When you execute a SELECT statement, it usually retrieves one or more rows of information – the exact number depends on how you construct the statement. These rows are collectively known […]

Read More
Exam Preparation
SQL Server
Study

NOTES | Foundations of Querying

Foundations of Querying T-SQL is the main language used to manage and manipulate data in Microsoft’s main relational database management system (RDBMS), SQL Server—whether on premises or in the cloud (Microsoft Windows Azure SQL Database). It all stems from the mathematical principals of set theory and predicate logic. T-SQL is a dialect of standard SQL […]

Read More
Certification
SQL Server
Study

NOTES | A Few Things

In preparing for this exam, my plan is to work my way through each chapter in the Training Kit book, to take notes, gather more information from across the internet and the book SQL Queries For Mere Mortals. In doing so, I’ll be documenting my notes. At times, it can/may be word for word from the training […]

Read More
Certification
Cisco
Study

Update: CCNA R&S Studies #2

Nibble, nibble, that’s all I can do. While I do not find the CCNA studies hard, I find I must nibble on networking technology a little at a time to better digest. SO, I’ll be going slow with this and only studying it lightly. In the meantime, I’m going to be studying MTA: 98-365 Microsoft […]

Read More
Certification
Microsoft
Study
Windows Workstation

Added a couple of new books for Windows 7, Configuring (70-680)

My studies continue in pursuit of the Windows 7, Configuring (70-680) certification and I have added a couple more books to my arsenal. Self-Paced Training Kit (Exam 70-680) Configuring Windows 7 (MCTS) (Microsoft Press Training Kit) by Ian McLean et al. Link: http://amzn.com/0735627088

Read More
Study

So, the journey begins.

I kick off this blog and start my journey to earn IT certifications and make a career transition into the technical side. For the last 4 years, I’ve been a Business Analyst and Security Administrator for an HRIMS and, while I’ve enjoyed it, I’ve realized how much I needed to be more involved on the […]

Read More