Easy Learning SQL Book
- Mar-2022 ,
- Zahidul Islam
Last Update: 08-Mar-2022 01:02PM
As data floods into your company, you need to put it to work right away—and 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. You’ll find new chapters on SQL and big data, analytic functions, and working with very large databases. Each chapter presents a self-contained lesson on a key SQL concept or technique using numerous illustrations and annotated examples. Exercises let you practice the skills you learn. Knowledge of SQL is a must for interacting with data. With Learning SQL, you’ll quickly discover how to put the power and flexibility of this language to work
Sohibd.com is a participant in the Amazon services LLC associates Program, an affiliate advertising program designed to provide a means for sites to earn advertising and linking to Amazon.com.*Amazon and the Amazon logo are trademarks of Amazon.com, Inc., or its affiliates. Additionally, Sohibd.com participates in various other affiliate programs, and we sometimes get a commission through purchases made through our links
Used for work to expand my SQL knowledge. The book uses MySQL as its practice, but provides concepts of what can be done in MS or Oracle as well. It sticks with concepts and includes practice. Learners like myself need both.
As a Data Analyst and coming from a non-CS background, this is just the best SQL book, to begin with. Although, I have amassed some experience programming in a couple of Languages. Overall, loving this book and keep loving it...
Excellent. Although this seems to be a book for someone who is slightly experienced with SQL coming into reading rather than a beginner. It is strange that the author does not use alias in his notation.
his is one of the better books I have read. It has just he right amount of details at the right places. Learning SQL this way is much faster than constantly searching StackOverflow. This book uses MySQL. Since popular databases conform to the ANSI standard, MySQL is good enough to be used as a learning vehicle. So other than the extra effort of getting MySQL set up on your machine, there is no downside to using MySQL.
Top Related Product
Why Learn SQL?
Whether you will be using a relational database or not, if you are working in data science, business intelligence, or some other facet of data analysis, you will likely need to know SQL, along with other languages/platforms such as Python & R. Data is everywhere, in huge quantities, and arriving at a rapid pace, & people who can extract meaningful information from all this data are in big demand.
Why Use This Book to Do It?
There are plenty of books out there that treat you like an idiot, or some other flavor of simpleton, but these books tend to just skim the surface. At the other end of the spectrum are reference guides that detail every permutation of every statement in a language, which can be useful if you already have a good idea of what you want to do but just need the syntax. This book strives to find the middle ground, starting with some background of the SQL language, moving through the basics, and then progressing into some of the more advanced features that will allow you to really shine. Additionally, this book ends with a chapter showing how to query data in nonrelational databases, which is a topic rarely covered in introductory books.
- 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 SQL’s built-in functions and use conditional logic in data statements
From the Preface
Programming languages come and go constantly, and very few languages in use today have roots going back more than a decade or so. Some examples are COBOL, which is still used quite heavily in mainframe environments; Java, which was born in the mid-1990s and has become one of the most popular programming languages; and C, which is still quite popular for operating systems and server development and for embedded systems. In the database arena, we have SQL, whose roots go all the way back to the 1970s.
SQL was initially created to be the language for generating, manipulating, and retrieving data from relational databases, which have been around for more than 40 years. Over the past decade or so, however, other data platforms such as Hadoop, Spark, and NoSQL have gained a great deal of traction, eating away at the relational database market.
As will be discussed in the last few chapters of this book, however, the SQL language has been evolving to facilitate the retrieval of data from various platforms, regardless of whether the data is stored in tables, documents, or flat files.
- Publisher : O'Reilly Media; 3rd edition (April 7, 2020)
- Language : English
- Paperback : 384 pages
- ISBN-10 : 1492057614
- ISBN-13 : 978-1492057611
- Item Weight : 1.3 pounds
- Dimensions : 7 x 1 x 9.25 inches