Prominent FileMaker developers Susan Prosser and Stuart Gripman know how to work magic with FileMaker Pro, and they share their knowledge in this bestselling book. You'll learn how to build a database and organize all of your information quickly and efficiently.

Need a quick and easy to understand introduction to MongoDB and NoSQL databases? MongoDB Basics, from The Definitive Guide to MongoDB, 2E, shows you how a document-oriented database system differs from a relational database, and how to install and get started using it. You'll also learn MongoDB design basics, including geospatial indexing, how to navigate, view, and query your database, and how to use GridFS with a bit of Python.

Beginning SQL Server for Developers is the perfect book for developers new to SQL Server and planning to create and deploy applications against Microsoft's market-leading database system for the Windows platform. Now in its fourth edition, the book is enhanced to cover the very latest developments in SQL Server, including the in-memory features that are introduced in SQL Server 2014. Within the book, there are plenty of examples of tasks that developers routinely perform. You'll learn to create tables and indexes, and be introduced to best practices for securing your valuable data. You'll learn design tradeoffs and find out how to make sound decisions resulting in scalable databases and maintainable code. SQL Server 2014 introduces in-memory tables and stored procedures. It's now possible to accelerate applications by creating tables (and their indexes) that reside entirely in memory, and never on disk. These new, in-memory structures differ from caching mechanisms of the past, and make possible the extraordinarily swift execution of certain types of queries such as are used in business intelligence applications. Beginning SQL Server for Developers helps you realize the promises of this new feature set while avoiding pitfalls that can occur when mixing in-memory tables and code with traditional, disk-based tables and code. Beginning SQL Server for Developers takes you through the entire database development process, from installing the software to creating a database to writing the code to connect to that database and move data in and out. By the end of the book, you'll be able to design and create solid and reliable database solutions using SQL Server. Takes you through the entire database application development lifecycle Includes brand new coverage of the in-memory features Introduces the freely-available Express Edition

There are many reasons for serving up dynamic content from a web site: to offer an online shopping site, create customized information pages for users, or just manage a large volume of content through a database. Anyone with a modest knowledge of HTML and web site management can learn to create dynamic content through the PHP programming language and the MySQL database. This book gives you the background and tools to do the job safely and reliably.

"Web Database Applications with PHP and MySQL," Second Edition thoroughly reflects the needs of real-world applications. It goes into detail on such practical issues as validating input (do you know what a proper credit card number looks like?), logging in users, and using templates

to give your dynamic web pages a standard look.

But this book goes even further. It shows how JavaScript and PHP can be used in tandem to make a user's experience faster and more pleasant. It shows the correct way to handle errors in user input so that a site looks professional. It introduces the vast collection of powerful tools available in the PEAR repository and shows how to use some of the most popular tools.

Even while it serves as an introduction to new programmers, the book does not omit critical tasks that web sites require. For instance, every site that allows updates must handle the possibility of multiple users accessing data at the same time. This book explains how to solve the problem in detail with locking.

Through a sophisticated sample application--Hugh and Dave's Wine Store--all the important techniques of dynamic content are introduced. Good design is emphasized, such as dividing logic from presentation. The book introducesPHP 5 and MySQL 4.1 features, while providing techniques that can be used on older versions of the software that are still in widespread use.

This new edition has been redesigned around the rich offerings of PEAR. Several of these, including the Template package and the database-independent query API, are fully integrated into examples and thoroughly described in the text. Topics include:

Installation and configuration of Apache, MySQL, and PHP on Unix(R), Windows(R), and Mac OS(R) X systems

Introductions to PHP, SQL, and MySQL administration

Session management, including the use of a custom database for improved efficiency

User input validation, security, and authentication

The PEAR repository, plus details on the use of PEAR DB and Template classes

Production of PDF reports

In "Advanced Transact-SQL for SQL Server 2000," authors Itzik Ben-Gan and Thomas Moreau explore the powerful capabilities of Transact-SQL (T-SQL). Ben-Gan and Moreau offer solutions to common problems encountered using all versions of SQL Server, with a focus on the latest version, SQL Server 2000.

Expert tips and real code examples teach advanced database programmers to write more efficient and better-performing code that takes full advantage of T-SQL. The authors offer practical solutions to the everyday problems programmers face and include in-depth information on advanced T-SQL topics such as joins, subqueries, stored procedures, triggers, user-defined functions (UDFs), indexed views, cascading actions, federated views, hierarchical structures, cursors, and more.

Performance problems are rarely problems per se. They are more often crises during which you're pressured for results by a manager standing outside your cubicle while your phone rings with queries from the help desk. You won't have the time for a leisurely perusal of the manuals, nor to lean back and read a book on theory. What you need in that situation is a book of solutions, and solutions are precisely what Oracle Database 12c Performance Tuning Recipes delivers. Oracle Database 12c Performance Tuning Recipes is a ready reference for database administrators in need of immediate help with performance issues relating to Oracle Database. The book takes an example-based approach, wherein each chapter covers a specific problem domain. Within each chapter are recipes, showing by example how to perform common tasks in that chapter's domain. Solutions in the recipes are backed by clear explanations of background and theory from the author team. Whatever the task, if it's performance-related, you'll probably find a recipe and a solution in this book.* Provides proven solutions to real-life Oracle performance problems * Offers relevant background and theory to support each solution * Gets straight to the point for when you're under pressure for results What you'll learn * Optimize the use of memory and storage * Monitor performance and troubleshoot problems * Identify and improve poorly-performing SQL statements * Adjust the most important optimizer parameters to your advantage * Create indexes that get used and make a positive impact upon performance * Automate and stabilize using key features such as SQL Tuning Advisor and SQL Plan Baselines Who this book is for Oracle Database 12c Performance Tuning Recipes is aimed squarely at Oracle Database administrators. The book especially appeals to those administrators desiring to have at their side a ready-to-go set of solutions to common database performance problems.

Expert Consolidation in Oracle Database 12c is your key to reducing data management costs and increasing data center efficiency. Consolidation and cloud computing are converging trends sweeping the industry. The same technologies enabling cloud computing enable consolidation as well, leading to savings on all fronts from the amount of power used for servers to the amount of floor space consumed to the number of administrators needed to manage an installation. Yet the consolidation process can be a long and winding road. Success requires planning, and consideration to the impacts on supporting infrastructure.Expert Consolidation in Oracle Database 12c guides you through planning and implementing a consolidated Oracle Database installation using the many new features built into the latest release of Oracle's database management system. You'll learn to identify candidates for consolidation and to recognize instances that are best left stand-alone. The book guides in working with clustered systems and ASM storage in the consolidated environment. Focus is given to Oracle Enterprise Manager 12c Cloud Control as a monitoring and management dashboard. Always the goal is to drive towards a cost-effective environment that is efficient both in technology and people. Focuses on the new consolidation features in Oracle Database 12c Helps you evaluate and correctly decide when to consolidate Leads to cost savings and improved data center efficiency

Pro Oracle SQL, Second Edition unlocks the power of SQL in the Oracle database--one of the most potent SQL implementations on the market today. To master it requires a multi-pronged approach: learn the language features, learn how and why the language features work, learn the supporting features that Oracle provides to help use the language effectively, and learn to think and work in sets. Karen Morton has updated the content for Oracle version 12c and helps you master powerful aspects of Oracle SQL from the inside-out. You'll learn analytic functions, the MODEL clause, and advanced grouping syntax--features that will help in creating good queries for reporting and business intelligence applications. Pro Oracle SQL, Second Edition also helps you minimize parsing overhead, read execution plans, test for correct results, understand performance management, and exert control over SQL execution in your database. You'll learn when to create indexes, how to verify that they make a difference, how to use SQL Baselines and Profiles to optimize and stabilize SQL execution plans, and much more.You'll also understand how SQL is optimized for working in sets, and that the key to getting accurate results lies in making sure that queries ask clear and precise questions. Pro Oracle SQL, Second Edition helps you work at a truly professional level in the Oracle dialect of SQL. You'll master the language, the tools to work effectively with the language, and the right way to think about a problem in SQL. * Endorsed by the OakTable Network, a group of Oracle technologists well-known for their rigorous and scientific approach to Oracle Database performance * Comprehensive--goes beyond the language with a focus on what you need to know to write successful queries and data manipulation statements. * Performance focused--teaches you how to measure the performance of your SQL statements and not just the syntax.What you'll learn * Master powerful SQL features implemented in the Oracle Database * Understand how the Oracle Optimizer develops execution plans * Read and interpret SQL execution plans * Quickly diagnose and fix badly performing SQL * Control execution plans through hints, profiles, and plan baselines * Optimize queries within packaged applications without touching the code * Recognize when not to waste time on SQL that is performing optimally Who this book is for Pro Oracle SQL, Second Edition is aimed at developers and database administrators who submit SQL for execution by an Oracle database. Readers should already know the basic four SQL statements, and be ready to learn deeply about Oracle's specific implementation of the language, including Oracle-specific features and syntax. Readers should also want to learn about Oracle Database features such as analytic queries, the MODEL clause, and the WITH clause (subquery factoring) that are designed to help developers and database administrators exert control over their SQL environment and its execution.

RMAN Recipes for Oracle Database 12c is an example-driven approach to the Oracle database administrator's #1 job responsibility: * Be able to recover the database. Of all the things you are responsible for as database administrator, nothing is more important than the data itself. Like it or not, the fearsome responsibility of protecting your organization's most critical data falls squarely upon your shoulders: * Lose that data and your company could fail. * Lose that data and you could be out of a job. Oracle's flagship database product fortunately implements a wide-ranging feature set to aid you in the all-important task of safeguarding against data loss. Recovery Manager, or RMAN, is at the heart of that feature set, and is the tool most-often used to initiate database backup and recovery operations. In this book, well-known authors and database experts Darl Kuhn, Sam Alapati, and Arup Nanda have created a set of examples encompassing the gamut of backup and recovery tasks that you might need to perform. Sometimes, especially when the heat is on, a good example is what you need to get started towards a solution. RMAN Recipes for Oracle Database 12c delivers.It'll be the book you reach for when that dreaded call comes in at 3:00am some dreary morning. It'll be the book that lets you sleep at night knowing that no matter what transpires, that you've done your job well and can recover from any outage. RMAN Recipes for Oracle Database 12c gets right to the point with quick and easy-to-read, step-by-step solutions that can help you backup and recover your data with confidence.

Enterprise Manager 12c (EM12c), Oracle's newest and fully-integrated enterprise management product, now provides a complete cloud lifecycle management solution and enterprise environment management interface. Expert Oracle Enterprise Manager 12c opens up the secrets of this incredible management tool, saving you time while enhancing your visibility as someone management can rely upon to deliver reliable database service in today's increasingly chaotic and change-driven IT environment. Expert Oracle Enterprise Manager 12c covers all the topics you demand and need to function effectively, from basic monitoring and configuration to advanced metric extensions and plugins. Real-life scenarios and demonstrations place you in the comfort zone of using the EM12c console, and the experienced author team provides deep understanding of the inner workings of this new Enterprise Manager. Database administrators and system administrators are expected to offer increasing levels of service for 24X7 systems and newer cloud environments. Em12c offers robust, end-to-end intelligent management of the complete environment. It includes direct, real-time integration with Oracle's online knowledgebase.Expert Oracle Enterprise Manager 12c helps you master this important tool and manage any challenge that comes your way. * Provides example solutions to everyday problems through EM12c features. * Explains the changes in EM12c, included trusted extensions. * Focuses on advanced aspects of the EM12c interface. What you'll learn * Installation and agent employment * Patching and provisioning * Advanced techniques for managing and monitoring * Use of EM12c in cloud environments, with RAC, and for Exadata * Creation of EM12c plugins and metric extensions * High-availability and disaster-recovery options with EM12c * Incident Manager and EM12c job management Who this book is for Expert Oracle Enterprise Manager 12c is for database administrators who are ready to upgrade, or who have already upgraded to Enterprise Manager 12c. The book also appeals to system administrators who may have responsibility for helping support Oracle Database environments -- including RAC and Exadata -- at the enterprise level.

Business intelligence projects do not need to cost multi-millions of dollars or take months or even years to complete Using rapid application development (RAD) techniques along with Microsoft SQL Server 2012, this book guides database administrators, SQL programmers, and report specialists in creating practical, cost-effective business intelligence solutions for their companies and departments. Pro SQL Server 2012 BI Solutions provides practical examples of cost-effective business intelligence projects. Readers will be guided through several complete projects that build a foundation for real-world solutions. Even with limited experience using Microsoft's SQL Server, Integration Server, Analysis Server, and Reporting Server, you can leverage your existing knowledge of SQL programming and database design to provide users with the business intelligence reports they need.* Provides recipes for multiple business intelligence scenarios * Progresses from simple to advanced projects using several examples * Shows Microsoft SQL Server technology used to complete real-world business intelligence projects What you'll learn * How to plan and implement cost-effective business intelligence projects * How to create practical data warehouse databases * How to extract, transform, and load data with Integration Services * How to develop OLAP cubes and dimensions on Analysis Server * How to create Reporting Server reports using both SQL and MDX * How to apply performance-tuning techniques to get the most from your solutions Who this book is for Pro SQL Server 2012 BI Solutions is aimed at database administrators, SQL programmers, and report developers who create business intelligence solutions for midsized businesses and departments.Table of Contents * Business Intelligence Solutions * A Big Picture Overview * Planning Solutions * Designing a Data Warehouse * Creating a Data Warehouse * ETL Processing with SQL * Beginning the ETL Process with SSIS * Concluding the ETL Process with SSIS * Beginning the SSAS Project * Configuring Dimensions with SSAS * Creating and Configuring SSAS Cubes * Additional Cube and Dimension Configurations * Creating Reports with SQL Queries * Reporting with MDX Queries * Reporting with Microsoft Excel * Creating Reports with SSRS * Configuring Reports with SSRS * Testing and Tuning BI Solutions * Approve, Release, and Prepare

Beginning SQL Server 2012 for Developers is the perfect book for developers new to SQL Server and planning to create and deploy applications against Microsoft's market-leading database system for the Windows platform. Now in its third edition, the book is enhanced to cover the very latest developments in SQL Server 2012. Also new in the book is coverage of the no-cost Express Edition. Whether you have no knowledge of databases, or have knowledge of desktop databases such as Microsoft Access, or even come from another brand such as Oracle Database, Beginning SQL Server 2012 for Developers provides the insights to get up and running with SQL Server 2012. Within the book, there are plenty of examples of tasks that developers routinely perform. You'll learn to create tables and indexes, and best practices for securing your valuable data. You'll learn design tradeoffs and find out how to make sound decisions resulting in scalable databases and maintainable code. Beginning SQL Server 2012 for Developers takes you through the entire database development process, from installing the software to creating a database to writing the code to connect to that database and move data in and out. By the end of the book, you'll be able to design and create solid and reliable database solutions using SQL Server 2012. * Takes you through the entire database application development lifecycle * Includes brand new coverage of SQL Server 2012 features * Introduces the freely-available Express Edition What you'll learn * How to install SQL Server 2012 * How to build a database application from start to finish * How to create tables and indices to manage your data * How to write stored code to execute directly in the database server * How to back up, recover, and otherwise maintain your database * How to connect to your database from client languages such as C# and VB .NET Who this book is for Beginning SQL Server 2012 for Developers is ideal for developers starting out with SQL Server 2012. There is no prerequisite background in developing database applications.Developers from other platforms and those brand new to database programming alike will find in Beginning SQL Server 2012 for Developers an excellent introduction to using and programming Microsoft's database platform. Table of Contents * Overview and Installation * SQL Server Management Studio * Database Design and Creation * Security and Compliance * Defining Tables * Creating Indexes and Database Diagramming * Database Backups and Recovery * Database Maintenance * Inserting and Deleting Data * Selecting and Updating Data * Building a View * Stored Procedures, Functions, and Security * Essentials for Effective Coding * Advanced T-SQL * Triggers * Connecting from Client Code

Oracle Core: Essential Internals for DBAs and Developers by Jonathan Lewis provides just the essential information about Oracle Database internals that every database administrator needs for troubleshooting - no more, no less. Oracle Database seems complex on the surface. However, its extensive feature set is really built upon upon a core infrastructure resulting from sound architectural decisions made very early on that have stood the test of time. This core infrastructure manages transactions and the ability to commit and roll back changes, protects the integrity of the database, enables backup and recovery, and allows for scalability to thousands of users all accessing the same data. Most performance, backup, and recovery problems that database administrators face on a daily basis can easily be identified through understanding the essential core of Oracle Database architecture that Lewis describes in this book.* Provides proven content from a world-renowned performance and troubleshooting expert * Emphasizes the significance of internals knowledge to rapid identification of database performance problems * Covers the core essentials and does not waste your time with esoterica What you'll learn * Oracle's core architectural foundations * How much overhead is reasonable * How to recognize when you're doing too much work * How to predict bottlenecks and why they will happen * How to minimise contention and locking * Why concurrency can slow things down significantly Who this book is for Oracle Core: Essential Internals for DBAs and Developers is aimed at database administrators ready to move beyond the beginning stage of doing work by rote towards the mastery stage, in which knowledge of what needs to be done comes not from a set of recipe-style instructions, but rather from the intimate knowledge and understanding of the system to be managed. Experienced database administrators will also find the book useful in solidifying their knowledge and filling in any missing pieces of the Oracle Database puzzle.Table of Contents * Introduction * Redo and Undo * Transactions and Consistency * Latches and Locks * Caches and Copies * Writing and Recovery * RAC and Ruin * Dumping and Debugging * Working and Waiting

Pro Access 2010 Development is a fundamental resource for developing business applications that take advantage of the features of Access 2010 and the many sources of data available to your business. In this book, you'll learn how to build database applications, create Web-based databases, develop macros and Visual Basic for Applications (VBA)tools for Access applications, integrate Access with SharePoint and other business systems, and much more. What you'll learn How to build business applications that integrate local data, web-generated data, and data available from SQL Server and other sources How to develop VBA routines and macros to enhance the automation of your database How to deploy databases to your users and "web-ify" your application for access from anywhere How to secure access to your data and maintain its integrity How to integrate Access with SharePoint and other business applications Who this book is for

This book is for intermediate to advanced Access developers who want to get up to speed with the new features available in Access 2010. Experienced Access users who want to begin developing code-based applications and project solutions in Access will also find this book useful. Table of Contents Introduction Definingand Relating Tables Using Data Macros DesigningQueries Creating PivotTables Standard Forms Creatinga CheckOut Form Creating aCustomer Admin Form EnhancingProductAdministration Enhancing the User Experience Branding with Themes and Styles Reports Upsizing Distributing the Application Publishing to the Web Integrating Outlook Using External Data Miscellaneous Features Security

Foundations of SQL Server 2008 R2 Business Intelligence introduces the entire exciting gamut of business intelligence tools included with SQL Server 2008. Microsoft has designed SQL Server 2008 to be more than just a database. It's a complete business intelligence (BI) platform. The database is at its core, and surrounding the core are tools for data mining, modeling, reporting, analyzing, charting, and integration with other enterprise-level software packages. SQL Server 2008 puts an incredible amount of BI functionality at your disposal. But how do you take advantage of it? That's what this book is all about. Authors Guy Fouche and Lynn Langit show how to implement end-to-end BI solutions using SQL Server Analysis Services (SSAS), SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), and other tools in the Microsoftbusiness intelligencetoolkit. You'll learn about all-features such as PowerPivot and Report Builder 3.0. Also provided are clear examples of predictive analysis made possible through powerful data mining features in SQL Server. If you're an analyst or developer working with SQL Server 2008 who is charged with delivering results that drive business success, you can't afford to be without this book; you can't afford to ignore the powerfulbusiness intelligencesuite that Microsoft has placed at your disposal. Provides the big picture of Microsoft's BI tool suite Covers PowerPivot and other game-changing technologies introduced alongside SQL Server 2008 Release 2 Gives a practical analysis of features based on real-world practices What you'll learn Apply dimensional- and fact-based modeling to create OLAP schemas Optimize data extraction and transformation with SQL Server Integration Services Develop OLAP and data-mining solutions using SQL Server Analysis Services Create compelling reports using the new Report Builder 3.0 in SQL Server Reporting Services Deliver self-service business-intelligence via Microsoft PowerPivot Manage and maintain control over your business intelligence environment Who this book is for

Foundations of SQL Server 2008 R2 Business Intelligence is for business intelligence analysts and developers wanting to employ the full stack of business intelligence tools that are part of SQL Server. The book also appeals to database administrators managing databases in support of business intelligence efforts. Table of Contents What Is Business Intelligence? OLAP Modeling Concepts Introducing OLAP Modeling with SSAS Intermediate OLAP Modeling with SSAS Advanced OLAP Modeling with SSAS Cube Storage and Aggregation Introducing SSIS Intermediate SSIS Advanced SSIS Reporting Tools Data Mining with Excel Introducing PowerPivot Introduction to MDX Introduction to Data Mining

Oracle PL/SQL Recipes is your go to book for PL/SQL programming solutions. It takes a task-oriented approach to PL/SQL programming that lets you quickly look up a specific task and see the pattern for a solution. Then it's as simple as modifying the pattern for your specific application and implementing it. And you're done and home for dinner.
Oracle PL/SQL Recipes is another in Apress' ongoing series of recipe books aimed at Oracle practitioners. The recipe format is ideal for the busy professional who just needs to get the job done. Covers the most common PL/SQL programming problems Presents solutions in ready-to-use format Stays short and to-the-point What you'll learn Move business logic into the database Implement robust exception-handling Optimize and debug, taking advantage of Oracle SQL Developer Integrate PL/SQL with web-based applications Interface with Java code and dynamic languages in the database, and running externally Run the UTPLSQL unit-testing framework Who this book is for

Oracle PL/SQL Recipes is database administrators and developers wanting to take advantage of Oracle Database's built-in support for procedural logic. Database administrators can use PL/SQL to automate administrative tasks, audit access to sensitive data, and more. Developers will be able to optimize processing, push business logic into the database layer, and interface with Java and web applications. Table of Contents PL/SQL Fundamentals Essential SQL Looping and Logic Functions, Packages, and Procedures Triggers Type Conversion Numbers, Strings, and Dates Dynamic SQL Exceptions PL/SQL Collections and Records Automating Routine Tasks Oracle SQL Developer Analyzing and Improving Performance Using PL/SQL on the Web Java in the Database Accessing PL/SQL from JDBC, HTTP, Groovy, and Jython Unit Testing With utPLSQL

Extensive coverage of PHP and MySQL-more than any other book for beginners Updated for PHP 5.3 Author W. Jason Gilmore is a well-known and highly respected PHP developer and author as well as the organizer of CodeMash Beginning PHP and MySQL: From Novice to Professional, Fourth Edition is a major update of W. Jason Gilmore's authoritative book on PHP and MySQL. The fourth edition includes complete coverage of PHP 5.3 features, including namespacing, an update of AMP stack installation and configuration, updates to Zend Framework, coverage of MySQL Workbench, and much more. You'll not only receive extensive introductions to the core features of PHP, MySQL, and related tools, but you'll also learn how to effectively integrate them in order to build robust data- driven applications. Gilmore has seven years of experience working with these technologies, and he has packed this book with practical examples and insight into the real-world challenges faced by developers. Accordingly, you will repeatedly return to this book as both a valuable instructional tool and reference guide.

Now in its second edition, this best-selling book by Tom Kyte of Ask Tom fame continues to bring you some of the best thinking on how to apply Oracle Database to produce scalable applications that perform well and deliver correct results. Tom has a simple philosophy: you can treat Oracle as a black box and just stick data into it or you can understand how it works and exploit it as a powerful computing environment. If you choose the latter, then you'll find that there are few information management problems that you cannot solve quickly and elegantly. This fully revised second edition covers the latest developments in Oracle Database 11g. Each feature is taught in a proof-by-example manner, not only discussing what it is, but also how it works, how to implement software using it, and the common pitfalls associated with it. Don't treat Oracle Database as a black-box. Get this book. Get under the hood. Turbo-charge your career.* Fully-revised to cover Oracle Database 11g* Proof-by-example approach: Let the evidence be your guide* Dives deeply into Oracle Databases's most powerful featuresWhat you'll learn* Develop an evidence-based approach to problem solving* Manage transactions in highly concurrent environments* Speed access to data through table and index design* Manage files and memory structures for performance and reliability* Scale up through partitioning and parallel processing* Load and unload data to interface with external systems* Think for yourself; don't take Tom's word for it Who this book is for This book is aimed at Oracle Database administrators, at PL/SQL and Java developers writing code to be deployed inside the database, and at developers of external applications who use Oracle Database as a data store. It is the go to book for those wishing to create efficient and scalable applications.

Even if you have little or no knowledge of T-SQL, Beginning T-SQL 2008 will bring you up to intermediate level and teach you best practices along the way. You'll learn how to write code that will help you to achieve the best-performing applications possible.

You'll find an introduction to databases, normalization, and SQL Server Management Studio. You'll understand how data is stored in a database and learn how to use at least one of the available tools to get to that data.

Each subsequent chapter teaches an aspect of T-SQL, building on the skills learned in previous chapters. Exercises are included in each chapter because the only way to learn T-SQL is to write some code.

This book will do more than just give the syntax and examples. It will teach you techniques to help you avoid common errors and create robust and well-performing code.Imparts best practices for writing T-SQL Helps readers avoid common errors Shows how to write scalable code that yields good performance What you'll learn Understand the fundamentals of relational theory, upon which Transact-SQL is based Write accurate queries that are scalable and perform well Combine set-based and procedural processing, obtaining the best from both worlds Embed business logic in your database through stored procedures and functions Simplify your work through new and advanced features such as common-table expressions and virtual tables Enhance performance by knowing when to apply features such table value parameters Who this book is for

This book is for developers who will be writing database applications against SQL Server databases. Table of Contents Getting Started Writing Simple SELECT Queries Using Functions and Expressions Querying Multiple Tables Grouping and Summarizing Data Manipulating Data Understanding T-SQL Programming Logic Moving Logic to the Database Working with New Data Types Writing Advanced Queries Where to Go Next?

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 tomove 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 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 nextcareer 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 Applied Mathematics for Database Professionals

The insights that Jonathan provides into the workings of the cost-based optimizer will make a DBA a better designer, and a Developer a better SQL coder. Both groups will become better troubleshooters. -- Thomas Kyte, VP (Public Sector), Oracle Corporation

The question, "Why isn't Oracle using my index?" must be one of the most popular (or perhaps unpopular) questions ever asked on the Oracle help forums. You've picked exactly the right columns, you've got them in the ideal order, you've computed statistics, you've checked for null columnsand the optimizer flatly refuses to use your index unless you hint it. What could possibly be going wrong?

If you've suffered the frustration of watching the optimizer do something completely bizarre when the best execution plan is totally obvious, or spent hours or days trying to make the optimizer do what you want it to do, then this is the book you need. Youll come to know how the optimizer "thinks," understand why it makes mistakes, and recognize the data patterns that make it go awry. With this information at your fingertips, you will save an enormous amount of time on designing and trouble-shooting your SQL.

The cost-based optimizer is simply a piece of code that contains a model of how Oracle databases work. By applying this model to the statistics about your data, the optimizer tries to efficiently convert your query into an executable plan. Unfortunately, the model can't be perfect, your statistics can't be perfect, and the resulting execution plan may be far from perfect.

In "Cost-Based Oracle Fundamentals," the first book in a series of three, Jonathan Lewisone of the foremost authorities in this fielddescribes the mostcommonly used parts of the model, what the optimizer does with your statistics, and why things go wrong. With this information, youll be in a position to fix entire problem areas, not just single SQL statements, by adjusting the model or creating more truthful statistics.

With special focus on the next major release of MySQL, this resource provides a solid framework for anyone new to MySQL or transitioning from another database platform, as well as experience MySQL administrators. The high-profile author duo provides essential coverage of the fundamentals of MySQL database management--including MySQL's unique approach to basic database features and functions--as well as coverage of SQL queries, data and index types, stores procedure and functions, triggers and views, and transactions. They also present comprehensive coverage of such topics as MySQL server tuning, managing storage engines, caching, backup and recovery, managing users, index tuning, database and performance monitoring, security, and more.

Introduce your students to the latest advancements that Microsoft (R) Office and Access (R) have to offer with MICROSOFT (R) OFFICE 365 & ACCESS (R) 2019: COMPREHENSIVE -- new to the acclaimed Shelly Cashman Series (R). MICROSOFT (R) OFFICE 365 & ACCESS (R) 2019: COMPREHENSIVE continues the series' strong history of innovation with a hallmark learning approach enhanced to address the varied learning styles of today's students. A trademark step-by-step, screen-by-screen approach encourages students to expand their understanding of the software through experimentation, critical thought, and personalization. This new edition and accompanying resources are designed to engage readers and improve retention while also engaging them in real-world scenarios to reinforce critical skills to make them successful in their educational and professional careers. In addition, MindTap and updated SAM (Skills Assessment Manager) online resources are available to guide additional study and ensure successful results.