Try for free

Database Processing: Fundamentals, Design, and Implementation, Global Edition

David M. Kroenke, David J. Auer

Information

  • Publisher
  • ISBN
  • ePub ISBN
  • Pearson UK
  • 9781292107646
  • 9781292107639
  • Published at
  • Pressing
  • 2016
  • 14

About this book

Online Chapters on SQL Server 2014 (Chapter 10A), Oracle Database (Chapter 10B), and MySQL 5.6 (Chapter 10C) now have a section on importing data from Microsoft Excel 2013 worksheets. Material on big data and the evolving NoSQL movement from Chapter 12 has been expanded upon in a new Appendix K. New material on virtualization and cloud computing is also included in Chapter 12. The SQL topics of UNION, INTERSECTION, and EXCEPT in Chapter 2 have been reorganized and expanded to provide a more concise presentation of SQL queries, so that nearly all SQL query topics are covered in one chapter (the exception is correlated subqueries, which are still reserved for Chapter 8). Microsoft SQL Server 2014. Although most of the topics covered are backward compatible with Microsoft SQL Server 2012 and Microsoft SQL Server 2008 R2 Express edition, all material in the book now uses SQL Server 2014 in conjunction with Office 2013, exclusively. Oracle Database 12c and Oracle Database Express Edition 11g Release 2. The new edition has been updated to include Oracle Database 12c and Oracle Database Express Edition 11g Release 2, the preferred Oracle Database product for use on personal computers. The current version of the Oracle SQL Developer GUI tool provides a common interface to both versions of Oracle Database, and detailed examples of how to use it are provided. Microsoft Windows Server 2012 R2 and Windows 8.1. The new edition has been updated with discussion and illustration of Microsoft Windows Server 2012 R2 as the server operating system and Windows 8.1 as the workstation operating system. Windows 7 material has been retained where appropriate, and in some places the authors present both the Windows 7 and Window 8.1 versions of operations and utilities. Server virtualization, cloud computing, Big Data, and the Not only SQL movement. Coverage includes server virtualization, cloud computing, Big Data, and the Not only SQL movement. UPDATED! Online Appendix I, "Getting Started with Web Servers, PHP and the NetBeans IDE" has been updated to include NetBeans IDE instead of the Eclipse IDE. This new material provides a simplified (but still detailed) introduction to the installation and use of the Microsoft IIS Web server, PHP, the Java JDK, and the NetBeans IDE used for Web database application development as discussed in Chapter 11. The organization and topic selection of the Fourteenth Edition are also designed to: Use a consistent, generic Information Engineering (IE) Crow’s Foot E-R diagram notation for data modeling and database design. Provide a detailed discussion of specific normal forms within a discussion of normalization that focuses on pragmatic normalization techniques. Create Web database applications based on widely used Web development technology. Provide an introduction to business intelligence (BI) systems. Discuss the dimensional database concepts used in database designs for data warehouses and online analytical processing (OLAP).

Note: Some books are only available in specific countries.

Therefore, always check if your books are available in your country before subscribing by using the search function in the app at buku.app.