Structured Query Language (SQL) is the set of statements with which all programs and users access data in a database. SQL is the standard query language to fetch, modify, update & process the data in Relational Database Management System. Relational Database Management System A relational database is a database that is treated as a set of tables and manipulated in accordance with the relational model of data. It contains a set of objects used to store, manage, and access data. Examples of such objects are tables, views, indexes, functions, triggers, and packages. And the software used for Relational Database is known as Relational Database Management System.
Table of Contents
1. History of SQL
2. SQL Components: An Overview
3. Data Types in SQL
4. Planning a Database: An Example: -
5. Creating Tables
6. Inserting Data using Insert
7. Getting Data with Select Statement
8. Working with Operators
9. Selecting Unique rows with Distinct
10. Arraging Data with Order by
11. Working with Strings
12. SQL AND
13. Basic SQL Funtion
14. Sub-Queries, Nested Queries
15. Constraints in the Table
16. SQL UPDATE
17. View
18. Relationships in a RDBMS
19. Structure Modification,Updation and Deletion
20. Alter Table Statement
21. Joins
22. INNER JOIN
23. Outer Join
24. Outer Join contd..
25. Cartesian Join/Cross Join
26. SELF JOIN
27. SET operation – UNION
28. SET operation – INTERSECT
29. SET operation – MINUS
30. Views
31. Horizontal View
32. Vertical View
33. Index In Database
34. Types of INDEXES
35. DCL – Granting Privileges
36. Revoking Privileges (REVOKE)
37. Regular Expressions
