SQL

SQL Tutorial index

• What is SQL ?
• What are Data and Database?
• Database Model Working.
• Relational database model
• Development Environment for SQL
• How to install Oracle SQL Developer 12C?
• How to Create Database connection?
• How to Retrieve data Using Select statement?
• What are the Constraints in database?
• Restricting data using where clause
• Sorting data using Order by Statement.
• Use of SQL Function.
• Data type conversion in SQL
• Use of Nested Functions.
• Difference between NVL and NVL2.
• Case and Decode in SQL
• What are Number functions in SQL?
• Use of Date Function in SQL.
• What are Group Functions in SQL?
• Use of Group By Function in SQL.
• What is Subqueries in SQL?
• How SQL Join Works?
• What is Set Operator in SQL?
• Different SQL Statement.
• What is Data Definition Language(DDL)?
• What is Data Manipulation Language(DML)?
• Use of Database Object in SQL.
• Different Sequence in SQL.
• Indexes in SQL.
• How to Control data access in SQL?
• 100 SQL queries which You should learn.
• Oracle row count for all tables in schema.