This is SQL is a clear, complete, and modern introduction to the language that defines data itself. Written by best-selling author Robin Nixon, it takes you from the foundations of relational databases through to advanced querying, design patterns, and modern SQL:2023 features — showing not only how SQL works, but why it became the universal language for data. This book stands apart for its precision and clarity. Every topic is explained in plain language, with practical examples and carefully structured sections that build knowledge logically. There’s no filler or confusion — just clean explanations, real queries, and insights into how SQL is used professionally across modern database systems. Whether you’re new to databases, brushing up for certification, or translating experience from another language, This is SQL gives you a complete and lasting understanding of how to design, query, and optimize data the right way. SQL underpins almost every technology stack — from web apps to analytics, from embedded systems to enterprise clouds. Mastering it properly means mastering how information itself is organized, retrieved, and transformed. This is SQL teaches not just commands and syntax, but the relational thinking behind them. How relational databases organize information through tables, keys, and relationships The core of SQL: SELECT, INSERT, UPDATE, DELETE, and filtering with WHERE, GROUP BY, and ORDER BY Designing efficient schemas with constraints, normalization, and referential integrity Writing complex joins, subqueries, and set operations that mirror real business logic Using views, transactions, and permissions safely and effectively Modern SQL: window functions, CTEs, JSON data, table constructors, and SQL:2023 syntax updates Performance and optimization: indexing, partitioning, and query tuning techniques Plain English explanations — every topic taught clearly, without jargon or assumptions No wasted pages — concise, practical sections you can learn from quickly Cross-database coverage — examples that work across MySQL, PostgreSQL, SQLite, and more Up to date — includes features and syntax standardized through SQL:2023 Kindle-optimized layout — clean, readable HTML design for every screen A full learning path — from fundamentals to modern analytics and data engineering
What you’ll learn
Why this book?
Procurando This is SQL: Everything you need to know (Coding Series) (English Edition)? Aqui você encontra tudo sobre este livro de Robin Nixon. Nesta página estão a descrição da obra, os detalhes da edição (267 páginas) e os formatos disponíveis para baixar: pdf, ibook, epub, kindle. Se você gosta de Inglês e Outras Línguas, Por Idioma, eBooks em inglês, Computação, internet e mídia digital, explore também outros títulos da mesma categoria no Porto do livro Português. Veja ainda as outras obras de Robin Nixon em nosso catálogo.
Autores populares
Unknown Author (194) Barrett Williams (163) ChatGPT ChatGPT (122) Сергей Каледин (100) Lyudmil Tsvetkov (95) Sharifa McFarlane (92) Kingston Publishing (76) YouGuide (52) animarueaidezain (49) Rodrigo B Santos (48) Nikolay Krechet (46) Hayden Van Der Post (45) Coins and More (42) Evgeniia Naumchenko (40) SHIZUOKANOSORATETSU (40) Manoj Palwe (39) Various (39) Clayton Louis Turnage (38) keieisyakentoushikaken (37) Valet WorkShop (37)Principais publicadores
Forgotten Books Routledge CRC Press HardPress Springer LitRes PublishDrive Packt Publishing OUP Oxford Tirant Lo Blanch Palgrave Macmillan epubli Wiley Chapman and Hall/CRC Hart Publishing Aspen Publishing Cambridge University Press Bloomsbury Academic Penguin Oxford University Press