Whether on-premises or in the cloud, organizations often ask database administrators to create and manage optimal database designs for data warehouses, data lakes, and many other extensive databases using relational database management systems. We will use these databases for business intelligence, data mining, and data analytics. They are different from traditional online transaction processing systems. So what special design concerns will we face? What database editions and features to rely upon? What kind of query execution plans should we seek?
View the educational webinar “Tips for Data Warehouses and Other Very Large Databases” with Bert Scalzo to discover all pertinent issues, which some may even consider best practices, for such specialized database requirements. While the basic concepts will be applicable universally, examples will be in Oracle, MySQL, SQL Server, and PostgreSQL.