SQL is a language that is used to manage relational databases. It provides a facility for easily declaring and using variables. We can use variables for storing temporary values in memory for performing calculations. In SQL variables can be used in the same way we use in any other programming language. SQL Declare Variable In …
How to Declare a Variable in SQL and Assign a Value? Read More »
SQL Server database is a term you’re probably already familiar with. When it comes to storing large amounts of data, databases are extremely useful. And as you’ve figured out, SQL Server’s default settings aren’t always the best. When working with new user databases, this is the case. We can define a database as, In SQL …
What is Filegroup in Sql Server? When & How to Create? Read More »
In this article, we will have a look at the difference between Entity and Attribute, which form the core principles of the Entity-Relationship Model in Database Management System. We will look at the description of each in detail with examples and compare them for a clear idea. Entity An Entity is defined as any object …
Oracle is a Database Management System that is used across the world in various companies. Oracle makes use of SQL or ‘Sequel’ language for data manipulation & operations on data. Today, in this article, we will check out the History of Oracle database. ‘SEQUEL’ was developed by IBM Corporation Ltd to use various Codd’s models …
Companies everywhere are handling more data than ever and all these terabytes of data need to be stored somewhere. Should you store the data in a database, a data warehouse, or a data lake? How do you know what is best for your company? Choosing the right data storage solution will depend greatly on how …
In this article we look into the difference between Primary Key and Unique Key Constraints. We will see the description of both along with how to define a schema and create attributes in a table with these constraints. Primary Key A Primary Key is a key attribute or a column which is used to uniquely …
In this article we look into the difference between CLOB and BLOB datatypes in Oracle/MYSQL. We will also see about the description of each datatype and how to create attributes in a table with these datatypes. So, CLOB and BLOB are types of Large Object Datatypes (LOB). LOB’s are a set of datatypes used to …
Difference between CLOB and BLOB Datatypes in ORACLE/MYSQL Read More »
In this article, we look into the difference between DELETE, DROP and TRUNCATE commands in SQL. We will also see the general syntax related to each of the commands and the corresponding queries to implement these commands in SQL. DELETE The SQL DELETE command is used to delete existing records or rows from a table. …
Difference between DELETE, DROP and TRUNCATE in SQL Read More »
