Articles liés à SOLVING BUSINESS PROBLEMS USING SQL: A DEFINITIVE GUIDE...

SOLVING BUSINESS PROBLEMS USING SQL: A DEFINITIVE GUIDE FOR BEGINNERS WHO WANT TO BE PROFICIENT IN DATABASE DESIGN AND WRITING SQL - Couverture souple

 
9781795478298: SOLVING BUSINESS PROBLEMS USING SQL: A DEFINITIVE GUIDE FOR BEGINNERS WHO WANT TO BE PROFICIENT IN DATABASE DESIGN AND WRITING SQL

Synopsis

Are you getting ready for your new job?

Data analysis and presentation is one of the most in-demand job skills right now. Knowing SQL syntaxes and applying them to the real world problems will give you advantage in your career.

Whether you are going to start a new job, or you are a database administrator, developer of web or mobile applications, or you are engaged in a similar business applications role, a good understanding of SQL is essential for communicating with modern database systems. The point is that, if you are working with data, you definitely need to know SQL.

There are plenty of resources regarding SQL syntaxes, but it is difficult to find resources that shows how to apply these syntaxes for solving real world business problems. This book is filling this gap.

This book is for anyone who has little to no knowledge about databases or SQL and would like to become an expert in it. The lessons and practice scenarios in this book are designed to teach a total beginner how to build a complete database from scratch using SQL. For those of you who are not novices, we recommend this book as a valuable resource for:

  • Application developers who want to learn how to write SQL on their own rather than rely on a database developer to do it for them
  • Application developers who want to become a solution designer/architect by becoming proficient in database design and SQL
  • Data analysts, data architects, report analysts or report developers who have to answer a lot of business questions and want to use SQL to answer those questions
  • Application users who want to go the extra mile and find answers to their own questions using SQL
  • Anyone who is an expert in one database tool and wants to become an expert in another database tool
  • Business users or project managers who would like to know how to talk to technical people (such as those mentioned above)
  • Anyone who can write SQL but doesn’t know how to design a database from a business case

In short, if you want to take a more active role in how your database powers your business, the SQL skills taught in this book will give you an advantage in your career.

You will learn how to:

  • Create data model for your business
  • Convert data model into physical database
  • Insert, update and delete data
  • Solve real world problems related to data
  • Recover your data from disaster


Table of Contents

  1. A Basic Vocabulary of Database Design & SQL
  2. The E-commerce Site Case Study
  3. Installing SQL Tools
  4. Converting a logical data model into a physical database
  5. Manipulating Data
  6. Retrieving Static Data without a Table
  7. Retrieving All Rows from a Table
  8. Retrieving subset of rows from a table
  9. Summarizing Retrieved Rows from a Table
  10. Retrieving and Summarizing Data from Multiple Tables Using Inner Join
  11. Retrieving and summarizing data from multiple tables using Outer Join
  12. Retrieving and Summarizing Data from Multiple Tables Using UNION
  13. Working with Views
  14. Comparing Data Between Rows Within the Same Table or Result Set Using Self-Join
  15. Working with Flow-control Statements
  16. Working with Stored Procedures
  17. Working with Triggers
  18. Improving query performance using indexes
  19. Backing up and restoring a database
  20. Appendix A Solutions to the Practice Business Problems

Les informations fournies dans la section « Synopsis » peuvent faire référence à une autre édition de ce titre.

Acheter D'occasion

état :  Satisfaisant
Used book that is in clean, average...
Afficher cet article
EUR 19,02

Autre devise

EUR 13,90 expédition depuis Etats-Unis vers France

Destinations, frais et délais

Acheter neuf

Afficher cet article
EUR 39,66

Autre devise

EUR 11,53 expédition depuis Royaume-Uni vers France

Destinations, frais et délais

Résultats de recherche pour SOLVING BUSINESS PROBLEMS USING SQL: A DEFINITIVE GUIDE...

Image d'archives

Rahman, Hafizur
Edité par Independently Published, 2019
ISBN 10 : 1795478292 ISBN 13 : 9781795478298
Ancien ou d'occasion Couverture souple

Vendeur : Better World Books: West, Reno, NV, Etats-Unis

Évaluation du vendeur 5 sur 5 étoiles Evaluation 5 étoiles, En savoir plus sur les évaluations des vendeurs

Etat : Good. Used book that is in clean, average condition without any missing pages. N° de réf. du vendeur 52418462-75

Contacter le vendeur

Acheter D'occasion

EUR 19,02
Autre devise
Frais de port : EUR 13,90
De Etats-Unis vers France
Destinations, frais et délais

Quantité disponible : 1 disponible(s)

Ajouter au panier

Image d'archives

Rahman, Hafizur
Edité par Independently published, 2019
ISBN 10 : 1795478292 ISBN 13 : 9781795478298
Ancien ou d'occasion Couverture souple

Vendeur : SecondSale, Montgomery, IL, Etats-Unis

Évaluation du vendeur 4 sur 5 étoiles Evaluation 4 étoiles, En savoir plus sur les évaluations des vendeurs

Etat : Good. Item in good condition. Textbooks may not include supplemental items i.e. CDs, access codes etc. N° de réf. du vendeur 00050503796

Contacter le vendeur

Acheter D'occasion

EUR 17,30
Autre devise
Frais de port : EUR 30,09
De Etats-Unis vers France
Destinations, frais et délais

Quantité disponible : 1 disponible(s)

Ajouter au panier

Image d'archives

Hafizur Rahman
Edité par Independently published, 2019
ISBN 10 : 1795478292 ISBN 13 : 9781795478298
Neuf Paperback

Vendeur : Revaluation Books, Exeter, Royaume-Uni

Évaluation du vendeur 5 sur 5 étoiles Evaluation 5 étoiles, En savoir plus sur les évaluations des vendeurs

Paperback. Etat : Brand New. 363 pages. 10.98x8.50x1.22 inches. In Stock. N° de réf. du vendeur zk1795478292

Contacter le vendeur

Acheter neuf

EUR 39,66
Autre devise
Frais de port : EUR 11,53
De Royaume-Uni vers France
Destinations, frais et délais

Quantité disponible : 1 disponible(s)

Ajouter au panier

Image d'archives

Rahman, Hafizur
Edité par Independently published, 2019
ISBN 10 : 1795478292 ISBN 13 : 9781795478298
Ancien ou d'occasion Couverture souple

Vendeur : Goodwill, Brooklyn Park, MN, Etats-Unis

Évaluation du vendeur 5 sur 5 étoiles Evaluation 5 étoiles, En savoir plus sur les évaluations des vendeurs

Etat : VeryGood. Cover/Case has some rubbing and edgewear. Access codes, CDs, slipcovers and other accessories may not be included. N° de réf. du vendeur 2Y6JCV0003Q7_ns

Contacter le vendeur

Acheter D'occasion

EUR 13,80
Autre devise
Frais de port : EUR 64,49
De Etats-Unis vers France
Destinations, frais et délais

Quantité disponible : 1 disponible(s)

Ajouter au panier