|
Samay Live | |
|
EBooks » Database
* Taking readers through the basics of the language, right up to some more advanced topics, this book is a practical, hands-on resource and aims to keep the reader involved at all times * Focuses on the SQL standard and is loaded with detailed examples and code; each chapter includes practice exercises that readers can challenge themselves with before looking at the sample solutions in the appendix * Paul Wilton is a successful Wrox "Beginning" book author and is an ideal author to write for those who want a firm grasp of standard SQL before learning the details specific to a particular database product * SQL is an international standard for manipulating data in databases and is used by database programmers in all major database systems: Microsoft, IBM, Oracle, MySQL, and many others
When using software products with graphical interfaces, we
frequently focus so much on the details of how to use the interface
that we forget about the more general concepts that allow us to
understand and put the software to effective use. This is particularly
true of a powerful database product like Microsoft Access. Novice, and
sometimes even experienced, programmers are so concerned with how
something is done in Access that they often lose sight of the general
principles that underlie their database applications.
Access Database Design & Programming, 2nd Edition, an update to the bestselling first edition, features:
- A discussion of Access' new VBA Integrated
Development Environment, which, for the first time, is the one used by
Word, Excel, and PowerPoint
- An expansion of the discussion of the VBA language itself, in response to reader requests
- A discussion of Microsoft's latest data access
technology, called Active Data Objects (or ADO), along with a
discussion of Open Database Connectivity(ODBC), which is intimately
connected with ADO
 Learn how to build databases on personal digital devices to be used with PDA
applicationsSeveral years ago, the business community accepted the Internet as a viable
solution to extending the corporate environment. Today, there is another movement
towards enhancing this methodology–– empowering mobile wireless business
users with increasingly powerful PDAs. Robert Laberge and Srdjan Vujosevic have written the first book ever to cover
mobile database development. They discuss the many methods of connecting to
the Internet, Intranet, or a specific computer and how they are all viable business
solutions for today’s large, medium, and small corporations.
 This study guide provides instructions for installing, configuring, and troubleshooting the SQL Server 2000, and it offers assistance preparing for the Microsoft Certified Professional examination. The last fourth of the book consists of topic-speci fic question-and- answer reviews. A companion CD contains supplemental materials, files related to the exercises in the book, and a trial version of SQL Server 2000. Book Description Learn how to install, configure, and administer SQL Server 2000--as you prepare for MCP Exam 70-228, a core requirement for MCDBA certification and an elective for the MCSE and MCSA tracks.  World-renowned expert Rebecca M. Riordan has written the definitive
database design book for working developers who aren’t database
experts. No matter how messy or complex your data challenge, Designing Effective Database Systems shows you how to design an effective, high-performance database to solve it. Riordan
begins by thoroughly demystifying the principles of relational design,
making them accessible to every professional developer. Next, she
offers the field’s clearest introduction to dimensional database
modeling—practical insight for designing today’s increasingly important
analytical applications. One task at a time, the author
illuminates every facet of database analysis and design for both
traditional databases and the dimensional databases used for data
warehousing, showing how to avoid common architectural pitfalls that
complicate development and reduce extensibility. The book concludes
with comprehensive, expert guidance on designing databases for maximum
usability.
|
| |
|