SQL for everyone – Telegram
SQL for everyone
175 subscribers
71 photos
50 files
15 links
По рекламе - @cyberJohnny
Download Telegram
MySQL_Pocket_Reference_SQL_Functions_and_Utilities_2_ed_G_Reese
977.1 KB
👉Уже немного осталось до выходлных, держитесь!

MySQL Pocket Reference: SQL Functions and Utilities. 2 ed G. Reese

The MySQL Pocket Reference is a quick reference that you can take with you anywhere you go. Instead of racking your brain for the exact syntax of a variant of ALTER TABLE that you generally never use, you can reach into your laptop case and grab this reference. As an experienced MySQL architect, administrator, or programmer, you can look to this reference.
🤗
NoSQL Distilled. P. Sadalage, M. Fowler
6 MB
😼У вас понедельник. Но, не волнуйтесь, это пройдет!

NoSQL Distilled. P. Sadalage, M. Fowler

Every project is different, and there’s no way we can write a simple decision tree to choose the right data store. Instead, what we are attempting here is to provide you with enough background on how NoSQL databases work, so that you can make those judgments yourself without having to trawl the whole web. We’ve deliberately made this a small book, so you can get this overview pretty quickly. It won’t answer your questions definitively, but it should narrow down the range of options you have to consider and help you understand what questions you need to ask.
🤗
Правильно ли описан порядок работы с курсором?
Открыть курсор (OPEN)
Получить запись из курсора (FETCH) Обработать запись Закрыть курсор (CLOSE)
Anonymous Quiz
48%
Да
5%
Нет
35%
В SQL нет курсоров
12%
Посмотреть ответ
SQL. Быстрый старт. К. Фиайли.pdf
3.6 MB
Это не учебная тревога!
Это учебник!

SQL. Быстрый старт. К. Фиайли

В настоящем издании рассказывается об использовании запросов SQL для решения соответствующих классов задач по выборке данных, их модификации или по работе с объектами структуры базы данных. Все конструкции подробно описываются и иллюстрируются большим количеством примеров. Кроме того, для каждого типа запросов рассматриваются отклонения от стандарта в реализации наиболее распространенных СУБД: MS Access, MS SQL Server, Oracle, MySQL и PostgreSQL.
Команда удаляющая строки из таблицы "CUSTOMER" ?
Anonymous Quiz
8%
REMOVE FROM CUSTOMER
17%
DROP FROM CUSTOMER
70%
DELETE FROM CUSTOMER WHERE
2%
UPDATE FROM CUSTOMER
2%
Посмотреть ответ
Pro SQL Server Internals 2-Ed. D. Korotkevitch
33.3 MB
Pro SQL Server Internals 2-Ed. D. Korotkevitch

The book is logically separated into eight different parts. Even though all of these parts are relatively independent of each other, I would encourage you to start with Part I, “Tables and Indexes,” anyway. This part explains how SQL Server stores and works with data, which is the key point in understanding SQL Server Internals. The other parts of the book rely on this understanding.
😅
Pro_SQL_Server_2012_Relational_Database_Design_and_Implementation
5.2 MB
Приветствуем учебный понедельник! 🤟

Pro SQL Server 2012 Relational Database Design and Implementation. L. Davidson

This book is written for professional programmers who have the need to design a relational database using any of the Microsoft SQL Server family of databases. It is intended to be useful for the beginner to advanced programmer, either strictly database programmers or a programmer that has never used a relational database product before to learn why relational databases are designed in the way they are, and get some practical examples and advice for creating databases. Topics covered cater to the uninitiated to the experienced architect to learn techniques for concurrency, data protection, performance tuning, dimensional design, and more.
Добавить запись в SQL можно при помощи?
Anonymous Quiz
10%
CREATE
11%
ADD
77%
INSERT
1%
MAKE
1%
Посмотреть ответ
🤟
Defensive Database Programming with SQL Server. A. Kuznetsov
1 MB
Вместо 🍻, держите 📚, потому что только среда!

Defensive Database Programming with SQL Server. A. Kuznetsov

This book describes a lot of specific problems, and typical approaches that will lead to more robust code, However, my main goal is more general: it is to demonstrate how to think defensively, and how to proactively identify and eliminate potential vulnerabilities in T-SQL code during development rather than after the event when the problems have already occurred.
The book breaks down into ten chapters, as described below. Eight of these chapters are available in this free eBook version; the final two chapters are included in paid versions only.
Какая команда используется для чтения записей в SQL?
Anonymous Quiz
71%
SELECT
20%
READ
6%
QUERY
3%
Посмотреть ответ
SQL_Server_2017_Integration_Services_Cookbook_Cote_C_,_Lah_M_,_Sarka
14.8 MB
🤩А вот теперь можно!

Сразу после сохранения учебника по SQL!

SQL Server 2017 Integration Services Cookbook. Cote C., Lah M., Sarka D.

SQL Server Integration Services is a tool that facilitates data extraction, consolidation, and loading options (ETL), SQL Server coding enhancements, data warehousing, and customizations. With the help of the recipes in this book, you'll gain hands-on experience of SSIS 2017 as well as the new 2016 features, design and development improvements including SCD, tuning, and customizations.
😄
Mastering_PostgreSQL_in_Application_Development_Fontaine_Dimitri
2.1 MB
Входим в понедельник очень позитивно🥲🥲🥲

Mastering PostgreSQL in Application Development. Fontaine Dimitri

The book covers the following topics:
write SQL queries to PostgreSQL DBMS;
PostgreSQL tools;
data type;
data management;
parallel control.

Advantages:
relevant material on the topic;
numerous examples.
Что из перечисленного верно для индекса в SQL?
Anonymous Quiz
53%
CREATE INDEX ID
5%
REMOVE INDEX ID
18%
ADD INDEX ID
10%
CHANGE INDEX ID
13%
Посмотреть ответ