In a real-time situation, there are scenarios when we would like to remove the table from the database. Let us discuss in detail about the process of removing a table from the database. SQL DROP TABLE The SQL DROP TABLE statement informs the database that a particular table needs to be removed. SQL DROP TABLE […]
SQL Create Table
When we have to store data in relational databases, the first part is to create the database. Next step is to create a table in the database that will store our data. In this tutorial, we will discuss how to create a table using SQL queries in MySQL and PostgreSQL databases. I am not covering […]
SQL Select Database – MySQL, PostgreSQL, SQL Server
When we work with different databases based on different requirements, we need to select the database before running any SQL command. The SQL command is then run post selection of database. Let us try to understand how to select a database in different Databases. MySQL PostgreSQL SQL Server MySQL Select Database In order to perform […]
SQL Alias
There are cases when the column name or the table name that is existing in the database is not so human readable. We can use SQL ALIAS feature to assign a new name to the table or columns in our query. SQL ALIAS is used for temporary naming of table or column of a table […]
SQL Drop Database – MySQL, PostgreSQL, SQL Server
When we work with the database there are very rare cases when we want to drop the complete database. However, sometimes it’s required to do a complete cleanup and fresh database setup. The meaning of dropping a database is that all the tables in the database will be deleted along with the data that is […]
SQL Rename Database
In the real world, there is very minimal chance when we need to rename database but still renaming database is a very valid scenario in real time. Today we will try to rename databases in some of the most used Databases of the world. Introduction In this section, we will see how different databases provides […]
SQL Create Database – PostgreSQL, MySQL, SQL Server
The start of data storage is from the creation of a database. As the name suggests database is a base for data. A database typically contains different tables based on the necessity of data storage. SQL Create Database In this section, we will see how different databases provides the feature of creating a database. So […]
Install SQL Server Express and SQL Server Management Studio
SQL server is one of the most used databases in the world. Also, SQL server’s performance is well known to the world. In order to understand any system the best way is to try out the system. We will also do the same. Let us install SQL Server into our Windows system. Install SQL Server […]
SQL Select Top
SQL Select Top SQL SELECT TOP clause is very useful when dealing with a huge set of data or tables with a huge amount of data. This clause is used to restrict the number of records to return a result set. The SELECT TOP clause can be used in two ways. By providing the number […]
SQL Limit – MySQL Limit
When we work with a huge amount of data there are cases when we need to restrict the number of rows that should be returned as part of the query. In order to help us with the same, SQL provides us with a feature called SQL Limit. This clause has to be the last one […]