![]() In this example I'll use a college Enrollment Table. To gain a better understanding of normalization and the challenges it addresses, let's explore an example of a table that hasn't been normalized. It structures tables in a way that minimizes challenges by reducing data duplication, avoiding data modification implications and helping to simplify data queries from the database. Normalization is an important process used in database systems. And be able to list some of the issues associated with them. By the end of this video, you'll be able to explain what database normalization is and you'll also be able to demonstrate an understanding of insert, update and deletion anomalies. Fortunately these issues can be resolved with the use of database normalization. But there are several issues that you're likely to encounter when working with tables such as unnecessary data duplication, issues with updating data and the effort required to query data. You’ll also gain experience with the following:Īt this stage, you might be familiar with the process for creating tables within a database. and plan and design a simple relational database system Manipulate records in a database with the use of SQL statements and commands Identify and interpret basic SQL statements and commands Identify and explain the different types of core technology and management systems used in Demonstrate a working knowledge of the concepts and principles that underpin how databases work You’ll then practice basic creation and data selection tasks with the use of Structured Query Language (SQL) commands.īy the end of this course, you’ll be able to: ![]() You’ll also learn to distinguish between different types of database management systems. In this course, you’ll receive an introduction to databases and explore the different ways in which they can be used to store and manage data. Therefore, it’s essential that all back-end developers possess strong knowledge and experience with how databases work. Some common tasks that end-users carry out using these applications include storing, searching, extracting and manipulating data. Back-end developers write applications that end-users use to interact with databases. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |