SQL

What Is SQL?

---

SQL is a slandered language for accessing and manipulating database.Its ANSI Standard. SQL is a Structured Query Language. You can access and manipulate database.

SQL Can Do:

SQL can Execute queries against a database.

SQL can retrieve data from database.

SQL can Insert records in database.

SQL can Update records in a database.

SQL can Delete records from a database.

SQL can Create new database.

SQL can Create new table in a database.

SQL can Create stored procedure in a database.

SQL can Create view in a database.

SQL can Set permissions on tables, procedures and views.

The topic will cover in this tutorial in Advance SQL:

CREATE DB
CREATE TABLE
CREATE INDEX
Key & CONSTRAINT
AUTO INCREMENT
SELECT
INSERT
UPDATE
DELETE
DROP
USE DATABASE
LIKE
WILDCARD
IN
BETWEEN
ALIAS
JOIN
UNION & UNION ALL
INTERSECT
TOP
TRUNCATE
ALTER
VIEW
SUBQUERY
WHERE
AND & OR
NULL & NOT NULL
GRANT & REVOKE
TRANSACTION
DISTINCT
Functions
AVG()
COUNT()
SUM()
FIRST()
LAST()
MAX()
MIN()
GROUP BY()
HAVING()
ORDER BY()
UCASE()
LCASE()
MID()
LEN()

NOW()

Author : Unknown

Share this

Related Posts