1. Create a table by writing query
2. Alter table by writing query
3. Backup DB
4. Access control in the table

Create a table by writing query

Pattern:

CREATE TABLE table_name (
    column1 datatype,
    column2 datatype,
    column3 datatype,
   ....
); 

Query:

CREATE TABLE 

A sub-query is a SQL query that is used inside another query.

There is no specific pattern for sub-query. Sub-query is used when need to query from another or multiple tables and show data.

Suppose, you have to query with … Read more

SQL join clause is used to combine rows from two or multiple tables based on a common columns between them.

There are several types of Join, like:

1. Left Join
2. Right Join
3. Inner Join
4. Full Outer Join
5. Self Join
6. Cross Join

Aggregate functions are used to perform calculations on multiple values and return it to as a single column value.

There are 5 types of ISO standard aggregate functions:

1. COUNT
2. SUM
3. AVG
4. MAX
5. MIN

COUNT:

Example:

Query to find total rows … Read more

The GROUP BY statement is used with aggregate functions (COUNT, MAX, MIN, SUM, AVG) to group the result set by one or more columns.

Pattern:

SELECT column_name FROM table_name GROUP BY column_name;
or
SELECT column_name1,column_name2 FROM table_name GROUP BY column_name1,column_name2;

If you want to sort data, then you have to use order by clause. If you want to sort data in ascending order, then you have to use the following query:

Pattern:

select * from table_name order by column_name ASC;

In this topic we will learn following queries:

1. SELECT
2. DISTINCT
3. WHERE clause
4. AND, OR, NOT
5. LIMIT
6. LIKE
7. IN
8. BETWEEN

SELECT

select is used to fetch all data from a table.

Pattern:

SELECT * FROM table;

Example:

SELECT * FROM employees;

Insert Data

Now we will add some data using the SQL insert query

Insert query pattern:

insert into table_name (column1,column2,column3,……..columnN) values (‘value1′,’value2′,’value3′,……….,’valueN’);

Now insert some data into our newly created table using this query:

INSERT INTO employees (Emp_id,FirstName,LastName,Department,Designation,Salary) VALUES ('1001','Abdur', 

SQL commands are 4 types. DDL, DML, DCL and TCL

Here I am describing about the SQL Commands.

DDL

DDL is the short name of Data Definition Language. It used to create, update, and delete database schemas and their … Read more

You can install MySQL on your local PC in two ways. The first way is to install MySQL wizard that make your localhost as MySQL server. The second way is to install Xampp server.

The difference between the 2 ways … Read more