Certification

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
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
SQL Server

Preparation | Exam 70-461 (Querying Microsoft SQL Server 2012)

My current goal is to become a Microsoft Certified Solutions Expert: Business Intelligence. Preparing for the exam My plan is to work my way through each chapter in the Training Kit book. I will read each chapter, answer the quick check questions, the lesson review questions, work through the case scenarios and complete all the practice exercises. I […]

Read More
Certification
SQL Server

MCSE: Business Intelligence | Starting my journey

My goal for 2020/2021 is to become a Microsoft Certified Solutions Expert (MCSE): Business Intelligence. The three Training Kit books arrived today:  Training Kit (Exam 70-461): Querying Microsoft SQL Server 2012 Training Kit (Exam 70-462): Administering Microsoft SQL Server 2012 Databases Training Kit (Exam 70-463): Implementing a Data Warehouse with Microsoft SQL Server 2012. While […]

Read More
Certification
SQL

Microsoft SQL Server Database Certifications

SQL Server offers a broad range of tools and add-ons for business intelligence, data warehousing and data-driven applications of all kinds. That probably explains why Microsoft offers database-related credentials at every level of its certification program, from the Microsoft Technology Associate (MTA) all the way to the Microsoft Certified Solutions Expert (MCSE) program. In September 2016, Microsoft announced […]

Read More
Certification
Lab Environment

CCNA in 60 Days – maybe not…

Now that I’ve picked up a Microsoft cert using a desktop technology, I am moving to learn more about networking to continue building a strong knowledge base. I originally intended to begin my CCNA studies using the CCNA in 60 days method (buy the book here). However, I do not like to rush myself to […]

Read More
Certification
Microsoft
Windows Workstation

Passed: MCTS: Windows 7, Configuration

Feels good to have a Microsoft Cert finally! After the holidays and a little break, I’ve now passed the MCTS: Windows 7, Configuration exam. The exam was a lot more difficult than I expected, with more than a few simulations, multi-part questions with multiple available answers, etc. All in all, this was a real eye-opener […]

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