Welcome to the only guidebook series that takes a visual approach to professional-level computer topics. Open the book and you'll discover step-by-step screen shots that demonstrate over 110 Excel data analysis techniques, including:
* Identifying trends in your data
* Sorting, filtering, and identifying lists
* Creating, editing, and checking formulas
* Calculating interest rates and depreciation
* Performing simple sorts and filters
* Hiding rows or columns in a PivotTable
* Adding and removing chart data
* Querying an Access database
* Assigning digital signatures
* Solving a formula with a data table
"I was stuck on an Excel problem for two days. Finally, I opened one of your books, and there was a macro to accomplish exactly what I needed! You made me look good to the boss."
-Rob L. Meerscheidt(The Woodlands, TX)
* High-resolution screen shots demonstrate each task
* Succinct explanations walk you through step by step
* Two-page lessons break big topics into bite-sized modules
* "Apply It" and "Extra" sidebars highlight useful tips
Don't miss this book.
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.
Get started using Office 2007 right away--the QuickSteps way. Color screenshots and clear instructions guide you through all of the essential features and functions of the world's most popular productivity suite. Follow along and learn how to create great-looking Word documents; build number-crunching Excel spreadsheets; manage Outlook email, contacts, and schedules; and design impressive PowerPoint presentations. Get the book that gets you up and running on Office 2007 in no time.
Use these handy guideposts:
- Shortcuts for accomplishing common tasks
- Need-to-know facts in concise narrative
- Helpful reminders or alternate ways of doing things
- Bonus information related to the topic being covered
- Errors and pitfalls to avoid
This book describes C# 3.0. It is divided into two parts. Part I provides a comprehensive discussion of the C# language, including the new features added by version 3.0. This is the largest part in the book, and it describes the keywords, syntax, and features that define the language. I/O, file handling, reflection, and the preprocessor are also discussed in Part I.Part II explores the C# class library, which is the .NET Framework class library.
This library is huge! Because of space limitations, it is not possible to cover the entire .NET Framework class library in one book. Instead, Part II focuses on the core library, which is contained in the System namespace. Also covered are collections, multi-threading, networking, and Windows Forms. These are the parts of the library that nearly every C#programmer will use.
This book does not require any previous programming experience. If you already know C++ or Java, you will be able to advance quite rapidly because C# has much in common with those languages. If you don’t have any previous programming experience, you will still be able to learn C# from this book, but you will need to work carefully through the examples in each chapter.
