{"product_id":"9781484214190","title":"Introducing SQL Server","description":"\u003cp\u003e\u003cem\u003eIntroducing SQL Server\u003c\/em\u003e 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. \u003c\/p\u003e\u003cp\u003eDo you quake at the sight of a SELECT statement? Start to shiver when people start talking about tables and rows? Fear not, \u003cem\u003eIntroducing SQL Server\u003c\/em\u003e 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.\u003c\/p\u003e\u003cp\u003e\u003cem\u003eIntroducing SQL Server\u003c\/em\u003e 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. \u003cem\u003eIntroducing SQL Server\u003c\/em\u003e shows you that databases don’t need to be difficult. \u003c\/p\u003e\u003cul\u003e\n\u003cli\u003eTeaches you how to build a SQL Server database from scratch\u003c\/li\u003e\n\u003cli\u003eTakes a tutorial-based approach, with each chapter building on the last\u003c\/li\u003e\n\u003cli\u003eCovers what you need to know for common SQL Server development tasks\u003c\/li\u003e\n\u003c\/ul\u003e\u003cp\u003e \u003c\/p\u003e\u003cp\u003e \u003c\/p\u003eWhat you’ll learn\u003cul\u003e\n\u003cli\u003eInstall SQL Server and customize your system\u003c\/li\u003e\n\u003cli\u003eBuild databases and table\u003c\/li\u003e\n\u003cli\u003eBecome conversant with the T-SQL language\u003c\/li\u003e\n\u003cli\u003eImport data using text files and T-SQL\u003c\/li\u003e\n\u003cli\u003eProgram in T-SQL, creating stored procedures and functions\u003c\/li\u003e\n\u003cli\u003eAdminister SQL Server at a basic level, including query and index management\u003c\/li\u003e\n\u003c\/ul\u003eWho this book is for      \u003cp\u003e     \u003cem\u003eIntroducing SQL Server \u003c\/em\u003eis for anybody who wants to learn how databases are put together in Microsoft SQL Server. It’s especially helpful to database newcomers, software developers who want to improve their SQL Server knowledge, and those whose SQL knowledge has lapsed over time. \u003cem\u003eIntroducing SQL Server’s \u003c\/em\u003eunique tutorial-led approach makes it a great choice for those who enjoy learning by doing. It’s also a great reference book to keep on your desk.      \u003c\/p\u003e     Table of Contents\u003cp\u003eChapter 1: What is SQL Server?\u003c\/p\u003e\u003cp\u003eChapter 2: Obtaining and Installing SQL Server\u003c\/p\u003e\u003cp\u003eChapter 3: Database Basics\u003c\/p\u003e\u003cp\u003eChapter 4: Tables\u003c\/p\u003e\u003cp\u003eChapter 5: Putting Good Tables Together\u003c\/p\u003e\u003cp\u003eChapter 6: Automating Deployment with SQLCMD\u003c\/p\u003e\u003cp\u003eChapter 7: NULLs and Table Constraints\u003c\/p\u003e\u003cp\u003eChapter 8: Inserts, Updates, and Deletes\u003c\/p\u003e\u003cp\u003eChapter 9: Bulk Inserting Data\u003c\/p\u003e\u003cp\u003eChapter 10: Creating Data Import Scripts\u003c\/p\u003e\u003cp\u003eChapter 11: The SELECT Statement\u003c\/p\u003e\u003cp\u003eChapter 12: Joining Tables\u003c\/p\u003e\u003cp\u003eChapter 13: Views\u003c\/p\u003e\u003cp\u003eChapter 14: Indexes\u003c\/p\u003e\u003cp\u003eChapter 15: Transactions\u003c\/p\u003e\u003cp\u003eChapter 16: Functions\u003c\/p\u003e\u003cp\u003eChapter 17: Table-Valued Functions\u003c\/p\u003e\u003cp\u003eChapter 18: Stored Procedures – Part 1\u003c\/p\u003e\u003cp\u003eChapter 19: Stored Procedures – Part 2\u003c\/p\u003e\u003cp\u003eChapter 20: Bits and Pieces\u003c\/p\u003e\u003cp\u003eChapter 21: Appendix A: SQL Data Types\u003c\/p\u003e\u003cp\u003eChapter 22: Appendix B: Glossary\u003c\/p\u003e\u003cp\u003eChapter 23: Appendix C: Common SQL Server System Objects\u003c\/p\u003e\u003cp\u003eChapter 24: Appendix D: Exercises\u003c\/p\u003e","brand":"Apress","offers":[{"title":"Default Title","offer_id":47182393147632,"sku":"9781484214190","price":39.99,"currency_code":"USD","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0737\/7593\/9824\/files\/9781484214190_p0.jpg?v=1763632538","url":"https:\/\/shop-qa.barnesandnoble.com\/products\/9781484214190","provider":"Barnes \u0026 Noble (DEV)","version":"1.0","type":"link"}