{"product_id":"9781449390891","title":"Learning SQL on SQL Server 2005","description":"\u003cp\u003eAnyone who interacts with today's modern databases needs to know SQL (Structured Query Language), the standard language for generating, manipulating, and retrieving database information. In recent years, the dramatic rise in the popularity of relational databases and multi-user databases has fueled a healthy demand for application developers and others who can write SQL code efficiently and correctly. \u003c\/p\u003e \u003cp\u003eIf you're new to databases, or need a SQL refresher, \u003ci\u003eLearning SQL on SQL Server 2005\u003c\/i\u003e is an ideal step-by-step introduction to this database query tool, with everything you need for programming SQL using Microsoft's SQL Server 2005-one of the most powerful and popular database engines used today. Plenty of books explain database theory. This guide lets you apply the theory as you learn SQL. You don't need prior database knowledge, or even prior computer knowledge.\u003c\/p\u003e \u003cp\u003eBased on a popular university-level course designed by authors Sikha Saha Bagui and Richard Walsh Earp, \u003ci\u003eLearning SQL on SQL Server 2005\u003c\/i\u003e starts with very simple SQL concepts, and slowly builds into more complex query development. Every topic, concept, and idea comes with examples of code and output, along with exercises to help you gain proficiency in SQL and SQL Server 2005. With this book, you'll learn:\u003c\/p\u003e\u003cul\u003e\n\u003cli\u003eBeginning SQL commands, such as how and where to type an SQL query, and how to create, populate, alter and delete tables\u003c\/li\u003e\n\u003cli\u003eHow to customize SQL Server 2005's settings and about SQL Server 2005's functions\u003c\/li\u003e\n\u003cli\u003eAbout joins, a common database mechanism for combining tables\u003c\/li\u003e\n\u003cli\u003eQuery development, the use of views and other derived structures, and simple set operations\u003c\/li\u003e\n\u003cli\u003eSubqueries, aggregate functions and correlated subqueries, as well as indexes and constraints that can be added to tables in SQL Server 2005\u003c\/li\u003e\n\u003c\/ul\u003e \u003cp\u003eWhether you're an undergraduate computer science or MIS student, a self-learner who has access to the new Microsoft database, or work for your company's IT department, \u003ci\u003eLearning SQL on SQL Server 2005\u003c\/i\u003e will get you up to speed on SQL in no time.\u003c\/p\u003e","brand":"O'Reilly Media, Incorporated","offers":[{"title":"Default Title","offer_id":47134761189616,"sku":"9781449390891","price":20.49,"currency_code":"USD","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0737\/7593\/9824\/files\/9781449390891_p0.jpg?v=1763831270","url":"https:\/\/shop-qa.barnesandnoble.com\/products\/9781449390891","provider":"Barnes \u0026 Noble (DEV)","version":"1.0","type":"link"}