Category: Sql

  • PostgreSQL 8 for Windows (Database Professional's Library) by Richard Blum

    By Richard Blum

    The best way to establish a PostgreSQL database server on WindowsGet up-and-running on PostgreSQL quick utilizing this hands-on advisor. jam-packed with real-world examples, PostgreSQL eight for home windows provides you with useful, step by step information on fitting, configuring, and utilizing PostgreSQL 8--the full-featured, open-source database administration system--on home windows systems. you will discover ways to administer, safe, and track your database and use SQL. you are going to additionally observe find out how to interface Microsoft entry, Microsoft .NET, visible C++, and Java with the PostgreSQL database.Install and configure PostgreSQL eight on home windows customise your approach utilizing the configuration documents paintings with the utilitiesAdminister your database from the pgAdmin III graphical interface Use the psql command line software to manually execute SQL commandsTake benefit of integrated features or create your individual kept methods and triggers enforce validated protection measuresMaintain optimum database performanceAccess a PostgreSQL database from a Microsoft entry program and migrate entry databases to PostgreSQLCreate .NET, visible C++, and Java functions that interface along with your PostgreSQL server
    Show description

  • Delivering Business Intelligence with Microsoft SQL Server by Brian Larson

    By Brian Larson

    Remodel disparate firm facts into actionable enterprise intelligence positioned well timed, mission-critical details within the fingers of staff throughout your company utilizing Microsoft SQL Server 2005 and the great details during this exact source. offering enterprise Intelligence with Microsoft SQL Server 2005 indicates you, step by step, the best way to writer, customise, and distribute info that may supply your organization the aggressive facet. it is all correct here--from facts mining, warehousing, and scripting innovations to MDX queries, KPI research, and the all-new Unified Dimensional version. Real-world examples, start-to-finish workouts, and downloadable code all through illustrate all the integration, research, and reporting features of SQL Server 2005.
    Show description

  • Beginning Microsoft SQL server 2008 administration by Chris Leiter, Dan Wood, Michael Cierkowski, Albert Boettger

    By Chris Leiter, Dan Wood, Michael Cierkowski, Albert Boettger

    SQL Server 2008 introduces many new positive factors that would switch database management strategies; many DBAs could be pressured emigrate to SQL Server 2008. This e-book teaches you the way to enhance the talents required to effectively administer a SQL Server 2008 database; no earlier adventure is needed. the fabric covers approach deploy and configuration/architecting, enforcing and tracking defense controls, configuring and handling community communications, automating management projects, catastrophe prevention and restoration, functionality tracking, optimizing and making sure excessive availability, in addition to significant SQL Server 2008 parts together with Integration prone, Reporting companies, research companies, and repair dealer.
    Show description

  • Beginning SQL Server for Developers: Fourth Edition by Robin Dewson (auth.)

    By Robin Dewson (auth.)

    Beginning SQL Server for Developers is the precise e-book for builders new to SQL Server and making plans to create and installation functions opposed to Microsoft’s market-leading database approach for the home windows platform. Now in its fourth version, the ebook is greater to hide the very most modern advancements in SQL Server, together with the in-memory positive factors which are brought in SQL Server 2014.

    Within the publication, there are many examples of projects that builders commonly practice. You’ll discover ways to create tables and indexes, and be brought to most sensible practices for securing your worthy facts. You’ll research layout tradeoffs and tips to make sound judgements leading to scalable databases and maintainable code.

    SQL Server 2014 introduces in-memory tables and saved tactics. it really is now attainable to speed up functions by way of growing tables (and their indexes) that stay totally in reminiscence, and not on disk. those new, in-memory buildings fluctuate from caching mechanisms of the earlier, and make attainable the terribly speedy execution of particular types of queries comparable to are utilized in enterprise intelligence functions. Beginning SQL Server for builders helps you recognize the guarantees of this new function set whereas averting pitfalls which could ensue while blending in-memory tables and code with conventional, disk-based tables and code.

    Beginning SQL Server for Developers takes you thru the total database improvement strategy, from fitting the software program to making a database to writing the code to connect with that database and movement information out and in. by means of the tip of the ebook, you’ll be capable to layout and create reliable and trustworthy database strategies utilizing SQL Server.

    • Takes you thru the complete database program improvement lifecycle
    • Includes fresh insurance of the in-memory features
    • Introduces the freely-available convey Edition
    Show description

  • Oracle PL/SQL Language Pocket Reference: A Guide to Oracle's by Steven Feuerstein, Bill Pribyl, Chip Dawes

    By Steven Feuerstein, Bill Pribyl, Chip Dawes

    Be extra effective with the Oracle PL/SQL language. The 5th variation of this well known pocket reference places the syntax of particular PL/SQL language components correct at your fingertips, together with positive aspects further in Oracle Database 12c.

    Whether you're a developer or database administrator, if you want solutions quick, the Oracle PL/SQL Language Pocket Reference will prevent hours of frustration with concise summaries of:

    - primary language components, corresponding to block constitution, datatypes, and declarations
    - Statements for software keep watch over, cursor administration, and exception handling
    - documents, techniques, capabilities, triggers, and packages
    - Execution of PL/SQL capabilities in SQL
    - Compilation strategies, object-oriented gains, collections, and Java integration

    This convenient pocket reference is an ideal significant other to Steven Feuerstein and invoice Pribyl's bestselling Oracle PL/SQL Programming.
    Show description

  • Microsoft SQL Server 2012 Analysis Services: The BISM by Alberto Ferrari

    By Alberto Ferrari

    Research tabular information utilizing the BI Semantic version (BISM) in Microsoft SQL Server 2012 research prone - and find a less complicated procedure for developing corporate-level BI recommendations. Led via 3 BI specialists, you will methods to construct, set up, and question a BISM tabular version with step by step courses, examples, and most sensible practices. This hands-on e-book indicates you ways the tabular model's in-memory database permits you to practice quick analytics - even if you are a specialist BI developer new to research companies or accustomed to its multidimensional version.
    Show description

  • Pro T-SQL 2012 Programmer's Guide, 3rd Edition by Jay Natarajan, Scott Shaw, Rudi Bruchez, Michael Coles

    By Jay Natarajan, Scott Shaw, Rudi Bruchez, Michael Coles

    Professional T-SQL 2012 Programmer's advisor is each developer's secret to meaking complete use of SQL Server 2012's strong, integrated Transact-SQL language. Discussing new and current beneficial properties, the booklet takes you on knowledgeable guided journey of Transact-SQL performance. absolutely functioning examples and downloadable resource code deliver technically actual and interesting therapy of Transact-SQL into your personal arms. step by step factors be sure readability, and an advocacy of best-practices will steer you down the line to good fortune. Transact-SQL is the language builders and DBAs use to have interaction with SQL Server. it really is used for every thing from querying info, to writing saved methods, to dealing with the database. New positive factors in T-SQL 2012 comprise complete aid for window services, saved sequences, the facility to throw blunders, info paging, and extra. a lot of these vital new good points are coated during this e-book.
    Show description

  • Best Damn Exchange, SQL and IIS Book Period by Henrik Walther, Chris Adams, Mark Horninger

    By Henrik Walther, Chris Adams, Mark Horninger

    Trade, SQL and IIS are on the center of such a lot Microsoft firm servers. The 2007 releases of those items, besides the discharge of home windows Vista and home windows 2008 Server, represents the largest overhaul of home windows company items due to the fact that home windows 2000. The dramatic adjustments to safeguard instruments and the addition of positive aspects that help "anywhere access" current IT pros with a steep studying curve. guaranteeing that those items are configured to fulfill regulatory compliance requisites provides addtionaly complexity to daily administration community administration.
    Show description

  • Microsoft SQL Server 2005 Analysis Services Step by Step by Reed Jacobson

    By Reed Jacobson

    Your hands-on consultant to studying Microsoft SQL Server research prone, Microsofts customizable research resolution for company information modeling and interpretation. research providers is a strong software for enterprise intelligence, so figuring out the essentialshow to create a dice, in addition to the best way to set up, customise, and expand the elemental calculationsis serious to harnessing the entire merits of SQL Server. This step by step educational indicates you ways to start, the right way to construct scalable analytical purposes, and the way to exploit and administer complex positive aspects. Interactivity good points (enhanced in SQL Server 2005), facts translation, and defense also are coated intimately. With step-by-step, you're employed at your individual speed via hands-on, learn-by-doing workouts. no matter if youre a starting programmer or new to this model of the expertise, youll comprehend the basic ideas for utilizing research companies. A spouse CD contains info units and pattern code.
    Show description

  • Mastering SQL Server 2005 Reporting Services Infrastructure by Joseph L. Jorden

    By Joseph L. Jorden

    Cutting-edge DBAs want to know the right way to paintings with clients, administration, and key stakeholders to spot organizational wishes and leverage the know-how to fulfill them. protecting intermediate to complex topics, resembling functionality tuning, this publication exhibits you ways to construct a reporting infrastructure that may be utilized in any environment.Focusing on six key ideas simplicity, readability, generality, automation, and communications all important components of significant stories, you will research every thing you want to recognize to layout a document infrastructure that integrates the easiest practices of reporting structures. if you are comprehensive, you could have a roadmap that permits you to assist company managers utilize this technology.Loaded with real-world examples, this booklet palms you with directions that follow both good to small companies and mega-corporations.
    Show description