Articles liés à Creating SQL Queries Using T-SQL Made Easy

Creating SQL Queries Using T-SQL Made Easy - Couverture souple

 
9781935208440: Creating SQL Queries Using T-SQL Made Easy

Synopsis

This book covers learning how to create SQL queries using T-SQL/SQL Server.

If you have been looking for a book that has easy to understand step-by-step instructions and screen shots that show you how to use T-SQL to create queries from data stored in a SQL Server database, this is the book for you. This book has been designed to have you creating queries quickly, by teaching you the basics and more. It is written from the perspective that you have not created queries using T-SQL and SQL Server.



Most companies would find it helpful if they had employees, that could create queries to answer business needs. In my 25+ years of experience, I have noticed that few, if any people outside of the IT department have SQL skills. If that sounds like you, this book will teach you how to create SQL queries. This book is not just for people already in IT. While this book is designed for SQL beginners, it is also helpful for Data Analysts, Engineers and Scientists.



To help you become familiar with the syntax and features of SQL, this book contains over 490 illustrations that provide a visual tour of the results of the queries that you create. There are over 410 ready to use queries in the examples and exercises in this book, that you can use to create queries on your own.



This book will show you how to use some of the most used SQL keywords, operators and functions, by completing the hands on exercises. This book will get you up and running quickly, by teaching the basics of creating queries and a little more, so that you can use T-SQL and SQL Server to create the queries that you need.



You will learn how to:




  • Create queries that use several operators and functions

  • Filter data, to retrieve just the data that you need

  • Sort and group data

  • Join tables so that data from more than one table can be retrieved at the same time

  • Create subqueries and more



In today's work environment, being able to create queries that can be used to analyze the data, will give you an edge over other people. SQL isn't just for the IT department anymore. After completing the exercises in this book, you will be able to create queries that answer questions like the ones listed below.





  • What are the yearly sales by region?

  • What are the top 10 selling products, based on the quantity sold?

  • How many customers in California placed orders in 2018?





  • If you need to learn how to create SQL queries using MySQL, see ISBN 978-1-935208-45-7.

    If you need to learn how to create SQL queries using an SQLite database, see ISBN 978-1-935208-46-4.

    If you need to learn how to create SQL queries using PostgreSQL, see ISBN 978-1-935208-47-1.

    If you need to learn how to create SQL queries using Oracle SQL, see ISBN 978-1-935208-48-8.


    If you already know some SQL, but want to get more practice, my Big Book Of SQL Queries (ISBN 978-1-935208-49-5), has over 250 practice queries that you can use to create queries in any of the following versions of SQL: T-SQL/SQL Server, MySQL, SQLite, PostgreSQL or Oracle.

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

  • ÉditeurTolana Publishing
  • Date d'édition2019
  • ISBN 10 1935208446
  • ISBN 13 9781935208440
  • ReliureBroché
  • Langueanglais
  • Nombre de pages308
  • Coordonnées du fabricantnon disponible

Acheter neuf

Afficher cet article
EUR 55,18

Autre devise

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

Destinations, frais et délais

Résultats de recherche pour Creating SQL Queries Using T-SQL Made Easy

Image d'archives

Murphy, Indera E
Edité par Tolana Publishing, 2019
ISBN 10 : 1935208446 ISBN 13 : 9781935208440
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. 308 pages. 11.00x8.50x0.70 inches. In Stock. N° de réf. du vendeur zk1935208446

Contacter le vendeur

Acheter neuf

EUR 55,18
Autre devise
Frais de port : EUR 11,81
De Royaume-Uni vers France
Destinations, frais et délais

Quantité disponible : 1 disponible(s)

Ajouter au panier

Image d'archives

Murphy, Indera E
Edité par Tolana Publishing, 2019
ISBN 10 : 1935208446 ISBN 13 : 9781935208440
Neuf paperback

Vendeur : dsmbooks, Liverpool, Royaume-Uni

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

paperback. Etat : New. New. book. N° de réf. du vendeur D8S0-3-M-1935208446-6

Contacter le vendeur

Acheter neuf

EUR 111
Autre devise
Frais de port : EUR 29,52
De Royaume-Uni vers France
Destinations, frais et délais

Quantité disponible : 1 disponible(s)

Ajouter au panier