SQL (Structured Query Language)

SQL Tutorial

SQL tutorial provides basic and advanced concepts of SQL. Our SQL tutorial is designed for beginners and professionals.

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.

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.

SQL JOIN Tutorial

Our SQL join tutorial provides full detail of INNER JOIN, OUTER JOIN, LEFT OUTER JOIN, RIGHT OUTER JOIN and SELF JOIN.

SQL Keys

SQL keys are primary key, composite key, foreign key, alternate key and unique key. In SQL keys tutorial, we will provide description and examples of each key.

SQL QUIZ

SQL Basics, CRUD and Miscellaneous quizzes.