This is a simple test or assignment to see how comfortable someone is using SQL at the beginner to advanced level. Exercises of this nature
Author: SHAFI SHAIK
Hi, this is Shafi Shaik, Microsoft Solutions Specialist in Data platform as well as in Data Management & Analytics. I am a certified associate in Oracle SQL*Plus and extensively trained in MongoDB Administration. My current role is Database administration with hands-on expertise in almost all relational databases namely Microsoft SQL Server, MySQL, Oracle SQL*Plus, PostGreSQL & Teradata. I'm also specialized in database development, warehousing, traditional data analysis and Big Data analysis.
Connecting MongoDB Cloud to Navicat
This article explains how to connect MongoDB cloud to MongoDB Compass, Workbench, and Navicat Premium. Click on “Databases” from the left-side navigator and click on
Reorganize vs Rebuild Indexes
DBAs frequently have to choose between rebuilding the indexes and reorganizing them. Depending on how fragmented the index is, one must make a choice. Reorganizing
SQL Server Pivot Table Example
The SQL Server pivot function allows you to visualize data comparisons, patterns, and trends by representing the data in a calculated, condensed, and analytical manner.
SQL Server – Job Completion Status
One of the often-used scripts that DBAs keep on hand must be the one that shows how far a session has advanced. The statement below
@@ROWCOUNT in SQL Server
The system function @@ROWCOUNT is used to return the number of rows that were impacted by the last statement that was executed. The number of
Big Data & SQL 