Secure Nginx with Let's Encrypt SSL Certificate on Ubuntu 18.04
What is SSL Certificate? Over time, cases of internet related security breaches have been on the rise as hackers continue…
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…
SQL Alias – JournalDev
Sql Alias There are cases when the column name or the table name that is existing in the database is…
SQL Drop Database – MySQL, PostgreSQL, SQL Server
SQL Drop Database When we work with the database there are very rare cases when we want to drop the…
SQL Rename Database – JournalDev
In the real world, there is very minimal chance when we need to rename database but still renaming database is…
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…
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…
SQL Select Top – JournalDev
SQL Select Top SQL SELECT TOP clause is very useful when dealing with a huge set of data or tables…