Books

SQL for dummies (engelsk)


Details


...

...

...

...

...

...

...

...

...

...

...

...


Description


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.

Content

Latest edition, 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


Periodica

The article is a part of

The articles in  are frequently about

Articles with same topics

In


Articles

All registered articles grouped by issue

...

...

...

...

...