Index
C
Classes
user-defined data types as
410Common table expressions (CTEs)
244–248CREATE TEMPORARY TABLE
243D
Date and time manipulation
Data modification
copying rows from another table
199–200Divide (relational algebra)
61–63E
Entity relationship diagrams (ERDs)
,
392–397I
Intersect (relational algebra)
59–61J
Join (relational algebra)
Join (in WHERE clause)
replacing with uncorrelated subquery
125–130JOIN (SQL command)
replacing with uncorrelated subquery
125–130M
Many-to-many relationships
13–15Modifying table structure
O
Object-oriented databases
390Object-oriented paradigm
versus relational data model
384–389Object-relational data model
entity-relationship diagrams for
392–397One-to-many relationships
11–13One-to-one relationships
10–11Operators
<= (less than or equal to)
86–88>= (greater than or equal to)
86–88P
Product (relational algebra)
42–45R
Relational data model
referential integrity
16–18versus object-oriented data model
382–389Relationship operators
88–86Renaming table elements
258S
SELECT (SQL command)
changing data types with CAST
167–169common table expressions (CTEs) for
244–248removing duplicate rows
80–82Select (relational algebra)
SQL
standard conformance
67–69U
Union (relational algebra)
37–38User-defined data types (UDTs)
W
WHERE clause
complex predicates for
97–98logical operators for
88–90operator prececdence
91–92primary key expressions
96–97relationship operators for
86–88
..................Content has been hidden....................
You can't read the all page of ebook, please click
here login for view all page.