VIPBOOK.SU
ЭЛЕКТРОННАЯ БИБЛИОТЕКА






Добро пожаловать на сайт электронной библиотеки!
Здесь можно найти произведения русских и зарубежных авторов.
Скачать множество книг и журналов различных жанров и направлений.
Большой выбор художественной, бизнес, учебной и технической литературы.
Все представленные здесь книги и журналы имеют подробное описание и обложку.
Наша библиотека регулярно пополняется только новыми и интересными материалами!

«Подробнее о сайте»            «Правила сайта»            «Написать нам»            «Статьи»

Rahul Batra - SQL Primer: An Accelerated Introduction to SQL Basics

Компьютерные >> Операционные системы





Разместил: Ingvar16

16-06-2018, 03:55

Просмотров: 136





Rahul Batra - SQL Primer: An Accelerated Introduction to SQL Basics

Build a core level of competency in SQL so you can recognize the parts of queries and write simple SQL statements. SQL knowledge is essential for anyone involved in programming, data science, and data management. This book covers features of SQL that are standardized and common across most database vendors. You will gain a base of knowledge that will prepare you to go deeper into the specifics of any database product you might encounter.

Examples in the book are worked in PostgreSQL and SQLite, but the bulk of the examples are platform agnostic and will work on any database platform supporting SQL. Early in the book you learn about table design, the importance of keys as row identifiers, and essential query operations. You then move into more advanced topics such as grouping and summarizing, creating calculated fields, joining data from multiple tables when it makes business sense to do so, and more. Throughout the book, you are exposed to a set-based approach to the language and are provided a good grounding in subtle but important topics such as the effects of null value on query results. With the explosion of data science, SQL has regained its prominence as a top skill to have for technologists and decision makers worldwide. SQL Primer will guide you from the very basics of SQL through to the mainstream features you need to have a solid, working knowledge of this important, data-oriented language.

What You'll Learn

Create and populate your own database tables
Read SQL queries and understand what they are doing
Execute queries that get correct results
Bring together related rows from multiple tables
Group and sort data in support of reporting applications
Get a grip on nulls, normalization, and other key concepts
Employ subqueries, unions, and other advanced features

Who This Book Is For

Anyone new to SQL who is looking for step-by-step guidance toward understanding and writing SQL queries. The book is aimed at those who encounter SQL statements often in their work, and provides a sound baseline useful across all SQL database systems. Programmers, database managers, data scientists, and business analysts all can benefit from the baseline of SQL knowledge provided in this book.

Название: SQL Primer: An Accelerated Introduction to SQL Basics
Автор: Rahul Batra
Издательство: Apress
ISBN: 1484235754
Год: 2018
Страниц: 199
Язык: английский
Формат: pdf (true), azw3, rtf, epub
Размер: 10.1 MB

Скачать Rahul Batra - SQL Primer: An Accelerated Introduction to SQL Basics









Похожие публикации

David Paper - Data Science Fundamentals for Python and MongoDB David Paper - Data Science Fundamentals for Python and MongoDB
Build the foundational data science skills necessary to work with and better understand complex data science algorithms. This example-driven book provides complete Python coding examples to complement and clarify data science concepts, and enrich

Sanket Thodge - Cloud Analytics with Google Cloud Platform Sanket Thodge - Cloud Analytics with Google Cloud Platform
Combine the power of analytics and cloud computing for faster and efficient insights. With the ongoing data explosion, more and more organizations all over the world are slowly migrating their infrastructure to the cloud. These cloud platforms also

Sricharan Vadapalli - Hands-on DevOps Sricharan Vadapalli - Hands-on DevOps
Transform yourself into a specialist in DevOps adoption for Big Data on cloud. DevOps strategies have really become an important factor for big data environments. This book initially provides an introduction to big data, DevOps, and Cloud computing

Laine Campbell, Charity Majors - Database Reliability Engineering: Designing and Operating Resilient Database Systems Laine Campbell, Charity Majors - Database Reliability Engineering: Designing and Operating Resilient Database Systems
The infrastructure-as-code revolution in IT is also affecting database administration. With this practical book, developers, system administrators, and junior to mid-level DBAs will learn how the modern practice of site reliability engineering

Chekanov S. Numeric Computation and Statistical Data Analysis on the Java Platform Chekanov S. Numeric Computation and Statistical Data Analysis on the Java Platform
Numeric Computation and Statistical Data Analysis on the Java Platform is a great choice for those who want to learn how statistical data analysis can be done using popular programming languages, who want to integrate data analysis algorithms in

Database Design for Mere Mortals: A Hands-On Guide to Relational Database Design (3rd Edition) Database Design for Mere Mortals: A Hands-On Guide to Relational Database Design (3rd Edition)
The #1 Easy, Commonsense Guide to Database Design! Michael J. Hernandez’s best-selling Database Design for Mere Mortals® has earned worldwide respect as the clearest, simplest way to learn relational database design. Now, he’s made this hands-on,

Practical Database Programming with Visual Basic.NET Practical Database Programming with Visual Basic.NET
The most up-to-date Visual Basic.NET programming textbook—covering both fundamentals and advanced-level programming techniques—complete with examples and solutions Visual Basic.NET (VB.NET) is an object-oriented computer programming language that

Access 2010 All-in-One For Dummies Access 2010 All-in-One For Dummies
What kind of golden nuggets are in your data? This reference shows how to take advantage of Microsoft Access 2010's new features and capabilities so you can, well, access the information you need. You'll breeze through everything from tables,

Marc Delisle - Mastering phpMyAdmin 3.4 for Effective MySQL Management Marc Delisle - Mastering phpMyAdmin 3.4 for Effective MySQL Management
PHPmyAdmin is one of the most widely used open source applications, which is written in PHP. phpMyAdmin supports a wide range of operations with MySQL. Currently, it can create and drop databases, create/drop/alter tables, delete/edit/add fields,

PHP & MySQL: The Missing Manual PHP & MySQL: The Missing Manual
If you can build websites with CSS and javascript, this book takes you to the next level—creating dynamic, database-driven websites with PHP and MySQL. Learn how to build a database, manage your content, and interact with users through queries




Отзывы и Комментарии





Добавление комментария

Ваше Имя:
Ваш E-Mail:(необязательно)
  • bowtiesmilelaughingblushsmileyrelaxedsmirk
    heart_eyeskissing_heartkissing_closed_eyesflushedrelievedsatisfiedgrin
    winkstuck_out_tongue_winking_eyestuck_out_tongue_closed_eyesgrinningkissingstuck_out_tonguesleeping
    worriedfrowninganguishedopen_mouthgrimacingconfusedhushed
    expressionlessunamusedsweat_smilesweatdisappointed_relievedwearypensive
    disappointedconfoundedfearfulcold_sweatperseverecrysob
    joyastonishedscreamtired_faceangryragetriumph
    sleepyyummasksunglassesdizzy_faceimpsmiling_imp
    neutral_faceno_mouthinnocent

Книги