Session

Advanced Accidental Database Design - Full Day

In this advanced workshop we cover enhancements in SQL Server 2017 for building databases in an enterprise environment on modern project teams.

With demonstrations and several exercises, this workshop uses group labs to cover advanced database design skills…but this isn’t your average "Here's how to create a table, now go build a database" course. Our goal is to cover new features in SQL Server that are relevant to modern enterprise development practices. We’ll talk about some of the pain points designers feel as well as the costs, benefits, and risks associated with design choices.

Discussion topics will include:

• Advanced database design process
• Security/Encryption/Data masking/Audit
• Advanced Table design Topics {Temporal/In-Memory/Compression}
• Understanding when to scale out versus scale up, and how
• Other Advanced Topics

Attendees will leave this session with an understanding of the following:
• Advanced database architecture design process for modern enterprise development projects
• New and advanced features available in SQL Server 2017
• How to decide which design features are the right design choices for your needs

The day will include lecture style format as well as interactive discussions and exercises.

Level - 300 (Intermediate)
Track - DBA
Other speakers: Karen Lopez

Attendee prerequisites:
Hands-on experience with SQL Server (any version) basic design concepts including normalization, constraints, indexes, datatypes and integrity features.
Basic understanding of database administration concepts.
Familiarity with basic Azure and Data Platform features.

Karen Lopez

Data Evangelist for InfoAdvisors, Space Enthusiast, & TeamData Coach

Toronto, Canada

Actions

Please note that Sessionize is not responsible for the accuracy or validity of the data provided by speakers. If you suspect this profile to be fake or spam, please let us know.

Jump to top