Language : English
Published : 2016-01-08
Pages : 600
Ebook Modern Database Management
For introductory courses in Database Management. Provide the latest information in database development Focusing on what leading database practitioners say are the most important aspects to database development, Modern Database Management presents sound pedagogy, and topics that are critical for the practical success of database professionals. The Twelfth Edition further facilitates learning with illustrations that clarify important concepts and new media resources that make some of the more challenging material more engaging. Also included are general updates and expanded material in the areas undergoing rapid change due to improved managerial practices, database design tools and methodologies, and database technology.
The #1 Easy, Common-Sense Guide to SQL Queries-Updated for Today’s Databases, Standards, and Challenges SQL Queries for Mere Mortals(R) has earned worldwide praise as the clearest, simplest tutorial on writing effective SQL queries. The authors have updated this hands-on classic to reflect new SQL standards and database applications and teach valuable new techniques. Step by step, John L. Viescas and Michael J. Hernandez guide you through creating reliable queries for virtually any modern SQL-based database. They demystify all aspects of SQL query writing, from simple data selection and filtering to joining multiple tables and modifying sets of data. Three brand-new chapters teach you how to solve a wide range of challenging SQL problems. You’ll learn how to write queries that apply multiple complex conditions on one table, perform sophisticated logical evaluations, and think “outside the box” using unlinked tables. Coverage includes — Getting started: understanding what relational databases are, and ensuring that your database structures are sound — SQL basics: using SELECT statements, creating expressions, sorting information with ORDER BY, and filtering data using WHERE — Summarizing and grouping data with GROUP BY and HAVING clauses — Drawing data from multiple tables: using INNER JOIN, OUTER JOIN, and UNION operators, and working with subqueries — Modifying data sets with UPDATE, INSERT, and DELETE statements Advanced queries: complex NOT and AND, conditions, if-then-else using CASE, unlinked tables, driver tables, and more Practice all you want with downloadable sample databases for today’s versions of Microsoft Office Access, Microsoft SQL Server, and the open source MySQL database. Whether you’re a DBA, developer, user, or student, there’s no better way to master SQL. informit.com/aw forMereMortals.com
About the Author
John L. Viescas is an independent database consultant with more than 45 years of experience. He began his career as a systems analyst, designing large database applications for IBM mainframe systems. He spent 6 years at Applied Data Research in Dallas, Texas, where he directed a staff of more than 30 people and was responsible for research, product development, and customer support of database products for IBM mainframe computers. While working at Applied Data Research, John completed a degree in business finance at the University of Texas at Dallas, graduating cum laude. John joined Tandem Computers, Inc., in 1988, where he was responsible for the development and implementation of database marketing programs in Tandem’s U.S. Western Sales region. He developed and delivered technical seminars on Tandem’s relational database management system, NonStop SQL. John wrote his first book, A Quick Reference Guide to SQL (Microsoft Press, 1989), as a research project to document the similarities in the syntax among the ANSI-86 SQL standard, IBM’s DB2, Microsoft’s SQL Server, Oracle Corporation’s Oracle, and Tandem’s NonStop SQL. He wrote the first edition of Running Microsoft Access (Microsoft Press, 1992) while on sabbatical from Tandem. He has since written four editions of Running, three editions of Microsoft Office Access Inside Out (Microsoft Press, 2003, 2007, and 2010-the successor to the Running series), and Building Microsoft Access Applications (Microsoft Press, 2005). John formed his own company in 1993. He provides information systems management consulting for a variety of small to large businesses around the world, with a specialty in the Microsoft Access and SQL Server database management products. He maintains offices in Nashua, New Hampshire, and Paris, France. He has been recognized as a “Most Valuable Professional” (MVP) since 1993 by Microsoft Product Support Services for his assistance with technical questions on public support forums. He set a landmark 20 consecutive years as an MVP in 2013. You can visit John’s Web site at www.viescas.com or contact him by e-mail at firstname.lastname@example.org. Michael J. Hernandez has been an independent relational database consultant specializing in relational database design. He has more than 20 years of experience in the technology industry, developing database applications for a wide variety of clients. He’s been a contributing author to a wide variety of magazine columns, white papers, books, and periodicals, and is coauthor of the best-selling SQL Queries for Mere Mortals. Mike has been a top-rated and noted technical trainer for the government,the military, the private sector, and companies throughout the United States. He has spoken at numerous national and international conferences, and has consistently been a top-rated speaker and presenter. Aside from his technical background,Mike has a diverse set of skills and interests that he also pursues, ranging from the artistic to the metaphysical. His greatest interest is still the guitar, as he’s been a practicing guitarist for more than 40 years and played professionally for 15 years. He’s also a working actor, a great cook, loves to teach (writing,public speaking,music), has a gift for bad puns, and even reads Tarot cards. He says he’s never going to retire, per se, but rather just change whatever it is he’s doing whenever he finally gets tired of it and move on to something else that interests him.
Translates case management from a business problem perspective into appropriate Oracle product usage
Explains how to conceptualize and implement quality case management solutions with these products
Details a solution architecture and a roadmap for case management implementation and adoption
Covers the key Oracle technologies that support case management solution components
Includes tutorials with step-by-step instructions on building case management solutions using Oracle Siebel and Oracle BPM suites
Organizations increasingly need to deal with unstructured processes that traditional business process management (BPM) suites are not designed to deal with. High-risk, yet high-value, loan origination or credit approvals, police investigations, and healthcare patient treatment are just a few examples of areas where a level of uncertainty makes outcome and execution of work flow non-deterministic.
Case management is a way to govern and control these unstructured processes and non-deterministic outcomes. Oracle recently completed its BPM technology stack with broad case management functionality and is now able to deliver case management capabilities in a variety of flavors that combine packaged applications and middleware technology.
Oracle Case Management Solutions is the first book to translate case management from a business problem perspective into appropriate Oracle product usage. Covering the key Oracle technologies that support case management solution components, it explains how to conceptualize and implement quality case management solutions with these products.
The team of authors consists of leading industry consultants engaged in providing case management solutions as well as veteran software product management professionals dealing with tools for building case management applications. The authors share insights gained through their extensive case management experience in terms of its use in solving real-world business problems and in applying technologies to create efficient fit-for-purpose computer applications that embody modern computing trends.
Detailing a proven solution architecture and reliable roadmap for case management implementation and adoption, the book includes tutorials with step-by-step instructions on building case management solutions using Oracle Siebel and Oracle BPM suites.
About the Author
Leon Smiers works as a Solution Architect for Capgemini, The Netherlands in the area of Oracle Technology and Architecture, where he is one of the leading Oracle specialists. He has done a lot of work and research in the field of integration and new technologies, like RFID, SOA, EDA, BPM, and case management, on which he wrote articles and presented at international conferences. Currently Leon is setting up Solution Architectures for large Oracle based projects and is the Oracle BPM Thought leader for Capgemini. Based on his close cooperation with Oracle development and product management, Leon was awarded the Oracle ACE title in 2010. Leon is co-inventor of the Common Reference Architecture mode or CORA model, which helps in getting control over the IT landscape in a Hybrid environment and delivers a predictable, repeatable, and risk-aware solution design (http://www.coramodel.com). Manas Deb is a senior director in the Fusion Middleware/SOA and BPM Suite product group at Oracle HQ. He he has been leading outbound product management globally and his current focus is on strategic customer engagements. Manas has worked in the software industry for over 20 years, most of which was spent in product development and management, and on architecting and leading many enterprise-level application development and business integration projects in a variety of industries. Manas attended post-graduate studies at the University of Texas at Austin. He has a PhD in Computer Science and Applied Mathematics, as well as an MBA. Prasen Palvankar is a director of Product Management at Oracle and currently leads product management of Case Management, Business Activity Monitoring, and Oracle Business Rules products in the Oracle BPM Suite product family. Prasen has more than 20 years of work experience in all aspects of software application development, including consulting, solution and enterprise architecture, business integration, process management, and advanced training development and delivery. Joop Koster is an experienced Oracle Solution Architect, CRM, and Front-Office Consultant. He has 15 years of IT Consulting experience and more than 10 years of management experience in the Printing Industry. He is familiar with Front-Office, Contact Center, Multi-Channel customer interaction, and CRM technologies. He has broad experience in marketing, sales, and services processes and technologies and has worked in both B2B and B2C environments.
Provide a balanced approach to databases as the market-leading DATABASE SYSTEMS: DESIGN, IMPLEMENTATION, and MANAGEMENT, 13E emphasizes the knowledge and skills necessary for success and makes databases accessible without overwhelming students. Readers gain a solid foundation in database design and implementation as diagrams, illustrations, and tables clarify in-depth coverage of database design. Students learn how successful database implementation involves designing databases to fit within a larger strategic data environment. Revised coverage of SQL introduces more examples and simpler explanations that focus on areas most important for a database career — making supplementary SQL materials unnecessary. Additional coverage of Big Data Analytics and NoSQL, including related Hadoop technologies, offers a strong hands-on approach. MindTap now include a digital auto-graded MySQL environment.