The book focuses on installing, configuring, administering and developing databases using SQL Server 2014. Learn how to create a main database and its objects: tables, indexes, views, stored procedures and functions, triggers, etc. is Shown, the performance of image objects and their characteristics. Describes the data types, including XML, spatial, and user data. Given the syntax and semantics of Transact-SQL statements in the notation of Backus—Naur form and R-graphs. Considered in detail the characteristics and interactions of the transaction. Paid attention to backup and restore the database. During the creation of the sample database described examples of using data manipulation statements, triggers, stored procedures, etc. Source codes of the examples posted on the website of the publisher.