Using SQL

Description

A general introduction to stand-alone database applications explains step-by-step how to create and access databases using Structured Query Language. Discusses how to develop SQL applications embedded in dBASE and Oracle.

Get the book

Amazon.com

Search the book

eBay.com

Search the book

Similar books

• 

  Data Analysis Using SQL and Excel

  By Gordon S. Linoff

  This edition features the up-to-date information business managers and data analysts need. The book begins with the basics of SQL for data mining, Excel to present results, and simple ideas from statistics to understand your data.

• 

  Data Analysis Using SQL and Excel

  By Gordon S. Linoff

  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.

• 

  PROC SQL by Example: Using SQL within SAS

  By Howard Schreier

  This text is ideal for SAS programmers seeking to add PROC SQL to their SAS toolkits as well as SQL programmers striving to better integrate the SAS DATA step and SQL. This book is part of the SAS Press program.

• 

  Learn SQL Database Programming: Query and manipulate databases from popular relational database servers using SQL

  By Josephine Bush

  Starting with an overview of relational database management systems, this book will show you how to set up and use MySQL Workbench and design a database using practical examples.

• 

  SQL: Learn SQL (Using Mysql) in One Day and Learn It Well. SQL for Beginners with Hands-On Project.

  By Jamie Chan, Lcf Publishing

  In addition, as Richard Branson puts it: "The best way of learning about anything is by doing." Throughout the book, we'll be building a database together.

• 

  Data Analysis Using SQL and Excel

  By Gordon Linoff

  The book also discusses: How entity-relationship diagrams describe the structure of data Ways to use SQL to generate SQL queries Descriptive statistics, such as averages, p-values, and the chi-square test How to incorporate geographic ...

• 

  Pro VS 2005 Reporting using SQL Server and Crystal Reports

  By Rod Paddock, Kevin Goff

  The listing utilizes the methods in your base data access layer to return the result sets for the aging receivables report. Listing 5-8. Custom Data Access Classfor the Aging Receivables Report using System; using System.

• 

  Practical Guide to Using SQL in Oracle

  By Dr. Sikha Bagui, Dr. Richard Earp, Earp

  So, assume that the EmpN table now looks like this: EMPNAME EMPNO SUPEREMPNO --------------- ---------- ---------- Sam Miller 104 102 Susan Sommers 105 Kimmy Keebler 101 102 Patsy Cox 102 105 Mili Sinha 103 102 From this table we can ...

• 

  Data Mining and Statistical Analysis Using SQL

  By John Lovett, Robert P. Trueblood

  ... b) + ', [x])' EXEC(60) /* Obtain the difference */ UPDATE ##Compare SET [Diff] = [y]-[y_eq] /* Calculate the correlation coefficient */ SELECT (CorrCalc = (SELECT Sqrt{1.0 - (Var([Diff]) / War([y]))) FROM ##Compare) print ...

• 

  Microsoft SQL Server 2012 High-Performance T-SQL Using Window Functions

  By Itzik Ben-Gan

  Ideal whether you’re a database administrator or developer, this practical guide demonstrates ways to use more than a dozen T-SQL querying solutions to address common business tasks.