Database design and management
Master the essentials of data management with our comprehensive guide on how to learn database management. Whether you’re a beginner or looking to enhance your skills, our lessons cover key concepts like relational databases, SQL queries, and data modeling. Gain hands-on experience in database creation, maintenance, and optimization as you learn database management system fundamentals and prepare for real-world applications.
The way in which computers manage data has come a long way over the last few decades. Today’s users take for granted the many benefits found in a database system. In this self-paced course you lean about history of database, types of databases, and how to model data using Entity Relationship diagrams. You also learn how to translate a logical database design into physical one.
This course comes with many hands-on examples to help beginners grasp concepts thoroughly.
Learn Oracle Database
Ready to dive into Oracle? Our guide on how to learn Oracle database will walk you through the basics of one of the most powerful database systems in the industry. With our learn Oracle database program, you’ll explore everything from installation to advanced SQL functions and PL/SQL programming. This beginner-friendly course is perfect for anyone aiming to build a career in database administration and management.
Requirements
None.
Topics and Subtopics
Here is the course outline:
Click here to download course materials like project source files.
1- Before the Advent of Database Systems
- File-based Approach
- Database Approach
2- Fundamental Concepts
- What Is a Database?
- Database Management System
3- Characteristics and Benefits of a Database
- Characteristics and Benefits of a Database
4- Types of Data Models
- High-level Conceptual Data Models
- Record-based Logical Data Models
5- Data Modeling
- Degrees of Data Abstraction
- Data Abstraction Layer
- Schemas
- Logical and Physical Data Independence
6- Classification of Database Management Systems
- Classification Based on Data Model
- Classification Based on User Numbers
- Classification Based on Database Distribution
- Distributed database system
7- The Relational Data Model
The video clip of session 7 is merged with session 8 video.
- Fundamental Concepts in the Relational Data Model
- Properties of a Table
8- The Entity Relationship Data Model
- Entity, Entity Set and Entity Type
- Kinds of Entities
- Attributes & Types of Attributes
- Keys & Types of Keys
- Nulls
- Relationships & Types of Relationships
9- Integrity Rules and Constraints
- Domain Integrity
- Enterprise Constraints & Business Rules
- Relationship Types
10- ER Modeling
- Relational Design and Redundancy
- Insertion Anomaly
- Update Anomaly
- Deletion Anomaly
- How to Avoid Anomalies
Project 1- University Registration Data Model Example
The video of project 1 is merged with project 2 video
Project 2- Sample ERD Exercises
Related Courses
- Introduction to No-SQL Database Design
- Learn Graph Database Design by Examples
Private Tutoring Classes
To take skills you learn from this course to the next level, taking the following tutoring classes are highly recommended. It is also a great opportunity to discuss your questions and problems related to this course with an experienced instructor:
- Private tutoring sessions for system administrator management- Weekly and monthly plans
- Database design and SQL coding- Private tutoring sessions
What Is Next?
After finishing this course, you can enroll in any of following Coding Bootcamps school classes:
- Learn SQL Programming by Examples
- Introduction to Linux OS
- Web Development with PHP & MySQL
- Learn PHP Programming
- Intro to HTML and CSS