Microsoft SQL Server 2012 a Beginners Guide 5/E (Revised)

Get up and running on Microsoft SQL Server 2012 in no time with help from this thoroughly revised, practical resource. Filled with real-world examples and hands-on exercises, Microsoft SQL Server 2012: A Beginner's Guide, Fifth Edition starts by explaining fundamental relational database system concepts. Then, you'll learn how to write Transact-SQL statements, execute simple and complex database queries, handle system administration and security, and use the powerful analysis, business intelligence, and reporting tools. XML, spatial data, and full-text search are also covered in this step-by-step tutorial.

• Install, configure, and customize SQL Server 2012
• Create and modify database objects with Transact SQL statements
• Write stored procedures and user-defined functions
• Handle backup and recovery
• Automate administrative tasks
• Tune your database system for optimal performance, availability, and reliability
• Implement security measures using authentication, encryption, and authorization
• Work with SQL Server Analysis Services, SQL Server Reporting Services, and other business intelligence tools
• Store, display, and query XML documents
• Manage spatial data
• Query documents using MS Full-Text Search (FTS)