SØG - mellem flere end 8 millioner bøger:
Viser: Introductory Relational Database Design for Business, with Microsoft Access
Introductory Relational Database Design for Business, with Microsoft Access Vital Source e-bog
Jonathan Eckstein og Bonnie R. Schultz
(2017)
Introductory Relational Database Design for Business, with Microsoft Access
Jonathan Eckstein og Bonnie R. Schultz
(2018)
Sprog: Engelsk
om ca. 10 hverdage
Detaljer om varen
- 1. Udgave
- Vital Source searchable e-book (Reflowable pages)
- Udgiver: John Wiley & Sons (November 2017)
- Forfattere: Jonathan Eckstein og Bonnie R. Schultz
- ISBN: 9781119329442
A hands-on beginner’s guide to designing relational databases and managing data using Microsoft Access
Relational databases represent one of the most enduring and pervasive forms of information technology. Yet most texts covering relational database design assume an extensive, sophisticated computer science background. There are texts on relational database software tools like Microsoft Access that assume less background, but they focus primarily on details of the user interface, with inadequate coverage of the underlying design issues of how to structure databases. Growing out of Professor Jonathan Eckstein’s twenty years’ experience teaching courses on management information systems (MIS) at Rutgers Business School, this book fills this gap in the literature by providing a rigorous introduction to relational databases for readers without prior computer science or programming experience.
Relational Database Design for Business, with Microsoft Access helps readers to quickly develop a thorough, practical understanding of relational database design. It takes a step-by-step, real-world approach, using application examples from business and finance every step the way. As a result, readers learn to think concretely about database design and how to address issues that commonly arise when developing and manipulating relational databases. By the time they finish the final chapter, students will have the knowledge and skills needed to build relational databases with dozens of tables. They will also be able to build complete Microsoft Access applications around such databases. This text:
- Takes a hands-on approach using numerous real-world examples drawn from the worlds of business, finance, and more
- Gets readers up and running, fast, with the skills they need to use and develop relational databases with Microsoft Access
- Moves swiftly from conceptual fundamentals to advanced design techniques
- Leads readers step-by-step through data management and design, relational database theory, multiple tables and the possible relationships between them, Microsoft Access features such as forms and navigation, formulating queries in SQL, and normalization
Introductory Relational Database Design for Business, with Microsoft Access is the definitive guide for undergraduate and graduate students in business, finance, and data analysis without prior experience in database design. While Microsoft Access is its primary “hands-on” learning vehicle, most of the skills in this text are transferrable to other relational database software such as MySQL.
Bookshelf online: 5 år fra købsdato.
Bookshelf appen: ubegrænset dage fra købsdato.
Udgiveren oplyser at følgende begrænsninger er gældende for dette produkt:
Print: 10 sider kan printes ad gangen
Copy: højest 2 sider i alt kan kopieres (copy/paste)
Detaljer om varen
- Hardback: 328 sider
- Udgiver: John Wiley & Sons, Limited (Januar 2018)
- Forfattere: Jonathan Eckstein og Bonnie R. Schultz
- ISBN: 9781119329411
A hands-on beginner's guide to designing relational databases and managing data using Microsoft Access
Relational databases represent one of the most enduring and pervasive forms of information technology. Yet most texts covering relational database design assume an extensive, sophisticated computer science background. There are texts on relational database software tools like Microsoft Access that assume less background, but they focus primarily on details of the user interface, with inadequate coverage of the underlying design issues of how to structure databases. Growing out of Professor Jonathan Eckstein's twenty years' experience teaching courses on management information systems (MIS) at Rutgers Business School, this book fills this gap in the literature by providing a rigorous introduction to relational databases for readers without prior computer science or programming experience.
Relational Database Design for Business, with Microsoft Access helps readers to quickly develop a thorough, practical understanding of relational database design. It takes a step-by-step, real-world approach, using application examples from business and finance every step the way. As a result, readers learn to think concretely about database design and how to address issues that commonly arise when developing and manipulating relational databases. By the time they finish the final chapter, students will have the knowledge and skills needed to build relational databases with dozens of tables. They will also be able to build complete Microsoft Access applications around such databases. This text:
- Takes a hands-on approach using numerous real-world examples drawn from the worlds of business, finance, and more
- Gets readers up and running, fast, with the skills they need to use and develop relational databases with Microsoft Access
- Moves swiftly from conceptual fundamentals to advanced design techniques
- Leads readers step-by-step through data management and design, relational database theory, multiple tables and the possible relationships between them, Microsoft Access features such as forms and navigation, formulating queries in SQL, and normalization
Introductory Relational Database Design for Business, with MicrosoftAccess is the definitive guide for undergraduate and graduate students in business, finance, and data analysis without prior experience in database design. While Microsoft Access is its primary "hands-on" learning vehicle, most of the skills in this text are transferrable to other relational database software such as MySQL.
... FROM Statement 215 WHERE Conditions 217 Inner Joins 218 Cartesian Joins and a Different Way to Express Inner Joins 221 Aggregation 228 GROUP BY 231 HAVING 237 ORDER BY 238 The Overall Conceptual Structure of Queries 240 Exercises 243 11 Advanced Query Techniques 253 Outer Joins 253 Outer Joins and Aggregation 256 Joining Multiple Records from the Same Table: AS in the FROM Clause 260 Another Use for AS in the FROM Clause 262 An Introduction to Query Chaining and Nesting 262 A More Complicated Example of Query Chaining: The League Standings 265 Subqueries and Back to the Plumbing Store Database 270 Practical Considerations and "Bending the Rules" Against Redundancy 274 Exercises 275 12 Unary Relationships 279 Employee Database 279 Setting Up and Querying a Unary Relationship in Access 283 The Course Catalog Database 291 Exercises 294 Further Reading 301 Index 303