Database Design Fundamentals

The Calgary PASS User Group is a local association that organizes events and activities to provide SQL Server and other data professionals with cutting-edge information about Microsoft data platform technologies, including SQL Server and Azure SQL Database, and provide new speakers the opportunity to get involved in the community.You can visit https://www.meetup.com/calgarydata/ for more information about our events. We no longer publish them on this site.

Calgary Data User Group

<P><B>Database Design Fundamentals</B></P>
<P>Data should be easy to work with in SQL Server if the database has been organized as close as possible to the standards of normalization that have been proven for many years, but are often thought of as old-fashioned. Many common T-SQL programming "difficulties" are the result of struggling against these standards and can be avoided by understanding the requirements, applying normalization, as well as a healthy dose of simple common sense.</P>
<P>In this session you will get an overview of how to design a relational database, allowing you to work with the data structures instead of against them. This will let you use SQL naturally, enabling the query engine internals to optimize your output needs without you needing to spend a lot of time thinking about it. This will mean less time trying to figure out why SUBSTRING(column,3,1) = 'A' is killing your performance, and more time for solving the next customer problem.</P>
<H3>Speaker:</H3>
<P><B>Louis Davidson</B> has over 19 years as a corporate database developer and architect. Currently he is the Data Architect for the Christian Broadcasting Network out of Nashville, Tennessee. Nearly all of Louis' professional experience has been with Microsoft SQL Server from the early days, to whatever is the latest version currently in beta.</P>
<H3>Sponsor:</H3>
<P><IMG ALT="Simplivity" SRC="https://cdn.evbuc.com/eventlogos/133300116/simplivitymaster.png" HEIGHT="79" WIDTH="300"></P>

Microsoft Canada

Our {communityGuidelinesLink} describe the sort of content we prohibit on Eventbrite. If you suspect an event may be in violation, you can report it to us so we can investigate.

To report other categories of prohibited or illegal content, submit {link}

Database Design Fundamentals

More events from Calgary Data User Group

Discover more events from Calgary Data User Group, from Science & Tech to other experiences you might love.

Still looking for the right event?

Explore all events in Calgary and filter by date, category, and more to find the perfect fit.

Database Design Fundamentals

More events from Calgary Data User Group

Discover more events from Calgary Data User Group, from Science & Tech to other experiences you might love.

More Science & Tech events

Browse more Science & Tech events with different dates, prices, and formats to find your next great experience.

Still looking for the right event?

Explore all events in Calgary and filter by date, category, and more to find the perfect fit.