Microsoft SQL Server 2012 A Beginners Guide 5/E

Microsoft SQL Server 2012 A Beginners Guide 5/E

<h4>Essential Microsoft SQL Server 2012 Skills Made Easy</h4> <p>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, <i>Microsoft SQL Server 2012: A Beginner's Guide, Fifth Edition</i> 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.</p> <ul> <li>Install, configure, and customize SQL Server 2012</li> <li>Create and modify database objects with Transact SQL statements</li> <li>Write stored procedures and user-defined functions</li> <li>Handle backup and recovery</li> <li>Automate administrative tasks</li> <li>Tune your database system for optimal performance, availability, and reliability</li> <li>Implement security measures using authentication, encryption, and authorization</li> <li>Work with SQL Server Analysis Services, SQL Server Reporting Services, and other business intelligence tools</li> <li>Store, display, and query XML documents</li> <li>Manage spatial data</li> <li>Query documents using MS Full-Text Search (FTS)</li> </ul>