Database Easy by Toth, Kalman

Database Easy (Paperback) (ISBN-13: 9781482593075)

Vendor: Kalman Toth
Product type: Books
Format: Paperback
$14.95
$14.95
$14.95
Subtotal: $14.95
Database Easy by Toth, Kalman

Database Easy

$14.95
Database Easy by Toth, Kalman

Database Easy

$14.95
Format: Paperback
Description
Description
x
Live the American dream! Earn from $100,000 to $200,000 as a database professional.Easy relational database design teach-by-practical-diagrams-&-examples book for software developers who are new to relational database and client/server technologies or who know some database design, and wish to refresh & expand their RDBMS design technology horizons. Proficiency in at least one computer programming language, Windows file system & Excel is assumed. Since the book is career advancement oriented, it has a number of 3NF database design examples with metadata explanations along with practical SQL queries (over 400 SELECT queries) and T-SQL scripts, 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 which is the basis for multi-dimensional OLAP cubes. The book teaches through vivid database diagrams and T-SQL queries 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. In addition to quick learning, the best way to master relational database design & T-SQL programming is to type the query in your own SQL Server Management Studio Query Editor, test it, examine it, change it and study it. Wouldn't it be easier just to copy & paste it? It would, but the learning value would diminish rapidly. The book was designed to be readable quickly 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 basic relational database design book likely to be sufficient for career advancement as a database developer.

Live Life Active, Agile, Brilliant, Healthy & Happy!

Author: Kalman Toth
ISBN-10: 1482593076
ISBN-13: 9781482593075
Publisher: Createspace Independent Publishing Platform
Language: English
Published: 02/20/2013
Pages: 300
Format: Paperback
Weight: 1.19lbs
Size: 9.69h x 7.44w x 0.63d
By Kalman Toth
By Kalman Toth
x
Kalman Toth has been working with relational database technology since 1990 . His relational database career since then includes database design, database development, database administration, OLAP architecture and Business Intelligence development. Applications included enterprise-level general ledger & financial accounting, bond funds auditing, stock market feeds processing, broker-dealer firm risk management, derivative instruments analytics, consumer ecommerce database management for online dating, personal finance, physical fitness, diet and health. He has designed over 20 databases. His MSDN forum participation in the Transact-SQL and SQL Server Tools was rewarded with the Microsoft Community Contributor award in 2011 and 2012. Kalman has a Master of Arts degree in Physics from Columbia University and a Master of Philosophy degree in Computing Science also from.

Recently Viewed Products