Beginner database design & SQL programming using microsoft SQL server 2014 / Kalman Toth

By: Toth, Kalman [author]Material type: TextTextPublication details: [Place of publication not identified] : [publisher not identified], c2014Description: xxviii, 576 pages : illustrations ; 25 cmISBN: 9781499321739Subject(s): DATABASE MANAGEMENT | SQL SERVERLOC classification: QA 76.9 .T68 2014
Contents:
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.
Summary: 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.
Item type: Books
Tags from this library: No tags from this library for this title. Log in to add tags.
    Average rating: 0.0 (0 votes)
Item type Current library Home library Collection Shelving location Call number Copy number Status Date due Barcode
Books Books LRC - Graduate Studies
National University - Manila
Gen. Ed. - CCIT General Circulation GC QA 76.9 .T68 2014 (Browse shelf (Opens below)) c.1 Available NULIB000013111

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.

There are no comments on this title.

to post a comment.

© 2021 NU LRC. All rights reserved.Privacy Policy I Powered by: KOHA