Jeff Taylor
Principal Data Consultant
Fulton Analytics
Database Design 101
Jeff Taylor
Principal Data Consultant
Fulton Analytics
A Senior Data Engineer, Architect & Consultant. Friend Of Redgate. Octopus Insider. Over 25 years of experience specializing in performance tuning and critical data issues.
Currently serving as the President of the Jacksonville SQL Server Users Group and is an active board member of the Jacksonville Development Users Group.
jssug.org
Every 3rd Wednesday 6-8pm
Except for May, November and December
Annual Free Data Conference
May 6th, 2023
Volunteers - We Want You
https://sqlsaturday.com/jax
20th Anniversary T-Shirt
https://www.customink.com/fundraising/jssug
20th Anniversary Party
@ Autobahn
Pictures!
Jeff Taylor
Principal Data Consultant
Fulton Analytics
Database Design 101
Database Design 101
Outline
- History
- Forms 1st-3rdNF, Boyce-Codd or 4th NF
- Data Warehouse - Star Schema
- Key Value Pair
- OLTP - Relational - RDBMS
- Define Relationships
- Consistency in Naming
- Pascal vs. Camel Casing
- Logging - Temporal Tables
Questions
Thank you
Jeff Taylor
Thank you for attending my session today. If you have any additional questions please don't hesitate to reach out. My contact information is below. Please don't forget to evaluate my session!