Need to Return Your Textbook Rental?
Beginning SQL Server 2012 for Developers and over one million other books are available for Amazon Kindle. Learn more

Sorry, this item is not available in
Image not available for
Color:
Image not available

To view this video download Flash Player

 


or
Sign in to turn on 1-Click ordering
Sell Us Your Item
For a $15.21 Gift Card
Trade in
More Buying Choices
Have one to sell? Sell yours here
Start reading Beginning SQL Server 2012 for Developers on your Kindle in under a minute.

Don't have a Kindle? Get your Kindle here, or download a FREE Kindle Reading App.

Beginning SQL Server 2012 for Developers (Expert's Voice SQL Server) [Paperback]

Robin Dewson
5.0 out of 5 stars  See all reviews (2 customer reviews)

Buy New
$34.41 & FREE Shipping on orders over $35. Details
Rent
$26.50
In Stock.
Ships from and sold by Amazon.com. Gift-wrap available.
In Stock.
Want it Monday, July 14? Choose One-Day Shipping at checkout. Details
Free Two-Day Shipping for College Students with Amazon Student

Formats

Amazon Price New from Used from
Kindle Edition $22.99  
Paperback $34.41  
Shop the new tech.book(store)
New! Introducing the tech.book(store), a hub for Software Developers and Architects, Networking Administrators, TPMs, and other technology professionals to find highly-rated and highly-relevant career resources. Shop books on programming and big data, or read this week's blog posts by authors and thought-leaders in the tech industry. > Shop now

Book Description

April 22, 2012 1430237503 978-1430237501 3

Beginning SQL Server 2012 for Developers is the perfect book for developers new to SQL Server and planning to create and deploy applications against Microsoft’s market-leading database system for the Windows platform. Now in its third edition, the book is enhanced to cover the very latest developments in SQL Server 2012.

Also new in the book is coverage of the no-cost Express Edition. Whether you have no knowledge of databases, or have knowledge of desktop databases such as Microsoft Access, or even come from another brand such as Oracle Database, Beginning SQL Server 2012 for Developers provides the insights to get up and running with SQL Server 2012.

Within the book, there are plenty of examples of tasks that developers routinely perform. You’ll learn to create tables and indexes, and best practices for securing your valuable data. You’ll learn design tradeoffs and find out how to make sound decisions resulting in scalable databases and maintainable code.

Beginning SQL Server 2012 for Developers takes you through the entire database development process, from installing the software to creating a database to writing the code to connect to that database and move data in and out. By the end of the book, you’ll be able to design and create solid and reliable database solutions using SQL Server 2012.

  • Takes you through the entire database application development lifecycle
  • Includes brand new coverage of SQL Server 2012 features
  • Introduces the freely-available Express Edition

What you’ll learn

  • How to install SQL Server 2012
  • How to build a database application from start to finish
  • How to create tables and indices to manage your data
  • How to write stored code to execute directly in the database server
  • How to back up, recover, and otherwise maintain your database
  • How to connect to your database from client languages such as C# and VB .NET

Who this book is for

Beginning SQL Server 2012 for Developers is ideal for developers starting out with SQL Server 2012. There is no prerequisite background in developing database applications. Developers from other platforms and those brand new to database programming alike will find in Beginning SQL Server 2012 for Developers an excellent introduction to using and programming Microsoft’s database platform.

Table of Contents

  1. Overview and Installation
  2. SQL Server Management Studio
  3. Database Design and Creation
  4. Security and Compliance
  5. Defining Tables
  6. Creating Indexes and Database Diagramming
  7. Database Backups and Recovery
  8. Database Maintenance
  9. Inserting and Deleting Data
  10. Selecting and Updating Data 
  11. Building a View
  12. Stored Procedures, Functions, and Security 
  13. Essentials for Effective Coding
  14. Advanced T-SQL
  15. Triggers
  16. Connecting from Client Code

Frequently Bought Together

Beginning SQL Server 2012 for Developers (Expert's Voice SQL Server) + Microsoft SQL Server 2012 T-SQL Fundamentals (Developer Reference)
Price for both: $64.78

Buy the selected items together

Customers Who Bought This Item Also Bought


Editorial Reviews

About the Author

Robin Dewson has been hooked on programming ever since he bought his first computer, a Sinclair ZX80, in 1980. He has been working with SQL Server since version 6.5 and Visual Basic since version 5. Robin is a consultant mainly in the city of London, where he has been for nearly eight years. He also has been developing a rugby-related website as well as maintaining his own site at Fat-Belly.com.

Product Details

  • Series: Expert's Voice SQL Server
  • Paperback: 720 pages
  • Publisher: Apress; 3 edition (April 22, 2012)
  • Language: English
  • ISBN-10: 1430237503
  • ISBN-13: 978-1430237501
  • Product Dimensions: 9.2 x 7.5 x 1.7 inches
  • Shipping Weight: 2.8 pounds (View shipping rates and policies)
  • Average Customer Review: 5.0 out of 5 stars  See all reviews (2 customer reviews)
  • Amazon Best Sellers Rank: #106,085 in Books (See Top 100 in Books)

More About the Author

I grew up in Symington in Lanarkshire where my mum and dad had a local post office and grocers. I discovered my interest in computers through the Sinclair ZX80 whilst still at school and the interest was increased on a visit to Glasgow University where I saw a Commodore Pet in action. Thanks solely to my mother and father who trawled the papers looking for jobs and colleges, I ended up at Motherwell Technical College where I gained an SOND in Computer Data Processing.

Having studied at Motherwell Technical College as it was then named, just across the road from Fir Park football ground home of Motherwell FC, including day release at Ravesncraig Steel woorks, I then moved to two years at the Scottish College of Textiles (S.C.O.T) in Galashiels. Although a textile college this was one of the best colleges for computing due to the small class sizes and the great facilities there. At S.C.O.T I gained further COBOL experience on an IBM mainframe. This was also where I met my first real computer game, Collossus Cave! An excellent adventure that kept most of the students engrossed for months! I also met some of the best people at this college, a few who I still keep in contact with. College is a great place to move in to adult hood.

From S.C.O.T. I found my first job which was with Texas Instruments in Bedford. This is was a whole new set of thinking with working in a big organisation where you compiled your code on a mainframe in Dallas from your computer in England.

I stayed with Texas Instruments for just over a year having been under the wing of a big Brian Nicholson. I met some great people there as well but time moved on and I ended up in Hemel Hempstead with Atlas Copco and then on to Link Associates in Chesham, Bucks. A software house by trade, gave me great exposure to new programming languages and how to develop with them, as well as exposure to client Asset Management and the retail industry.

After just over 2 years it was time to break out on my own as a consultant. My first consultancy lasted just over 8 years with Save & Propser in Romford, Essex, England. Still on mainframes I used a Computer Associates product called Ideal.

During this time I started to teach myself Clipper, then on to FoxPro and FoxBase almost at the same time, using FoxPro to write a generic Fantasy game simulation and FoxBase to look after a postal football game I inherited called Sick Parrot. I soon moved on to Visual FoxPro which gave me the insight to the joys that are Object Orientated Programming. This allowed me to move jobs in to Lehman Brothers.

I soon learned the restrictedness of having the programming language along side the database language and so taught myself Visual Basic (v5) and SQL Server (6.5). Very soon after version 7 of SQL Server came along so I moved straight to there and avoid some of the problems with 6.5 solutions. I also taught myself Visual Basic 6 where I completed some work for Rohbe Inc using SQL Server 2000.

Moving from this point I have moved through ASP, SQL Server 2005 to SQL Server 2012, C#, Visual Basic.Net, ASP.NET, Java, Sybase and many other technologies through leaning on the job or reading and working travelling to work. And I am still learning today.


Customer Reviews

5.0 out of 5 stars
(2)
5.0 out of 5 stars
4 star
0
3 star
0
2 star
0
1 star
0
Share your thoughts with other customers
Most Helpful Customer Reviews
2 of 2 people found the following review helpful
5.0 out of 5 stars Excellent, well written book April 6, 2013
By BBowman
Format:Paperback|Verified Purchase
One of my college professors went with this book and I am very grateful. This is my second time taking this class and I have a 94% in the class, where I failed the previous class. Since I take classes online and at night (1-day a week) the quality of a book can make all the difference in the world in learning a technology. The author covers all task from both T-SQL commands and doing things with the GUI so one can get a feel for the way he/she wants to do them. The text is very detailed and easy to follow; in addition, this is not very dry at all, which says a lot for a book on an IT related subject. I highly recommend this book to anyone trying to learn SQL or Microsoft SQL server.
Comment | 
Was this review helpful to you?
0 of 3 people found the following review helpful
5.0 out of 5 stars A great beginning. November 29, 2012
By Len
Format:Paperback|Verified Purchase
Simple reading with lots of practise. I was able to follow and work through the examples and try solutions at work.
Comment | 
Was this review helpful to you?
Search Customer Reviews
Search these reviews only

What Other Items Do Customers Buy After Viewing This Item?


Forums

There are no discussions about this product yet.
Be the first to discuss this product with the community.
Start a new discussion
Topic:
First post:
Prompts for sign-in
 



Look for Similar Items by Category