• Computers

SQL For Dummies


Author: Allen G. Taylor
Publisher: John Wiley & Sons
ISBN: 111865711X
Category: Computers
Page: 480
View: 4108
Uncover the secrets of SQL and start building better relational databases today! This fun and friendly guide will help you demystify database management systems so you can create more powerful databases and access information with ease. Updated for the latest SQL functionality, SQL For Dummies, 8th Edition covers the core SQL language and shows you how to use SQL to structure a DBMS, implement a database design, secure your data, and retrieve information when you need it. Includes new enhancements of SQL:2011, including temporal data functionality which allows you to set valid times for transactions to occur and helps prevent database corruption Covers creating, accessing, manipulating, maintaining, and storing information in relational database management systems like Access, Oracle, SQL Server, and MySQL Provides tips for keeping your data safe from theft, accidental or malicious corruption, or loss due to equipment failures and advice on eliminating errors in your work Don't be daunted by database development anymore - get SQL For Dummies, 8th Edition, and you'll be on your way to SQL stardom.

    • Computers

SQL All-in-One For Dummies


Author: Allen G. Taylor
Publisher: John Wiley & Sons
ISBN: 9781118038659
Category: Computers
Page: 744
View: 9508
The soup-to-nuts guide on all things SQL! SQL, or structured query language, is the international standard language for creating and maintaining relational databases. It is the basis of all major databases in use today and is essential for the storage and retrieval of database information. This fun and friendly guide takes SQL and all its related topics and breaks it down into easily digestible pieces for you to understand. You’ll get the goods on relational database design, development, and maintenance, enabling you to start working with SQL right away! Provides an overview of the SQL language and examines how it is integral for the storage and retrieval of database information Includes updates to SQL standards as well as any new features Explores SQL concepts, relational database development, SQL queries, data security, database tuning, and more Addresses the relationship between SQL and programming as well as SQL and XML If you’re looking for an up-to-date sequel to the bestelling first edition of SQL All-in-One For Dummies, then this is the book for you!

    • Computers

Oracle PL / SQL For Dummies


Author: Michael Rosenblum,Paul Dorsey
Publisher: John Wiley & Sons
ISBN: 9781118054796
Category: Computers
Page: 432
View: 4494
Find tips for creating efficient PL/SQL code If you know a bit about SQL, this book will make PL/SQL programming painless! The Oracle has spoken—you need to get up to speed on PL/SQL programming, right? We predict it'll be a breeze with this book! You'll find out about code structures, best practices, and code naming standards, how to use conditions and loops, where to place PL/SQL code in system projects, ways to manipulate data, and more. Discover how to Write efficient, easy-to-maintain code Test and debug PL/SQL routines Integrate SQL and PL/SQL Apply PL/SQL best practices Use new features introduced in Oracle 9i and 10g

    • Computers

Microsoft SQL Server 2008 For Dummies


Author: Mike Chapple
Publisher: John Wiley & Sons
ISBN: 9780470486658
Category: Computers
Page: 408
View: 2495
If you’re a database administrator, you know Microsoft SQL Server 2008 is revolutionizing database development. Get up to speed on SQL Server 2008, impress your boss, and improve your company’s data management — read Microsoft SQL Server 2008 For Dummies! SQL Server 2008 lets you build powerful databases and create database queries that give your organization the information it needs to excel. Microsoft 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 Microsoft SQL Server 2008 For Dummies is a great first step toward becoming a SQL Server 2008 pro!

    • Computers

Database Development For Dummies


Author: Allen G. Taylor
Publisher: John Wiley & Sons
ISBN: 1118085256
Category: Computers
Page: 360
View: 2651
From ATMs to the personal finance, online shopping to networked information management, databases permeate every nook and cranny of our highly-connected, information-intensive world. Databases have become so integral to the business environment that, nowadays, it’s next to impossible to stay competitive without the assistance of some sort of database technology—no matter what type or size of business you run. But developing your own database can be very tricky. In fact, whether you want to keep records for a small business or run a large e-commerce website, developing the right database system can be a major challenge. Which is where this friendly guide comes in. From data modeling methods and development tools to Internet accessibility and security, Database Development For Dummies shows you, step-by-step, everything you need to know about building a custom system from the ground up. You’ll discover how to: Model data accurately Design a reliable functional database Deliver robust relational databases on time and on budget Build a user-friendly database application Put your database on the Web In plain English, author Allen Taylor acquaints you with the most popular data modeling methods, and he shows you how to systematically design and develop a system incorporating a database and one or more applications that operate on it. Important topics he explores include: Understanding database architecture and how it has evolved Recognizing how database technology affects everyday life Using a structured approach to database development Creating an appropriate data model Developing a reliable relational design Understanding the complexities you’re likely to encounter in designing a database and how to simplify them Implementing your design using Microsoft Access 2000, SQL Server and other powerful database development tools Keeping your database secure Putting your database on the Internet Today’s powerful, low-cost database development tools make it possible for virtually anybody to create their own database. Get Database Development For Dummies and discover what it takes to design, develop and implement a sophisticated database system tailored to you and your company’s current and future data storage and management needs.


    • Computers

LINQ For Dummies


Author: John Paul Mueller
Publisher: John Wiley & Sons
ISBN: 0470507616
Category: Computers
Page: 364
View: 5379
If you’ve asked yourself “Why can’t I develop database and XML queries in a language I already know?”, then Language INtegrated Query, or LINQ, is for you. LINQ For Dummies introduces you to LINQ and the .NET Framework technologies, so you can use LINQ to query any object, any data set, any kind of XML, and SQL Server—no questions asked. This plain-English guide gives you a thorough overview of LINQ, from understanding the tasks it performs to making LINQ work with both Visual Basic and Visual Studio 2005. It explains the four LINQ providers in the .NET Framework, the easiest ways to go about accessing data, and how to write more efficient applications with less code using LINQ. There’s also clear guidance on combining third-party providers with LINQ to create even more powerful apps. With this single, comprehensive guide, you’ll discover how to: Use one query language with all Microsoft languages Examine .NET language extensions and work with extension methods, partial methods, lambda expressions, and query expressions LINQ to DataSet operators, SQL server operations, XML API, or Active Directory Deal with databases — download and install the Northwind database, generate Northwind entity classes, and create the Northwind XML mapping file Create the partial class example, the partial method example, and the database modification example Use objects with LINQ Query databases in Visual Basic and C# As an added bonus, you can visit the companion Web site for LINQ examples in C# and Visual Basic. With LINQ For Dummies, you’ll link up with LINQ in no time and see how you can query almost anything! Note: CD-ROM/DVD and other supplementary materials are not included as part of eBook file.

    • Computers

Microsoft SQL Server 2008 All-in-One Desk Reference For Dummies


Author: Robert D. Schneider,Darril Gibson
Publisher: John Wiley & Sons
ISBN: 1118051947
Category: Computers
Page: 768
View: 1425
If you’re in charge of database administration, developing database software, or looking for database solutions for your company, Microsoft SQL Server 2008 All-In-One Desk Reference For Dummies can help you get a handle on this extremely popular relational database management system. Here you’ll find what’s new in the latest version; how to choose and install the right variation for your needs; how to monitor, maintain, and protect your data; and what it takes to keep your database healthy. You’ll discover how to: Build and maintain tables Design a database and communicate with it Retrieve, analyze, and report data Build solid, robust database applications Use the SQL Server Optimizer and Query Designer Navigate SQL Server with Visual Studio Develop useful reports with the Report Builder and Report Designer Create Business Intelligence solutions with Business Intelligence Development Studio Configure your server and perform major administrative tasks To help you quickly find what you need, Microsoft SQL Server 2008 All-In-One Desk Reference For Dummies is divided into nine minibooks: Essential Concepts Designing and Using Databases Interacting With Your Data Database Programming Reporting Services Analysis Services Performance Tips and Tricks Database Administration Appendixes Microsoft SQL Server 2008 All-In-One Desk Reference For Dummies gets you started, helps you solve problems, and will even answer your questions down the road!

    • Computers

NoSQL For Dummies


Author: Adam Fowler
Publisher: John Wiley & Sons
ISBN: 1118905741
Category: Computers
Page: 456
View: 2713
NoSQL databases are critical for managing big data. Fowler provides specific evaluation criteria for choosing the NoSQL database that's ideal for your organization, and gives real-world examples of using NoSQL databases for mission-critical enterprise architectures and projects.

    • Computers

Oracle 11g For Dummies


Author: Chris Zeis,Chris Ruel,Wessler
Publisher: John Wiley & Sons
ISBN: 9780470465073
Category: Computers
Page: 408
View: 5778
Are you a seasoned system administrator charged with setting up an Oracle database? Or did you suddenly become a DBA by default? If database administration with Oracle is part of your job, you’ll be glad to have Oracle 11g For Dummies in your cubicle. This nuts-and-bolts guide walks you through the mysteries of Oracle and database administration. You’ll learn how to understand Oracle database architecture, set up and manage an Oracle database, and keep it running in tiptop form. Oracle 11g For Dummies covers: The building blocks behind the database engine as well as Oracle’s physical and logical structures Hardware, software, system, and storage requirements for implementation How to recognize and accommodate the differences between Oracle installations on Windows and on Linux/UNIX Daily and intermittent tasks necessary to keep your database running properly How to assess potential threats to your database, configure Oracle Recovery Manager, and set up backup and recovery procedures When to use online, offline, controlfile, and archivelog backups Troubleshooting methodology and how to use Oracle database logs and other diagnostic utilities Different ways to manage your database How to automate jobs with the Oracle Scheduler Using SQL in Oracle, and a great deal more Completely up to date for the newest release of Oracle, Oracle 11g For Dummies will give you both the information and the confidence to set up and maintain an Oracle database for your organization.

    • Computers

Oracle 12c For Dummies


Author: Chris Ruel,Wessler
Publisher: John Wiley & Sons
ISBN: 1118745310
Category: Computers
Page: 432
View: 7138
Presents a guide to the features of Oracle 12c database software, covering such topics as creating a database, using SQL, making tablespaces, troubleshooting, and facilitating backup and recovery.

    • Computers

PHP and MySQL For Dummies


Author: Janet Valade
Publisher: John Wiley & Sons
ISBN: 9780470585474
Category: Computers
Page: 456
View: 1164
Here's what Web designers need to know to create dynamic, database-driven Web sites To be on the cutting edge, Web sites need to serve up HTML, CSS, and products specific to the needs of different customers using different browsers. An effective e-commerce site gathers information about users and provides information they need to get the desired result. PHP scripting language with a MySQL back-end database offers an effective way to design sites that meet these requirements. This full updated 4th Edition of PHP & MySQL For Dummies gets you quickly up to speed, even if your experience is limited. Explains the easy way to install and set up PHP and MySQL using XAMPP, so it works the same on Linux, Mac, and Windows Shows you how to secure files on a Web host and how to write secure code Packed with useful and understandable code examples for Web site creators who are not professional programmers Fully updated to ensure your code will be compliant based on PHP 5.3 and MySQL 5.1.31 Provides clear, accurate code examples PHP & MySQL For Dummies, 4th Edition provides what you need to know to create sites that get results. Note: CD-ROM/DVD and other supplementary materials are not included as part of eBook file.

    • Computers

Microsoft Business Intelligence For Dummies


Author: Ken Withee
Publisher: John Wiley & Sons
ISBN: 9780470606346
Category: Computers
Page: 432
View: 3083
Learn to create an effective business strategy using Microsoft's BI stack Microsoft Business Intelligence tools are among the most widely used applications for gathering, providing access to, and analyzing data to enable the enterprise to make sound business decisions. The tools include SharePoint Server, the Office Suite, PerformancePoint Server, and SQL Server, among others. With so much jargon and so many technologies involved, Microsoft Business Intelligence For Dummies provides a much-needed step-by-step explanation of what's involved and how to use this powerful package to improve your business. Microsoft Business Intelligence encompasses a broad collection of tools designed to help business owners and managers direct the enterprise effectively This guide provides an overview of SharePoint, PerformancePoint, the SQL Server suite, Microsoft Office, and the BI development technologies Explains how the various technologies work together to solve functional problems Translates the buzzwords and shows you how to create your business strategy Examines related technologies including data warehousing, data marts, Online Analytical Processing (OLAP), data mining, reporting, dashboards, and Key Performance Indicators (KPIs) Simplifies this complex package to get you up and running quickly Microsoft Business Intelligence For Dummies demystifies these essential tools for enterprise managers, business analysts, and others who need to get up to speed.

    • Computers

Microsoft SQL Server 2005 Programming For Dummies


Author: Andrew Watt
Publisher: John Wiley & Sons
ISBN: 9780470128596
Category: Computers
Page: 416
View: 6283
Create and modify databases and keep them secure Get up to speed on using T-SQL to store and manipulate data SQL Server 2005 improves an already great database management system. This book shows you how to put it to work in a hurry. You'll find out how to use the SQL Server Management Studio and the SQLCMD utility to write T-SQL code, retrieve data from single or multiple SQL Server tables, add data using the INSERT statement, and much more. * Create queries to retrieve data * Ensure SQL Server security * Use Visual Studio(r) 2005 with SQL Server * Create tables, views, and indexes * Work with Common Language Runtime * Query XML data

    • Computers

Microsoft SQL Server 2005 For Dummies


Author: Andrew Watt
Publisher: John Wiley & Sons
ISBN: 9780470007419
Category: Computers
Page: 432
View: 737
Now updated to reflect the much-anticipated "Yukon" release of SQL Server, this friendly guide shows database developers and administrators as well as those who use database application how to get up to speed fast Offers a gentle introduction to relational database design and shows how to build databases, create database applications, and maintain and optimize database performance Covers the major new features of the "Yukon" release-including analysis services, reporting services, and notification services

    • Computers

Sams Teach Yourself SQL in 10 Minutes


Author: Ben Forta
Publisher: Pearson Education
ISBN: 0672336073
Category: Computers
Page: 274
View: 326
Explains how to use Structured Query Language to work within a relational database system, including information retrieval, security, data manipulation, and user management.

    • Computers

SAS For Dummies


Author: Stephen McDaniel,Chris Hemedinger
Publisher: John Wiley & Sons
ISBN: 9781118044018
Category: Computers
Page: 408
View: 7662
Created in partnership with SAS, this book explores SAS, a business intelligence software that can be used in any business setting or enterprise for data delivery, reporting, data mining, forecasting, statistical analysis, and more SAS employee and technologist Stephen McDaniel combines real-world expertise and a friendly writing style to introduce readers to SAS basics Covers crucial topics such as getting various types of data into the software, producing reports, working with the data, basic SAS programming, macros, and working with SAS and databases

    • Computers

Getting Started with SQL

A Hands-On Approach for Beginners
Author: Thomas Nield
Publisher: "O'Reilly Media, Inc."
ISBN: 1491938560
Category: Computers
Page: 134
View: 4552
Businesses are gathering data today at exponential rates and yet few people know how to access it meaningfully. If you’re a business or IT professional, this short hands-on guide teaches you how to pull and transform data with SQL in significant ways. You will quickly master the fundamentals of SQL and learn how to create your own databases. Author Thomas Nield provides exercises throughout the book to help you practice your newfound SQL skills at home, without having to use a database server environment. Not only will you learn how to use key SQL statements to find and manipulate your data, but you’ll also discover how to efficiently design and manage databases to meet your needs. You’ll also learn how to: Explore relational databases, including lightweight and centralized models Use SQLite and SQLiteStudio to create lightweight databases in minutes Query and transform data in meaningful ways by using SELECT, WHERE, GROUP BY, and ORDER BY Join tables to get a more complete view of your business data Build your own tables and centralized databases by using normalized design principles Manage data by learning how to INSERT, DELETE, and UPDATE records

    • Computers

Microsoft SQL Server 2005 Reporting Services For Dummies


Author: Mark Robinson
Publisher: John Wiley & Sons
ISBN: 9780471758846
Category: Computers
Page: 436
View: 819
Find the right information and present it the right way Take full advantage of all SQL Server Reporting Services can do for you Without a way to interpret it, the data in your database just sits there doing nothing. Now you have help! This handy guide shows you how to retrieve data and create reports with the newest version of SQL Server Reporting Services, so you can deliver both hard copy and interactive, Web-based reports that tell your story. Discover how to Access information from different databases Build the right queries Choose the best report type Move from other reporting tools Deliver reports on demand Produce drill-down and drill-through reports