” I love my family, my wife and I share almost everything. We have been known to end each others sentences, and when times were
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.
Apache Impala Quiz-1
Test your knowledge of Apache Impala.
Apache Sqoop – Quiz-1
Test your knowledge of Apache Sqoop.
Default Constraint – SQL Server
The DEFAULT constraint is used to provide a column’s default value. If no alternative value is supplied, that is, if the user leaves the column
Entity Integrity
Entity Integrity ensures that the table contains no duplicate records and that the field that identifies each entry is distinct and never null. The Primary
Data Retrieval in SQL Server
We obtain data from SQL Server tables using the SELECT command, but this command is insufficient because we are not expected to receive the entire