糖心vlog官网观看

In this module, we discuss the basic concepts of conceptual database design. We understand anomalies in database operations. You will be introduced to the Entity鈥揜elationship (ER) model, which is a popular high-level conceptual data model. We will discuss the diagrammatic notations used with the ER model, the ER model's constraints, and their use in the design of conceptual schemas for database applications. We also understand the basics of the Enhanced Entity鈥揜elationship (EER) Model.

In this module, we discuss the basic concepts of Relational Model. We understand the Relational Model Terminologies. We discuss the characteristics of Relations and the Relational constraints. We also learn and understand the update Operations and the ways to deal with Constraint Violations. We learn the steps and process of mapping ER Constructs to relations.

In this module, we will learn formal query languages associated with the relational model. We will look at query operators in these languages and see how we can combine the operators to get the desired results.

In this module, we will learn Structured Query Language(SQL), which is a standard-based language implemented by all relational databases to enable working with the structure and contents of the database . We will look at statements for defining schema, querying, and updating data in the database.

In this module, we discuss the basic concepts of Functional dependencies and inference rules. We understand anomalies in database operations. We understand the need for normalization of relational schemas. We discuss the conditions for various Normal Forms- 2NF, 3NF, and BCNF. We explore the process of decomposition used to take a relation to higher normal forms. We learn how to check whether a decomposition is lossless or dependency-preserving.

In this module, you will understand important disk properties and how data is stored on the disk. You learn about the File storage schemes for storing data. You learn important static hashing and dynamic hashing schemes used for storing and fast retrieval of data from the database

In this module, you will understand what is Indexing and its purpose in Databases. You will gain knowledge about the various categories of Indexing schemes like- Primary indexing, Secondary indexing and Multilevel indexing, and also learn how to design the same. You will understand and learn to design B+ tree indexing structures for Relational databases.

In this module, you learn about the Transaction model used in relational database systems which includes the need for a transaction, concept of schedule, serial and concurrent schedules, and serializability. You learn the need for concurrency control and the concept of locks-based concurrency control, deadlock and deadlock detection. You also learn about Timestamp-based protocols for concurrency control.

In this module, first, you learn various schemes to recover from loss in the event of a crash, and restoring the databases with minimum impact. You learn more on log-based recovery techniques including checkpointing. Then, you understand the steps in SQL query processing and you are introduced to Query optimisation and Heuristics used. Next, you will get an introduction to Database security and important schemes used in securing databases from unauthorised access.