Learning
Unix.com

Learning
Oracle.com

Learning
Java.net

Learning
C.net

Learning
VB.net

Learning
SAP.com

Database Trends and Applications - Free Monthly Publication

Database Trends and Applications (DBTA) magazine is the leading monthly publication providing corporate information project teams with timely coverage of the technology, intelligence and insight needed to conceptualize, plan, initiate, implement and manage large-scale, integrated, information-rich projects. Building on its long tradition within the multivalue and multi-dimensional database market, Database Trends and Applications now addresses the full range of enterprise information issues, including operational, transactional and analytical systems.

Application Developers

Programming Microsoft SQL Server 2008 By: Leonard Lobel, Andrew J. Brust, Stephen Forte [Microsoft Press] Written by industry professionals who have been working with SQL Server 2008 since the earliest code, this reference expertly covers the programming fundamentals for SQL Server 2008 with crucial real-world context and extensive code samples. Get the hands-on programming instruction, practical examples, and best practices you need to master the core programmability features in SQL Server 2008. Led by three experts in database design and business intelligence solutions, you ll learn the essential tools and techniques for developing robust applications. Discover how to: Program views, stored applications, triggers, and functions using T-SQL Work with the new data types, LINQ, and the ADO.NET Entity Framework Automate common administration and maintenance tasks Debug databases, reports, and objects using Microsoft Visual Studio® 2008 Write transactional code and implement local and distributed transactions Use business intelligence tools, such as SQL Server Reporting Services, SQL Server Analysis Services, and SQL Server Integration Services Many of the book s examples, exercises, and code samples are available for download from the companion Web site.

Murach's SQL Server 2008 for Developers By: Bryan Syverson, Joel Murach Every application developer who uses SQL Server 2008 should own this book. To start, this book presents the essential SQL statements for retrieving and updating the data in a database, because that's what every application developer needs to know. Then, it shows you how to design and create a database, because application developers often end up in the role of database designer and DBA. Next, it shows how to work with views, scripts, stored procedures, functions, triggers, cursors, transactions, locking, security, XML data, and BLOB data with FILESTREAM storage. These features allow you to create database applications that are thoroughly professional. Finally, this book shows how to use the CLR integration feature, so you can use C# or Visual Basic to code stored procedures, functions, triggers, aggregate functions, and user-defined types.

Microsoft SQL Server 2008 For Dummies By: Mike Chapple SQL Server 2008 lets you build powerful databases and create database queries that give your organization the information it needs to excel. icrosoft SQL Server 2008 For Dummies helps you build the skills you need to set up, administer, and troubleshoot SQL Server 2008. You’ll be able to: Develop and maintain a SQL Server system Design databases with integrity and efficiency Turn data into information with SQL Server Reporting Services Organize query results, summarizing data with aggregate functions and formatting output Import large quantities of data with SSIS Keep your server running smoothly Protect data from prying eyes Develop and implement a disaster recovery plan Improve performance with database snapshots Automate SQL Server 2008 administration

Beginning SQL Server 2008 for Developers: From Novice to Professional By: Robin Dewson 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.

Microsoft SQL Server 2008 Bible By: Paul Nielsen, Uttam Parui, Mike Whit Harness the power of SQL Server, Microsoft’s high-performance database and data analysis software package, by accesing everything you need to know in Microsoft SQL Server 2008 Bible. Learn the best practices, tips, and tricks from this comprehensive tutorial and reference, which includes specific examples and sample code, with nearly every task demonstrated in both a graphical and SQL code method. Understand how to develop SQL Server databases and data connections, how to administer the SQL Server and keep databases performing optimally, and how to navigate all the new features of the 2008 release.

© 2008 Krislyn Technologies LLC. All rights reserved. All trademarks are owned by the respective company or Krislyn Technologies LLC.