Overview of SQL

SQL is a standard language for accessing and manipulating databases.

---

What is SQL?

• SQL stands for Structured Query Language
• SQL lets you access and manipulate databases
• SQL is an ANSI (American National Standards Institute) standard

SQL is just a query language, it is not a database. To perform SQL queries, you need to install any database for example Oracle, MySQL, MongoDB, PostGre SQL, SQL Server, DB2 etc.

SQL DATABASE

SQL CREATE, DROP and RENAME DATABASE

SQL TABLE

SQL CREATE, DROP, DELETE, RENAME, TRUNCATE and COPY TABLE

SQL SELECT

SQL SELECT statement with UNIQUE, DISTINCT, AS and IN keywords and first(), last(), top(), sum(), random() and count() functions.

SQL INSERT

SQL INSERT INTO, INSERT SELECT and INSERT multiple rows.

SQL UPDATE

SQL UPDATE statement, update with JOIN and update DATE.

SQL DELETE

SQL DELETE TABLE, DELETE One Row, DELETE all rows, DELETE VIEW, DELETE database, DELETE duplicate rows and DELETE with INNER JOIN