Mike Mcquillan

Introducing SQL Server (eBook, PDF)

• Format: PDF

Produktbeschreibung

Introducing SQL Server does exactly that; it introduces SQL Server. It concentrates on the core skills professionals need to be successful with SQL Server, using a holistic approach to show how the various parts of SQL Server complement each other. The book is a short and easy read - unintimidating yet sure to please. It avoids the overly-deep approach of other "beginner" books on the topic in favor of getting across what really matters in as short a time as possible.

---

Dieser Download kann aus rechtlichen Gründen nur mit Rechnungsadresse in A, B, BG, CY, CZ, D, DK, EW, E, FIN, F, GR, HR, H, IRL, I, LT, L, LR, M, NL, PL, P, R, S, SLO, SK ausgeliefert werden.

Produktdetails

• Verlag: Apress
• Seitenzahl: 388
• Erscheinungstermin: 30. September 2015
• Englisch
• ISBN-13: 9781484214190
• Artikelnr.: 43909114

Autorenporträt

Mike McQuillan is a software and database specialist who lives with his wife and daughter in the United Kingdom. Mike is a polyglot programmer who began messing around with computers in the 1980s, firstly with an Atari 800XL and then a Sinclair Spectrum. He took up databases in the 1990s, and quickly fell in love with SQL. He's been working with SQL Server since version 7, and is a SQL Server MCSA. When he's not tinkering with computers, Mike enjoys taking the family on walks around Cheshire with the family pups, Dolly and Bertie.

Inhaltsangabe

1: What is SQL Server?.-2: Obtaining and Installing SQL Server.-3: Database Basics.-4: Tables.-5: Putting Good Tables Together.-6: Automating Deployment with SQLCMD.-7: NULLs and Table Constraints.-8: Inserts, Updates, and Deletes.-9: Bulk Inserting Data.-10: Creating Data Import Scripts.-11: The SELECT Statement.-12: Joining Tables.-13: Views.-14: Indexes.-15: Transactions.-16: Functions.-17: Table-Valued Functions.-18: Stored Procedures - Part 1.-19: Stored Procedures - Part 2.-20: Bits and Pieces.-Appendix A: SQL Data Types.-Appendix B: Glossary.-

Appendix C: Common SQL Server System Objects.-Appendix D: Exercises