- Table View
- List View
SQL Essentials For Dummies
by Richard Blum Allen G. TaylorA 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 get what you need, fast. Great for a brush-up on the basics or as an everyday desk reference, this book is one you can rely on. Strengthen your understanding of the basics of SQL Review what you've already learned or pick up key skills Use SQL to create, manipulate, and control relational databases Jog your memory on the essentials as you work and get clear answers to your questions Perfect for supplementing classroom learning, reviewing for a certification, and staying knowledgeable on the job, SQL Essentials For Dummies is the convenient, direct, and digestible reference you've been looking for.
SQL for Data Analysis: Advanced Techniques for Transforming Data into Insights
by Cathy TanimuraWith the explosion of data, computing power, and cloud data warehouses, SQL has become an even more indispensable tool for the savvy analyst or data scientist. This practical book reveals new and hidden ways to improve your SQL skills, solve problems, and make the most of SQL as part of your workflow.You'll learn how to use both common and exotic SQL functions such as joins, window functions, subqueries, and regular expressions in new, innovative ways--as well as how to combine SQL techniques to accomplish your goals faster, with understandable code. If you work with SQL databases, this is a must-have reference.Learn the key steps for preparing your data for analysisPerform time series analysis using SQL's date and time manipulationsUse cohort analysis to investigate how groups change over timeUse SQL's powerful functions and operators for text analysisDetect outliers in your data and replace them with alternate valuesEstablish causality using experiment analysis, also known as A/B testing
SQL for Data Analytics: Perform fast and efficient data analysis with the power of SQL
by Benjamin Johnston Upom Malik Matt GoldwasserTake your first steps to become a fully qualified data analyst by learning how to explore large relational datasets. Key Features Explore a variety of statistical techniques to analyze your data Integrate your SQL pipelines with other analytics technologies Perform advanced analytics such as geospatial and text analysis Book Description Understanding and finding patterns in data has become one of the most important ways to improve business decisions. If you know the basics of SQL, but don't know how to use it to gain business insights from data, this book is for you. SQL for Data Analytics covers everything you need progress from simply knowing basic SQL to telling stories and identifying trends in data. You'll be able to start exploring your data by identifying patterns and unlocking deeper insights. You'll also gain experience working with different types of data in SQL, including time-series, geospatial, and text data. Finally, you'll understand how to become productive with SQL with the help of profiling and automation to gain insights faster. By the end of the book, you'll able to use SQL in everyday business scenarios efficiently and look at data with the critical eye of analytics professional. What you will learn Use SQL to summarize and identify patterns in data Apply special SQL clauses and functions to generate descriptive statistics Use SQL queries and subqueries to prepare data for analysis Perform advanced statistical calculations using the window function Analyze special data types in SQL, including geospatial data and time data Import and export data using a text file and PostgreSQL Debug queries that won't run Optimize queries to improve their performance for faster results Who this book is for If you're a database engineer looking to transition into analytics, or a backend engineer who wants to develop a deeper understanding of production data, you will find this book useful. This book is also ideal for data scientists or business analysts who want to improve their data analytics skills using SQL. Knowledge of basic SQL and database concepts will aid in understanding the concepts covered in this book.
SQL for Data Analytics: Harness the power of SQL to extract insights from data, 3rd Edition
by Jun Shan Matt Goldwasser Upom Malik Benjamin JohnstonTake your first steps to becoming a fully qualified data analyst by learning how to explore complex datasetsKey FeaturesMaster each concept through practical exercises and activitiesDiscover various statistical techniques to analyze your dataImplement everything you've learned on a real-world case study to uncover valuable insightsBook DescriptionEvery day, businesses operate around the clock, and a huge amount of data is generated at a rapid pace. This book helps you analyze this data and identify key patterns and behaviors that can help you and your business understand your customers at a deep, fundamental level. SQL for Data Analytics, Third Edition is a great way to get started with data analysis, showing how to effectively sort and process information from raw data, even without any prior experience. You will begin by learning how to form hypotheses and generate descriptive statistics that can provide key insights into your existing data. As you progress, you will learn how to write SQL queries to aggregate, calculate, and combine SQL data from sources outside of your current dataset. You will also discover how to work with advanced data types, like JSON. By exploring advanced techniques, such as geospatial analysis and text analysis, you will be able to understand your business at a deeper level. Finally, the book lets you in on the secret to getting information faster and more effectively by using advanced techniques like profiling and automation. By the end of this book, you will be proficient in the efficient application of SQL techniques in everyday business scenarios and looking at data with the critical eye of analytics professional.What you will learnUse SQL to clean, prepare, and combine different datasetsAggregate basic statistics using GROUP BY clausesPerform advanced statistical calculations using a WINDOW functionImport data into a database to combine with other tablesExport SQL query results into various sourcesAnalyze special data types in SQL, including geospatial, date/time, and JSON dataOptimize queries and automate tasksThink about data problems and find answers using SQLWho this book is forIf you're a database engineer looking to transition into analytics or a backend engineer who wants to develop a deeper understanding of production data and gain practical SQL knowledge, you will find this book useful. This book is also ideal for data scientists or business analysts who want to improve their data analytics skills using SQL.Basic familiarity with SQL (such as basic SELECT, WHERE, and GROUP BY clauses) as well as a good understanding of linear algebra, statistics, and PostgreSQL 14 are necessary to make the most of this SQL data analytics book.
SQL for Data Scientists: A Beginner's Guide for Building Datasets for Analysis
by Renee M. TeateJump-start your career as a data scientist—learn to develop datasets for exploration, analysis, and machine learning SQL for Data Scientists: A Beginner's Guide for Building Datasets for Analysis is a resource that’s dedicated to the Structured Query Language (SQL) and dataset design skills that data scientists use most. Aspiring data scientists will learn how to how to construct datasets for exploration, analysis, and machine learning. You can also discover how to approach query design and develop SQL code to extract data insights while avoiding common pitfalls. You may be one of many people who are entering the field of Data Science from a range of professions and educational backgrounds, such as business analytics, social science, physics, economics, and computer science. Like many of them, you may have conducted analyses using spreadsheets as data sources, but never retrieved and engineered datasets from a relational database using SQL, which is a programming language designed for managing databases and extracting data. This guide for data scientists differs from other instructional guides on the subject. It doesn’t cover SQL broadly. Instead, you’ll learn the subset of SQL skills that data analysts and data scientists use frequently. You’ll also gain practical advice and direction on "how to think about constructing your dataset." Gain an understanding of relational database structure, query design, and SQL syntax Develop queries to construct datasets for use in applications like interactive reports and machine learning algorithms Review strategies and approaches so you can design analytical datasets Practice your techniques with the provided database and SQL code In this book, author Renee Teate shares knowledge gained during a 15-year career working with data, in roles ranging from database developer to data analyst to data scientist. She guides you through SQL code and dataset design concepts from an industry practitioner’s perspective, moving your data scientist career forward!
SQL For Dummies
by Allen G. TaylorUncover the secrets of SQL and start building better relational databases today!This fun and friendly guide will help you demystify database management systems so you can create more powerful databases and access information with ease. Updated for the latest SQL functionality, SQL For Dummies, 8th Edition covers the core SQL language and shows you how to use SQL to structure a DBMS, implement a database design, secure your data, and retrieve information when you need it.Includes new enhancements of SQL:2011, including temporal data functionality which allows you to set valid times for transactions to occur and helps prevent database corruptionCovers creating, accessing, manipulating, maintaining, and storing information in relational database management systems like Access, Oracle, SQL Server, and MySQLProvides tips for keeping your data safe from theft, accidental or malicious corruption, or loss due to equipment failures and advice on eliminating errors in your workDon't be daunted by database development anymore - get SQL For Dummies, 8th Edition, and you'll be on your way to SQL stardom.
SQL For Dummies (For Dummies Series)
by Allen G. TaylorGet ready to make SQL easy! Updated for the latest version of SQL, the new edition of this perennial bestseller shows programmers and web developers how to use SQL to build relational databases and get valuable information from them. Covering everything you need to know to make working with SQL easier than ever, topics include how to use SQL to structure a DBMS and implement a database design; secure a database; and retrieve information from a database; and much more. SQL is the international standard database language used to create, access, manipulate, maintain, and store information in relational database management systems (DBMS) such as Access, Oracle, SQL Server, and MySQL. SQL adds powerful data manipulation and retrieval capabilities to conventional languages—and this book shows you how to harness the core element of relational databases with ease. Server platform that gives you choices of development languages, data types, on-premises or cloud, and operating systems Find great examples on the use of temporal data Jump right in—without previous knowledge of database programming or SQL As database-driven websites continue to grow in popularity—and complexity—SQL For Dummies is the easy-to-understand, go-to resource you need to use it seamlessly.
SQL für Dummies (Für Dummies)
by Allen G. TaylorDaten und Datenbanken sind quasi überall. Mit der Standardabfragesprache SQL können Daten in relationalen Datenbanken einfach, strukturiert und zielsicher abgefragt werden. Erfahren Sie in diesem Buch, welches kein Vorwissen voraussetzt, wie man Datenbanken erstellt, wie man Daten ordnet und abfragt und wie man SQL-Anweisungen in Programme und Websites einbindet. Nutzen Sie dieses Buch auch als Nachschlagewerk. Ganz wichtig: Sie lernen auch, wie Sie Ihre Datenbanken und Daten schützen und wie Sie typische Fehler vermeiden.
SQL für Dummies (Für Dummies)
by Allen G. TaylorDaten und Datenbanken sind quasi überall. Mit der Standardabfragesprache SQL können Daten in relationalen Datenbanken einfach, strukturiert und zielsicher abgefragt werden. Erfahren Sie in diesem Buch, das kein Vorwissen voraussetzt, wie Sie Datenbanken erstellen, Daten ordnen und abfragen und wie Sie SQL-Anweisungen in Programme und Websites einbinden. Nutzen Sie dieses Buch auch als Nachschlagewerk. Ganz wichtig: Sie lernen auch, wie Sie Ihre Datenbanken und Daten schützen und wie Sie typische Fehler vermeiden.
SQL Hacks: Tips & Tools for Digging Into Your Data
by Andrew Cumming Gordon RussellWhether you're running Access, MySQL, SQL Server, Oracle, or PostgreSQL, this book will help you push the limits of traditional SQL to squeeze data effectively from your database. The book offers 100 hacks -- unique tips and tools -- that bring you the knowledge of experts who apply what they know in the real world to help you take full advantage of the expressive power of SQL. You'll find practical techniques to address complex data manipulation problems. Learn how to:Wrangle data in the most efficient way possibleAggregate and organize your data for meaningful and accurate reportingMake the most of subqueries, joins, and unionsStay on top of the performance of your queries and the server that runs themAvoid common SQL security pitfalls, including the dreaded SQL injection attackLet SQL Hacks serve as your toolbox for digging up and manipulating data. If you love to tinker and optimize, SQL is the perfect technology and SQL Hacks is the must-have book for you.
SQL in a Nutshell: A Desktop Quick Reference Guide (In a Nutshell (O'Reilly))
by Brand Hunt Kevin Kline Daniel KlineFor programmers, analysts, and database administrators, SQL in a Nutshell is the essential reference for the SQL language used in today's most popular database products. This new edition clearly documents every SQL command according to the latest ANSI standard, and details how those commands are implemented in Microsoft SQL Server 2008, Oracle 11g, and the MySQL 5.1 and PostgreSQL 8.3 open source database products. You'll also get a concise overview of the Relational Database Management System (RDBMS) model, and a clear-cut explanation of foundational RDBMS concepts -- all packed into a succinct, comprehensive, and easy-to-use format. This book provides: Background on the Relational Database Model, including current and previous SQL standards Fundamental concepts necessary for understanding relational databases and SQL commands An alphabetical command reference to SQL statements, according to the SQL2003 ANSI standard The implementation of each command by MySQL, Oracle, PostgreSQL, and SQL Server An alphabetical reference of the ANSI SQL2003 functions, as well as the vendor implementations Platform-specific functions unique to each implementation Beginning where vendor documentation ends, SQL in a Nutshell distills the experiences of professional database administrators and developers who have used SQL variants to support complex enterprise applications. Whether SQL is new to you, or you've been using SQL since its earliest days, you'll get lots of new tips and techniques in this book.
SQL in a Nutshell
by Kevin KlineSQL in a Nutshell is a practical and useful command reference to the latest release of the Structured Query Language (SQL99). For experienced SQL programmers, analysts, and database administrators, it's a handy key to each of the SQL commands and its use in both commercial (Microsoft SQL Server 2000 and Oracle 8 i ) and open source (MySQL, PostgreSQL 7.0) implementations. SQL in a Nutshell is also a great learning resource for novice and auxiliary SQL users.
SQL in a Nutshell: A Desktop Quick Reference
by Kevin Kline Brand Hunt Daniel KlineSQL in a Nutshell applies the eminently useful "Nutshell" format to Structured Query Language (SQL), the elegant--but complex--descriptive language that is used to create and manipulate large stores of data. For SQL programmers, analysts, and database administrators, the new second edition of SQL in a Nutshell is the essential date language reference for the world's top SQL database products. SQL in a Nutshell is a lean, focused, and thoroughly comprehensive reference for those who live in a deadline-driven world.This invaluable desktop quick reference drills down and documents every SQL command and how to use it in both commercial (Oracle, DB2, and Microsoft SQL Server) and open source implementations (PostgreSQL, and MySQL). It describes every command and reference and includes the command syntax (by vendor, if the syntax differs across implementations), a clear description, and practical examples that illustrate important concepts and uses. And it also explains how the leading commercial and open sources database product implement SQL. This wealth of information is packed into a succinct, comprehensive, and extraordinarily easy-to-use format that covers the SQL syntax of no less than 4 different databases.When you need fast, accurate, detailed, and up-to-date SQL information, SQL in a Nutshell, Second Edition will be the quick reference you'll reach for every time. SQL in a Nutshell is small enough to keep by your keyboard, and concise (as well as clearly organized) enough that you can look up the syntax you need quickly without having to wade through a lot of useless fluff. You won't want to work on a project involving SQL without it.
SQL in a Nutshell: A Desktop Quick Reference
by Kevin Kline Regina O. Obe Leo S. HsuFor 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 implemented in Microsoft SQL Server 2019 and Oracle 19c, as well as in the MySQL 8, MariaDB 10.5, and PostgreSQL 14 open source database products.You'll also get a concise overview of the relational database management system (RDBMS) model and a clear-cut explanation of foundational RDBMS concepts--all packed into a succinct, comprehensive, and easy-to-use format.Sections include:Background on the relational database model, including current and previous SQL standardsFundamental concepts necessary for understanding relational databases and SQL commandsAn alphabetical command reference to SQL statements, according to the SQL:2016 ANSI standardThe implementation of each command by MySQL, Oracle, PostgreSQL, and SQL ServerAn alphabetical reference of the ANSI SQL:2016 functions and constructs as well as the vendor implementationsPlatform-specific functions unique to each implementation
SQL Injection Strategies: Practical techniques to secure old vulnerabilities against modern attacks
by Ettore Galluccio Edoardo Caselli Gabriele LombariLearn to exploit vulnerable database applications using SQL injection tools and techniques, while understanding how to effectively prevent attacks Key Features Understand SQL injection and its effects on websites and other systems Get hands-on with SQL injection using both manual and automated tools Explore practical tips for various attack and defense strategies relating to SQL injection Book Description SQL injection (SQLi) is probably the most infamous attack that can be unleashed against applications on the internet. SQL Injection Strategies is an end-to-end guide for beginners looking to learn how to perform SQL injection and test the security of web applications, websites, or databases, using both manual and automated techniques. The book serves as both a theoretical and practical guide to take you through the important aspects of SQL injection, both from an attack and a defense perspective. You'll start with a thorough introduction to SQL injection and its impact on websites and systems. Later, the book features steps to configure a virtual environment, so you can try SQL injection techniques safely on your own computer. These tests can be performed not only on web applications but also on web services and mobile applications that can be used for managing IoT environments. Tools such as sqlmap and others are then covered, helping you understand how to use them effectively to perform SQL injection attacks. By the end of this book, you will be well-versed with SQL injection, from both the attack and defense perspective. What you will learn Focus on how to defend against SQL injection attacks Understand web application security Get up and running with a variety of SQL injection concepts Become well-versed with different SQL injection scenarios Discover SQL injection manual attack techniques Delve into SQL injection automated techniques Who this book is for This book is ideal for penetration testers, ethical hackers, or anyone who wants to learn about SQL injection and the various attack and defense strategies against this web security vulnerability. No prior knowledge of SQL injection is needed to get started with this book.
SQL & NoSQL Databases: Models, Languages, Consistency Options and Architectures for Big Data Management
by Andreas Meier Michael KaufmannThis book 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 coming innovations. The book opens with a broad look at data management, including an overview of information systems and databases, and an explanation of contemporary database types:SQL and NoSQL databases, and their respective management systemsThe nature and uses of Big DataA high-level view of the organization of data management Data Modeling and Consistency Chapter-length treatment is afforded Data Modeling in both relational and graph databases, including enterprise-wide data architecture, and formulas for database design. Coverage of languages extends from an overview of operators, to SQL and and QBE (Query by Example), to integrity constraints and more. A full chapter probes the challenges of Ensuring Data Consistency, covering:Multi-User OperationTroubleshootingConsistency in Massive Distributed DataComparison of the ACID and BASE consistency models, and more System Architecture also gets from its own chapter, which explores Processing of Homogeneous and Heterogeneous Data; Storage and Access Structures; Multi-dimensional Data Structures and Parallel Processing with MapReduce, among other topics. Post-Relational and NoSQL Databases The chapter on post-relational databases discusses the limits of SQL – and what lies beyond, including Multi-Dimensional Databases, Knowledge Bases and and Fuzzy Databases. A final chapter covers NoSQL Databases, along withDevelopment of Non-Relational Technologies,Key-Value, Column-Family and Document StoresXML Databases and Graphic Databases, and more The book includes more than 100 tables, examples and illustrations, and each chapter offers a list of resources for further reading. SQL & NoSQL Databases conveys the strengths and weaknesses of relational and non-relational approaches, and shows how to undertake development for big data applications. The book benefits readers including students and practitioners working across the broad field of applied information technology.This textbook has been recommended and developed for university courses in Germany, Austria and Switzerland.
SQL- & NoSQL-Datenbanken: 9. erweiterte und aktualisierte Auflage
by Michael Kaufmann Andreas MeierDie Autoren führen in relationale (SQL) und nicht-relationale (NoSQL) Datenbanken ein. Die 9. Auflage erklärt die drei Typen relationale Datenbanken, Graphdatenbanken und Dokumentdatenbanken im Detail anhand der Themen Datenbankmanagement, Datenbankmodellierung, Datenbanksprachen, Datenbanksicherheit und Systemarchitektur. Das Buch bietet außerdem einen Überblick auf postrelationale und nicht-relationale Datenbanksysteme.In den ersten fünf Kapiteln analysieren die Autoren detailliert die Verwaltung, Modellierung, Sprachen, Sicherheit und Architektur von relationalen Datenbanken, Graphdatenbanken und Dokumentendatenbanken. Außerdem wird ein Überblick über andere SQL- und NoSQL-basierte Datenbankansätze gegeben. Neben klassischen Konzepten wie dem Entitäts- und Beziehungsmodell und seiner Abbildung in SQL-Datenbankschemata, Abfragesprachen oder dem Transaktionsmanagement werden weitere Aspekte für NoSQL-Datenbanken wie nicht-relationale Datenbankschemas und Abfragesprachen (MQL, Cypher), das Map/Reduce-Verfahren, Verteilungsoptionen (Sharding, Replikation) oder das CAP-Theorem (Consistency, Availability, Partition Tolerance) erläutert.Die 9. Auflage bietet neu eine vertiefte Einführung in Dokumentdatenbanken mit einer Methode zur Modellierung von Dokumentstrukturen, einem Überblick auf dokumentenorientierte Datenbanksprache MongoDB Query Language MQL sowie Sicherheits- und Architekturaspekte. Die neue Auflage berücksichtigt neue Entwicklungen der Sprache Cypher. Das Thema Datenbanksicherheit wird neu als eigenes Kapitel eingeführt und im Detail bezüglich Datenschutz, Integrität und Transaktionen analysiert. Texte zum Datenmanagement, zur Datenbankprogrammierung und zum Data Warehouse wurden aktualisiert. Zudem erklärt die 9. Auflage die Konzepte JSON, JSON-Schema, BSON, indexfreie Nachbarschaft, Cloud-Datenbanken, Suchmaschinen und Zeitreihendatenbanken.Eine Webseite ergänzt den Inhalt des Buches durch Tutorien für Abfrage- und Manipulationssprachen (SQL, Cypher), Übungsumgebungen für Datenbanken (MySQL, Neo4j), zwei Fallstudien mit OpenOffice Base und Neo4j sowie als Unterrichtsmaterial Folienvorlagen mit allen Abbildungen Das Buch richtet sich sowohl an Studierende, die eine Einführung in das Gebiet der SQL- und NoSQL-Datenbanken möchten, als auch auch an Praktiker in Datenwissenschaften und Informatik, denen es hilft, Stärken und Schwächen relationaler und nicht-relationaler Ansätze sowie Entwicklungen für Big-Data-Anwendungen besser einschätzen zu können
SQL on Big Data
by Sumit PalLearn various commercial and open source products that perform SQL on Big Data platforms. You will understand the architectures of the various SQL engines being used and how the tools work internally in terms of execution, data movement, latency, scalability, performance, and system requirements. This book consolidates in one place solutions to the challenges associated with the requirements of speed, scalability, and the variety of operations needed for data integration and SQL operations. After discussing the history of the how and why of SQL on Big Data, the book provides in-depth insight into the products, architectures, and innovations happening in this rapidly evolving space. SQL on Big Data discusses in detail the innovations happening, the capabilities on the horizon, and how they solve the issues of performance and scalability and the ability to handle different data types. The book covers how SQL on Big Data engines are permeating the OLTP, OLAP, and Operational analytics space and the rapidly evolving HTAP systems. You will learn the details of: Batch Architectures--Understand the internals and how the existing Hive engine is built and how it is evolving continually to support new features and provide lower latency on queries Interactive Architectures--Understanding how SQL engines are architected to support low latency on large data sets Streaming Architectures--Understanding how SQL engines are architected to support queries on data in motion using in-memory and lock-free data structures Operational Architectures--Understanding how SQL engines are architected for transactional and operational systems to support transactions on Big Data platforms Innovative Architectures--Explore the rapidly evolving newer SQL engines on Big Data with innovative ideas and concepts Who This Book Is For: Business analysts, BI engineers, developers, data scientists and architects, and quality assurance professionals
SQL para Iniciantes
by Preston Prescott Rafaella C. S. BarrosEsse livro guia você passo a passo no ensino de como criar bancos de dados, populá-los com dados, extrair apenas os dados que você precisa e muito mais. Descrição do livro Data de publicação: 15 de fevereiro de 2015 Aprenda o SQL Básico e Habilidades de Bancos de Dados Saber como fazer consultas em SQL e fazer pesquisas em um banco de dados é uma habilidade essencial se você é um Administrador de Banco de Dados, Administrador de Sistemas ou Programador. Passo a Passo em Português Esse livro guia você passo a passo no ensino de como criar bancos de dados, populá-los com dados, extrair apenas os dados que você precisa e muito mais. Esse livro usa uma linguagem simples, clara e concisa, toda projetada para ajudá-lo a aprender SQL da maneira mais fácil possível. Eis algumas das coisas que você irá aprender quando ler SQL para Iniciantes: Como criar e excluir bancos de dados. Como projetar tabelas e que tipos de dados usar e quando. Maneiras de popular seu banco de dados e tabelas com dados. Como alterar uma tabela após ter sido criada. Como extrair tudo, ou apenas alguns, dados de um banco de dados. Como recuperar e classificar dados. Realizar cálculos matemáticos usando SQL como média, encontrar o maior número em um conjunto e mais. Formatar os dados em um banco de dados incluindo retornar os dados como caixa alta ou baixa e mais. Como escrever declarações e cláusulas SQL eficientes. Como e por quê criar relacionamentos em seus bancos de dados. A diferenças entre inner, outer, right e left join. Como executar subconsultas SQL. Como construir declarações SQL complexas usando cláusulas múltiplas e operadores Maneiras de resumir dados em seus bancos de dados E muito mais... Funciona com Microsoft SQL Server, MySQL, MariaDB, SQLite, IBM DB2, PostgreSQL, Microsoft Access e Oracle. Você pode usar as consultas SQL e conceitos encontrados em SQL para Inicia
SQL para Principiantes
by Preston Prescott Andrés ParraudAprendizaje de lo Esencial de SQL y Habilidades de Bases de Datos Sabiendo cómo construir consultas SQL y encontrar el rumbo dentro de bases de datos es una habilidad esencial si eres un Administrador de Bases de Datos, Administrador de Sistemas o Programador. Paso a paso en Español Este libro te guiará paso a paso, enseñándote cómo crear bases de datos, llenarlas de datos, extraer exactamente lo que necesitas, y mucho más. El libro utiliza un lenguaje llano, claro y conciso pensado para ayudarte a aprender SQL de la manera más sencilla posible. Estas son sólo algunas de las cosas que aprenderás cuando leas SQL para Principiantes: Cómo crear y borrar bases de datos. Cómo diseñar tablas y qué tipos de datos usar en ellas. Formas de llenar tu base de datos y tablas con datos. Cómo modificar una tabla luego de crearla. Cómo extraer todo, o sólo una parte, de los datos de la base de datos. Cómo recuperar y ordenar datos. Realizar cálculos matemáticos usando SQL; promedio, encontrar el valor más alto de un conjunto, y más. Dar formato a los datos en una base de datos, incluyendo devolver los datos en mayúsculas, minúsculas, y más. Cómo escribir sentencias y cláusulas SQL eficientes. Cómo y por qué crear relaciones en tus bases de datos. La diferencia entre unión interna, externa, derecha e izquierda. Cómo ejecutar sub-consultas SQL. Cómo construir sentencias SQL complejas, usando cláusulas y operadores. Formas de resumir los datos en tus bases de datos. Y mucho más... Funciona con Microsoft SQL Server, MySQL, MariaDB, SQLite, IBM DB2, PostgreSQL, Microsoft Access, y Oracle. Podrás usar las consultas SQL, y los conceptos que encuentras en SQL para Principiantes funcionan en cualquier base de datos SQL, incluyendo SQL Server, MySQL, PostgreSQL, y Oracle. Invalor
SQL per principianti: imparate l'uso dei database Microsoft SQL Server, MySQL, PostgreSQL e Oracle
by Eugenia Franzoni Preston PrescottImparate quello che serve su SQL e database. Sapere come creare delle query SQL e navigare nei database è essenziale se siete un amministratore di database, un amministratore di sistemi o un programmatore. Passo-passo con linguaggio semplice. Questo libro vi guida passo-passo nella creazione di database, nell'inserimento dei dati al loro interno, nell'estrazione dei dati che vi servono e molto altro, con un linguaggio chiaro, semplice e conciso in modo da aiutarvi ad imparare l'SQL il più facilmente possibile. Ecco solo alcune delle cose che imparerete leggendo "SQL per principianti": Come creare e cancellare database. Come progettare tabelle e quali tipi di dati usare. Come popolare il database e le tabelle con i dati. Come modificare una tabella già creata. Come estrarre tutti i dati o solo alcuni. Come estrarre e ordinare i dati. Effettuare calcoli matematici usando SQL come la media, il massimo di un insieme e altri. Formattare i dati, tra cui rendere il testo minuscolo, maiuscolo, e altro. Come scrivere dichiarazioni e clausole SQL efficienti. Come e perché creare relazioni nei database. La differenza tra inner, outer, right e left join. Come fare sottoquery. Come costruire dichiarazioni complesse usando più clausole e operatori. Come riassumere i dati del database E molto altro... Funziona con Microsoft SQL Server, MySQL, MariaDB, SQLite, IBM DB2, PostgreSQL, Microsoft Access e Oracle. Potete usare le query e i concetti di SQL trovati in questo libro su qualsiasi database SQL, compresi SQL Server, MySQL, PostgreSQL e Oracle. Preziosissimo per i programmatori... Tutti i programmi di computer, tranne quelli più semplici, interagiscono con i database. Non importa quale linguaggio stiate usando, dovrete creare, leggere, aggiornare o cancellare dati da un database. Le query che imparerete funzioneranno con linguaggi quali PHP, Python, Ruby, e altri. SQL
SQL Pocket Guide: A Guide to SQL Usage (Pocket References Ser.)
by Jonathan GennickIf you're a programmer or database administrator who uses SQL in your day-to-day work, this popular pocket guide is the ideal on-the-job reference. You'll find many examples that address the language's complexity, along with key aspects of SQL used in IBM DB2 Release 9.7, MySQL 5.1, Oracle Database 11g Release 2, PostgreSQL 9.0, and Microsoft SQL Server 2008 Release 2. SQL Pocket Guide describes how these database systems implement SQL syntax for querying, managing transactions, and making changes to data. It also shows how the systems use SQL functions, regular expression syntax, and type conversion functions and formats. All example SQL statements in this book execute against a set of tables, with data that you can quickly download. The third edition covers important database changes, including: Oracle's support of the recursive WITH syntax, and addition of PIVOT and UNPIVOT operators Functions new to Oracle, such as LISTAGG, NTH_VALUE, and more PostgreSQL's support of recursive WITH and some window functions DB2 syntax and datatypes, some compatible with Oracle MySQL features such as the TIMESTAMP type and the TO_SECONDS function
SQL Pocket Guide
by Jonathan GennickSQL is the language of databases. It's used to create and maintain database objects, place data into those objects, query the data, modify the data, and, finally, delete data that is no longer needed. Databases lie at the heart of many, if not most business applications. Chances are very good that if you're involved with software development, you're using SQL to some degree. And if you're using SQL, you should own a good reference or two. Now available in an updated second edition, our very popular SQL Pocket Guide is a major help to programmers, database administrators, and everyone who uses SQL in their day-to-day work. The SQL Pocket Guide is a concise reference to frequently used SQL statements and commonly used SQL functions. Not just an endless collection of syntax diagrams, this portable guide addresses the language's complexity head on and leads by example. The information in this edition has been updated to reflect the latest versions of the most commonly used SQL variants including:Oracle Database 10g, Release 2 (includingthe free Oracle Database 10g Express Edition (XE))Microsoft SQL Server 2005MySQL 5IBM DB2 8.2PostreSQL 8.1 database
SQL Pocket Guide: A Guide to SQL Usage
by Alice ZhaoIf you use SQL in your day-to-day work as a data analyst, data scientist, or data engineer, this popular pocket guide is your ideal on-the-job reference. You'll find many examples that address the language's complexities, along with key aspects of SQL used in Microsoft SQL Server, MySQL, Oracle Database, PostgreSQL, and SQLite.In this updated edition, author Alice Zhao describes how these database management systems implement SQL syntax for both querying and making changes to a database. You'll find details on data types and conversions, regular expression syntax, window functions, pivoting and unpivoting, and more.Quickly look up how to perform specific tasks using SQLApply the book's syntax examples to your own queriesUpdate SQL queries to work in five different database management systems NEW: Connect Python and R to a relational databaseNEW: Look up frequently asked SQL questions in the "How Do I?" chapter
SQL Pocket Guide, 2nd Edition
by Jonathan GennickSQL is the language of databases. It's used to create and maintain database objects, place data into those objects, query the data, modify the data, and, finally, delete data that is no longer needed. Databases lie at the heart of many, if not most business applications. Chances are very good that if you're involved with software development, you're using SQL to some degree. And if you're using SQL, you should own a good reference or two. Now available in an updated second edition, our very popular SQL Pocket Guide is a major help to programmers, database administrators, and everyone who uses SQL in their day-to-day work. The SQL Pocket Guide is a concise reference to frequently used SQL statements and commonly used SQL functions. Not just an endless collection of syntax diagrams, this portable guide addresses the language's complexity head on and leads by example. The information in this edition has been updated to reflect the latest versions of the most commonly used SQL variants including: * Oracle Database 10g, Release 2 (including the free Oracle Database 10g Express Edition (XE)) * Microsoft SQL Server 2005 * MySQL 5 * IBM DB2 8.2 * PostreSQL 8.1 database