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 email@example.com. 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.
Database Principles: Fundamentals of Design, Implementations and Management with CourseMate and eBook Access Card 2nd Edition
The second edition of Database Principles maintains its engaging writing style and brevity; its unique balance between theory and practice and its wealth of examples throughout the text; inspiring student-friendly learning at its best. The international edition provides a solid and practical foundation for the design, implementation and management of database systems. This foundation is built on the notion that, while databases are very practical things, their successful creation depends on understanding the important concepts that define them. The new edition has been updated with all the latest developments and technologies and incorporates a generous number of localised and motivating business vignettes that tie the concepts to real-life situations. This edition is suitable for a first course in databases at undergraduate level and will also provide essential material for conversion postgraduate courses. Providing comprehensive and practical coverage of core database concepts, it is an ideal text not only for those studying database management systems in the context of computer science, but also those on courses in the areas of information systems and business information technology. This textbook also comes packaged with a fully tailored CourseMate and an Instructor’s website will also be available to adopters.
Please note that the digital access code that comes with the print book is valid for use in a specific Asia territory only.
CB CourseSmart eBook – The ultimate eBook experience has arrived! Easily access our eBooks with features that will improve your reading experience, and tools to help you take notes and organize your studies.
Practical and easy to understand, DATABASE SYSTEMS: DESIGN, IMPLEMENTATION, AND MANAGEMENT, Eleventh Edition, gives students a solid foundation in database design and implementation. Filled with visual aids such as diagrams, illustrations, and tables, this market-leading text provides in-depth coverage of database design, demonstrating that the key to successful database implementation is in proper design of databases to fit within a larger strategic view of the data environment. Renowned for its clear, straightforward writing style, this text provides students with an outstanding balance of theory and practice. The eleventh edition has been updated to include expanded relational algebra coverage, updated business vignettes showing the impact of database tech in the real world, updated coverage of cloud data services, expanded coverage of Big Data and related Hadoop technologies, SQL coverage expanded to include MySQL databases, and many other improvements! In addition, new review questions, problem sets, and cases have been added throughout the book so that students have multiple opportunities to test their understanding and develop real and useful design skills.
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.