SQL Tutorial

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,….

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….

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….

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….

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….

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…..

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….

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….

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….

SQL Select Into

SQL Select Into SQL SELECT INTO operator is a very useful operator when it comes to data migration. SELECT INTO is used for the following two purposes. SELECT INTO copies data from all the columns….

Generic selectors
Exact matches only
Search in title
Search in content
Search in posts
Search in pages