Webcast : MSSQLTips | Principles of Data Modeling

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.

Here is your download link for ER/Studio Enterprise Team Edition!

Please choose the file that meets your system requirements:

Topics :

Products :

K. Brian Kelley

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.

Try ER/Studio Data Architect FREE for 14 days



Improve data quality, enhance data lineage, and create effective data models to build business-driven data architecture with ER/Studio Data Architect.

Start for Free