- Clip Art
- Sex Differentiation
- Radicalism
- Miller, Andrew
- Football
- Rocks & Minerals
- ( A )
- Bankruptcy
- Cyclades
- Post-Impressionism
- General
- Desai, Kiran
- Non-Euclidean Geometries
- General
- Hardcover
- Product Management
- Constitutions
- Wyoming
- Lewis, Beverly
- Biographies & Memoirs
- Wisconsin
- Firefighting
- General
- Smith, Taylor
- Service
- Solid State Physics
- Law Office Education
- Paleoecology
- Depression
- German
- Some of our other sites:
- Books
- Clothing, Shoes and Accessories
- Baby Clothes and Accessories
- Cosmetics, Beauty Products and Fragrances
- Cellphones, Call Plans and Accessories
- Video Games
- DVDs
- Electronics, Gadgets and Computers
- Health and Personal Care
- Home and Garden
- Home DIY
- Jewelry
- Magazines and Newspapers
- Music Downloads
- Musical Instruments
- Office Equipment and Supplies
- Software and Games
- Sporting Goods
- Toys and Games
- Watches
- UK Books
- UK Video Games
- UK Home and Garden
- UK Electronics, Gadgets and Computers
- UK Baby Clothes and Accessories
- UK Software and Games
- UK Sporting Goods
- UK Toys and Games
Books : Computers & Internet : Databases : Beginning & Introductory
-
I can report that Gilmore and Apress have given the world one book that will replace many other PHP and MySQL volumes. This is one that the reader will consistently rely on and keep near to hand.
— Mary Norbury-Glaser, Slashdot contributor
I can summarize this review in nine words: If you want to learn PHP, buy this book.
— Gregg Bolinger, JavaRanch Sheriff
...an extremely detailed book.
— Richard Testani, Apple-Sauce.com
Beginning PHP 5 and MySQL: From Novice to Professional offers a comprehensive introduction to two of the most popular open source technologies on the planet: the PHP scripting language and the MySQL database server. You are not only exposed to the core features of both technologies, but will also gain valuable insight into how they are used in unison to create dynamic data-driven web applications, not to mention learn about many of the undocumented features of the most recent versions.
The first part of the book is devoted to PHP's foundational features, with special focus on those new to PHP 5, including the improved object-oriented support, exception handling, SQLite support, SimpleXML, and much more. But PHP 5-specific topics are only part of what's covered; you'll also learn about the language's core capabilities, beginning with a survey of installation and configuration tasks. Early chapters are devoted to basic PHP programming concepts such as variables, datatypes, arrays, string manipulation, and user interaction. Later chapters cover session handling, LDAP integration, the Smarty templating engine, and Web Services support.
Next up is a broad overview of the powerful MySQL database server. Among other topics, you'll learn about the installation and configuration process, datatypes, key security features, and various administration utilities. With this groundwork in pace, you'll then learn about PHP's assortment of MySQL functions, accompanied by dozens of examples depicting the creation and execution of queries. You'll also learn how to perform searches, and manage database transactions.
Whether you're a newcomer searching for a thorough introduction to these popular technologies, or a seasoned developer in need of a comprehensive reference, this book is for you.
-
For the first time, SQL Server 2005 provides features that can support large-scale enterprise databases. With this powerful new release, you may find yourself being called upon to perform duties that are no longer strictly "administrative," duties that have become much more complicated and difficult. With that in mind, a team of experienced Microsoft Certified Professionals provides you with the necessary information to be a more competent and successful database developer or administrator.Beginning with a foundation that features detailed coverage of typical administrative duties, the authors proceed to explain how to build complex data transformations for data import, build distributed data solutions, and maintain the security and integrity of the database. You will be able to apply what you learn to real-world scenarios, and smoothly navigate the vastly changed landscape of SQL Server 2005 administration.
What you will learn from this book
- How to install, maintain, and manage an SQL Server 2005 installation, including high availability and security considerations
- Various features such as the Common Language Runtime, SQL Server Integration Services, Notification Service, and the Service Broker
- How to use the tools that are necessary to manage configuration, backups, restores, security, availability, performance, and monitoring
- A sampling of some of the more advanced areas and complex jobs of the broadening role of a database administrator in the enterprise
Who this book is for
This book is for both developers and administrators who are responsible for the management and maintenance of an SQL Server 2005 database. Familiarity with relational database concepts and SQL is assumed.
Wrox Beginning guides are crafted to make learning programming languages and technologies easier than you think, providing a structured, tutorial format that will guide you through all the techniques involved.
Enhance Your Knowledge Advance Your Career
-
-
- After a quick primer on database design basics and the SQL query language (for those programmers who may be building their first database application), this book provides an overview of SQL Server itself, which has been dramatically redesigned with the 2005 release
- Once readers have grasped the fundamentals of database design and SQL concepts, they will then learn how to implement those concepts with Microsoft SQL Server 2005
- Addresses creating and changing tables, managing keys, database normalization, writing scripts, working with stored procedures, programming with XML, and using SQL Server reporting and data transformation services
- The companion Web site provides all of the code found in the book
-
Class-tested and coherent, this groundbreaking new textbook teaches web-era information retrieval, including web search and the related areas of text classification and text clustering from basic concepts. Written from a computer science perspective by three leading experts in the field, it gives an up-to-date treatment of all aspects of the design and implementation of systems for gathering, indexing, and searching documents; methods for evaluating systems; and an introduction to the use of machine learning methods on text collections. All the important ideas are explained using examples and figures, making it perfect for introductory courses in information retrieval for advanced undergraduates and graduate students in computer science. Based on feedback from extensive classroom experience, the book has been carefully structured in order to make teaching more natural and effective. Although originally designed as the primary text for a graduate or advanced undergraduate course in information retrieval, the book will also create a buzz for researchers and professionals alike.
-
SQL Server 2008 is a first–rate database management system. It offers more capability than any previous release of SQL Server. More than just a classic relational database management system, SQL Server 2008 includes exciting and powerful features that make it useful for everything from large corporate data warehouses to ad hoc departmental databases. You’ll find enhanced support for XML, new support for spatial data, transparent data encryption, a policy–based management system, and more.
Author and developer Robin Dewson will show you the way from beginner to SQL Server 2008 professional. Learn to install SQL Server 2008 and navigate around Management Studio before getting right to the heart of mastering fundamental SQL Server 2008 tasks: creating tables, storing data, securing data, and retrieving it again. Dewson ensures you’ll be fully prepared to use all the basics and create a solid foundation for your own projects.
Don’t forget about backups! Your database will house important data, so backing up is essential to protect yourself from inevitable hardware failure. Dewson walks you through SQL Server 2008’s easy–to–use backup and recovery feature set, giving you the grounding that you need in order to set up a reliable plan for recovery in your own environment.
Learn to use Transact–SQL, a full–blown procedural language that is built right into the database system. Transact–SQL is the key to unlocking everything that SQL Server 2008 has to offer. Using Transact–SQL, you can write centrally encapsulated business logic through the use of stored procedures, automatically trigger processing through the use of triggers, and manipulate data within the server without having to move data back and forth across the network.
Finally, you’ll learn a bit about SQL Server 2008 Reporting Services, a powerful tool that allows enterprise reporting. Reporting Services enables you to develop and serve reports across your organization and even to business partners outside your company. Reporting Services also gives end users the ability to create their own reports, helping them transform business data into valuable, usable information to guide their day–to–day decisions.
What you’ll learn
- Install and manage SQL Server on your system.
- Create and secure tables.
- Store and query data; use indexes to improve query performance.
- “Sleep when the wind blows,” because you have a solid backup and recovery process.
- Run procedural code inside your database in the form of Transact–SQL procedures and triggers.
- Serve up business reports to in–house users and outside business partners via SQL Server 2008 Reporting Services.
Who is this book for?
Developers new to SQL Server 2008. If you are just beginning to develop software using SQL Server 2008, or if you are planning to do so in the near future, this book will set you on the road to success.
About the Apress Beginning Series
The Beginning series from Apress is the right choice to get the information you need to land that crucial entry–level job. These books will teach you a standard and important technology from the ground up because they are explicitly designed to take you from “novice to professional.” You’ll start your journey by seeing what you need to knowbut without needless theory and filler. You’ll build your skill set by learning how to put together real–world projects step by step. So whether your goal is your next career challenge or a new learning opportunity, the Beginning series from Apress will take you there—it is your trusted guide through unfamiliar territory!
-
Beginning Database Design: From Novice to Professional 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, youll learn how to discover and represent the details and scope of the problem in question.
Database design is not an exact science, and solid database design principles and examples help demonstrate the consequences of simplifications and pragmatic decisions. The rationale is to try to keep it simple, but allow room for development as situations change or resources permit. The book also features an introduction for implementing the final design in a relational database.
-
Following the critical thinking, problem-solving approach of the New Perspectives Series learners will gain a comprehensive understanding of Microsoft Access 2007, including the new features of the software. The case-based tutorials challenge learners to apply what they are learning to real-life tasks, preparing them to easily transfer skills to new situations. With the New Perspectives Series approach, learners understand why they’re learning what they’re learning, and are better situated to retain skills.
-
Part of the New Perspectives series, this text offers a case-based, problem-solving approach and innovative technology for meaningful learning of Microsoft Access 2003.
-
Get started with PL/SQL, the built-in language that every Oracle developer and database administrator must know, in Beginning PL/SQL, a fast-paced and example-filled tutorial. Learn from author Don Bales extensive experience to discover the most commonly used aspects of PL/SQL without wasting time with obscure and obsolete features.
Author Don Bales takes his 20+ years of experience and a wealth of statistics he's gathered on PL/SQL usage over those years and applies the 80/20 rule &emdash; cover whats most needed and used by PL/SQL professionals and avoid whats not necessary! The result is a book that covers all the key features of PL/SQL without wasting your time discussing esoteric and obsolete parts of the language. Learn what really matters, so that you can get to work feeling confident with what you know about PL/SQL.
- Discover the 20% of PL/SQL that gives you 80% of the bangkey topics covered include variables and datatypes, executing statements, working with cursors, real-world objects, debugging, testing, and more.
- Learn how to write production-level, object-oriented PL/SQLyoull explore relational PL/SQL, but unlike most other books on the subject, Don Bales emphasizes the use of PL/SQLs object-oriented features as well.
- Work through real examples of using of PL/SQLyoull learn PL/SQL by applying it to real-world business problems, not by heavy theory.
What youll learn
- How important SQL is in PL/SQL
- How to use PL/SQL in both a relational and object-relational setting
- How to create maintainable, modular, and reusable PL/SQL program units
- The importance of testing as you go, and of building a permanent test plan for each module
- The importance of building debugging capabilities into your code and building a permanent debug facility for each module
- The importance of documenting as you go, and in the process building a permanent documentation set for your reusable modules
- How to apply modular PL/SQL to solve real-world problems
Who is this book for?
Anyone who wants to learn how to create stored procedures against an Oracle database using PL/SQL. Programmers developing applications to be deployed against an Oracle database will need PL/SQL to take full advantage of the power Oracle has to offer. Database administrators who wish to implement functionality exposed only via PL/SQL package interfaces will also find this book useful.
About the Apress Beginning Series
The Beginning series from Apress is the right choice to get the information you need to land that crucial entry-level job. These books will teach you a standard and important technology from the ground up because they are explicitly designed to take you from "novice to professional." Youll start your journey by seeing what you need to knowbut without needless theory and filler. Youll build your skill set by learning how to put together real-world projects step by step. So whether your goal is your next career challenge or a new learning opportunity, the Beginning series from Apress will take you thereit is your trusted guide through unfamiliar territory!
-
Get the fast answers--in full color--that make learning the new version of Microsoft Office Access plain and simple! This no-nonsense guide helps you learn the easy way to navigate Office Access 2007 with numbered steps and concise, straightforward language that show the most expedient ways to learn a new skill or solve a problem. You'll learn the essentials for working with Office Access 2007--discovering how to perform everyday tasks and answer your own questions quickly. You'll learn how to create databases and forms, filter data, run queries, and generate reports. You'll also discover how to make data entry faster, sort and filter data, work with PivotTable® reports, and even publish your documents to the Web--plus more! With PLAIN & SIMPLE, you don't have to wade through superfluous details. This easy-to-use book delivers fast, precise information--exactly how and when you need it!
-
Ever have a bad data day? If you're a business user, architect, analyst, designer or developer, then you've probably had some bad data days. It comes with the territory. Overcoming these problems is much easier if you have an in-depth understanding of the actual data. That's where a data model comes in handy. It's a diagram that uses text and symbols to represent groupings of data, giving you a clear picture of your business and application environment. Data Modeling Made Simple provides the tools you need to read, create and validate models of your business and applications.This book contains everything about modeling you need to know but were too afraid to ask, such as:
- What are the traditional and nontraditional uses of a data model?
- How do subject area, logical, and physical data models differ?
- When do I build a BSAM, ASAM, or CSAM?
- What is the easiest way to apply normalization?
- Where can I best leverage abstraction?
- How do I decide whether to use denormalization or dimensionality?
- What are primary, foreign, alternate, virtual, and surrogate keys?
- What is the best approach to building the models?
- How can I use the Scorecard system to validate a data model?
Plus over 30 exercises to reinforce concepts and sharpen your skills!
Reviews:
"What a great book—and a fun read too! Steve has captured the essence of data modeling and made it simple. For those who are not data modelers but need to work with them, this book is an excellent primer. For those who model data occasionally but not routinely, it is an invaluable quick reference. And for those of us who are experienced (and incorrigible) data modelers, Data Modeling Made Simple is a terrific reminder that we really can keep it simple!"
David Wells, Director of Education, Data Warehousing Institute
"An excellent introduction from someone who knows his subject and knows how to teach it"
Graeme Simsion, University of Melbourne
“Data Modeling Made Simple is a must read for all professionals new to data modeling as well as those that want to ‘speak the language’ and understand the concepts. Steve writes as though he is right there with you, walking you through the terminology, explaining the symbols, and telling you what you should consider doing before, during and after you have modeled your data.”
Robert S. Seiner, President, KIK Consulting & Educational Services, LLC and Publisher of The Data Administration Newsletter, tdan.com
“Data Modeling Made Simple is an excellent training guide for anyone entering the data modeling field. Steve Hoberman takes the fundamental concepts of data modeling and presents them in an easy to understand and entertaining manner that I’m sure you will find valuable.”
David Marco, President, EWSolutions
“How does one who is not a formally trained ‘data modeler’ understand the basics of data modeling? Steve Hoberman has created an informative, fun, easy to follow, and practical book sharing data modeling concepts which are essential for any professional involved in information technology. Mr. Hoberman clearly answers key questions behind the what, why and how of data modeling and reinforces the explanations with appropriate examples, analogies and exercises.”
Len Silverston, Best-Selling Author of The Data Model Resource Book, Volumes 1 and 2
-
-
Introduction to Data Mining presents fundamental concepts and algorithms for those learning data mining for the first time. Each major topic is organized into two chapters, beginning with basic concepts that provide necessary background for understanding each data mining technique, followed by more advanced concepts and algorithms.
-
Assuming only basic knowledge of C# 2008, Beginning C# 2008 Databases teaches all the fundamentals of database technology and database programming readers need to quickly become highly proficient database users and application developers.
A comprehensive tutorial on both SQL Server 2005 and ADO.NET 3.0, Beginning C# 2008 Databases explains and demonstrates how to create database objects and program against them in both T–SQL and C#. Full of practical, detailed examples, it’s been fully revised and updated for C# 2008 and offers the most complete, detailed, and gentle introduction to database technology for all C# programmers at any level of experience.
- Comprehensively and concisely explains fundamental database concepts and programming techniques
- Rich in working examples of both T–SQL and C# programs
- Covers all the features most database programming ever requires
What you’ll learn
- How relational databases work and how to use them
- How C# uses ADO.NET to access databases
- How to write stored procedures in T–SQL and call them from C# programs
- How to use XML in database applications
- How to use LINQ to simplify C# database programming
- How to install SQL Server 2005 Express and Visual C# 3.0
- Express and use them to teach yourself database programming by doing it
Who is this book for?
Beginning C# 2008 Databases is for every C# programmer. Database programming requires relatively little knowledge of C# but a lot of knowledge about relational database concepts and the database language SQL. This book assumes no prior database experience and teaches you, always through hands–on examples, how to create and use relational databases with SQL and how to access them with C#. Almost every application needs to access a database, and this book teaches all the fundamentals you needand may ever needto develop professional database applications.
About the Apress Beginning Series
The Beginning series from Apress is the right choice to get the information you need to land that crucial entry-level job. These books will teach you a standard and important technology from the ground up because they are explicitly designed to take you from “novice to professional.” You’ll start your journey by seeing what you need to know—but without needless theory and filler. You’ll build your skill set by learning how to put together real–world projects step by step. So whether your goal is your next career challenge or a new learning opportunity, the Beginning series from Apress will take you there—it is your trusted guide through unfamiliar territory!
Related Titles from Apress
- Beginning C# 2008: From Novice to Professional
- Beginning Database Design: From Novice to Professional
- Pro C# 2008 and the .NET 3.5 Platform, Fourth Edition
- Pro LINQ: Language Integrated Query in C# 2008
-
- Supported by all major database systems, XML provides an easy, standardized method of transferring data between databases and to and from the Web, independent of the software in use
- Offers database programmers and data-driven Web developers detailed guidance on how to understand and work with XML as data
- Numerous hands-on, step-by-step examples help readers learn to simplify database work using XML
- Shows how to use XML to exchange data between multiple databases either internally or with external customers and partners
- Covers XML in popular databases including Oracle Database, SQL Server, and brief coverage of DB2 Database
- Covers basic syntax for XML, the XML DOM, and XSL – with an emphasis on database use, and native XML databases
- Additional topics covered include Native XML databases, XPath, XQuery, XLink, XPointer, DTDs, XML Schemas, among others
-
In Microsoft Access 2007: Introductory Concepts and Techniques you’ll find features that are specifically designed to improve retention, and prepare for future success. Our trademark step-by-step, screen-by-screen approach now encourages readers to expand their understanding of the Access 2007 software through experimentation, exploration, and planning ahead.
-
-
Beginning VB 2008 Databases teaches you everything you need to know about relational databases, SQL, and ADO.NET 2.0, giving you a sound start in developing console and Windows database applications. The book also includes chapters on the new SQL Server XML data type and the forthcoming LINQ enhancements to the next version of Visual Basic.
In addition to teaching you database basics like using SQL to communicate with databases, this book provides you with detailed, code-practical techniques to access data in Visual Basic 2008 across a range of coding situations. Code-heavy and full of practical detail, this book has been fully revised and upgraded for .NET 3.5 and offers you the best contemporary practice in this core programming area, so that you’ll find yourself using it in nearly all your .NET projects.
- Provides step-by-step instructions on how to install and configure necessary tools
- Presents all essential SQL query and update concepts and syntax, so you don’t need prior familiarity with relational databases or SQL
- Describes how to use ADO.NET transactions, exceptions, and events
- Covers ADO.NET features for handling XML, text, and binary data within a Visual Basic 2008 context
- Explains all concepts through straightforward code examples
What you’ll learn
- How relational databases work and how to use them
- How Visual Basic uses ADO.NET to access databases
- How to write stored procedures in T-SQL and call them from Visual Basic programs
- How to use XML in database applications
- How to use LINQ to simplify VB database programming
- How to install SQL Server 2005 Express and use it to teach yourself databases by doing databases
Who is this book for?
Beginning VB 2008 Databases is for every VB programmer. Database programming requires relatively little knowledge of VB but a lot of knowledge about relational database concepts and the database language SQL. This book assumes no prior database experience and teaches you, always through hands-on examples, how to create and use relational databases with SQL and how to access them with VB. Almost every application needs to access a database, and this book teaches all the fundamentals you may ever need to develop professional database applications.
About the Apress Beginning Series
The Beginning series from Apress is the right choice to get the information you need to land that crucial entry-level job. These books will teach you a standard and important technology from the ground up because they are explicitly designed to take you from “novice to professional.” You’ll start your journey by seeing what you need to knowbut without needless theory and filler. You’ll build your skill set by learning how to put together real-world projects step by step. So whether your goal is your next career challenge or a new learning opportunity, the Beginning series from Apress will take you thereit is your trusted guide through unfamiliar territory!
-
What is this book about?Written by an Access programmer with more than 10 years of VBA experience, this is the perfect guide for Access users who are ready to take their databases to the next level, or for programmers who are new to Access or VBA. Veteran Access developer Denise Gosnell shows readers the ins and outs of Access VBA and provides plenty of source code, and fully developed sample applications to guide you along the way.
Not only do readers learn to build “stand-alone” desktop applications, but readers also learn how to integrate Access applications with Web Services, and SQL Server.