In a previous post, it was explained how to update the default date or date column in MySQL when a row gets updated. The clause
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.
Answers – Problem Scenarios for Practice
Please refer to the SQL practice questions here. Answers to those problem scenarios are given below. Answer to Problem Scenario # 1 UPDATE tbOrdersTickets SET
JSON Array to ROWS – MySQL
I recently received a request to divide a JSON data type row value containing an array of numbers into multiple rows. That is one value
SQL Server – Problem Scenarios for Practice
There is no denying that practice is a key factor in students developing subject-matter knowledge. Really, practice is essential to maximize the impact of training.
SQL Server Training
Some argue that “..relational databases are out of date and do not match current trends..”, while others contend that “..SQL cannot handle big data..” and “..SQL cannot handle unstructured data..”. There
Dynamic SQL – Part-1
The method we use to write SQL queries so that they are dynamically built alongside application actions is known as “dynamic SQL.” In other words,
Big Data & SQL 