SQL Data types and Literals | Types of SQL commands ~ DDL, DML, DQL, DCL, TCL | SQL Operator | DBMS

#DBMS #SQL #NoSQL #CloudDatabase #DatabaseAsAService #MultiModelDB #AIinDBMS #AugmentedAnalytics #DataOps #BigData #DataEngineering #DataAnalytics #DatabaseSecurity #ZeroTrustSecurity #BlockchainDB #DataGovernance #PostgreSQL #MongoDB #MySQL #OracleDB #GraphDatabase #ETL #DataWarehouse #DatabaseDesign
Unit-1

Introduction

Overview of DBMS,
Database System v/s File System,
Architecture of DBMS,
Data models,
Entity Relationship Diagram,
Types of Keys,
Integrity Rules,
Data Dictionary,
Normalization (INF, 2 NF, 3NF, BCNF, 4NF, 5NF),
inclusion dependencies,
loss less join decompositions,
Codd's Rules

Unit-2

Transaction Management

Transactions: Concepts,
ACID Properties,
States Of Transaction,
Serializaibility,
Conflict & View Serializable Schedule,
Checkpoints,
Deadlock Handling

Unit-3

Database Querying & Concurrency Control

Relational Algebra,
Set Operations,
Relational Calculus,
Steps In Query Processing,
Algorithms For Selection,
Sorting And Join Operations,
Understanding Cost Issues In Queries,
Query Optimization,
Transformation Of Relational Expressions,
Query Evaluation Plans

Concurrency Control: Locks Based Protocols,
Time Stamp Based Protocols,
Validation Based Protocol,
Multiple Granularity,
Multi-version Schemes

Unit-4

Recovery System & Security

Failure Classifications,
Recovery & Atomicity,
Log Base Recovery,
Recovery with Concurrent Transactions,
Shadow Paging,
Failure with Loss of Non-Volatile Storage,
Recovery From Catastrophic Failure,
Introduction to Security & Authorization,
Introduction to emerging Databases-OODBMS,
ORDBMS,
Distributed database,
Multimedia database Special database-limitations of conventional databases,
advantages of emerging databases.

Unit-5

SOL and PL/SQL

Introduction to SQL,
Characteristics of SQL,
Advantages of SQL,
SQL data types and literals,
Types of SQL commands,
SQL operators,
Tables,
views and indexes,
Constraints,
Group By and Having Clause,
Order By Clause,
Queries and sub queries,
Functions,
PL PL/SOL basics,
blocks,
architecture,
variables,
constants,
attributes,
character set,
PL/SQL control structure,
data types,
conditional and
sequential control statements,
cursors,
exceptions,
triggers,
functions,
procedures ,
packages.

Видео SQL Data types and Literals | Types of SQL commands ~ DDL, DML, DQL, DCL, TCL | SQL Operator | DBMS канала Book & Talks