Author: Jay Arthur
Publisher: McGraw Hill Professional
ISBN: 0071759492
Category : Business & Economics
Languages : en
Pages : 498
Book Description
Your LEAN and mean guide to Lean Six Sigma Ready to implement better, faster, cheaper, more-profitable processes in your organization? Lean Six Sigma Demystified, Second Edition, shows you how to use proven techniques for simplifying, streamlining, and optimizing business practices for maximum productivity and profitability. Written in a step-by-step format, this practical guide covers the fundamental methods and tools of Lean Six Sigma. You'll get details on reducing defects and deviation, sustaining improvements, and achieving laser-focused process innovations. Measurement systems analysis (MSA), Design for Lean Six Sigma, and statistical tools such as analysis of variance (ANOVA) are also discussed. Clear examples, helpful diagrams, and concise explanations make it easy to understand the material, and end-of-chapter quizzes and a final exam reinforce key concepts. It's a no-brainer! You'll learn about: The seven speed bumps of Lean Value stream mapping and spaghetti diagramming Control charts, Pareto charts, and Ishikawa diagrams to laser-focus improvements Excel power tools for Lean Six Sigma Lean Six Sigma tar pits Ways to implement Lean Six Sigma to maximize results and minimize costs Simple enough for a beginner, but challenging enough for an advanced student, Lean Six Sigma Demystified, Second Edition, is your shortcut to this powerful improvement methodology. You'll also get a 90-day free trial of Q1 Macros software for Lean Six Sigma.
Six Sigma Demystified: A Self-Teaching Guide
Author: Paul A. Keller
Publisher: McGraw Hill Professional
ISBN: 0071469540
Category : Business & Economics
Languages : en
Pages : 498
Book Description
Taking the mystery out of Six Sigma implementation This easy-to-understand reference in the popular Demystified series teaches the methods of Six Sigma, explains their applications, and tests expertise without confusing statistics and formulas. Expert Paul Keller and Six Sigma guru Tom Pyzdek describe helpful tools for Six Sigma teams, identifying their uses, limitations, and application during multiple stages of DMAIC. They also outline additional tools for full effectiveness and provide necessary calculations and assumptions. In addition, they provide: Detailed examples and diagrams Practical exercises and complete solutions A final exam to test overall knowledge Materials ideal for self-study or for training groups of Black Belts and Green Belts
Publisher: McGraw Hill Professional
ISBN: 0071469540
Category : Business & Economics
Languages : en
Pages : 498
Book Description
Taking the mystery out of Six Sigma implementation This easy-to-understand reference in the popular Demystified series teaches the methods of Six Sigma, explains their applications, and tests expertise without confusing statistics and formulas. Expert Paul Keller and Six Sigma guru Tom Pyzdek describe helpful tools for Six Sigma teams, identifying their uses, limitations, and application during multiple stages of DMAIC. They also outline additional tools for full effectiveness and provide necessary calculations and assumptions. In addition, they provide: Detailed examples and diagrams Practical exercises and complete solutions A final exam to test overall knowledge Materials ideal for self-study or for training groups of Black Belts and Green Belts
Lean Six Sigma for Hospitals: Improving Patient Safety, Patient Flow and the Bottom Line, Second Edition
Author: Jay Arthur
Publisher: McGraw Hill Professional
ISBN: 1259641090
Category : Technology & Engineering
Languages : en
Pages : 400
Book Description
Simple Steps to Improve Patient Safety, Patient Flow and the Bottom Line A Doody's Core Title for 2021! This thoroughly revised resource shows, step-by-step, how to simplify, streamline, analyze, and optimize healthcare performance using tested Lean Six Sigma and change management techniques. Lean Six Sigma for Hospitals, Second Edition, follows the patient from the front door of the hospital or emergency room all the way through discharge. The book fully explains how to improve operations and quality of care while dramatically reducing costs—often in just five days. Real-world case studies from major healthcare institutions illustrate successful implementations of Lean Six Sigma. Coverage includes: • Lean Six Sigma for hospitals, emergency departments, operating rooms, medical imaging facilities, nursing units, pharmacies, and ICUs • Patient flow and quality • Clinical staff • Order and claims accuracy • Billing and collection • Defect and medical error reduction • Excel power tools for Lean Six Sigma • Data mining and analysis • Process flow charts and control charts • Laser-focused process innovation • Statistical tools for Lean Six Sigma • Planning and implementation
Publisher: McGraw Hill Professional
ISBN: 1259641090
Category : Technology & Engineering
Languages : en
Pages : 400
Book Description
Simple Steps to Improve Patient Safety, Patient Flow and the Bottom Line A Doody's Core Title for 2021! This thoroughly revised resource shows, step-by-step, how to simplify, streamline, analyze, and optimize healthcare performance using tested Lean Six Sigma and change management techniques. Lean Six Sigma for Hospitals, Second Edition, follows the patient from the front door of the hospital or emergency room all the way through discharge. The book fully explains how to improve operations and quality of care while dramatically reducing costs—often in just five days. Real-world case studies from major healthcare institutions illustrate successful implementations of Lean Six Sigma. Coverage includes: • Lean Six Sigma for hospitals, emergency departments, operating rooms, medical imaging facilities, nursing units, pharmacies, and ICUs • Patient flow and quality • Clinical staff • Order and claims accuracy • Billing and collection • Defect and medical error reduction • Excel power tools for Lean Six Sigma • Data mining and analysis • Process flow charts and control charts • Laser-focused process innovation • Statistical tools for Lean Six Sigma • Planning and implementation
Lean Six Sigma for Hospitals: Simple Steps to Fast, Affordable, and Flawless Healthcare
Author: Jay Arthur
Publisher: McGraw Hill Professional
ISBN: 0071753265
Category : Medical
Languages : en
Pages : 370
Book Description
DELIVER FASTER, BETTER, AND CHEAPER HEALTHCARE IN AS FEW AS FIVE DAYS 4 STAR DOODY'S REVIEW! "The main purpose is to present simple steps to help hospitals start getting faster, better, and cheaper in five days or less while achieving the goal of fast, affordable, and flawless healthcare. Healthcare has many opportunities for improvement and the use of Lean Six Sigma concepts can make a dramatic impact. This book provides the basic information to do that."--Doody's Review Service Lean Six Sigma for Hospitals: Simple Steps to Fast, Affordable, Flawless Healthcare explains how to use tested Lean Six Sigma methods and tools to rapidly improve hospital operations and quality of care and reduce costs. These proven strategies follow the patient from the front door of the hospital or emergency room all the way through discharge, examining key aspects of patient flow and quality. The trail of billing and collections is also followed to discover and eliminate cash flow leaks. This practical guide emphasizes both the clinical and operational sides to reduce the "three demons of quality"--delay, defects, and deviation. Real-world case studies from major hospitals illustrate successful implementations of Lean Six Sigma. Coverage Includes: Achieving a faster, better hospital in five days--emergency department, door-to-balloon time, operating room, medical imaging, lab, nursing unit, clinical staff, pharmacy, order accuracy, diagnosis, ICU Lean for accelerated patient flow Reducing medical errors with Six Sigma Creating a more profitable hospital in five days by reducing denied, rejected, and appealed claims Six Sigma for hospitals Excel power tools for Lean Six Sigma Identifying improvement projects through data mining and analysis Sustaining improvement using control charts Laser-focused process innovation Statistical tools for Lean Six Sigma Implementing Lean Six Sigma
Publisher: McGraw Hill Professional
ISBN: 0071753265
Category : Medical
Languages : en
Pages : 370
Book Description
DELIVER FASTER, BETTER, AND CHEAPER HEALTHCARE IN AS FEW AS FIVE DAYS 4 STAR DOODY'S REVIEW! "The main purpose is to present simple steps to help hospitals start getting faster, better, and cheaper in five days or less while achieving the goal of fast, affordable, and flawless healthcare. Healthcare has many opportunities for improvement and the use of Lean Six Sigma concepts can make a dramatic impact. This book provides the basic information to do that."--Doody's Review Service Lean Six Sigma for Hospitals: Simple Steps to Fast, Affordable, Flawless Healthcare explains how to use tested Lean Six Sigma methods and tools to rapidly improve hospital operations and quality of care and reduce costs. These proven strategies follow the patient from the front door of the hospital or emergency room all the way through discharge, examining key aspects of patient flow and quality. The trail of billing and collections is also followed to discover and eliminate cash flow leaks. This practical guide emphasizes both the clinical and operational sides to reduce the "three demons of quality"--delay, defects, and deviation. Real-world case studies from major hospitals illustrate successful implementations of Lean Six Sigma. Coverage Includes: Achieving a faster, better hospital in five days--emergency department, door-to-balloon time, operating room, medical imaging, lab, nursing unit, clinical staff, pharmacy, order accuracy, diagnosis, ICU Lean for accelerated patient flow Reducing medical errors with Six Sigma Creating a more profitable hospital in five days by reducing denied, rejected, and appealed claims Six Sigma for hospitals Excel power tools for Lean Six Sigma Identifying improvement projects through data mining and analysis Sustaining improvement using control charts Laser-focused process innovation Statistical tools for Lean Six Sigma Implementing Lean Six Sigma
The Handbook for Quality Management, Second Edition
Author: Thomas Pyzdek
Publisher: McGraw Hill Professional
ISBN: 0071799257
Category : Technology & Engineering
Languages : en
Pages : 512
Book Description
The definitive guide to organizational excellence--completely updated Fully revised for the latest American Society for Quality (ASQ) Certified Manager of Quality/Organizational Excellence (CMQ/QE) Body of Knowledge, The Handbook for Quality Management: A Complete Guide to Operational Excellence, Second Edition offers in-depth guidance on effectively applying the principles of quality management in today's business environment and delivering superior results. Designed to help you prepare for and pass the ASQ CMQ/QE exam, this authoritative volume also serves as an essential on-the-job reference. Coverage includes: Business-integrated quality systems Organizational structures The quality function Approaches to quality Customer-focused organizations Integrated planning Strategic planning Understanding customer expectations and needs Benchmarking Organizational assessment Process control Quantifying process variation Quality audits Supply chain management Continuous improvement Effective change management Six Sigma methodology, including detailed descriptions of the DMAIC and DMADV approaches Management of human resources Motivation theories and principles Management styles Resource requirements to manage the quality function Over the past 40 years, the quality management discipline has undergone steady evolution from disparate quality assurance efforts to strategic, business-integrated functions. Today's quality manager must be able to plan and implement measurable, cost-effective process-improvement initiatives across the organization. Written by two of the foremost authorities on the subject and fully updated for the latest American Society for Quality (ASQ) Certified Manager of Quality/Organizational Excellence (CMQ/OE) Body of Knowledge, The Handbook for Quality Management, Second Edition provides an operational guide to the proper understanding and application of quality management in the current business environment. It serves as a primary reference source for an organization's quality program and for anyone seeking to pass the CMQ/OE exam, given by the ASQ. The Handbook for Quality Management: A Complete Guide to Operational Excellence, Second Edition: Clearly defines quality management principles and their application within a cross section of industries Integrates the application of Theory of Constraints, Six Sigma, and Lean thinking into the Quality Management discipline Contains detailed methods for planning, including customer needs recognition, benchmarking, and organizational assessments Discusses controls such as statistical process control, audits, and supply chain management Explains the stages of continuous improvement Incorporates classic motivation theory with more current management practices advocated by Joiner, Senge, and Deming, among others Features simulated and past exam questions to help you study for the ASQ CMQ/OE exam with answers that can be found at www.mhprofessional.com/HQM2
Publisher: McGraw Hill Professional
ISBN: 0071799257
Category : Technology & Engineering
Languages : en
Pages : 512
Book Description
The definitive guide to organizational excellence--completely updated Fully revised for the latest American Society for Quality (ASQ) Certified Manager of Quality/Organizational Excellence (CMQ/QE) Body of Knowledge, The Handbook for Quality Management: A Complete Guide to Operational Excellence, Second Edition offers in-depth guidance on effectively applying the principles of quality management in today's business environment and delivering superior results. Designed to help you prepare for and pass the ASQ CMQ/QE exam, this authoritative volume also serves as an essential on-the-job reference. Coverage includes: Business-integrated quality systems Organizational structures The quality function Approaches to quality Customer-focused organizations Integrated planning Strategic planning Understanding customer expectations and needs Benchmarking Organizational assessment Process control Quantifying process variation Quality audits Supply chain management Continuous improvement Effective change management Six Sigma methodology, including detailed descriptions of the DMAIC and DMADV approaches Management of human resources Motivation theories and principles Management styles Resource requirements to manage the quality function Over the past 40 years, the quality management discipline has undergone steady evolution from disparate quality assurance efforts to strategic, business-integrated functions. Today's quality manager must be able to plan and implement measurable, cost-effective process-improvement initiatives across the organization. Written by two of the foremost authorities on the subject and fully updated for the latest American Society for Quality (ASQ) Certified Manager of Quality/Organizational Excellence (CMQ/OE) Body of Knowledge, The Handbook for Quality Management, Second Edition provides an operational guide to the proper understanding and application of quality management in the current business environment. It serves as a primary reference source for an organization's quality program and for anyone seeking to pass the CMQ/OE exam, given by the ASQ. The Handbook for Quality Management: A Complete Guide to Operational Excellence, Second Edition: Clearly defines quality management principles and their application within a cross section of industries Integrates the application of Theory of Constraints, Six Sigma, and Lean thinking into the Quality Management discipline Contains detailed methods for planning, including customer needs recognition, benchmarking, and organizational assessments Discusses controls such as statistical process control, audits, and supply chain management Explains the stages of continuous improvement Incorporates classic motivation theory with more current management practices advocated by Joiner, Senge, and Deming, among others Features simulated and past exam questions to help you study for the ASQ CMQ/OE exam with answers that can be found at www.mhprofessional.com/HQM2
Lean Six Sigma Demystified, Second Edition
Author: Jay Arthur
Publisher: Mcgraw-hill
ISBN: 9780071749091
Category : Business & Economics
Languages : en
Pages : 496
Book Description
Your LEAN and mean guide to Lean Six Sigma Ready to implement better, faster, cheaper, more-profitable processes in your organization? Lean Six Sigma Demystified, Second Edition, shows you how to use proven techniques for simplifying, streamlining, and optimizing business practices for maximum productivity and profitability. Written in a step-by-step format, this practical guide covers the fundamental methods and tools of Lean Six Sigma. You'll get details on reducing defects and deviation, sustaining improvements, and achieving laser-focused process innovations. Measurement systems analysis (MSA), Design for Lean Six Sigma, and statistical tools such as analysis of variance (ANOVA) are also discussed. Clear examples, helpful diagrams, and concise explanations make it easy to understand the material, and end-of-chapter quizzes and a final exam reinforce key concepts. It's a no-brainer! You'll learn about: The seven speed bumps of Lean Value stream mapping and spaghetti diagramming Control charts, Pareto charts, and Ishikawa diagrams to laser-focus improvements Excel power tools for Lean Six Sigma Lean Six Sigma tar pits Ways to implement Lean Six Sigma to maximize results and minimize costs Simple enough for a beginner, but challenging enough for an advanced student, Lean Six Sigma Demystified, Second Edition, is your shortcut to this powerful improvement methodology. You'll also get a 90-day free trial of Q1 Macros software for Lean Six Sigma.
Publisher: Mcgraw-hill
ISBN: 9780071749091
Category : Business & Economics
Languages : en
Pages : 496
Book Description
Your LEAN and mean guide to Lean Six Sigma Ready to implement better, faster, cheaper, more-profitable processes in your organization? Lean Six Sigma Demystified, Second Edition, shows you how to use proven techniques for simplifying, streamlining, and optimizing business practices for maximum productivity and profitability. Written in a step-by-step format, this practical guide covers the fundamental methods and tools of Lean Six Sigma. You'll get details on reducing defects and deviation, sustaining improvements, and achieving laser-focused process innovations. Measurement systems analysis (MSA), Design for Lean Six Sigma, and statistical tools such as analysis of variance (ANOVA) are also discussed. Clear examples, helpful diagrams, and concise explanations make it easy to understand the material, and end-of-chapter quizzes and a final exam reinforce key concepts. It's a no-brainer! You'll learn about: The seven speed bumps of Lean Value stream mapping and spaghetti diagramming Control charts, Pareto charts, and Ishikawa diagrams to laser-focus improvements Excel power tools for Lean Six Sigma Lean Six Sigma tar pits Ways to implement Lean Six Sigma to maximize results and minimize costs Simple enough for a beginner, but challenging enough for an advanced student, Lean Six Sigma Demystified, Second Edition, is your shortcut to this powerful improvement methodology. You'll also get a 90-day free trial of Q1 Macros software for Lean Six Sigma.
Minitab Demystified
Author: Andrew Sleeper
Publisher: McGraw Hill Professional
ISBN: 0071762302
Category : Business & Economics
Languages : en
Pages : 576
Book Description
Need to learn Minitab? Problem Solved! Get started using Minitab right way with help from this hands-on guide. Minitab Demystified walks you through essential Minitab features and shows you how to apply them to solve statistical analysis problems. Featuring coverage of Minitab 16, this practical guide explores the Minitab interface and the full range of Minitab graphics, Distribution models, statistical intervals, hypothesis testing, and sample size calculations are clearly explained. The book covers modeling tools of regression and the design of experiments (DOE) as well as the industrial quality tools of measurement systems analysis, control charts, capability analysis, acceptance sampling, and reliability analysis. Detailed examples and concise explanations make it easy to understand the material, and end-of-chapter quizzes and a final exam help reinforce key concepts. It's a no-brainer! You'll learn about: Accessing powerful Minitab functions with the Minitab assistant Confidence, prediction, and tolerance intervals Designing and analyzing experiments with hard-to-change variables Statistical process control (SPC), Six Sigma applications, and quality control Predicting the economic impact of sampling Analyzing life data with additional variables Simple enough for a beginner, challenging enough for an advanced student, and thorough enough for a Six Sigma professional, Minitab Demystified is your shortcut to statistical analysis success!
Publisher: McGraw Hill Professional
ISBN: 0071762302
Category : Business & Economics
Languages : en
Pages : 576
Book Description
Need to learn Minitab? Problem Solved! Get started using Minitab right way with help from this hands-on guide. Minitab Demystified walks you through essential Minitab features and shows you how to apply them to solve statistical analysis problems. Featuring coverage of Minitab 16, this practical guide explores the Minitab interface and the full range of Minitab graphics, Distribution models, statistical intervals, hypothesis testing, and sample size calculations are clearly explained. The book covers modeling tools of regression and the design of experiments (DOE) as well as the industrial quality tools of measurement systems analysis, control charts, capability analysis, acceptance sampling, and reliability analysis. Detailed examples and concise explanations make it easy to understand the material, and end-of-chapter quizzes and a final exam help reinforce key concepts. It's a no-brainer! You'll learn about: Accessing powerful Minitab functions with the Minitab assistant Confidence, prediction, and tolerance intervals Designing and analyzing experiments with hard-to-change variables Statistical process control (SPC), Six Sigma applications, and quality control Predicting the economic impact of sampling Analyzing life data with additional variables Simple enough for a beginner, challenging enough for an advanced student, and thorough enough for a Six Sigma professional, Minitab Demystified is your shortcut to statistical analysis success!
Microbiology DeMYSTiFieD, 2nd Edition
Author: Tom Betsy
Publisher: McGraw Hill Professional
ISBN: 0071761101
Category : Science
Languages : en
Pages : 321
Book Description
Demystified is your vaccine for tricky subjects like microbiology If you don't know your prokaryotes from your protozoa, or learning about fungi puts you in a funk, look no further--Microbiology Demystified, Second Edition is your cure for learning this topic's fundamental concepts and theories at your own pace. This practical guide eases you into this field of science, starting at the cell level. As you progress, you will master microbiology essentials such as bacteria, algae, viruses, pasteurization, and more. You will understand the difference between friendly and unfriendly microorganisms as well as the microscope's role in shaping microbiology. Detailed examples make it easy to understand the material, and end-of-chapter quizzes and a final exam help reinforce key ideas. It's a no-brainer! You'll learn about: Classification of microorganisms Immunology Germ theory Recombinant DNA technology Pathogens E.coli Antiseptics Simple enough for a beginner, but challenging enough for an advanced student, Microbiology Demystified. Second Edition, helps you master this essential subject.
Publisher: McGraw Hill Professional
ISBN: 0071761101
Category : Science
Languages : en
Pages : 321
Book Description
Demystified is your vaccine for tricky subjects like microbiology If you don't know your prokaryotes from your protozoa, or learning about fungi puts you in a funk, look no further--Microbiology Demystified, Second Edition is your cure for learning this topic's fundamental concepts and theories at your own pace. This practical guide eases you into this field of science, starting at the cell level. As you progress, you will master microbiology essentials such as bacteria, algae, viruses, pasteurization, and more. You will understand the difference between friendly and unfriendly microorganisms as well as the microscope's role in shaping microbiology. Detailed examples make it easy to understand the material, and end-of-chapter quizzes and a final exam help reinforce key ideas. It's a no-brainer! You'll learn about: Classification of microorganisms Immunology Germ theory Recombinant DNA technology Pathogens E.coli Antiseptics Simple enough for a beginner, but challenging enough for an advanced student, Microbiology Demystified. Second Edition, helps you master this essential subject.
Options DeMYSTiFieD, Second Edition
Author: Thomas A. McCafferty
Publisher: McGraw Hill Professional
ISBN: 0071751017
Category : Business & Economics
Languages : en
Pages : 290
Book Description
In good times and bad, you need to know your OPTIONS Market volatility is at a record high, which has investors running scared. You don't have to be one of them. Whether your goal is to protect your money in a downturn or profit handsomely from an upturn, trading options is the answer. Options DeMYSTiFieD reveals why today’s smartest investors rely on the versatility of the options marketplace--and how you can, too! With its quick, snappy explanations and easy-to-understand examples, it provides the knowledge you need to start trading options like a pro in no time. Chapterending quizzes and a final exam round out Options DeMYSTiFieD into a comprehensive self-teaching guide that allows you to learn at your own pace. This fast and easy guide has everything you need to: Protect your investments from market downturns--even those in your IRA or 401(k) Increase income from stocks you already own Multiply the leverage you have in the market to max out your profits Manage the risk of investing without decreasing profit potential Engage in more complex trading, such as covered calls, spreads, straddles, and hedges Simple enough for a beginner but challenging enough for an advanced trader, Options DeMYSTiFieD has what you need to build a solid foundation in options trading.
Publisher: McGraw Hill Professional
ISBN: 0071751017
Category : Business & Economics
Languages : en
Pages : 290
Book Description
In good times and bad, you need to know your OPTIONS Market volatility is at a record high, which has investors running scared. You don't have to be one of them. Whether your goal is to protect your money in a downturn or profit handsomely from an upturn, trading options is the answer. Options DeMYSTiFieD reveals why today’s smartest investors rely on the versatility of the options marketplace--and how you can, too! With its quick, snappy explanations and easy-to-understand examples, it provides the knowledge you need to start trading options like a pro in no time. Chapterending quizzes and a final exam round out Options DeMYSTiFieD into a comprehensive self-teaching guide that allows you to learn at your own pace. This fast and easy guide has everything you need to: Protect your investments from market downturns--even those in your IRA or 401(k) Increase income from stocks you already own Multiply the leverage you have in the market to max out your profits Manage the risk of investing without decreasing profit potential Engage in more complex trading, such as covered calls, spreads, straddles, and hedges Simple enough for a beginner but challenging enough for an advanced trader, Options DeMYSTiFieD has what you need to build a solid foundation in options trading.
Databases DeMYSTiFieD, 2nd Edition
Author: Andy Oppel
Publisher: McGraw Hill Professional
ISBN: 0071748008
Category : Computers
Languages : en
Pages : 450
Book Description
Learning DATABASE fundamentals just got a whole lot EASIER! Now you can design, build, and manage a fully functional database with ease. Thoroughly updated to cover the latest technologies and techniques, Databases Demystified, Second Edition gives you the hands-on help you need to get started. Written in a step-by-step format, this practical guide covers methods that can be used with any database, including Microsoft Access, MySQL, Microsoft SQL Server, and Oracle. You'll learn about relational database components, database queries, SQL, the database life cycle, logical database design using normalization, and physical database design. Data and process modeling, database security, Online Analytical Processing (OLAP), and XML are also covered. Detailed examples and concise explanations make it easy to understand the material, and end-of-chapter quizzes and a final exam help reinforce learning. It's a no-brainer! You'll find out how to: Create and run database queries using the forms-based query tool in Microsoft Access Write SQL statements and queries Use entity relationship diagrams (ERDs) for data modeling Design physical tables Connect databases to users, computer systems, and applications Secure database data Handle cursor processing, transaction management, and performance tuning Integrate XML documents and objects into databases Simple enough for a beginner, but challenging enough for an advanced student, Databases Demystified, Second Edition is your self-paced guide to learning universal database concepts.
Publisher: McGraw Hill Professional
ISBN: 0071748008
Category : Computers
Languages : en
Pages : 450
Book Description
Learning DATABASE fundamentals just got a whole lot EASIER! Now you can design, build, and manage a fully functional database with ease. Thoroughly updated to cover the latest technologies and techniques, Databases Demystified, Second Edition gives you the hands-on help you need to get started. Written in a step-by-step format, this practical guide covers methods that can be used with any database, including Microsoft Access, MySQL, Microsoft SQL Server, and Oracle. You'll learn about relational database components, database queries, SQL, the database life cycle, logical database design using normalization, and physical database design. Data and process modeling, database security, Online Analytical Processing (OLAP), and XML are also covered. Detailed examples and concise explanations make it easy to understand the material, and end-of-chapter quizzes and a final exam help reinforce learning. It's a no-brainer! You'll find out how to: Create and run database queries using the forms-based query tool in Microsoft Access Write SQL statements and queries Use entity relationship diagrams (ERDs) for data modeling Design physical tables Connect databases to users, computer systems, and applications Secure database data Handle cursor processing, transaction management, and performance tuning Integrate XML documents and objects into databases Simple enough for a beginner, but challenging enough for an advanced student, Databases Demystified, Second Edition is your self-paced guide to learning universal database concepts.