Master the fundamentals of Transact-SQL and develop your own code for querying and modifying data in Microsoft® SQL Server® 2012. Led by a SQL Server expert, you’ll learn the concepts behind T-SQL querying and programming, and then apply your knowledge with exercises in each chapter. Once you understand the logic behind T-SQL, you’ll quickly learn how to write effective code whether you’re a programmer or database administrator.
Work with programming practices unique to T-SQL
Create database tables and define data integrity
Query multiple tables using joins and subqueries
Simplify code and improve maintainability with table expressions
Implement insert, update, delete, and merge data modification strategies
Tackle advanced techniques such as window functions, pivoting and grouping sets
Control data consistency using isolation levels, and mitigate deadlocks and blocking
Take T-SQL to the next level with programmable objects
Master the fundamentals of Transact-SQL and develop your own code for querying and modifying data in Microsoft® SQL Server® 2012. Led by a SQL Server expert, you’ll learn the concepts behind T-SQL querying and programming, and then apply your knowledge with exercises in each chapter. Once you understand the logic behind T-SQL, you’ll quickly learn how to write effective code whether you’re a programmer or database administrator. Download eBook Free »
Training Kit (Exam 70-462): Administering Microsoft SQL Server 2012 Databases
Ace your preparation for the skills measured by Exam 70-462 and on the job with this official Microsoft study guide. Work at your own pace through a series of lessons and reviews that fully cover each exam objective. Then, reinforce and apply what you’ve learned through real-world case scenarios and practice exercises.
Training Kit (Exam 70-462): Administering Microsoft SQL Server 2012 Databases: Maximize your performance on the exam by mastering the skills and experience measured by these objectives:
Install and configure SQL Server
Maintain instances and databases
Optimize and troubleshoot SQL Server
Manage data
Implement security
Implement high availability
Ace your preparation for the skills measured by Exam 70-462 and on the job with this official Microsoft study guide. Work at your own pace through a series of lessons and reviews that fully cover each exam objective. Then, reinforce and apply what you’ve learned through real-world case scenarios and practice exercises. Download eBook Free »
Transcend the limitations of text-based requirements data using visual models that more rigorously identify, capture, and validate requirements
Get real-world guidance on best ways to use visual models how and when, and ways to combine them for best project outcomes
Practice the book’s concepts as you work through chapters
Change your focus from writing a good requirement to ensuring a complete system
Apply best practices for capturing, analyzing, and implementing software requirements through visual models and deliver better results for your business. The authors experts in eliciting and visualizing requirements walk you through a simple but comprehensive language of visual models that has been used on hundreds of real-world, large-scale projects. Build your fluency with core concepts and gain essential, scenario-based context and implementation advice as you progress through each chapter.
Apply best practices for capturing, analyzing, and implementing software requirements through visual models and deliver better results for your business. The authors experts in eliciting and visualizing requirements walk you through a simple but comprehensive language of visual models that has been used on hundreds of real-world, large-scale projects. Build your fluency with core concepts and gain essential, scenario-based context and implementation advice as you progress through each chapter. Download eBook Free »
Learn the fundamentals of programming with the Kinect™ API and begin building apps that use motion tracking, voice recognition, and more. If you have experience programming with C# simply start here! This book introduces must-know concepts and techniques through easy-to-follow explanations, examples, and exercises.
Build an application to display Kinect video on your PC
Have Kinect take photographs when it detects movement
Draw on a computer screen by moving your finger in the air
Track your body gestures and use them to control a program
Make a program that understands your speech and talks back to you
Play a part in your own augmented reality game
Create an “air piano” using Kinect with a MIDI device
Learn the fundamentals of programming with the Kinect™ API and begin building apps that use motion tracking, voice recognition, and more. If you have experience programming with C# simply start here! This book introduces must-know concepts and techniques through easy-to-follow explanations, examples, and exercises. Download eBook Free »
SOA Governance in Action: REST and WS-* Architectures
SOA Governance in Action: REST and WS-* Architectures is a hands-on guide for developers and technology leads who need to develop and implement policies for SOA projects. This book introduces the fundamentals of good governance, the best practices for implementing them, and how to support governance using various open source tools. You’ll follow an extensive case study that addresses the areas of service design, security, testing, and performance.
Governance is a serious word for a simple idea defining processes, roles, and expectations for a software project. It’s especially important in SOA where you have multiple stakeholders, competing requirements, and complex integration tasks. Good SOA governance blends established best practices, strong management and monitoring tools, and the flexibility to embrace new technologies and patterns.
SOA Governance in Action: REST and WS-* Architectures shows developers how to apply governance concepts and implementation practices to achieve success in SOA projects. You’ll learn practical techniques like building a metadata repository using WSO2 Registry or a custom monitoring dashboard using Bamos BAM. You’ll also explore other supporting tools, such as using OpenAM, to implement security related policies. Along the way, you’ll explore the nuances of writing policies that work for the project and click with your corporate culture. Download eBook Free »
The Well-Grounded Java Developer: Vital techniques of Java 7 and polyglot programming starts with thorough coverage of Java 7 features like try-with-resources and NIO.2. You’ll then explore a cross-section of emerging JVM-based languages, including Groovy, Scala, and Clojure. You will find clear examples that are practical and that help you dig into dozens of valuable development techniques showcasing modern approaches to the dev process, concurrency, performance, and much more.
Written for readers familiar with Java. No experience with Java 7 or new JVM languages required. The Well-Grounded Java Developer offers a fresh and practical look at new Java 7 features, new JVM languages, and the array of supporting technologies you need for the next generation of Java-based software.
The Well-Grounded Java Developer: Vital techniques of Java 7 and polyglot programming starts with thorough coverage of Java 7 features like try-with-resources and NIO.2. You’ll then explore a cross-section of emerging JVM-based languages, including Groovy, Scala, and Clojure. You will find clear examples that are practical and that help you dig into dozens of valuable development techniques showcasing modern approaches to the dev process, concurrency, performance, and much more. Download eBook Free »