Beginner Database Design Using Microsoft SQL Server

Bog
  • Denne udgave
  • Bog, paperback
  • Engelsk
  • 314 sider

Beskrivelse

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 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.

Læs hele beskrivelsen
Detaljer
  • SprogEngelsk
  • Sidetal314
  • Udgivelsesdato17-09-2012
  • ISBN139781479333424
  • Forlag Createspace
  • FormatPaperback
  • Udgave0
Størrelse og vægt
  • Vægt562 g
  • Dybde1,6 cm
  • coffee cup img
    10 cm
    book img
    18,8 cm
    24,6 cm

    Findes i disse kategorier...

    Se andre, der handler om...

    Velkommen til Saxo – din danske boghandel

    Hos os kan du handle som gæst, Saxo-bruger eller Saxo-medlem – du bestemmer selv. Skulle du få brug for hjælp, sidder vores kundeservice-team klar ved både telefonerne og tasterne.

    Om medlemspriser hos Saxo

    For at købe bøger til medlemspris skal du være medlem af Saxo Premium, Saxo Shopping eller Saxo Ung. De første 7 dage er gratis for nye medlemmer. Medlemskabet fornyes automatisk og kan altid opsiges. Læs mere om fordelene ved vores forskellige medlemskaber her.

    Machine Name: SAXO082