技术细节
分类 |
Development software |
页数 |
832 pages |
作者 |
Dusan Petkovic |
Microsoft SQL Server 2012 A Beginners Guide 5/E
<b>Essential Microsoft SQL Server 2012 Skills Made Easy</b>
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)