Why the need for data migration? Not too long ago, database software were limited to few brands and options. To…
Author: Ivan Lima
SQL Development
Welcome to the wide and wonderful world of SQL development. Whether you’re dipping your toes into these waters for the…
Database Cardinality
When dealing with databases, there are several concepts to learn. Modeling and designing a database might seem difficult at first….
Data Anomalies and Data Redundancy
Data redundancy in databases occurs when same piece of data is stored multiple times in the same table object or…
A Brief Lowdown On SQL Injection Attacks
SQL injection can be best defined as a security vulnerability on your web application. With this injection, an attacker can…
What is the Difference Among Databases, Data Warehouse, Data Mart, and Data Lake
There are many different ways to store, manipulate and retrieve data in a system. Many different software are available for…
A Comprehensive Guide on OLTP vs. OLAP
When talking about relational database management systems, there are 2 concepts that must be understood in order to accomplish the…
What is the difference between Data Lake and Data Warehouse?
The main difference between data lake and data warehouse is that the a data lake can be composed of all…
Data Control Language (DCL)
When talking DCL, we are mainly talking about a portion of security in SQL Server. There are only two commands,…
The Bits and Bytes of a SQL Server Datatype
What are the SQL Server datatypes? The SQL Server datatypes dictate the type of data an object can hold. Examples…