Webcast : ER/Studio Data Architect

Databases Don’t Build and Populate Themselves

Presenter: Stan Geiger

Databases are often like the big bang, suddenly they just exist, right? Well, not really, someone had to do the due diligence and design them conceptually then come up with a physical model for implementation. If it’s a transaction database, then we’re done and the application connects and, voila, data starts filling our database. But in other situations such as business intelligence, analytics, conversions, etc. we must move data from other systems into the database.

In this session we are going to discuss these two key aspects: database design patterns and Extract, Transform and Load (ETL). We will talk about the role of data modeling and SQL Server Integration Services for data migration.

About Stan: Stan Geiger is a Senior Product Manager at IDERA with over 25 years using Microsoft SQL Server. Stan has worked in various industries from fraud detection to healthcare. He has held several positions including database developer, DBA, and BI Architect, and has experience building Data Warehouse and ETL platforms, BI Analytics and OLTP systems.

Topics : Data Modeling,

Products : ER/Studio Data Architect,

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.