SQL

SQL Tutorial

SQL Aggregate Functions

SQL Aggregate Functions basically operate on multiple columns to perform the operations and serve to represent the output as an entity representing the operation executed. Syntax: DISTINCT enables the user to select distinct values from….

SQL Joins

SQL Joins combine two or more tables together based on the corresponding common column among them. Note: All the below mentioned queries are executed with reference to MySQL Database. Types of SQL Joins INNER JOIN LEFT OUTER….

SQL Auto Increment

Sometimes we don’t have unique identifiers in the table to create a primary key. In this case, we can take help from SQL to have a special column for the primary key, whose values will….

SQL Foreign Key

When a database table is designed an important factor is to make sure that the table is scalable enough and is normalized at the same time. In order to make sure that the tables are….

SQL Composite Key

In a real-time situation, there can be scenarios when one column is not good enough to uniquely identify a row. In such scenarios, we use a combination of columns to uniquely identify a row. SQL….

SQL Primary Key

In a world driven with data all over, it is very easy to get duplicate data. The nightmare of any database table designer is to create a table with the possibility of duplicate data insertion…..

SQL Constraints

In a real-world scenario, there are cases when we would like to restrict the type of data that is getting stored in the DB table. In order to achieve the restriction on the database, SQL….

SQL Temp Table

In real time scenario, consider that you have read-only access on a table and you have to manipulate some data in it. It is always useful to create a temp table when you want to….

SQL Copy Table

In real time we do face situations where we need to copy data from one table to another table or when we need to create a table from a set of data from the table…..

SQL Truncate Table

SQL Truncate Table Assume a case when we want to have the database but we would like to delete the data of the table. In such cases, TRUNCATE command is used to delete just the….

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