Webcast : ER/Studio Enterprise Team Edition

MSSQLTips | Principles of Data Modeling

Presenter: K. Brian Kelley

You’ve been tasked with coming up with a data model for a system. Where do you start? What do you need to know? What should you expect from a solid data model?

In this webinar we’ll look at:

  • The process of converting ideas and concepts into data structures.
  • What normalization is and why we use it.
  • How to move from the logical model to the physical model.
  • What specifically to consider when implementing a physical data model on SQL Server.

 

Armed with this information, you’ll be able to start the process of creating a data model or tweaking an existing data model. You’ll also have some areas to look for within SQL Server when a database with an implemented data model isn’t performing well.

Speaker:

K. Brian Kelley is an author, columnist, Certified Information Systems Auditor (CISA), and former Microsoft Data Platform (SQL Server) MVP (2009-2016) focusing primarily on SQL Server and Windows security. Brian currently serves as a data architect as well as an independent infrastructure/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, IT/Dev Connections, SQLConnections, the Techno Security and Forensics Investigation Conference, the IT GRC Forum, SyntaxCon, and at various SQL Saturdays, Code Camps, and user groups.

Topics : Data Modeling,Enterprise Architecture,

Products : ER/Studio Data Architect,ER/Studio Enterprise Team Edition,

Register for Free Webcast

Note: By filling and submitting this form you understand and agree that the use of IDERA’s website is subject to the General Website Terms of Use. Additional details regarding IDERA’s collection and use of your personal information, including information about access, retention, rectification, deletion, security, cross-border transfers and other topics, is available in the Privacy Policy.