Live the American dream! Earn from $100,000 to $200,000 as a database designer. Build a bright career in database design and SQL programming! Easy, light, tutorial-style Microsoft 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 prac...
Paperback: 312 pages
Publisher: CreateSpace Independent Publishing Platform (September 17, 2012)
Product Dimensions: 7.4 x 0.7 x 9.7 inches
Amazon Rank: 11278307
Format: PDF ePub Text TXT fb2 ebook
- Kalman Toth epub
- Kalman Toth ebooks
- 1479333425 pdf
- Computers and Technology epub ebooks
- 978-1479333424 epub
OK, I picked it up because it's free. But I found this was a pretty solid introduction to SQL 2012, with a small amount of database theory thrown in for good measure. If you want to know what's changed in the latest release of SQL Server, this text...
n 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.