Oracle SQL Developer Data Modeler for Database Design Mastery | 0:e upplagan

An Oracle ACE Director reveals how to design world-class databases on any platform with this powerful, free tool. Oracle SQL Developer Data Modeler for Database Design Mastery provides best practices for planning, executing, installing, deploying and maintaining any kind of database of any size using this robust, free product. Oracle SQL Developer Data Modeler flawlessly supports Oracle and non-Oracle database environments such as IBM DB2 and SQL Server. The author is an Oracle ACE Director with 20+ years of experience designing Oracle databases. Heli Helskyaho approaches the subject of database design from concept to the details of documenting code and walks you through the tremendous capabilities and full power of this free tool. She contrasts the ease of functionality and compatibility of Oracle SQL Developer Data Modeler against expensive third-party solutions. A chapter of the book is devoted to data modeling in regards to data warehousing, including how to develop Oracle OLAP models that can be imported directly into Oracle SQL Developer Data Modeler. It covers everything from concept to deployment to security and maintenance. It provides practical focus with minimal theory.It is filled with tips, tricks, and best practices. It is a uniquely useful approach to constructing the best possible database for every user.