Joe Celko’s Analytics and OLAP in SQL
Joe Celko’s Analytics and OLAP in SQL
Product Description
Before SQL programmers could begin working with OLTP (On-Line Transaction Processing) systems, they had to unlearn procedural, record-oriented programming before moving on to SQL’s declarative, set-oriented programming. This book covers the next step in your growth. OLAP (On-Line Analytical Processing), Data Warehousing and Analytics involve seeing data in the aggregate and over time, not as single transactions. Once more it is time to unlearn what you were previously taught.
This book is not an in-depth look at particular subjects, but an overview of many subjects that will give the working RDBMS programmers a map of the terra incognita they will face-if they want to grow.
* Expert advice from a noted SQL authority and award-winning columnist, who has given ten years of service to the ANSI SQL standards committee and many more years of dependable help to readers of online forums.
* First book that teaches what SQL programmers need in order to successfully make the transition from transactional systems (OLTP) into the world of data warehouse data and OLAP.
* Offers real-world insights and lots of practical examples.
* Covers the OLAP extensions in SQL-99; ETL tools, OLAP features supported in DBMSs, other query tools, simple reports, and statistical software.
Unlocking Microsoft C# v2.0 Programming Secrets
Unlocking Microsoft C# v2.0 Programming Secrets
Unlocking Microsoft C# v2.0 Programming Secrets
Product Description
This text is a handbook of instructions written for the programmer or analyst that shows how to insert common algorithmic functions in C# into one’s source code. The code is listed on a companion CD for easy transfer to one’s current C# program. The first 12 chapters discuss specifics of the Visual C# compiler: the integrated developer environment (IDE); moving projects from one location to another; passing information between windows; Visual C# code placement; classes, constructors, overloading, and helps; data types and declarations; conversions between data types; string manipulation and on-line data storage; branching and looping; and arithmetic.
Building powerful and robust websites with Drupal 6
This book updates the bestselling Drupal: Creating Blogs, Forums, Portals, and Community Websites for Drupal 6, the latest, much improved version of this popular open-source Content Management System. Targeting readers with little experience in website design, unfamiliar with PHP, MySQL or HTML, and with little to no experience of Drupal, it looks pragmatically at the steps needed from knowing you want a website right through to designing and building it like a pro, and then successfully managing and maintaining it. Experienced author David Mercer uses a friendly, engaging style that is clear and concise, allowing readers to advance rapidly until they can tackle any problem with confidence. Drupal is an elegantly designed, well-supported and flexible open-source CMS platform that empowers anyone to create a website or blog and is rapidly becoming first choice of people in the know. With this powerful tool you need not pay professionals to design a site; you can do the job yourself.
Web Host Manager Administration Guide
If you are running a web host or web space reseller then the chances are you’ll be using WebHost Manager. This book shows you how to get the most from the software, for both you and your customers. It provides solutions to common WHM problems and pitfalls, leading to better customer service provided at lower cost. You will learn how to set up WHM securely, offer a variety of account styles. You will see how to use WHM to elegantly manage multiple domains, SSL certificates, and various databases and server-side technologies such as PHP, MySQL, Perl, and Apache. WebHost Manager is a package used by web hosts to manage their servers and the individual user accounts they hold. It is part of the same package as cPanel, so the host uses WebHost Manager while the client uses cPanel. WebHost Manager is at the core of many web hosts’ business. Using web host manager, you can keep track of the accounts on your server, monitor their bandwidth and disk space usage, and much more. The book shows you how to: – Set up a fast, secure, and effective server with WHM – Work with Apache, PHP, Perl and Databases – Manage standard and reseller accounts and use third-party programs that assist in this process – Keep an eye on what is happening on your server by using tools that WHM provides and some third-party tools – Deal with reseller and non-reseller accounts – Manage DNS, IP and SSL issues using WHM – Manage security on an on-going basis by learning what to look for – Learn how to add useful features to WHM and cPanel – Discover places you can turn to for help if you need it
Drupal: Creating Blogs, Forums, Portals, and Community Websites
A complete guide to every aspect of creating a variety of different websites using Drupal. A trove of well-considered and practical information is presented in a logical and intuitive manner so that you can either build up your site step by step by reading from cover to cover or, alternatively, focus on your specific needs by diving into each chapter as required. Drupal is one of the most popular content management systems on the internet. Based on PHP/MySQL, its power and flexibility combined with its exceptional design mean it is already on the way to becoming the de facto standard for CMS Websites. Drupal’s modular design and structured source code make it both highly flexible and easily extended and modified. Drupal is extremely scalable, making it ideal for both a simple personal website as well as an industrial strength commercial or institutional web presence. Drupal is a model open source project in that it has a large, friendly community of people who contribute to the project in various ways. Drupal is not only free and easy to use, but this community provides on going mutual support. Drupal’s power means choosing an initial pathway can be daunting. The flexibility and power of its content management features mean the right approach needs to be taken. This book takes your from intial set up through site design and creation in a series of carefully structured steps. While there are a few advanced topics that are beyond the scope of the book, all of the core stages of creating a website using Drupal are covered in detail.Download Here
Vegas Pro 8 Editing Workshop – Focal Press
Complete handbook for new and advanced user … Douglas turns complex technology into easy-to-understand concepts with his accessible and graceful writing style” — Charlie White, executive producer, digitalmedianet.com
One of those famed jewels of knowledge…it should be required reading in any decent DA/DV production class, even if they do not use Vegas! — Joaquin (Kino) Gil, forum leader, producer and writer, CreativeCow.net & digitalmedia.net
…and exhaustive, richly detailed resource that no Vegas user should be without. Highly recommended!” — Jeffrey P. Fisher, music/audio/video producer and writer
Master Vegas Pro 8 by learning the inside tips and techniques from an award-winning professional.
Business Process Management with JBoss jBPM
This book teaches Business Analysts to model business processes in JBoss jBPM and generate workflow application code from their models without Java coding expertise. It is a full toolkit for anyone wanting to implement Business Process Management correctly, covering tasks common to all BPM implementations, although it is focused on popular, free, open-source jBPM, with its flexible, scalable process engine, pluggable modular architecture, and easy programming model (jPDL) blending the best of Java and declarative techniques. The practical approach with step-by-step instructions uses a realistic case study to explore and explain BPM, model creation, and implementation. It covers: efficient, standards-friendly mapping of business processes; using the jBPM toolset to work with business process maps, analyze process execution data, and for ongoing process improvement; setting up business rules: task assignments, escalation points; process variables; automating activities and decisions.
Securing Windows Server 2008: Prevent Attacks from Outside and Inside Your O…
Microsoft hails the latest version of its flagship server operating system, Windows Server 2008, as “the most secure Windows Server ever”. However, to fully achieve this lofty status, system administrators and security professionals must install, configure, monitor, log, and troubleshoot a dizzying array of new features and tools designed to keep the bad guys out and maintain the integrity of their network servers. This is no small task considering the market saturation of Windows Server and the rate at which it is attacked by malicious hackers. According to IDC, Windows Server runs 38% of all network servers. This market prominence also places Windows Server at the top of the SANS top 20 Security Attach Targets. The first five attack targets listed in the SANS top 20 for operating systems are related to Windows Server. This doesn’t mean that Windows is inherently less secure than other operating systems; it’s simply a numbers game. More machines running Windows Server. More targets for attackers to hack.
As a result of being at the top of the “most used” and “most hacked” lists, Microsoft has released a truly powerful suite of security tools for system administrators to deploy with Windows Server 2008. This book is the comprehensive guide needed by system administrators and security professionals to master seemingly overwhelming arsenal of new security tools including:
1. Network Access Protection, which gives administrators the power to isolate computers that don’t comply with established security policies. The ability to enforce security requirements is a powerful means of protecting the network.
2. Enhanced solutions for intelligent rules and policies creation to increase control and protection over networking functions, allowing administrators to have a policy-driven network.
3. Protection of data to ensure it can only be accessed by users with the correct security context, and to make it available when hardware failures occur.
4. Protection against malicious software with User Account Control with a new authentication architecture.
5. Increased control over your user settings with Expanded Group Policy.
…to name just a handful of the new security features. In short, Windows Server 2008 contains by far the most powerful and complex suite of security tools ever released in a Microsoft Server product. Securing Windows Server 2008 provides system administrators and security professionals with the knowledge they need to harness this power.
Liferay Portal Enterprise Intranets
As the world’s leading open source portal platform, Liferay provides a unified web interface to data and tools scattered across many sources. Within Liferay portal, a portal interface is composed of a number of portlets—self contained interactive elements that are written to a particular standard. Since portlets are developed independently of the portal itself, and loosely coupled with the portal, they are apparently SOA (Service-Oriented Architecture).Download Here
