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.