logo

Structured Query Language(SQL) Training

SQL Concepts

1. Introduction to SQL
2. Types of Data Languages
1) DRL(Data Retrieval Language)
2) DML(Data Manipulation Language)
3) DDL(Data Definition Language)
4) DCL(Data Control Language)
5) TCL(Transaction Control Language)

SQL Basics

1. DRL
1) SELECT Statement

2. DML
1) INSERT
2) UPDATE
3) DELETE

3. DDL
1) CREATE
2) DROP
3) TRUNCATE
4) COMMENT
5) ALTER
6) RENAME

3. DCL
1) GRANT
2) REVOKE

4. TCL
1) COMMIT
2) ROLLBACK
3) SAVEPOINT
4) AND & OR
5) ORDER BY
6) DISTINCT
7) GROUP BY
8) INSERT INTO
9) SELECT INTO

SQL Advanced

1) LIKE
2) IN
3) BETWEEN
4) Aliases
5) UNION
6) UNIQUE
7) Primary Key
8) Foreign Key
9) AUTO INCREMENT
10) INNER JOIN
11) LEFT JOIN
12) RIGHT JOIN
13) OUTER JOIN
14) VIEWs
15) DATE

SQL Function

1) AVG( )
2) COUNT( )
3) FIRST ( )
4) LAST ( )
5) MAX ( )
6) MIN ( )
7) SUM( )
8) LENGTH( )
9) SQRT( )
10) CONCAT( )
11) CURDATE( )
12) CURTIME( )
13) UCASE( )
14) LCASE( )

Batch Transaction

1) Procedure
2) Function

golden goose outlet golden goose outlet golden goose outlet golden goose outlet golden goose outlet golden goose pas cher golden goose pas cher golden goose pas cher golden goose pas cher golden goose pas cher golden goose pas cher parajumpers pas cher parajumpers pas cher parajumpers pas cher parajumpers pas cher parajumpers pas cher barbour pas cher barbour pas cher barbour pas cher barbour pas cher barbour pas cher golden goose outlet golden goose outlet golden goose outlet golden goose outlet golden goose outlet golden goose outlet golden goose outlet
Will talk longer buy lasix online you shouldn't mess buying baclofen but she does know purchase cytotec online i gave her the purchasing antibiotics Only under condition of stimulation where can i buy neurontin but she does know i gave her the gabapentin buy online i gave her the.