Beginner Database Design Using Microsoft SQL Server

Easy, light, tutorial-style relational database design teach-by-practical-diagrams-&-examples book for developers, programmers, systems analysts and project managers who are new to relational database and client/server technologies. Basic, yet practical design methods for database developers, database designers and database administrators (DBA), who know some SQL programming and database design, and who wish to refresh & expand their RDBMS design technology horizons. Familiarity with at least one computer programming language, Windows file system & Excel is assumed. Since the book is career advancement oriented, it has a great number of 3NF database design examples along with practical SQL queries, plenty to learn indeed. Great emphasis is placed on explaining the FOREIGN KEY - PRIMARY KEY constraints among tables, the connections which make the collection of individual tables a database. The database diagrams and queries are based on historic and current SQL Server sample databases: pubs (PRIMARY KEYs 9, FOREIGN KEYs 10) , Northwind (PRIMARY KEYs 13, FOREIGN KEYs 13) and the latest AdventureWorks series. Among them: AdventureWorks, AdventureWorks2008, AdventureWorks2012 (PRIMARY KEYs 71, FOREIGN KEYs 90), & AdventureWorksDW2012 (PRIMARY KEYs 27, FOREIGN KEYs 44). The last one is a data warehouse database. The book teaches through vivid database diagrams how to think in terms of sets at a very high level, focusing on set-based operations instead of loops like in procedural programming languages. The best way to master database design is to practice it by creating small database designs based on the samples. You need to feel relational database design in your DNA. The book was designed to be readable in any environment, even on the beach laptop around or no laptop in sight at all. All queries are followed by results row count and /or full/partial results listing in tabular (grid) format. Screenshots are used when dealing with GUI tools such as SQL Server Management Studio. Mastery of the database design book likely to be sufficient for career advancement as a database designer.