Naming Convention Comparison
by Sandra L. Emerson, Marcy Darnovsky, Judith S. Bowman
Practical SQL Handbook, The: Using SQL Variants, Fourth Edition
- Copyright
- List of Figures
- Foreword to the Fourth Edition
- Preface
- Introduction
- SQL and Relational Database Management
- Designing Databases
- Creating and Filling a Database
- Selecting Data from the Database
- Sorting Data and Other Selection Techniques
- Grouping Data and Reporting from It
- Joining Tables for Comprehensive Data Analysis
- Structuring Queries with Subqueries
- What Is a Subquery?
- How Do Subqueries Work?
- Joins or Subqueries?
- Subquery Rules
- Subqueries Returning Zero or More Values
- Subqueries Returning a Single Value
- Subqueries Testing Existence
- Subqueries in Multiple Levels of Nesting
- Subqueries in UPDATE, DELETE, and INSERT Statements
- Subqueries in FROM and SELECT Clauses
- Summary
- Creating and Using Views
- Security, Transactions, Performance, and Integrity
- Solving Business Problems
- Syntax Summary for the SQL Used in This Book
- Industry SQL Equivalents
- Glossary
- The bookbiz Sample Database
- Resources
- CD ROM Warranty
- Using the Practical SQL Handbook CD
Naming Convention Comparison
Figure B.1 shows how naming conventions compare in the five example systems. In the syntax comparison tables, these object names have been stripped down and reduced to their simplest forms.
Figure B.1. Naming Conventions
-
No Comment
..................Content has been hidden....................
You can't read the all page of ebook, please click here login for view all page.