Русский    English


If you want to know how to get data from the database, but you do not know what to begin with, then this book is intended for you. If you are not familiar with SQL language or even if you are a database specialist, then we hope that it will be of interest for you to test your knowledge level.

The goal of this book is quick study of SQL language. In this particular case «quick» does not mean «superficial». To the contrary, leaving alone many aspects of the language, I try to give thorough understanding of logical structure of data and, as a result, to give the idea of correct form of query taking into account structure. On top of that, we strongly believe, that reading of this book will contribute to understanding of the problems, which are outside the scope of this work.

Bookmark and Share
aggregate functions Airport ALL AND AS keyword ASCII AVG Battles Bezhaev Bismarck C.J.Date calculated columns Cartesian product CASE cast CHAR CHARINDEX Chebykin check constraint classes COALESCE common table expressions comparison predicates Computer firm CONVERT correlated subqueries COUNT CROSS APPLY CTE data type conversion data types database schema date/time functions DATEADD DATEDIFF DATENAME DATEPART DATETIME DDL DEFAULT DEFAULT VALUES DELETE DISTINCT DML duplicates EXCEPT exercise (-2) exercise 19 exercise 23 exercise 32 More tags
The book was updated
month ago
©SQL-EX,2008 [Evolution] [Feedback] [About] [Links] [Team]
All right reserved.
Rambler's Top100