Learn SQL

SQL tutorial provides basic and advanced concepts of SQL.

SQL (Structured Query Language) is used to perform operations on the records stored in database such as updating records, deleting records, creating and modifying tables, views etc.

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.