Previous
Previous Product Image

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

Original price was: ₹99.99.Current price is: ₹19.99.
Next

Easy Notes Of Object oriented programming unit-1 @Computer Diploma

Original price was: ₹99.99.Current price is: ₹19.99.
Next Product Image

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

Original price was: ₹99.99.Current price is: ₹19.99.

Unit – III Interactive SQL and Performance Tuning
3.1 SQL: Data-types, Data Definition Language (DDL), Data Manipulation language (DML),
Data Control Language (DCL), Transaction Control Language (TCL).
3.2 Clauses & Join: Different types of clauses – Where, Group by ,Order by, Having. Joins:
Types of Joins, Nested queries.
3.3 Operators: Relational, Arithmetic, Logical, Set operators.
3.4 Functions: Numeric , Date and time, String functions, Aggregate Functions.
3.5 Views, Sequences, Indexes: Views :-Concept ,Create ,Update, Drop Views.
Sequences :- Concept ,Create, Alter , Drop, Use of Sequence in table, Index:
Concept ,Types of Index , Create ,Drop Indexes

Hurry Up!
Add to Wishlist
Add to Wishlist

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.

Reviews

There are no reviews yet.

Be the first to review “Easy Notes Of Database Management System unit-3 @Computer Diploma”

Your email address will not be published. Required fields are marked *

Shopping cart

0
image/svg+xml

No products in the cart.

Continue Shopping