Module 5: Oracle Introduction & Retrieving Data

 Oracle introduction


DESCRIBE Command




SQL Statement Basics



Select Statements


Column Aliases


Quote Operator



DISTINCT and UNIQUE Operator




Arithmetic Expressions




















Comments

Post a Comment

Popular posts from this blog

module 2 : Data Modelling

 Relational Database model Entity Relationship Model (ER model) Types of Attributes and its Symbol Connectivity of Relationship Degree of an Relationship Designing an ER models   Conversion from ER Model to Relational Model    Conversion from ER Model to Relational Model_Composite Attributes Conversion from ER Model to Relational Model - Derived and Multi-valued Attributes   Many to Many Relationship                                       Many to One Relationships One to Many Relationships One to One Relationships   Strong and Weak Entity Sets Strong and Weak Entity Sets Strong and Weak Entity Sets_2 Cardinality of a Relationship Cardinality and Participation Examples Codd's Rules
Read more

Database Management System (DBMS)

                                                      Module 1: Introduction Concept and Characteristics of DBMS Overview : Learn the fundamental concepts of Database Management Systems. This video covers how a DBMS manages data efficiently, the importance of data integrity, and key characteristics like self-describing nature, insulation between programs and data, and support of multiple views. History and Evolution of Database Overview : Take a journey through the evolution of data storage. This video explains the transition from traditional file systems to hierarchical, network, relational, and modern NoSQL databases, highlighting why the world moved toward structured database management. Database System Architecture Overview : Understand the structural blueprint of a database. We explore the 1-tier, 2-tier, and 3-tier architectures, ex...
Read more