SQL For Dummies

(0) Donner la première évaluation
CHF 28.00
Download est disponible immédiatement
eBook (pdf)
Informations sur les eBooks
Les eBooks conviennent également aux appareils mobiles (voir les instructions).
Les eBooks d'Ex Libris sont protégés contre la copie par ADOBE DRM: apprenez-en plus.
Pour plus d'informations, cliquez ici.

Description

Get ready to make SQL easy! Updated for the latest version of SQL, the new edition of this perennial bestseller shows programmers and web developers how to use SQL to build relational databases and get valuable information from them. Covering everything you need to know to make working with SQL easier than ever, topics include how to use SQL to structure a DBMS and implement a database design; secure a database; and retrieve information from a database; and much more. SQL is the international standard database language used to create, access, manipulate, maintain, and store information in relational database management systems (DBMS) such as Access, Oracle, SQL Server, and MySQL. SQL adds powerful data manipulation and retrieval capabilities to conventional languages--and this book shows you how to harness the core element of relational databases with ease. * Server platform that gives you choices of development languages, data types, on-premises or cloud, and operating systems * Find great examples on the use of temporal data * Jump right in--without previous knowledge of database programming or SQL As database-driven websites continue to grow in popularity--and complexity--SQL For Dummies is the easy-to-understand, go-to resource you need to use it seamlessly.



Auteur

Allen G. Taylor is a 30-year veteran of the computer industry and the author of over 40 books, including SQL For Dummies and Crystal Reports For Dummies. He lectures nationally on databases, innovation, and entrepreneurship. He also teaches database development internationally through a leading online education provider.

Texte du rabat

  • Learn all the features in the latest version of SQL
  • Build a relational database and create a management system
  • Secure and protect your database from corruption

Get ready to make SQL easy

Updated for the latest version of SQL, the new edition of this perennial bestseller shows you how to use SQL to build relational databases and extract valuable information from them. Covering everything you need to know to make working with SQL easier than ever, topics include how to use SQL to structure a DBMS and implement a database design; secure a database; retrieve information from a database; and much more.??As database-driven websites continue to grow in popularityand complexitySQL For Dummies is the easy-to-understand, go-to resource you need to use it seamlessly.

Inside...

  • What SQL is and isn't
  • Use SQL to build databases
  • Build a multi-table relational database
  • Manipulate database data
  • Use advanced value expressions
  • Zero in on the data you want
  • Use relational operators
  • Provide database security


Contenu

Introduction 1

About This Book 1

Foolish Assumptions 2

Icons Used in This Book 2

Beyond the Book 3

Where to Go from Here 3

Part 1: Getting Started with SQL 5

Chapter 1: Relational Database Fundamentals 7

Keeping Track of Things 8

What Is a Database? 9

Database Size and Complexity 10

What Is a Database Management System? 10

Flat Files 12

Database Models 13

Database Design Considerations 20

Chapter 2: SQL Fundamentals 23

What SQL Is and Isn't 23

A (Very) Little History 25

SQL Statements 26

Reserved Words 28

Data Types 28

Null Values 49

Constraints 50

Using SQL in a Client/Server System 50

Using SQL on the Internet or an Intranet 52

Chapter 3: The Components of SQL 55

Data Definition Language 56

Data Manipulation Language 68

Data Control Language 76

Part 2: Using SQL to Build Databases 83

Chapter 4: Building and Maintaining a Simple Database Structure 85

Using a RAD Tool to Build a Simple Database 86

Building POWER with SQL's DDL 98

Portability Considerations 107

Chapter 5: Building a Multi-table Relational Database 109

Designing a Database 110

Working with Indexes 119

Maintaining Data Integrity 122

Normalizing the Database 134

Part 3: Storing and Retrieving Data 141

Chapter 6: Manipulating Database Data 143

Retrieving Data 144

Creating Views 145

Updating Views 149

Adding New Data 150

Chapter 7: Handling Temporal Data 163

Understanding Times and Periods 164

Working with Application-Time Period Tables 165

Working with System-Versioned Tables 171

Tracking Even More Time Data with Bitemporal Tables 175

Formatting and Parsing Dates and Times 176

Chapter 8: Specifying Values 179

Values 179

Value Expressions 186

Functions 189

Chapter 9: Using Advanced SQL Value Expressions 209

CASE Conditional Expressions 210

CAST Data-Type Conversions 217

Row Value Expressions 221

Chapter 10: Zeroing In on the Data You Want 223

Modifying Clauses 224

FROM Clauses 225

WHERE Clauses 226

Logical Connectives 243

GROUP BY Clauses 245

HAVING Clauses 247

ORDER BY Clauses 248

Limited FETCH 250

Peering through a Window to Create a Result Set 251

Chapter 11: Using Relational Operators 259

UNION 259

INTERSECT 262

EXCEPT 264

Join Operators 265

ON versus WHERE 282

Chapter 12: Delving Deep with Nested Queries 283

What Subqueries Do 285

Chapter 13: Recursive Queries 303

What Is Recursion? 303

What Is a Recursive Query? 306

Where Might You Use a Recursive Query? 306

Where Else Might You Use a Recursive Query? 311

Part 4: Controlling Operations 313

Chapter 14: Providing Database Security 315

The SQL Data Control Language 316

User Access Levels 316

Granting Privileges to Users 318

Granting Privileges across Levels 325

Granting the Power to Grant Privileges 327

Afficher plus

Détails sur le produit

Titre
SQL For Dummies
Auteur
EAN
9781119527084
Format
eBook (pdf)
Producteur
For Dummies
Genre
Langages de programmation
Parution
14.11.2018
Protection contre la copie numérique
Adobe DRM
Taille de fichier
6.22 MB
Nombre de pages
512
Afficher plus
Les clients ayant acheté cet article ont également acheté :