Xem 1-20 trên 1055 kết quả Using sql
  • Useful business analysis requires you to effectively transform data into actionable information. This book helps you use SQL and Excel to extract business information from relational databases and use that data to define business dimensions, store transactions about customers, produce results, and more. Each chapter explains when and why to perform a particular type of business analysis in order to obtain useful results, how to design and perform the analysis using SQL and Excel, and what the results should look like....

    pdf690p titatu_123 01-03-2013 38 19   Download

  • Using SQL Server In this section, you'll explore some of the tools you use to manage SQL Server. Specifically, you'll learn how to start and stop SQL Server

    pdf9p daisuphu 29-07-2010 59 14   Download

  • Using SQL SQL (pronounced sequel) is the standard language for accessing relational databases. As you'll see in this chapter, SQL is easy to learn and use

    pdf9p daisuphu 29-07-2010 43 4   Download

  • SQL For Dummies, 7th Edition, shows programmers and web developers how to use SQL to build relational databases and get valuable information from them. This book covers the core features of the SQL language. Topics covered include how to use SQL to structure a DBMS and implement a database design; secure a database; and retrieve information from a database. This edition will be revised to reflect the new enhancements of SQL/XML:2008.

    pdf434p possibletb 29-11-2012 56 24   Download

  • After completing this appendix, you should be able to do the following: Log in to SQL*Plus Edit SQL commands Format output using SQL*Plus commands Interact with script files

    ppt16p trinh02 28-01-2013 23 7   Download

  • Figure 3.6: Products where ProductName is like 'Cha%' The next SELECT statement uses the LIKE operator to retrieve products where the ProductName column

    pdf9p daisuphu 29-07-2010 36 4   Download

  • Figure 3.16: Using the DISTINCT keyword to retrieve distinct Country column values As you can see, the SELECT statement only displays Country column values that are unique: duplicate values are eliminated.

    pdf11p daisuphu 29-07-2010 44 3   Download

  • Removing Rows From a Table You use the DELETE statement to remove rows from a table. When removing a row, you specify the name of the table and the rows to delete using a WHERE clause

    pdf8p daisuphu 29-07-2010 46 3   Download

  • Learn to access Oracle databases through SQL statements and construct PL/SQL programs with guidance from Oracle expert, Jason Price. Published by Oracle Press, Oracle Database 11g SQL explains how to retrieve and modify database information, use SQL Plus and SQL Developer, work with database objects, write PL/SQL programs, and much more. Inside, you'll find in-depth coverage of the very latest SQL features and tools, performance optimization techniques, advanced queries, Java support, and XML. This book contains everything you need to master SQL....

    pdf690p thachnq 27-11-2009 1032 450   Download

  • Learn to: Create relational databases with powerful data retrieval capacity; Use SQL with XML and Access® 2010; Structure a database management system and implement database design; Work with all the core SQL features

    pdf467p cometome1991 07-06-2010 116 54   Download

  • SQL*Plus is an environment in which you can  Execute SQL statements to retrieve, modify, add, and remove data from database tables.  Format, perform calculations on, store, and print query results in the form of reports.  Issue SQL statements to create, alter, and remove database tables.  Create anonymous blocks, subprograms, database triggers using procedural language extension, PL/SQL. SQL*Plus has a variety of commands you need to use to execute subprograms, pass values in and out of PL/SQL blocks, and debug your code.

    pdf50p duypha 12-08-2009 188 45   Download

  • In just 24 sessions of one hour or less, you’ll learn how to use SQL to build effective databases, efficiently retrieve your data, and manage everything from performance to security! Using this book’s straightforward, step-by-step approach, you’ll learn hands-on through practical examples. Each lesson builds on what you’ve already learned, giving you a strong real-world foundation for success. The authors guide you from the absolute basics to advanced techniques—including views, transactions, Web data publishing, and even powerful SQL extensions for Oracle and Microsoft SQL Server...

    pdf492p btnghiaktvn 25-05-2011 84 35   Download

  • In the 20 years since the database language SQL was adopted as an international standard, and the 25 years since SQL database products appeared on the market, SQL has become the predominant language for storing, modifying, retrieving, and deleting data. Today, a significant portion of the world’s data—and the world’s economy—is tracked using SQL databases.

    pdf667p nghiasimon 22-09-2012 50 19   Download

  • QL For Dummies, 7th Edition, shows programmers and web developers how to use SQL to build relational databases and get valuable information from them. This book covers the core features of the SQL language. Topics covered include how to use SQL to structure a DBMS and implement a database design; secure a database; and retrieve information from a database. This edition will be revised to reflect the new enhancements of SQL/XML:2008.

    pdf467p caucaphung 01-02-2013 31 15   Download

  • Get ready for model-driven application development with SQL Server Modeling! This book covers Microsoft’s SQL Server Modeling (formerly known under the code name “Oslo”) in detail and contains the information you need to be successful with designing and implementing workflow modeling. Beginning SQL Server Modeling will help you gain a comprehensive understanding of how to apply DSLs and other modeling components in the development of SQL Server implementations.

    pdf257p caucaphung 02-02-2013 37 15   Download

  • ToyzUnlimited is a trendy toy store based in California. It buys toys from manufacturers, stocks them in its store and sells them for profits. ToyzUnlimited maintains the details of all branded toy products in a SQL Server 2005 database. To speed up the day-to-day tasks and operations related to the database, it has been decided to use SQL Server 2005 stored procedures for commonly performed tasks.

    pdf1p vudung75 20-04-2011 59 13   Download

  • Introduction Chapter 1: Introducing SQL CLR Chapter 2: Your First CLR Stored Procedure Chapter 3: SQL CLR Structure and Common Tasks Chapter 4: Creating SQL CLR Objects Chapter 5: Comparing T-SQL with Managed Code Chapter 6: Replacing Extended Stored Procedures, Functions, and Other T-SQL Objects Chapter 7: The .NET Framework’s Base Class Library Chapter 8: Using SQL CLR Stored Procedures in Your Applications Chapter 9: Handling Errors in CLR Stored Procedures Chapter 10: CLR Administration and Security Chapter 11: Case Study...

    pdf432p trasua_123 29-12-2012 36 13   Download

  • In this book, two of Microsoft’s leading consultants illustrate how to use SQL Server 2005 Business Intelligence (BI) technologies to solve real-world problems in markets ranging from retail and finance to healthcare. Drawing on extensive personal experience with Microsoft’s strategic customers, John C. Hancock and Roger Toren offer unprecedented insight into BI systems design and step-by-step best practices for implementation, deployment, and management.

    pdf439p bongbong_hong 25-12-2012 38 10   Download

  • Teach Yourself PL/SQL in 21 Days- P1: Welcome to Sams Teach Yourself PL/SQL in 21 Days, Second Edition. The fact that you purchased this book indicates that you have an interest in learning the PL/SQL language, which is Oracle’s relational database procedural programming language.

    pdf586p sakuraphuong 20-05-2013 38 10   Download

  • Contents at a Glance Foreword Preface Acknowledgements 1 Introduction to Oracle SQL 2 New Features of Oracle SQL 3 Oracle Database Architecture 4 The SELECT Statement 5 Filtering Rows 6 Sorting Rows 7 Operators, Conditions, and Pseudocolumns 8 Using SQL*Plus 9 Single-Row Functions 10 Joining Tables 11 Grouping and Summarizing Data 12 Subqueries 13 Unusual Query Types 14 Expressions 15 Data Manipulation Language (DML) 1

    pdf499p bongbong_hong 19-12-2012 27 8   Download

Đồng bộ tài khoản