Microsoft SQL Server 2012 Step by Step [Lingua inglese] - Brossura

Leblanc, Patrick

Brossura

ISBN 10: 0735663866 ISBN 13: 9780735663862

Casa editrice: Microsoft Press, 2013

Riassunto

Your hands-on, step-by-step guide to building applications with Microsoft® SQL Server® 2012

Teach yourself the programming fundamentals of SQL Server 2012-one step at a time. Ideal for beginning SQL Server database administrators and developers, this tutorial provides clear guidance and practical, learn-by-doing exercises for building database solutions that solve real-world business problems.

Discover how to:

• Install and work with core components and tools
• Create tables and index structures
• Manipulate and retrieve data
• Secure, manage, back up, and recover databases
• Apply techniques for building high-performing applications
• Use clustering, database mirroring, and log shipping

Su questo libro

L'autore:

Patrick LeBlanc is a Data Platform Technical Solution Professional at Microsoft, working directly with customers on the business value of SQL Server. He co-authored SharePoint 2010 Business Intelligence 24-Hour Trainer and Knight’s Microsoft Business Intelligence 24-Hour Trainer, and founded www.sqllunch.com, a website devoted to teaching SQL Server technologies.

Contenuti:

IntroductionGetting started with Microsoft SQL Server 2012Chapter 1: Overview of Microsoft SQL Server 2012Chapter 2: Installing, Configuring, and Upgrading Microsoft SQL Server 2012Chapter 3: Using SQL Server 2012 administration and development toolsDesigning databasesChapter 4: Designing SQL Server databasesChapter 5: Creating your first tableChapter 6: Building and maintaining indexesAdvanced database design topicsChapter 7: Table compressionChapter 8: Table partitioningChapter 9: Database snapshotsChapter 10: The SELECT statementUsing Transact-SQL (T-SQL)Chapter 11: Advanced data retrieval topicsChapter 12: Modifying dataChapter 13: Built-in scalar functionsCreating other database objectsChapter 14: Advanced T-SQL topicsChapter 15: ViewsChapter 16: User-defined functionsChapter 17: Stored proceduresChapter 18: Data manipulation triggersSQL Server replicationChapter 19: ReplicationDatabase maintenanceChapter 20: BackupsChapter 21: Managing and maintaining indexes and statisticsChapter 22: Maintenance plansDatabase managementChapter 23: SQL Server ProfilerChapter 24: Extended EventsChapter 25: SQL Server securityChapter 26: Resource GovernorChapter 27: SQL Server AgentChapter 28: Database MailChapter 29: Data definition triggersChapter 30: Dynamic management objectsHigh-availability solutionsChapter 31: AlwaysOnChapter 32: Log shippingAbout the Author

Su questa edizione

• Editore: Microsoft Press
• Data di pubblicazione: 2013
• ISBN 10: 0735663866
• ISBN 13: 9780735663862
• Rilegatura: Copertina flessibile
• Numero di pagine: 480