Easy Notes Of Database Management System unit-3 @Computer Diploma

Description

3.1 SQL Commands and Data Types

• SQL commands: DDL, DML, DCL, TCL, CREATE TABLE, ALTER TABLE, DROP TABLE, INSERT, UPDATE, DELETE, SELECT, COMMIT, ROLLBACK, GRANT, REVOKE.
• Data types: SQL data types, integer, varchar, date, numeric.

3.2 Clauses and Joins

• Clauses: SQL WHERE clause, GROUP BY, ORDER BY, HAVING, subquery.
• Joins: SQL Joins, INNER JOIN, LEFT JOIN, RIGHT JOIN, FULL OUTER JOIN, self join, cross join.
• Nested Queries: nested query, subquery, correlated subquery, EXISTS.

3.3 Operators

• Operators: SQL operators, relational operators, arithmetic operators, logical operators, set operators.
• Specific Operators: AND, OR, NOT, LIKE, IN, BETWEEN, UNION, INTERSECT, EXCEPT.

3.4 Functions

• Functions: SQL functions, numeric functions, string functions, date and time functions, aggregate functions.
• Aggregate Functions: COUNT(), SUM(), AVG(), MIN(), MAX().

3.5 Views, Sequences, and Indexes

• Views: SQL views, create view, update view, drop view, virtual table.
• Indexes: SQL indexes, create index, drop index, clustered index, non-clustered index.
• Sequences: SQL sequence, create sequence, use of sequence.