2nd Edition. — O’Reilly Media, Inc., 2025. — 540 p. — ISBN: 978-1-098-17985-4. CockroachDB is the distributed SQL database that handles the demands of today's data-driven applications. The second edition of this popular hands-on guide shows software developers, architects, and DevOps/SRE teams how to use CockroachDB for applications that scale elastically and provide seamless...
Independent publication, 2025. — 168 р. — ASIN : B0DWB2PJQ2. Unlock the Power of SQL for Data Analysis with "SQL for Data Analysis: A Beginner's Guide to Querying and Database Mastery" Are you ready to master the art of data analysis using SQL, the most widely used language for managing and querying relational databases? Whether you're a beginner, a professional, or someone...
Sonar Publishing, 2024. — 590 p. — ASIN: B0DLKFT9JL. In today's fast-paced digital world, understanding how to efficiently store, manage, and retrieve data is crucial for businesses and developers alike. SQL and NoSQL Full Mastery: A Comprehensive Guide to Modern Data Management offers a deep dive into the world of both relational and non-relational databases, providing readers...
John Wiley & Sons, Inc., 2025. — 211 p. — ISBN 978-1-394-29696-5. A right-to-the-point guide on all the key topics of SQL programming. SQL Essentials For Dummies is your quick reference to all the core concepts of SQL—a valuable common standard language used in relational databases. This useful guide is straightforward—with no excess review, wordy explanations, or fluff—so you...
HiTeX Press, 2024. — 425 р. — ASIN: B0DL3ZZC2S. "Database Design with SQL: Building Fast and Reliable Systems" is an essential resource for beginners eager to master the fundamentals of database management and SQL. This comprehensive guide demystifies the core principles of database systems, providing readers with the knowledge to design efficient data architectures and execute...
CompreQuest Books, 2024. — 581 p. — ASIN: B0CW8CHLG3. Unlock the full potential of SQL with "Advanced SQL Programming: Techniques for Efficient Data Management." Embark on a journey into the depths of SQL mastery with "Advanced SQL Programming: Techniques for Efficient Data Management." Whether you're a seasoned SQL developer or new to the field, this comprehensive guide...
O’Reilly Media, 2024. — 324 p. — ISBN 978-1-098-14238-4. With the shift from data warehouses to data lakes, data now lands in repositories before it's been transformed, enabling engineers to model raw data into clean, well-defined datasets. dbt (data build tool) helps you take data further. This practical book shows data analysts, data engineers, BI developers, and data...
3rd Edition. — Pearson Education, 2022. — 272 р — ISBN 978-0-13-763269-5. Get Started Fast with SQL! The only book you need to gain a quick working knowledge of SQL and relational databases. Many SQL texts attempt to serve as an encyclopedic reference on SQL syntaxan approach that is often counterproductive because that information is readily available in online references...
Independently published, 2023-11-29. — 122 p. — ISBN-13: 979-8223842149. SQL For Beginners: The Comprehensive Guide To Learning, Understanding, And Mastering SQL Programming For Managing, Analyzing, and Manipulating Data Learn the secrets of SQL and how to become an expert in any database. Do you want to learn SQL, but you're not even sure where to start? Would you like to...
BPB Publications, 2023. — 162 p. — ISBN 978-93-55518-583. A comprehensive guide to SQL and NoSQL interview questions for software professionals. Key Features Get familiar with different concepts and queries in SQL. Comprehensive coverage of different types of NoSQL databases. Understand the performance tuning strategies and best practices for NoSQL databases. In every...
O’Reilly Media, 2023. — 282 р. — ISBN 13: 978-1-098-15227-7. If you were handed two different but related sets of data, what tools would you use to find the matches? What if all you had was SQL SELECT access to a database? In this practical book, author Jim Lehmer provides best practices, techniques, and tricks to help you import, clean, match, score, and think about...
CRC Press, 2024. — 244 p. — ISBN: 978-1003358435. Mastering SQL helps readers gain a firm understanding of the Structured Query Language. Structured Query Language, more often known as SQL, is the de facto standard language for working with databases. It is a specialized language for handling data-related tasks like creating a database, putting information into tables,...
2nd Edition. — Springer, 2023. — 263 р. — ISBN 978-3-031-27908-9. This textbook offers a comprehensive introduction to relational (SQL) and non-relational (NoSQL) databases. The authors thoroughly review the current state of database tools and techniques and examine upcoming innovations. In the first five chapters, the authors analyze in detail the management, modeling,...
Independently published, 2022-12-01. — 432 p. — ISBN-13: 979-8366642675. Do you want to learn good coding techniques quickly and easily? Are you looking for a well explained introduction to SQL for absolute beginners? This book provides all the essentials in one handy place! Structured Query Language is abbreviated as SQL. SQL is used to communicate with databases. It is...
GitforGits, 2023. — 235 р. SQL 101 Crash Course is a comprehensive beginner's guide that takes you through the world of SQL, right from understanding databases to mastering complex queries. This book is designed to provide you with a solid foundation in SQL, along with practical examples and real-world scenarios to reinforce your learning. In this book, you'll explore the key...
Apress Media, LLC, 2023. — 400 p. — ISBN-13: 978-1-4842-9492-5. Learn the basics of writing SQL scripts. Using Standard SQL as the starting point, this book teaches writing SQL in various popular dialects, including PostgreSQL, MySQL/MariaDB, Microsoft SQL Server, Oracle, and SQLite. The book starts with a general introduction to writing SQL and covers the basic concepts....
Remylent, 2023. — 105 р. — ISBN: 978-2-38518-037-9. SQL (Structured Query Language) is a query language for relational database management. In this book, you will discover the basics of its organization and its characteristics. Using the PhpMyAdmin environment, you will learn how to create a database, tables, columns, constraints, keys (primary and foreign), joins and many...
Mercury Learning and Information, 2022. — 292 р. — ISBN: 978-1-68392-814-0. As part of the best-selling Pocket Primer series, this book is primarily for data scientists and machine learning engineers who want to expand their current knowledge of SQL using MySQL as the primary RDBMS. It includes Python-based code samples to access data from a MySQL table in a Pandas data frame...
Pragmatic Bookshelf, 2022. — 340 р. — ISBN-13: 978-1680508987. Each chapter in this book helps you identify, explain, and correct a unique and dangerous antipattern. The four parts of the book group the antipatterns in terms of logical database design, physical database design, queries, and application development. The chances are good that your application’s database layer...
2nd Edition (Final). — O’Reilly Media, Inc., 2022. — 319 p. — ISBN: 978-1-098-13724-3. • 2022-10-03: First release Perform fast interactive analytics against different data sources using the Trino high-performance distributed SQL query engine. In the second edition of this practical guide, you'll learn how to conduct analytics on data where it lives, whether it's a data lake...
Apress Media LLC, 2022. — 264 p. — ISBN-13: 978-1-4842-8224-3. Meet CockroachDB! This book is your practical introduction and starts at the beginning, with software installation and foundational concepts. It then teaches you how to create CockroachDB clusters that are ready for production environments. You will master high availability. And you will learn to create, optimize,...
BPB Online, 2022. — 622 p. — ISBN 978-93-55512-376. This book will take you on an interactive journey to master SQL querying from the most fundamental to the most advanced level using various T-SQL techniques to provide meaningful insights from your SQL Server data. The book begins with an introduction to the fundamental concepts of both SQL and SQL Server. It then guides...
4th Edition. — O’Reilly Media, 2022. — 838 p. — ISBN-13: 978-1-492-08886-8. For programmers, analysts, and database administrators, this Nutshell guide is the essential reference for the SQL language used in today's most popular database products. This new fourth edition clearly documents SQL commands according to the latest ANSI/ISO standard and details how those commands are...
Пер. с англ. А. Павлов. — СПб.: Питер, 2022. — 224 с.: ил. — (Библиотека программиста). — ISBN 978-5-4461-1835-9. Что общего между самыми востребованными профессиями и стремительным увеличением количества информации в мире? Ответ: язык структурированных запросов (SQL). SQL – рабочая лошадка среди языков программирования, основа основ для современного анализа и управления...
O’Reilly Media, Inc., 2022. — 476 p. — ISBN 978-1-098-10025-4. Get the lowdown on CockroachDB, the distributed SQL database built to handle the demands of today's data-driven cloud applications. In this hands-on guide, software developers, architects, and DevOps/SRE teams will learn how to use CockroachDB to create applications that scale elastically and provide seamless...
2nd Edition. — No Starch Press, 2022. — 448 p. — ISBN-13: 978-1-7185-0107-2. Analyze data like a pro, even if you’re a beginner. Practical SQL is an approachable and fast-paced guide to SQL (Structured Query Language), the standard programming language for defining, organizing, and exploring data in relational databases. Anthony DeBarros, a journalist and data analyst, focuses...
5th edition. — Sams Publishing, 2020. — 256 p. — ISBN 978-0135182796. Sams Teach Yourself SQL in 10 Minutes offers straightforward, practical answers when you need fast results. By working through the book’s 22 lessons of 10 minutes or less, you’ll learn what you need to know to take advantage of the SQL language. Lessons cover IBM DB2, Microsoft SQL Server and SQL Server...
2nd Edition. — O’Reilly Media, Inc., 2020-11-03. — 572 p. — ISBN: 978-1-098-10014-8. You may know SQL basics, but are you taking advantage of its expressive power? This second edition applies a highly practical approach to Structured Query Language (SQL) so you can create and manipulate large stores of data. Based on real-world examples, this updated cookbook provides a...
Packt, 2020. - 475p. - ISBN: 9781800204768 Get up to speed with the new features added to Microsoft SQL Server 2019 Analysis Services and create models to support your business Key Features Explore tips and tricks to design, develop, and optimize end-to-end data analytics solutions using Microsoft's technologies Learn tabular modeling and multi-dimensional cube design...
Packt, 2020. — 522 p. — ISBN: 9781789954326. Use Microsoft SQL Server 2019 to implement, administer, and secure a robust database solution that is disaster-proof and highly available Key Features Explore new features of SQL Server 2019 to set up, administer, and maintain your database solution successfully Develop a dynamic SQL Server environment and streamline big data...
2nd Edition. — Packt Publishing Limited, July 2020. — 580 p. — ISBN: 978-1-80056-072-7. Take a step-by-step approach to learning SQL data analysis in this interactive workshop that uses fun exercises and activities to make learning data analytics for beginners easy and approachable. Every day, businesses operate around the clock and a huge amount of data is generated at a rapid...
4th Edition. — In Easy Steps Limited, 2020. — 192 p.— ISBN: 978-1840789027. SQL (Structured Query Language) is THE standard language used world-wide for database communication on all popular database software. It allows the storage and manipulation of data both on Windows platforms and on Unix-based platforms, such as Linux. SQL in easy steps, 4th edition begins by explaining...
No Starch Press, 2018. — 386 p. — ISBN13: 978-1-59327-827-4. Practical SQL is an approachable and fast-paced guide to SQL (Structured Query Language), the standard programming language for defining, organizing, and exploring data in relational databases. The book focuses on using SQL to find the story your data tells, with the popular open-source database PostgreSQL and the...
Packt, 2020. - 200p. - ISBN: 9781800204591 Learn By the end of this book, you will be able to: Choose an operating system for SQL Server in Azure VMs Use the Azure Management Portal to facilitate the deployment process Verify connectivity and network latency in cloud Configure storage for optimal performance and connectivity Explore various disaster recovery options for SQL...
Packt, 2020. - 564p. - ISBN: 9781838984762 Learn everything you need to know to build efficient SQL queries using this easy-to-follow beginner's guide Key Features Explore all SQL statements in depth using a variety of examples Get to grips with database querying, data aggregate, manipulation, and much more Understand how to explore and process data of varying complexity to...
Kellyn Gorman, Allan Hirt, Dave Noderer, Mitchell Pearson, James Rowland-Jones, Dustin Ryan, Arun Sirpal, Buck Woody. — Packt Publishing, 2020. — 488 p. — ISBN: 978-1-83882-621-5. Explore the impressive storage and analytic tools available with the in-cloud and on-premises versions of Microsoft SQL Server 2019. Microsoft SQL Server comes equipped with industry-leading features...
Amazon.com Services LLC., 2020. — 140 p. — ASIN: B084G7QQHJ. If you want to learn SQL fast and even if you have no technical skills whatsoever, Read On… How many times have you thought about learning how to code but got discouraged because you had no technical background, didn’t have the time to learn, or you just didn’t think you were smart enough? Well, we have good news for...
3rd Edition. — O’Reilly Media, Inc., 2020. — 393 p. — ISBN: 1492057614. 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,...
O’Reilly Media, Inc., 2020. — 357 p. — ISBN: 978-1-492-04427-7. Perform fast interactive analytics against different data sources using the Presto high-performance, distributed SQL query engine. With this practical guide, you’ll learn how to conduct analytics on data where it lives, whether it’s Hive, Cassandra, a relational database, or a proprietary data store. Analysts,...
2nd Edition. — Packt Publishing Ltd., 2020. — 383 p. — ISBN: 978-1-80020-367-9. Cut through the noise and get real results with a step-by-step approach to learning about SQL data analysis You already know that you want to learn data analysis with SQL, and a smarter way to learn is to learn by doing. The Applied SQL Data Analytics Workshop focuses on building up your practical...
Packt Publishing, 2019. — 269 p. — ISBN: 978-1-83864-235-8. Cut through the noise and get real results with a step-by-step approach to learning SQL You already know you want to learn SQL, and the best way to learn SQL is to learn by doing. The SQL Workshop focuses on building up your SQL database management skills so that you can easily store and retrieve data or become the...
Clydebank Media LLC., 2019. — 249 p. — ISBN13: 978-1945051234. “THE BEST SQL BOOK FOR BEGINNERS IN 2020 – HANDS DOWN!” Not sure how to prepare for the data-driven future? This book shows you EXACTLY what you need to know to successfully use the SQL programming language to enhance your career! Are you a developer who wants to expand your mastery to database management? Then you...
3rd Edition. — John Wiley & Sons, Inc., 2019. — 816 p. — ISBN: 978-1-11956-961-9. The latest on SQL databases SQL All -In-One For Dummies, 3rd Edition, is a one-stop shop for everything you need to know about SQL and SQL-based relational databases. Everyone from database administrators to application programmers and the people who manage them will find clear, concise...
3rd Edition. — Packt Publishing, 2019. — 637 p. — ISBN: 978-1-78953-546-4. PostgreSQL is one of the most popular open source database management systems in the world, and it supports advanced features included in SQL standards. This book will familiarize you with the latest features in PostgreSQL 11, and get you up and running with building efficient PostgreSQL database...
Packt Publishing, 2019. — 1060 p. — ISBN: 978-1-78953-758-1. A practical guide to administer, monitor and replicate your PostgreSQL 11 database PostgreSQL is a powerful, open source database management system with an enviable reputation for high performance and stability. With many new features in its arsenal, PostgreSQL 11 allows you to scale up your PostgreSQL infrastructure....
Momentum Press, 2019. — 99 p. — ISBN13: 978-1-94561-263-3 (e-book). SQL by Example uses one case study to teach the reader basic structured query language (SQL) skills. The author has tested the case study in the classroom with thousands of students. While other SQL texts tend to use examples from many different data sets, the author has found that once students get used to one...
7th.ed. — McGraw-Hill, 2020. — 825 p. — ISBN: 978-1-26-045887-9. Get Up to Speed on Microsoft SQL Server 2019 Quickly and Easily Start working with Microsoft SQL Server 2019 in no time with help from this thoroughly revised, practical resource. Filled with real-world examples and hands-on exercises, Microsoft SQL Server 2019: A Beginner’s Guide, Seventh Edition starts by...
Amazon Digital Services LLC, 2019. — 92 р. As a business, it is likely that you will need to hold onto a lot of data. Some of this data is going to be about your customers, like their name, address, credit card information, and more. And some of that information is going to be about your products and services. You want to make sure that any and all information that your...
3rd Edition. — O’Reilly Media, 2008. — 819 p. — ISBN: 978-0-596-51884-4. Целевая аудитория: начинающие разработчики. Настоящее издание популярного справочника по языку SQL содержит описание всех операторов SQL, описанных стандартом 2003 года, реализованных в таких СУБД, как Microsoft SQL Server 2008, Oracle 11g, MySQL 5.1 и PostgreSQL 8.3. Также в руководстве рассмотрены основы...
3rd Edition. — Addison-Wesley Professional, 2015. — 745 p. — ISBN: 978-0-321-99247-5. The #1 Easy, Common-Sense Guide to SQL Queries—Updated for Today’s Databases, Standards, and Challenges SQL Queries for Mere Mortals has earned worldwide praise as the clearest, simplest tutorial on writing effective SQL queries. The authors have updated this hands-on classic to reflect new...
9th Edition. — Wiley, 2019. — 512 p. — ISBN: 978-1-119-52707-7. Целевая аудитория: начинающие разработчики. Если вам нужен подробный и качественный материал по основам баз данных и языку запросов SQL, эта книга может похвастаться и тем, и другим. Вы узнаете про типы базы данных, а также рассмотрите примеры их использования. Научитесь выполнять SQL запросы на выборку, удаление и...
2016. — 82 p. — ASIN B01D0NX0G4. Need to learn SQL for work, but don’t know where to start? Ever tried to learn, but got bored with dry-as-dust textbooks? Let SQL With a Smile introduce you to the Structured Query Language with a laid-back approach…and a lot of bad jokes! Don’t get bogged down with database details you don’t need yet. SQL With a Smile uses a laid-back approach to...
Syncfusion Inc, 2017. — 102 p. SQL is the language of data, and therefore the intermediary language for those who straddle the line between technology and business. Every business application needs a database and SQL is the key to working with these databases. Nick Harrison’s SQL Queries Succinctly will show you how to craft queries in SQL, from basic CRUD statements and slicing...
Addison-Wesley Professional, 2017. — 562 p. — ISBN: 0134578899, 9780134578897. Effective SQL brings together practical solutions and insights so you can solve complex problems with SQL and design databases that simplify data management in the future. It’s the only modern book that brings together advanced best practices and realistic example code for all of these versions of...
CreateSpace Independent Publishing Platform, 2016. — 158 p. — ISBN10: 1539376869. — ISBN13: 978-1539376866. Have you always wanted to learn computer programming, but never get to it thinking it'll be too difficult and not knowing where to begin? Or perhaps you have some knowledge in programming but are interested in learning the SQL language fast? A book is your best...
Amazon Digital Services LLC, 2016. — 44 p. — ASIN: B01M7QPAQ7. This book assumes a familiarity with relational data tables. Readers should have access to a query environment that allows viewing data tables and running SQL queries against a database or data warehouse. Prerequisites Instructions Joining tables SQL Single-table operations Selecting columns Selecting rows Sorting...
Amazon Digital Services LLC, 2016. — 36 p. — ASIN: B01BI8KANO SQL is a universal programming language for interaction with databases. All statements here are designed to comply with SQL-89 and SQL-92, the 2 most common standards. Not all databases entirely comply with all standards, so be prepared to check for differences in the reference material for the DB you are using. This...
Amazon Digital Services LLC, 2016. — 77 p. — ASIN: B01CX2B006 SQL is a valuable and widely-used IT skill. It is the key to handling data in databases. It is used across technologies such as Microsoft SQL Server, MySQL, Oracle, and even Microsoft Access. This book gives you a way to learn SQL fast. It's a one-stop course to take readers from beginner-level, to a level where they...
CreateSpace Independent Publishing Platform, 2016. — 511 p. — ISBN10: 1532720408. — ISBN13: 978-1532720406 If you have a question about SQL Programming this is the book with the answers. SQL Programming: Questions and Answers takes some of the best questions and answers asked on the stackoverflow.com website. You can use this book to look up commonly asked questions, browse...
Amazon Digital Services LLC, 2016. — 30 p. — ASIN: B01D42UBP4 More and more companies these days are learning that they need to make DATA-DRIVEN decisions. With big data and data science on the rise, we have more data than we know what to do with. One of the basic languages of data analytics is SQL, which is used for many popular databases including MySQL, Postgres, Microsoft...
2nd Edition. — O’Reilly, 2015. — 208 p. — ISBN: 978-1-491-91646-9. Код примеров к книге выложен здесь. SQL is a powerful language for querying and manipulating data, but it’s tough to integrate it with your application. SQLAlchemy helps you map Python objects to database tables without substantially changing your existing Python code. If you’re an intermediate Python developer...
CreateSpace Independent Publishing Platform, 2015. — 168 p. — ISBN10: 1505805600, ISBN13: 978-1505805604. На англ. языке. If you are looking for a real compact practical guide on SQL, then this book is for you. SQL language is too voluminous and exposure of every aspect of this huge language is a very tedious task. Keeping aside the least utilized features, this book is rolled...
Комментарии