1. Новые складчины (Клуб Складчик) Показать еще

    23.01.2018: Мозг на миллион 3.0 (Ольга Фролова)

    23.01.2018: Молодильные травы. Тайны Гебеи (Ольга Левонюк)

    23.01.2018: [ast production] Мышечный панцирь

    22.01.2018: Заработок на онлайн играх (Роман Синицын)

    22.01.2018: [AST production] Путь саморазвития: Перезагрузка

  2. Гость, если у Вас на каком либо сайте есть аккаунт с повышенным статусом, то и у нас вы можете получить соответствующий статус. Подробнее читайте здесь https://skladchik.biz/threads/83942/
    Скрыть объявление
  3. Нужен организатор (Клуб Складчик) Показать еще

    19.01.2018: Бизнес на Амазон. Saleshub. Как заставить листинг продавать? (Артем Коршун)

    17.01.2018: Коучинг с 100$ к 100.000$ версия 21.0 (PLATINUM версия) Последний коучинг Дмитрия Ковпака

    16.01.2018: Adobe Photoshop. Базовый курс (Александр Сераков)

    14.01.2018: Геометрия (Videouroki) 7-11 класс

    13.01.2018: Колесо новолуний. Луна белой дороги (Лариса Кузнецова-Фетисова)

  4. Сбор взносов (Клуб Складчик) Показать еще

    19.01.2018: [mintpro.ru] Роль имиджевого портрета в деятельность инстаграмщика (Lena Mint)

    19.01.2018: Как маркетинговое семантическое ядро дает трафик, заявки и продажи? (Дмитрий Шевцов)

    18.01.2018: Как создать лесосад (Елена Арифулина)

    18.01.2018: Пряности и радости (Елена Невретдинова)

    18.01.2018: Прибыльная онлайн-школа (Александр Залогин)

Открыто Murach’s MySQL (2nd Edition) и SQL Queries for Mere Mortals (3rd Edition) 2...

Тема в разделе "Книги", создана пользователем Менеджер, 9 окт 2015.


Список пока что пуст. Запишитесь первым!

    Тип: Стандартная складчина
    Участников: 0/100
  1. 9 окт 2015
    Менеджер Организатор Организатор

    Murach’s MySQL (2nd Edition) и SQL Queries for Mere Mortals (3rd Edition) 2...

    John Viescas, Michael J. Hernandez - SQL Queries for Mere Mortals: A Hands-On Guide to Data Manipulation in SQL (3rd Edition)

    Автор: John Viescas, Michael J. Hernandez
    Язык: Английский
    Издательство: Addison-Wesley Professional
    Год: 2014 (June 21, 2014)
    ISBN: 0321992474
    Странниц: 792
    Форматы: EPUB, MOBI и PDF

    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 SQL standards and database applications and teach valuable new techniques.

    Step by step, John L. Viescas and Michael J. Hernandez guide you through creating reliable queries for virtually any modern SQL-based database. They demystify all aspects of SQL query writing, from simple data selection and filtering to joining multiple tables and modifying sets of data.

    Three brand-new chapters teach you how to solve a wide range of challenging SQL problems. You’ll learn how to write queries that apply multiple complex conditions on one table, perform sophisticated logical evaluations, and think “outside the box” using unlinked tables.

    Coverage includes

    -- Getting started: understanding what relational databases are, and ensuring that your database structures are sound

    -- SQL basics: using SELECT statements, creating expressions, sorting information with ORDER BY, and filtering data using WHERE

    -- Summarizing and grouping data with GROUP BY and HAVING clauses

    -- Drawing data from multiple tables: using INNER JOIN, OUTER JOIN, and UNION operators, and working with subqueries

    -- Modifying data sets with UPDATE, INSERT, and DELETE statements Advanced queries: complex NOT and AND, conditions, if-then-else using CASE, unlinked tables, driver tables, and more

    Practice all you want with downloadable sample databases for today’s versions of Microsoft Office Access, Microsoft SQL Server, and the open source MySQL database. Whether you’re a DBA, developer, user, or student, there’s no better way to master SQL.

    Joel Murach - Murach’s MySQL (2nd Edition)

    Автор: Joel Murach
    Язык: Английский
    Издательство: Mike Murach & Associates
    Год: 2015 (March 2, 2015)
    ISBN: 1890774820
    Странниц: 612
    Формат: PDF

    "If you ever wanted to learn to use MySQL, write SQL queries, create database elements, then this is the book to pick up." (JavaRanch.com)

    "I was amazed at how much information was packed into this book."

    "As a developer with almost 10 years of MySQL experience, I still picked up a lot of new detail on things I thought I knew."

    "I found this to be a great introductory book to MySQL."

    "Has already proven to be helpful in solving several challenges I've encountered on my current MySQL project."

    That's a sampling of what developers said about the 1st Edition of Murach's MySQL.

    Now, this 2nd Edition has been updated and improved throughout. As a result, it's easier than ever to use for learning MySQL from scratch, for switching to MySQL from another flavor of SQL (like MS SQL Server or Oracle), or for quickly looking up the forgotten details that are so essential as you develop database applications.

    Section 1 introduces you to relational databases and SQL, shows you how to use the graphical MySQL Workbench to work with a MySQL database, and teaches you to code SQL queries to retrieve, add, update, and delete data in a MySQL database. Section 2 goes deeper into querying, showing you how to work with summary queries, subqueries, data types, and functions. Section 3 shows you how to design a MySQL database using an EER model, implement the design, and create views. Section 4 shows how to create stored procedures that provide functionality similar to procedural programming languages like PHP, Java, C++, C#, and VB. And Section 5 introduces you to database administration tasks like securing and backing up database data.

    Whether you start from the beginning or jump in anywhere, it's a great guide for MySQL users at any level.


Участники складчины Murach’s MySQL (2nd Edition) и SQL Queries for Mere Mortals (3rd Edition) 2... смогут написать отзыв