1000+ Free Courses With Free Certificates: https://www.mygreatlearning.com/academy?ambassador_code=GLYT_DES_Top_SEP22&utm_source=GLYT&utm_campaign=GLYT_DES_Top_SEP22
Get your free certificate of completion for the My SQL Basics Course, Register Now: http://glacad.me/MySQLCourse
Data is present everywhere and hence its management becomes very important, but the foremost step is cleaning the database which is done by removing any kind of redundant data. Hence, Normalization plays an important role in database management. Hence, In today’s tutorial we’ll be discussing various normalization techniques in MySQL.
The process of minimizing redundancy from a relation or set of relations is referred to as Normalization. Redundancy in relation may cause insertion, deletion and updation anomalies. So, it helps to minimize the redundancy in relations. Normal forms are used to eliminate or reduce redundancy in database tables.
The most common Normalization techniques are 1NF, 2NF, 3NF and BCNF, where “NF” refers to Normal Form. These techniques have different rules and today we’ll be explaining all of that in the simplest way possible. So, watch the complete video for a Great Learning experience.
Following pointers will be covered in this video:
00:00:00 Introduction
00:51:00 What is Normalization?
00:01:27 Types of Normalization
00:02:13 Types of Normalization: 1NF
00:04:30 Types of Normalization: 2NF
00:06:38 Types of Normalization: 3NF
Visit Great Learning Academy, to get access to 80+ free courses with 1000+ hours of content on Data Science, Data Analytics, Artificial Intelligence, Big Data, Cloud, Management, Cybersecurity and many more. These are supplemented with free projects, assignments, datasets, quizzes. You can earn a certificate of completion at the end of the course for free. https://glacad.me/3duVMLE
Get the free Great Learning App for a seamless experience, enroll for free courses and watch them offline by downloading them. https://glacad.me/3cSKlNl
About Great Learning:
- Great Learning is an online and hybrid learning company that offers high-quality, impactful, and industry-relevant programs to working professionals like you. These programs help you master data-driven decision-making regardless of the sector or function you work in and accelerate your career in high growth areas like Data Science, Big Data Analytics, Machine Learning, Artificial Intelligence & more.
- For more interesting tutorials, don't forget to subscribe to our channel: https://bit.ly/2s92TDX
- Learn More at https://www.greatlearning.in/
For more updates on courses and tips follow us on:
- Telegram: https://t.me/GreatLearningAcademy
- Facebook: https://www.facebook.com/GreatLearningOfficial/
- LinkedIn: https://www.linkedin.com/company/great-learning/
- Follow our Blog: https://www.greatlearning.in/blog/?utm_source=Youtube
#MySQL#Normalization #GreatLearning