Treceți la conținutul principal

LIMBAJUL SQL

Table of Contents
Introduction 
1 Who Is the Teach Yourself SQL Book For?* 2 
DBMSs Covered in This Book * 2
Conventions Used in This Book *3
1 
Understanding SQL 5 
Database Basics *5 
What Is SQL? *.10 
Try It Yourself *.11 
Summary *12
2
 Retrieving Data 13 
The SELECT Statement *13 
Retrieving Individual Columns *14 
Retrieving Multiple Columns *16 
Retrieving All Columns *18 
Retrieving Distinct Rows *.19
 Limiting Results *20
 Using Comments *.23
 Summary *25
3 
Sorting Retrieved Data 27 
Sorting Data*27 
Sorting by Multiple Columns *29 
Sorting by Column Position *.30 
Specifying Sort Direction *.31 
Summary *34
4
 Filtering Data 35 
Using the WHERE Clause *35 
The WHERE Clause Operators *37 
Summary *42
5
 Advanced Data Filtering 43 
Combining WHERE Clauses *.43 
Using the IN Operator **47 
Using the NOT Operator *.49 
Summary *51
6 Using Wildcard Filtering 
53 Using the LIKE Operator *.53
 Tips for Using Wildcards *.60
 Summary *60
7 
Creating Calculated Fields 61 
Understanding Calculated Fields *61 
Concatenating Fields*62 
Performing Mathematical Calculations *68 
Summary *70
8 
Using Data Manipulation Functions 71 
Understanding Functions*.71
 Using Functions *73 
Summary *80
9 
Summarizing Data 81
 Using Aggregate Functions *.81 
Aggregates on Distinct Values *89
 Combining Aggregate Functions *90 
Summary *91
iv 
Sams Teach Yourself SQL in 10 Minutes
10 
Grouping Data 93 
Understanding Data Grouping *93 
Creating Groups *94 
Filtering Groups *96 Grouping and Sorting **99 
SELECT Clause Ordering *101 
Summary *.102
11 
Working with Subqueries 103 
Understanding Subqueries *103
 Filtering by Subquery**104 
Using Subqueries as Calculated Fields*108 
Summary *.111
12
 Joining Tables 113 
Understanding Joins **113 
Creating a Join *116 
Summary *.123
13 
Creating Advanced Joins 125
 Using Table Aliases*125 
Using Different Join Types *.126 
Using Joins with Aggregate Functions*132 
Using Joins and Join Conditions*134 
Summary *.135
14 
Combining Queries 137 
Understanding Combined Queries *137 
Creating Combined Queries*138 Summary *.144
vTable of Contents
15 
Inserting Data 145 
Understanding Data Insertion *145 
Copying from One Table to Another *.152 
Summary *.154
16 
Updating and Deleting Data 155 
Updating Data *155 
Deleting Data *157 
Guidelines for Updating and Deleting Data *160 
Summary *.161
17 
Creating and Manipulating Tables 163 
Creating Tables*163 
Updating Tables *.169 
Deleting Tables*171 
Renaming Tables *172 
Summary *.173
18
 Using Views 175
 Understanding Views**175
 Creating Views *179
 Summary *.185
19 
Working with Stored Procedures 187 
Understanding Stored Procedures *187
 Why to Use Stored Procedures *188 
Executing Stored Procedures *190 
Creating Stored Procedures*191 
Summary *.196
20 
Managing Transaction Processing 197
 Understanding Transaction Processing *197 
Controlling Transactions *199 
Summary *.204
vi 
Sams Teach Yourself SQL in 10 Minutes
21 
Using Cursors 205 
Understanding Cursors *.205 
Working with Cursors *207 
Summary *.211
22 
Understanding Advanced SQL Features 213 
Understanding Constraints *213 
Understanding Indexes *.220 
Understanding Triggers *.222 
Database Security *224 
Summary *.224

A Sample Table Scripts 225 
Understanding the Sample Tables *225 
Obtaining the Sample Tables *229

B Working in Popular Applications 233 
Using Apache Open Office Base*233 
Using Adobe ColdFusion *234 
Using IBM DB2*235 
Using MariaDB *235 
Using Microsoft Access*.235 
Using Microsoft ASP **236 
Using Microsoft ASP.NET *237 
Using Microsoft Query*238 
Using Microsoft SQL Server (including Microsoft SQL Server Express)*239 
Using MySQL *240 
Using Oracle*.241 
Using Oracle Express *241 
Using PHP *242
 Using PostgreSQL*243 
Using SQLite *244 
Configuring ODBC Data Sources *.245
viiTable of Contents

C 
SQL Statement Syntax 247
 ALTER TABLE *248 
COMMIT*248 
CREATE INDEX *248
 CREATE PROCEDURE**249
 CREATE TABLE *249 
CREATE VIEW *249 
DELETE *250
 DROP*250 
INSERT *250 
INSERT SELECT *.251 
ROLLBACK *251 
SELECT *252 
UPDATE *252

D 
Using SQL Datatypes 253 
String Datatypes*.254 
Numeric Datatypes *256 
Date and Time Datatypes *.257 
Binary Datatypes *258

E SQL Reserved Words 259
Index 265

Comentarii

Postări populare de pe acest blog

program principal cpp

#include "clasa.h" #include <stdio.h> #include <conio.h> #include <stdlib.h> #include <string.h> #define DELAY 9000000 void delay() { for(long i=0;i<DELAY;i++); } //constructor cu initializare de la tastatura BigInt::BigInt() {char x; signed char t[400]; int i; printf("\nNumarul cu semn "); do s=getche(); while((s!='+')&&(s!='-')); n=0; do {x=getche(); t[n]=x-'0'; n++; } while((x>='0')&&(x<='9')); n--; for(i=0;i<n;i++) nr[i]=t[n-i-1]; } //constructor cu initializare prin parametri BigInt::BigInt(char semn,signed char numar[],int dim) {int i; s=semn; n=dim; for(i=0;i<n;i++) nr[i]=numar[n-i-1]; } //transform un int negativ in pozitiv int BigInt::Pozitiv(int x) {int a,vb; a=0; vb=0; while(vb==0) if((x+a)==0) vb=1; else a=a+1; x=a; return x; } //constructor dintr-un nr int obisnuit BigInt::BigInt(int x) {int i; if(x>=0) s='+'…

NUMERE PRIME ALGORITM C++

// NUMERE PRIME ALGORITM C++//  reediting from scratch //on this page is just the study for a next algoritm for generating the parime nr series like Fibonnaci or ....if possibile

74111121313417374414124343447 if u know the red part you can generate the orange part
1 0 1 111112222 1 1 23

o aplicatie php localitati romania

//APLICATIA SE REFERA LA BAZA DE DATE SIRUTA

//dragtable.js


/* dragtable v1.0 June 26, 2008 Dan Vanderkam, http://danvk.org/dragtable/ http://code.google.com/p/dragtable/ \Bsortabledraggable\B Instructions: - Download this file - Add <script src="dragtable.js"></script> to your HTML. - Add class="draggable" to any table you might like to reorder. - Drag the headers around to reorder them. This is code was based on: - Stuart Langridge's SortTable (kryogenix.org/code/browser/sorttable) - Mike Hall's draggable class (http://www.brainjar.com/dhtml/drag/) - A discussion of permuting table columns on comp.lang.javascript Licensed under the MIT license. */ // Here's the notice from Mike Hall's draggable script: //***************************************************************************** // Do not remove this notice. // // Copyright 2001 by Mike Hall. // See http…