Bøger

SQL for dummies (engelsk)


Detaljer


...

...

...

...

...

...

...

...

...

...

...

...


Beskrivelse


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.

Indhold

Seneste udgave, bog

Indhold: Part I: Basic Concepts: Relational Database Fundamentals ; SQL Fundamentals ; The Components of SQL. Part II: Using SQL to Build Databases: Building and Maintaining a Simple Database Structure ; Building a Multitable Relational Database. Part III: Storing and Retrieving Data: Manipulating Database Data ; Specifying Values ; Using Advanced SQL Value Expressions ; Zeroing In on the Data You Want ; Using Relational Operators ; Delving Deep with Nested Queries ; Recursive Queries. Part IV: Controlling Operations: Providing Database Security ; Protecting Data ; Using SQL within Applications. Part V: Taking SQL to the Real World: Accessing Data with ODBC and JDBC ; Operating on XML Data with SQL. Part VI: Advanced Topics: Stepping through a Dataset with Cursors ; Adding Procedural Capabilities with Persistent Stored Modules ; Handling Errors ; Triggers. Part VII: The Part of Tens: Ten Common Mistakes ; Ten Retrieval Tips


Tidsskrift

Artiklen er en del af

Artiklerne i  handler ofte om

Artikler med samme emner

Fra


Artikler

Alle registrerede artikler fordelt på udgivelser

...

...

...

...

...