A hands-on guide to using Excel in the business context
First published in 2012, Using Excel for Business and Financial Modelling contains step-by-step instructions of how to solve common business problems using financial models, including downloadable Excel templates, a list of shortcuts and tons of...
Python is one of the most popular languages today. Relatively new
fields such as data science, AI, robotics, and data analytics, along with
traditional professions such as web development and scientific research,
are embracing Python. It’s increasingly important for programmers writing...
Identify and fix causes of poor performance. You will learn Query Store, adaptive execution plans, and automated tuning on the Microsoft Azure SQL Database platform. Anyone responsible for writing or creating T-SQL queries will find valuable the insight into bottlenecks, including how to recognize them and eliminate them.
SQL SERVER 2012 REPRESENTS A SIZABLE jump forward in scalability, performance, and usability for the DBA, developer, and business intelligence (BI) developer. It is no longer unheard of to have 40-terabyte databases running on a SQL Server. SQL Server administration used to just be the job of a database administrator (DBA), but as SQL Server...
Writing use cases as a means of capturing the behavioral requirements of software systems and business processes is a practice that is quickly gaining popularity. Use cases provide a beneficial means of project planning because they clearly show how people will ultimately use the system being designed. On the surface, use cases appear to be a...
This updated edition teaches everything you need to know to create effective web applications with the latest features in PHP 5.x. You’ll start with the big picture and then dive into language syntax, programming techniques, and other details, using examples that illustrate both correct usage and common idioms.
Today’s Web users expect exciting pages
that are updated frequently and provide
a customized experience. For them, Web
sites are more like communities, to which
they’ll return time and again. At the same
time, Web-site administrators want sites
that are easier to update and maintain,
understanding...
Take full advantage of all the powerful capabilities of Mathematica with help from this hands-on guide. Filled with examples and step-by-step explanations, Mathematica Demystified takes you from your very first calculation all the way to plotting complex fractals.
MySQL/PHP Database Applications Affordable Open Source Solutions to E-Commerce Challenges In this unique guide, two Web development gurus show you how to harness the open source power of MySQL and PHP — and create high-performance Web database applications that won't break the bank. Using plenty of ready-to-run code and seven concrete...