Next Generation Data Management: Database design, part 1
Dr. Mark Brady Overview:
The relational database was developed to overcome deficiencies of earlier designs. They have the most advanced theoretical foundations of all database types. For this reason, they are the most commonly used database today. In order to understand any other database type, one must first master the relational database.
Database design is a largely understudied subject, so many databases in use today have design defects leading to errors and lower analytical power.
Why you should Attend:
This webinar is for those who want to become database design experts. Participants will learn how to design or redesign relational databases. All material will be in plain English with terms defined as we go, so any participant with analytic aptitude will excel.
Areas Covered in the Session:
- Historical development: before there were relational databases
- Basic structure of the relational database
- What is a relation?
- Tuples, body, keys, candidate keys, foreign keys,
- Normal forms 1-6: redundancy leads to inconsistency, which leads to errors
- Lossless decomposition
- Joins
- Join dependency
- Boyce Codd normal form
- What is a function?
- Functional dependencies
- Look out for circular business constraints
- Other redundancies to look out for
- The database design process is really a process of discovery
- The problem with NULLS
- Have your cake and eat it too with views
- Introduction to SQL
Who Will Benefit:
- Data scientists
- programmers
- data Systems Engineers
- Database Administrators
- data Managers
Speaker Profile
Dr. Mark Brady is the former Chief Data Officer of the US Space Force, Chief Data Officer of the Air Force Space Command, Data Architect for the Department of Justice and Information Architect for the National Marine Fisheries Service (NMFS). In these roles, he established the first data management programs and data policies for all four organizations and also contributed to the development of policy for the National Atmospheric and Oceanic Administration (NOAA). He also helped established electronic trade standards as U.S. delegate to the United Nations, served on the White House Data Cabinet, and the National Oceanic and Atmospheric Administration’s Big Data Council. Prior to his federal service he conducted basic scientific research in neuroscience, taught neuroscience and statistics, and conducted industrial R&D. He is an inventor and author, with a number of AI patents from this work in industry.