Description

As data floods into your company you need to put it to work right awayand SQL is the best tool for the job With the latest edition of this introductory guide author Alan Beaulieu helps developers get up to speed with SQL fundamentals for writing database applications performing administrative tasks and generating reports Youll find new chapters on SQL and big data analytic functions and working with very large databases

Each chapter presents a selfcontained lesson on a key SQL concept or technique using numerous examples Exercises let you practice the skills you learn Knowledge of SQL is a must for interacting with data With Learning SQL youll quickly discover how to put the power and flexibility of this language to work

Move quickly through SQL basics and several advanced features

Use SQL data statements to generate manipulate and retrieve data

Create database objects such as tables indexes and constraints with SQL schema statements

Learn how datasets interact with queries understand the importance of subqueries

Convert and manipulate data with SQLs builtin functions and use conditional logic in data statements