SQL Training

SQL Training

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.

SYLLABUS


Oracle Training
SQL Tutorial
Introduction to SQL open linkWhat is SQLWhat is DatabaseWhat is RDBMSDBMS vs RDBMSSQL SyntaxSQL Data TypesSQL Operators
SQL Database
SQL CREATE DatabaseSQL DROP DatabaseSQL RENAME DatabaseSQL SELECT Database
SQL Table
What is TableSQL TABLE VariableSQL CREATE TABLESQL DROP TABLESQL DELETE TABLESQL RENAME TABLESQL TRUNCATE TABLESQL COPY TABLESQL TEMP TABLESQL ALTER TABLE
SQL Select
SELECT StatementSQL SELECT UNIQUESQL SELECT DISTINCTSQL SELECT COUNTSQL SELECT TOPSQL SELECT FIRSTSQL SELECT LASTSQL SELECT RANDOMSQL SELECT ASSQL SELECT INSQL SELECT MultipleSQL SELECT DATESQL SELECT SUMSQL SELECT NULL
SQL Clause
SQL WHERESQL ANDSQL ORSQL WITHSQL AS
SQL Order By
ORDER BY ClauseORDER BY ASCORDER BY DESCORDER BY RANDOMORDER BY LIMITORDER BY Multiple Cols
SQL Insert
INSERT StatementINSERT INTO ValuesINSERT INTO SELECTINSERT Multiple Rows
SQL Update
UPDATE StatementSQL UPDATE JOINSQL UPDATE DATE
SQL Delete
DELETE StatementSQL DELETE TABLESQL DELETE ROWSQL DELETE All RowsDELETE Duplicate RowsSQL DELETE DATABASESQL DELETE VIEWSQL DELETE JOIN
SQL Join
SQL JOINSQL Outer JoinSQL Left JoinSQL Right JoinSQL Full JoinSQL Cross Join
SQL Keys
Primary KeyForeign KeyComposite KeyUnique KeyAlternate Key
Difference
SQL vs NoSQL
PL/SQL Tutorial
PL/SQL Tutorial
Interview
SQL InterviewPL/SQL Interview
Quiz
SQL Quiz

Popular Posts

Search This Blog

  • ()
Training Trains. Powered by Blogger.

Follow by Email

Flickr

Privacy policy