Introducing SQL Server (eBook)
XXIII, 388 Seiten
Apress (Verlag)
978-1-4842-1419-0 (ISBN)
Do you quake at the sight of a SELECT statement? Start to shiver when people start talking about tables and rows? Fear not, Introducing SQL Server is here to rescue you. The book focuses on the knowledge and skills needed to begin your journey toward becoming a solid and competent SQL Server professional and database programmer. You'll learn the core concepts of SQL Server, from installing the software to executing and profiling queries.
Introducing SQL Server is aimed at SQL Server newcomers as well as at those wanting to improve their database skills. You'll put a comprehensive database together as you work through the book. You will create tables and learn to use constraints; create reusable functions and stored procedures; and even learn how indexes work and what they bring in terms of increased performance. Introducing SQL Server shows you that databases don't need to be difficult.
• Teaches you how to build a SQL Server database from scratch
• Takes a tutorial-based approach, with each chapter building on the last
• Covers what you need to know for common SQL Server development tasks
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.
Introducing SQL Server is a fast and easy introduction to SQL Server and the world of relational databases. You'll learn how databases work and how to use the T-SQL language by practicing on one of the most widely-used and powerful database engines in the corporate world: Microsoft SQL Server.Do you quake at the sight of a SELECT statement? Start to shiver when people start talking about tables and rows? Fear not, Introducing SQL Server is here to rescue you. The book focuses on the knowledge and skills needed to begin your journey toward becoming a solid and competent SQL Server professional and database programmer. You'll learn the core concepts of SQL Server, from installing the software to executing and profiling queries.Introducing SQL Server is aimed at SQL Server newcomers as well as at those wanting to improve their database skills. You'll put a comprehensive database together as you work through the book. You will create tables and learn to use constraints; create reusable functions and stored procedures; and even learn how indexes work and what they bring in terms of increased performance. Introducing SQL Server shows you that databases don't need to be difficult. * Teaches you how to build a SQL Server database from scratch* Takes a tutorial-based approach, with each chapter building on the last* Covers what you need to know for common SQL Server development tasks
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.
Chapter 1: What is SQL Server?Chapter 2: Obtaining and Installing SQL ServerChapter 3: Database BasicsChapter 4: TablesChapter 5: Putting Good Tables TogetherChapter 6: Automating Deployment with SQLCMDChapter 7: NULLs and Table ConstraintsChapter 8: Inserts, Updates, and DeletesChapter 9: Bulk Inserting DataChapter 10: Creating Data Import ScriptsChapter 11: The SELECT StatementChapter 12: Joining TablesChapter 13: ViewsChapter 14: IndexesChapter 15: TransactionsChapter 16: FunctionsChapter 17: Table-Valued FunctionsChapter 18: Stored Procedures – Part 1Chapter 19: Stored Procedures – Part 2Chapter 20: Bits and PiecesAppendix A: SQL Data TypesAppendix B: GlossaryAppendix C: Common SQL Server System ObjectsAppendix D: Exercises
| Erscheint lt. Verlag | 30.9.2015 |
|---|---|
| Zusatzinfo | XXIII, 388 p. 282 illus. |
| Verlagsort | Berkeley |
| Sprache | englisch |
| Themenwelt | Informatik ► Datenbanken ► SQL Server |
| ISBN-10 | 1-4842-1419-6 / 1484214196 |
| ISBN-13 | 978-1-4842-1419-0 / 9781484214190 |
| Haben Sie eine Frage zum Produkt? |
PDF (Wasserzeichen)Größe: 21,2 MB
DRM: Digitales Wasserzeichen
Dieses eBook enthält ein digitales Wasserzeichen und ist damit für Sie personalisiert. Bei einer missbräuchlichen Weitergabe des eBooks an Dritte ist eine Rückverfolgung an die Quelle möglich.
Dateiformat: PDF (Portable Document Format)
Mit einem festen Seitenlayout eignet sich die PDF besonders für Fachbücher mit Spalten, Tabellen und Abbildungen. Eine PDF kann auf fast allen Geräten angezeigt werden, ist aber für kleine Displays (Smartphone, eReader) nur eingeschränkt geeignet.
Systemvoraussetzungen:
PC/Mac: Mit einem PC oder Mac können Sie dieses eBook lesen. Sie benötigen dafür einen PDF-Viewer - z.B. den Adobe Reader oder Adobe Digital Editions.
eReader: Dieses eBook kann mit (fast) allen eBook-Readern gelesen werden. Mit dem amazon-Kindle ist es aber nicht kompatibel.
Smartphone/Tablet: Egal ob Apple oder Android, dieses eBook können Sie lesen. Sie benötigen dafür einen PDF-Viewer - z.B. die kostenlose Adobe Digital Editions-App.
Buying eBooks from abroad
For tax law reasons we can sell eBooks just within Germany and Switzerland. Regrettably we cannot fulfill eBook-orders from other countries.
aus dem Bereich
