April 2006
Beginner
352 pages
8h 24m
English
Content preview from Learning SQL on SQL Server 2005Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
O’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.I wanted to learn C and C++, but it didn't click for me until I picked up an O'Reilly book. When I went on the O’Reilly platform, I was astonished to find all the books there, plus live events and sandboxes so you could play around with the technology.I’ve been on the O’Reilly platform for more than eight years. I use a couple of learning platforms, but I'm on O'Reilly more than anybody else. When you're there, you start learning. I'm never disappointed.I'm always learning. So when I got on to O'Reilly, I was like a kid in a candy store. There are playlists. There are answers. There's on-demand training. It's worth its weight in gold, in terms of what it allows me to do.
Glossary of Terms
- Aggregate Function
A function that returns a result based on values of some attributes in multiple rows.
- Alias
A temporary intra-query substitute for a table name or column name.
- Alphanumeric
A data type that will accept a combination of characters as well as numbers.
- Anomaly
An undesirable consequence of a data modification.
- Attribute
Column in a table.
- Binary Intersection
An operation on two sets that generates unique values in common between two sets.
- Binary Set Difference
An operation on two sets that generates values in one set less those contained in another.
- Binary Union
An operation on two sets that generates all unique elements of both sets.
- Byte
A storage unit consisting of 8 bits.
- Candidate Key
A column (attribute, or group of columns) that identifies a unique row in a table. One of the candidate keys is chosen to be the primary key.
- Cartesian Product
A binary operation resulting in the combination of all rows of one table with all rows of another table.
- CHAR(size)
Data type that stores fixed-length character data, size characters long.
- Columns
Vertical slices of a table. Columns are defined to be one data type.
- Column Alias
A temporary column name within a query.
- Comments
Nonexecutable words included in SQL queries for documentation.
- Constant
An unvarying value used in a query.
- Constraint
A restriction placed on a value in a database used to increase data integrity.
- Correlated Subquery
A subquery in which the information in the subquery is referenced ...
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Read now
Unlock full access
More than 5,000 organizations count on O’Reilly
O’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.Julian F.
I wanted to learn C and C++, but it didn't click for me until I picked up an O'Reilly book. When I went on the O’Reilly platform, I was astonished to find all the books there, plus live events and sandboxes so you could play around with the technology.Addison B.
I’ve been on the O’Reilly platform for more than eight years. I use a couple of learning platforms, but I'm on O'Reilly more than anybody else. When you're there, you start learning. I'm never disappointed.Amir M.
I'm always learning. So when I got on to O'Reilly, I was like a kid in a candy store. There are playlists. There are answers. There's on-demand training. It's worth its weight in gold, in terms of what it allows me to do.