Русский    English

Prepare for the second stage of testing

The exercises that we have considered earlier in Chapters 3-4, make up the initial stage (or the learning stage) of testing on a site. These are rather simple problems the  solutions of which, as a rule, do not require knowledge of features of realization. It means that the solutions practically can be received in the framework of Standard SQL-92.

On the second-stage challenges, solutions require knowledge of specific realization, for example, string functions or functions of treatment of date/time values.

Exercises of this stage are not considered in the book as results of their solutions on a site allow you to earn the certificate. Nevertheless, we consider necessary to acquaint the reader with specific features  SQL(Structured Query Language) is a database computer language designed for the retrieval and management of data in relational database management systems (RDBMS), database schema creation and modification, and database object access control management.SQL Server, and also with some algorithmic receptions which can be applied to the solution of exercises on a site as well as to decision of the problems often arising in practice.

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 CONSTRAINT CONVERT correlated subqueries COUNT CROSS APPLY CTE data type conversion data types database schema DATEADD DATEDIFF DATENAME DATEPART DATETIME date_time functions DDL DEFAULT DEFAULT VALUES DELETE DISTINCT DML duplicates edge equi-join EXCEPT exercise (-2) More tags
The book was updated
month ago
©SQL-EX,2008 [Evolution] [Feedback] [About] [Links] [Team]
All right reserved.