Introduction to Data modeling
Short notice, but join us at Charleston Southern for Brian Kelley's talk on Introduction to Data Modeling
Abstract -
Improperly built bridges and buildings fail and collapse. Improperly built database do, too. Unfortunately, database design is becoming a lost art, leading to issues with both performance and data integrity. In this presentation we’ll look at the keys to proper database design. We’ll start with requirements gathering. Then we’ll tackle the logical design of the database. We’ll consider entities, domains, relationships, and proper normalization. Finally, we’ll move on to discussing how to implement our design, specifically using SQL Server.
Current Bio:
Brian Kelley is an author, columnist, Certified Information Systems Auditor (CISA), and former Microsoft SQL Server MVP (2009-2016) focusing primarily on SQL Server and Windows security. Brian currently serves as an infrastructure and security architect concentrating on Active Directory, SQL Server, and Windows Server. He has served in a myriad of other positions including senior database administrator, data warehouse architect, web developer, incident response team lead, and project manager. Brian has spoken at 24 Hours of PASS, SQLConnections, the TechnoSecurity and Forensics Investigation Conference, the IT GRC Forum, and at various SQL Saturdays, Code Camps, and user groups.
Short notice, but join us at Charleston Southern for Brian Kelley's talk on Introduction to Data Modeling
Abstract -
Improperly built bridges and buildings fail and collapse. Improperly built database do, too. Unfortunately, database design is becoming a lost art, leading to issues with both performance and data integrity. In this presentation we’ll look at the keys to proper database design. We’ll start with requirements gathering. Then we’ll tackle the logical design of the database. We’ll consider entities, domains, relationships, and proper normalization. Finally, we’ll move on to discussing how to implement our design, specifically using SQL Server.
Current Bio:
Brian Kelley is an author, columnist, Certified Information Systems Auditor (CISA), and former Microsoft SQL Server MVP (2009-2016) focusing primarily on SQL Server and Windows security. Brian currently serves as an infrastructure and security architect concentrating on Active Directory, SQL Server, and Windows Server. He has served in a myriad of other positions including senior database administrator, data warehouse architect, web developer, incident response team lead, and project manager. Brian has spoken at 24 Hours of PASS, SQLConnections, the TechnoSecurity and Forensics Investigation Conference, the IT GRC Forum, and at various SQL Saturdays, Code Camps, and user groups.
Good to know
Highlights
- 2 hours
- In person
Location
Charleston Southern University Room AH-207
9200 University Blvd
North Charleston, SC 29406
How do you want to get there?
