Interactive tutorial on SQL | SQL-tutorial.ru

			Content	Login

		SQL Problems and solutions S. I. Moiseenko

Русский

English

02:51

Last added:

Tags

ALL ANY ASCII AVG Battles C.J.Date Cartesian product CASE cast CHAR CHARINDEX COALESCE collation common table expressions comparison predicates CONVERT correlated subqueries COUNT CROSS JOIN CTE data type conversion DATEADD DATEDIFF DATENAME DATEPART DELETE DISTINCT DML DML exercises equi-join escape character EXCEPT exercise 10 exercise 11 exercise 17 exercise 2 exercise 23 exercise 39 exercise 56 exercise 57 exercise 59 exercise 6 exercise 60 exercise 7 exercise 8 EXISTS FROM FULL JOIN GROUP BY HAVING IDENTITY IN inner join INSERT INTERSECT ISNULL J.D.Ullman J.Widom join operations laptop LEFT LEFT OUTER JOIN LEN LIKE LOWER LTRIM Martin Gruber mistakes MySQL NULL numbering Oracle ORDER BY Outcomes OVER PARTITION BY PATINDEX PC PIVOT PostgreSQL predicates printer product Ranking functions recursive CTE REPLACE REPLICATE RIGHT RIGHT JOIN ROW_NUMBER select SQL Server STR string functions subquery SUBSTRING SUM tables join tips and solutions Transact-SQL type conversion UNION UNION ALL UNKNOWN UNPIVOT UPDATE UPPER varchar WHERE WITH упражнение 23

Развернуть всё

Свернуть всё

Content:

(1.1) What is this textbook devoted to?

(1.2) What is needed for work with the textbook?

(1.3) Useful tips on how to work with the textbook

(1.4) Terminology used and realization features

(1.5) Grateful acknowledgement

(Part I) Typical mistakes at the solution of SELECT statement exercises

(Chapter 1) Database "Computer firm"

(Chapter 2) Database «Recycled materials company»

(Chapter 3) Database «Ships»

(Chapter 4) Tips and solutions

(Part II) SQL data manipulation language

(Chapter 5.) SELECT statement

(Chapter 6.) Data modification statements

(Part III) Prepare for the second stage of testing

(Chapter 7) Transact-SQL string and datetime functions

(Chapter 8) Typical problems

(Part IV) New sql features

(Chapter 9) Ranking functions

(Chapter 10) PIVOT and UNPIVOT Operators

(Chapter 11) Common table expressions (CTE)

(Part V) Notes about data types

CHAR and VARCHAR

Appendix 1. Databases description

Appendix 2. Exercises list

©SQL-EX,2008 [Evolution] [Feedback] [About] [Links] [Team]
All right reserved.