Keyword : Category :
 
 
 
 
Windows
Unix
Php and mysql
Linux
Java
Mobile programming
Certification
Asterisk
Python
Autocad
3d-animation
Hacks
Programming
Hardware
Networking
Web design
Multimedia - graphics
Simple steps
Dummies
.net programming
Oracle
Sql server
Operating system
Telecommunications
Microsoft
Office
Web development
Cisco
Graphics
C sharp
Software development
Database
Computer science
Uml
Security
General
Cms
Mac
Android
 
 
Email:
 
 
INTRODUCTION TO ALGORITHMS
NRS 2712.00
 
Book details / order
MURACH'S SQL SERVER 2012 FOR DEVELOPERS TRAINING & REFERENCE
When we published the first edition of this book, we heard from plenty of developers who were just starting out using microsoft sql server and found this to be a great book for training. but we also heard from a lot of experienced developers who read it and were amazed to discover how much they didn't know about sql. that's why we've dubbed this book "the sql book that most developers don't even know they need." so whether you're new to sql...or whether you've been squeaking by with the sql you know, never realizing how much you're missing out on...this is the book for you. for example, you'll learn: how to create complex inner and outer joins, summary queries, and subqueries that do more of the database processing for you so that your applications can do less what the different data types are and how to handle the common problems you run into with various types of data how to use built-in functions to handle everyday challenges like manipulating character data, rounding numbers, and working with date/time values how to work with xml data how to take advantage of powerful backend database features like views, scripts, stored procedures, and triggers how to deal with database control features like cursors, transactions, and locking how to use the filestream storage feature to work efficiently with binary large objects (blobs), such as image, sound, and video files the basics of database design and implementation using the management studio or sql ddl statements (you can write more efficient queries when you know something about database design...and you'll start to see what your dba has to think about, if that's a career path that interests you) how to use the clr integration feature to create database objects by using ssdt (sql server data tools) with c# or visual basic who this book is for i think it's fair to say that most developers don't know enough about sql and the database management system they're using. as one customer put it, "i know just enough about sql server to be a little bit dangerous!" that's why developers often code sql statements that don't perform as efficiently as they ought to. that's why they aren't able to code some of the queries that they need for their applications. that's why they don't take advantage of all the features that sql server has to offer. and that's why this book should be required reading for every application programmer who uses sql server. beyond that, this is the right first book for anyone who wants to become a database administrator. of course, if you want to become a dba, you'll need to continue your study of sql server's advanced features after you finish this book...but you'll be well-prepared to go on. what are the prerequisites for using this book? everything you need to know about databases and sql is presented in this book. however, you'll get more out of chapter 20 (blobs) and section 5 (on clr integration) if you have some programming experience with a .net language like c# or visual basic. what if you have the previous edition of this book, murach's sql server 2008 for developers? for the most part, the sql language and features that are covered in this book haven't undergone major changes in the 2012 release. there are a few new features, like sequences for assigning values to integer columns, as well as some significant changes to clr integration. but if you already know sql server 2008, this book isn't essential for your initial upgrade to 2012...although you may want to have it on hand for reference. table of contents: section 1. an introduction to sql chapter 1. an introduction to relational databases and sql chapter 2. how to use the management studio section 2. the essential sql skills chapter 3. how to retrieve data from a single table chapter 4. how to retrieve data from two or more tables chapter 5. how to code summary queries chapter 6. how to code subqueries chapter 7. how to insert, update, and delete data chapter 8. how to work with data types chapter 9. how to use functions section 3. database design and implementation chapter 10. how to design a database chapter 11. how to create and maintain databases, tables, and sequences with sql statements chapter 12. how to use the management studio for database design section 4. advanced sql skills chapter 13. how to work with views chapter 14. how to code scripts chapter 15. how to code stored procedures, functions, and triggers chapter 16. how to work with cursors chapter 17. how to manage transactions and locking chapter 18. how to manage database security chapter 19. how to work with xml chapter 20. how to work with blobs section 5. clr integration chapter 21. an introduction to clr integration chapter 22. how to code clr stored procedures, functions, and triggers chapter 23. how to code aggregate functions and user-defined types resources. appendix a. how to install the required software for this book appendix b. how to install the files and databases used in this book appendix c. coding and syntax conventions

Author : Joel murach, bryan syverson
Publication : Murach
Isbn : 9789350239391
Store book number : 105
NRS 1120.00
  
Order This Book
*Marked Field Is Necessary
Your Name: *
Your Address:
Your Email: *
Your Cell Phone:
Your Work Phone:
Quantity: *
Total:
Message (if any)
Security code: *
Case Sensitive
 
 
Packt publication
Microsoft press
Wrox
Bpb
Phi
Dreamtech press
Sybex
Wiley
Tata
Oreilly
Macmilan
Vikas
Apress
Spd
Pearson
Cambridge
Oxford
Idg
Charles river media
Murach
Niit
Black book
Bible
Elsevier
Sk kataria
Pragmatic bookshelf
Fusion books
 
 
MURACH'S PYTHON PROGRAMMING
NRS 1280.00
 
 
Professional ASP.NET MVC 4
Mastering Microsoft Exchange ...
Android Hacker's Handbook
CCNA Cisco Certified Network ...
Windows Phone 7 Application ...
Beginning Drupal (Wrox Progr ...
Troubleshooting Windows 7 In ...
 More>>
 
All Right Reserved © bookplus.com.np 2008