Beginning Database Design

From Novice to Professional
Author: Clare Churcher
Publisher: Apress
ISBN: 1430242108
Category: Computers
Page: 252
View: 5881

Continue Reading →

Beginning Database Design, Second Edition provides short, easy-to-read explanations of how to get database design right the first time. This book offers numerous examples to help you avoid the many pitfalls that entrap new and not-so-new database designers. Through the help of use cases and class diagrams modeled in the UML, you’ll learn to discover and represent the details and scope of any design problem you choose to attack. Database design is not an exact science. Many are surprised to find that problems with their databases are caused by poor design rather than by difficulties in using the database management software. Beginning Database Design, Second Edition helps you ask and answer important questions about your data so you can understand the problem you are trying to solve and create a pragmatic design capturing the essentials while leaving the door open for refinements and extension at a later stage. Solid database design principles and examples help demonstrate the consequences of simplifications and pragmatic decisions. The rationale is to try to keep a design simple, but allow room for development as situations change or resources permit. Provides solid design principles by which to avoid pitfalls and support changing needs Includes numerous examples of good and bad design decisions and their consequences Shows a modern method for documenting design using the Unified Modeling Language

Beginning Databases with PostgreSQL

From Novice to Professional
Author: Richard Stones,Neil Matthew
Publisher: Apress
ISBN: 9781430200185
Category: Computers
Page: 664
View: 9266

Continue Reading →

*The most updated PostgreSQL book on the market, covering version 8.0 *Highlights the most popular PostgreSQL APIs, including C, Perl, PHP, and Java *This is two books in one; it simultaneously covers key relational database design principles, while teaching PostgreSQL

Beginning Database Design Solutions


Author: Rod Stephens
Publisher: John Wiley & Sons
ISBN: 9780470440520
Category: Computers
Page: 552
View: 2833

Continue Reading →

The vast majority of software applications use relational databases that virtually every application developer must work with. This book introduces you to database design, whether you're a DBA or database developer. You'll discover what databases are, their goals, and why proper design is necessary to achieve those goals. Additionally, you'll master how to structure the database so it gives good performance while minimizing the chance for error. You will learn how to decide what should be in a database to meet the application's requirements.

Beginning MySQL Database Design and Optimization

From Novice to Professional
Author: Chad Russell,Jon Stephens
Publisher: Apress
ISBN: 1590593324
Category: Computers
Page: 520
View: 1168

Continue Reading →

Nearly every non-trivial application requires data persistence, and for an application of any significant size and scope, persistence is typically achieved using a database. If you’re building or maintaining any significant application and are using MySQL, this book is for you. For open source and other types of projects, the MySQL database is a very popular choice: it’s free, fast, robust, and scalable, and it runs on all of the major platforms, allowing maximum use of available hardware resources. But it’s easy to disregard MySQL’s speed and other advantages if your database design is inefficient. Needlessly duplicating data, using improper types for columns, overloading a single table where multiple tables should be used, failing to leverage the calculation features of MySQL, and making multiple queries instead of an efficient single query are some of the common mistakes. Beginning MySQL Database Design and Optimization shows you how to identify, overcome, and avoid gross inefficiencies. It demonstrates how to maximize the many data manipulation features that MySQL includes. This book explains how to include tests and branches in your queries, how to normalize your database, and how to issue concurrent queries to boost performance, among many other design and optimization topics. You’ll also learn about some features new to MySQL 4.1 and 5.0 like subqueries, stored procedures, and views, all of which will help you build even more efficient applications.

Beginning SQL Queries

From Novice to Professional
Author: Clare Churcher
Publisher: Apress
ISBN: 1484219554
Category: Computers
Page: 234
View: 2879

Continue Reading →

Beginning Queries with SQL is a friendly and easily read guide to writing queries with the all-important — in the database world — SQL language. Anyone who does any work at all with databases needs to know something of SQL, and that is evidenced by the strong sales of such books as Learning SQL (O'Reilly) and SQL Queries for Mere Mortals (Pearson). Beginning Queries with SQL is written by the author of Beginning Database Design, an author who is garnering great reviews on Amazon due to the clarity and succinctness of her writing.

Beginning Oracle Database 11g Administration

From Novice to Professional
Author: Iggy Fernandez
Publisher: Apress
ISBN: 1590599683
Category: Computers
Page: 464
View: 6916

Continue Reading →

This book, written by veteran Oracle database administrator Iggy Fernandez, a regular on the Oracle conference circuit and the editor of NoCOUG Journal, is a manageable introduction to key Oracle database administration topics including planning, installation, monitoring, troubleshooting, maintenance, and backups, to name just a few. As is clear from the table of contents, this book is not simply a recitation of Oracle Database features such as what you find in the reference guides available for free download on the Oracle web site. For example, the chapter on database monitoring explains how to monitor database availability, database changes, database security, database backups, database growth, database workload, database performance, and database capacity. The chapters of this book are logically organized into four parts that closely track the way your database administration career will naturally evolve. Part 1 gives you necessary background in relational database theory and Oracle Database concepts, Part 2 teaches you how to implement an Oracle database correctly, Part 3 exposes you to the daily routine of a database administrator, and Part 4 introduces you to the fine art of performance tuning. Each chapter has exercises designed to help you apply the lessons of the chapter. Each chapter also includes a list of reference works that contain more information on the topic of the chapter. In this book, you'll find information that you won't find in other books on Oracle Database. Here you'll discover not only technical information, but also guidance on work practices that are as vital to your success as technical skills. The author's favorite chapter is "The Big Picture and the Ten Deliverables." If you take the lessons in that chapter to heart, you can quickly become a much better Oracle database administrator than you ever thought possible. What you’ll learn Theory of relational database management systems Oracle Database internals Licensing, architecture, and sizing Software installation and database creation Using indexes to improve performance User management and data loading How to monitor all aspects of your database How to solve and fix problems Database backups and database recovery Database maintenance Database tuning SQL tuning Who this book is for If you are an IT professional who has been thrust into an Oracle database administration role without the benefit of formal training, or you just want to understand how Oracle Database works, this book is for you. It's the book the author wishes he'd had when he first started using Oracle Database many years ago. It's the book that he would have liked to have given to the many IT colleagues and friends who, over the years, have asked him to teach them the basics of Oracle Database.

Beginning PHP and Oracle

From Novice to Professional
Author: W Jason Gilmore,Bob Bryla
Publisher: Apress
ISBN: 9781430203674
Category: Computers
Page: 763
View: 4329

Continue Reading →

This is an adaptation of Jason Gilmore’s best-selling book, Beginning PHP and MySQL. It’s a recognition of the growing use of PHP with commercial databases, Oracle in particular, enabling readers in Oracle-based shops to learn PHP on their chosen platform. Supplying the Oracle expertise is Bob Bryla, co-author of the Oracle Database 10g DBA Handbook and many other titles. His easy-going and straightforward style is an excellent match for Jason’s, making their book one of the best things going for those wanting to learn about using PHP with Oracle.

Beginning Database Design


Author: Gavin Powell
Publisher: John Wiley & Sons
ISBN: 0764574906
Category: Computers
Page: 467
View: 2670

Continue Reading →

From the #1 source for computing information, trusted by more than six million readers worldwide.

Beginning PL/SQL

From Novice to Professional
Author: Donald Bales
Publisher: Apress
ISBN: 9781430204206
Category: Computers
Page: 476
View: 3452

Continue Reading →

Beginning PL/SQL is a fast-paced and blissfully short introduction to Oracle's PL/SQL language. PL/SQL is the built-in language that every Oracle developer and database administrator simply must know. The book shows readers how to apply object-oriented PL/SQL to production applications. No other book on PL/SQL does this. It gives the reader practical advice on what works and what doesn’t, and advises on the performance tradeoffs between doing work in SQL versus in PL/SQL. This book gets readers up-to-speed on the core of the language without wasting time on esoteric and seldom used syntax.

Beginning DB2

From Novice to Professional
Author: Grant Allen
Publisher: Apress
ISBN: 1430205482
Category: Computers
Page: 515
View: 2115

Continue Reading →

IBM’s DB2 Express Edition is one of the most capable of the free database platforms available in today’s marketplace. In Beginning DB2, author Grant Allen gets you started using DB2 Express Edition for web sites, desktop applications, and more. The author covers the basics of DB2 for developers and database administrators, shows you how to manage data in both XML and relational form, and includes numerous code examples so that you are never in doubt as to how things work. In this book, you’ll find: A friendly introduction to DB2 Express Edition, an industrial–strength, relational database from IBM Dozens of examples so that you are never in doubt as to how things work Coverage of important language interfaces, such as from PHP, Ruby, C#, Python, and more The book is aimed at developers who want a robust database to back their applications.

Beginning Ruby

From Novice to Professional
Author: Peter Cooper
Publisher: Apress
ISBN: 1430223642
Category: Computers
Page: 620
View: 7467

Continue Reading →

Based on the bestselling first edition, Beginning Ruby: From Novice to Professional, Second Edition is the leading guide for every type of reader who wants to learn Ruby from the ground up. The new edition of this book provides the same excellent introduction to Ruby as the first edition plus updates for the newest version of Ruby, including the addition of the Sinatra and Ramaze web application frameworks and a chapter on GUI development so developers can take advantage of these new trends. Beginning Ruby starts by explaining the principles behind object-oriented programming and within a few chapters builds toward creating a full Ruby application. By the end of the book, in addition to in-depth knowledge of Ruby, you'll also have basic understanding of many ancillary technologies such as SQL, XML, web frameworks, and networking. Introduces readers to the Ruby programming language Takes readers from basic programming skills to web development with topics like Ruby-based frameworks and GUI programming Covers many ancillary technologies in order to provide a broader picture (e.g., databases, XML, network daemons)

Beginning Python

From Novice to Professional
Author: Magnus Lie Hetland
Publisher: Apress
ISBN: 1430206349
Category: Computers
Page: 688
View: 7265

Continue Reading →

Gain a fundamental understanding of Python's syntax and features with the second edition of Beginning Python, an up–to–date introduction and practical reference. Covering a wide array of Python–related programming topics, including addressing language internals, database integration, network programming, and web services, you'll be guided by sound development principles. Ten accompanying projects will ensure you can get your hands dirty in no time. Updated to reflect the latest in Python programming paradigms and several of the most crucial features found in Python 3.0 (otherwise known as Python 3000), advanced topics, such as extending Python and packaging/distributing Python applications, are also covered.

Beginning Database-Driven Application Development in Java EE

Using GlassFish
Author: Yuli Vasiliev
Publisher: Apress
ISBN: 143020964X
Category: Computers
Page: 400
View: 3937

Continue Reading →

Beginning Database-Driven Application Development in JavaTM EE: Using GlassFishTM focuses on the open source GlassFish persistence engine. This book shows Java programmers how to develop applications utilizing relational database technologies with examples using Oracle and MySQL and the GlassFish application development framework and deployment platform all based on Java EE. The book explains in detail how you can organize your Java EE solution into a multilayer architecture, placing most emphasis on how to implement the persistence and database tiers of an application. Through many examples, this book shows how you can efficiently use the Java Persistence features available in the Java EE platform. Find out how you can greatly simplify the task of building the persistence layer of your Java EE application by moving some application logic into the underlying database, utilizing database views, stored programs, and triggers. The book also explains how to deploy Java EE applications to GlassFish, a free, open source Java EE 5–compliant application server.

Beginning C

From Novice to Professional
Author: Ivor Horton
Publisher: Apress
ISBN: 1430202432
Category: Computers
Page: 614
View: 553

Continue Reading →

C is the programming language of choice when speed and reliability are required. It is used for many low-level tasks, such as device drivers and operating-system programming. For example, much of Windows and Linux is based on C programming. The updated 4th edition of Beginning C builds on the strengths of its predecessors to offer an essential guide for anyone who wants to learn C or desires a ‘brush-up’ in this compact, fundamental language. This classic from author, lecturer and respected academic Ivor Horton is the essential guide for anyone looking to learn the C language from the ground up.

Beginning PHP and MySQL E-Commerce

From Novice to Professional
Author: Cristian Darie,Emilian Balanescu
Publisher: Apress
ISBN: 9781430202912
Category: Computers
Page: 707
View: 4696

Continue Reading →

* PHP is an open-source server-side scripting language, with millions of users worldwide. It is more popular than Microsoft’s ASP and ASP.NET. Version 5, out before the end of Q2 of 2004, features new OO-programming capabilities. * MySQL is the most popular open source RDBMS. * There are a lot of E-commerce elements, such as credit card transaction processing, that are not easy to learn. This book will provide solid e-commerce solutions for PHP and MySQL developers. * This will be a good companion book to Apress’ 1893115518 Beginning PHP 5 and MySQL: From Novice to Professional by W.J. Gilmore.

Beginning SQL Server 2005 Express for Developers

From Novice to Professional
Author: Robin Dewson
Publisher: Apress
ISBN: 9781430203292
Category: Computers
Page: 464
View: 4089

Continue Reading →

SQL Server 2005 Express Edition is a free relational database management system from Microsoft and provides a major subset of full SQL Server 2005 functionality. Many users learn on SQL Server 2005 Express Edition and then move on to SQL Server 2005. This book is a comprehensive, clear and gentle introduction to all fundamental aspects of SQL Server 2005 Express and the T-SQL database language. It is highly readable yet technically thorough. The book assumes no prior experience in databases or programming and is ideal for any new SQL Server Express user, whatever their use of SQL Server Express.

Beginning ASP.NET 2.0 Databases

From Novice to Professional
Author: Damien Foggon
Publisher: Apress
ISBN: 9781430201465
Category: Computers
Page: 656
View: 8446

Continue Reading →

* Provides developers with the skills to build professional database-driven web sites using the latest ASP.NET 2.0 technologies. * ASP.NET developers looking to build DB-driven websites will find practical solutions, multiple ways to achieve success, and a handy case study to wrap up core content. * NET is used by millions of web developers and are looking for a comprehensive resource on 2.0 beta improvements.

Beginning Oracle Database 12c Administration

From Novice to Professional
Author: Ignatius Fernandez
Publisher: Apress
ISBN: 1484201930
Category: Computers
Page: 384
View: 2625

Continue Reading →

Beginning Oracle Database 12c Administration is your entry point into a successful and satisfying career as an Oracle Database Administrator. The chapters of this book are logically organized into four parts closely tracking the way your database administration career will naturally evolve. Part 1 "Database Concepts" gives necessary background in relational database theory and Oracle Database concepts, Part 2 "Database Implementation" teaches how to implement an Oracle database correctly, Part 3 "Database Support" exposes you to the daily routine of a database administrator, and Part 4 "Database Tuning" introduces the fine art of performance tuning. Beginning Oracle Database 12c Administration provides information that you won't find in other books on Oracle Database. You'll discover not only technical information, but also guidance on work practices that are as vital to your success as are your technical skills. The author's favorite chapter is "The Big Picture and the Ten Deliverables." (It is the editor’s favorite chapter too!) If you take the lessons in that chapter to heart, you can quickly become a much better Oracle database administrator than you ever thought possible. You will grasp the key aspects of theory behind relational database management systems and learn how to: • Install and configure an Oracle database, and ensure that it’s properly licensed; • Execute common management tasks in a Linux environment; • Defend against data loss by implementing sound backup and recovery practices; and • Improve database and query performance.

Beginning JSP , JSF and Tomcat Web Development

From Novice to Professional
Author: Giulio Zambon,Michael Sekler
Publisher: Apress
ISBN: 9781430204657
Category: Computers
Page: 448
View: 6767

Continue Reading →

As the majority of Java developers are only Web-tier developers; Java technologies like JavaServer Pages (JSP), JavaServer Faces (JSF), and Apache Tomcat are mainly applicable and relevant to their needs. This comprehensive and user-friendly book is the first and maybe even the only starter-level work of its kind combining the naturally complimentary JSP, JSF and Tomcat Web technologies into one consolidated treatment for developers focusing on just Java Web application development and deployment. This book is examples-driven using practical, real-time e-commerce case studies and scenarios throughout.

Beginning CakePHP

From Novice to Professional
Author: David Golding
Publisher: Apress
ISBN: 143020978X
Category: Computers
Page: 344
View: 9810

Continue Reading →

CakePHP is a leading PHP–based web app development framework. When asking a question on forums or chat rooms, many CakePHP beginners get little help from the experts. Simple questions can get a response like, “Well, just read the online manual and API.” Unfortunately, the online manual is depreciated, and who wants to absorb a programming language or framework from an API? Beginning CakePHP will do the following: Lead you from a basic setup of CakePHP to building a couple applications that will highlight CakePHP’s functionality and capabilities without delving too deeply into the PHP language, but rather what the CakePHP framework can offer the developer. Teach you to use CakePHP by incorporating advanced features into your web development projects. Target beginners of CakePHP or web frameworks in general as well as experienced developers with limited exposure to CakePHP. A secondary audience may include developers undecided on adopting CakePHP or business managers trying to assess the value of incorporating CakePHP into their toolbox.