Toth, Kalman

Beginner database design & SQL programming using microsoft SQL server 2014 / Kalman Toth - [Place of publication not identifed] : [publisher not identified], c2014 - xxviii, 576 pages : illustrations ; 25 cm.

Includes index.

Chapter 1. SQL server sample and system databases -- Chapter 2. Installing SQL server 2014 -- Chapter 3. Structure of select statement -- Chapter 4. SQL server management studio -- Chapter 5. Basic concepts of client-server computing -- Chapter 6. Fundamentals of relational database design -- Chapter 7. Normal forms and database normalization -- Chapter 8 : Functional database design -- Chapter 9. Advanced database design concepts -- Chapter 10. New programming features in SS 2012 and 2014 -- Chapter 11. Joining tables with inner and outer JOINs -- Chapter 12. Basic SELECT statement syntax and examples -- Chapter 13 : Subqueries in SELECT statements -- Chapter 14. SELEC INTO table creation and population -- Chapter 15. Modify data - insert, update, delete and merge -- Chapter 16. The Magic of transact-SQL programming -- Chapter 17. Exporting and importing data.

Developers across the world face database issues daily. While immersed in procedural languages with loops, RDBMS forces them to think in terms of sets without loops.

9781499321739


DATABASE MANAGEMENT

QA 76.9 .T68 2014