Название: MySQL Crash Course, 2nd Edition (Final)
Автор: Веn Fоrtа
Издательство: Addison-Wesley Professional/Pearson Education
Год: 2024
Страниц: 304
Язык: английский
Формат: pdf (true)
Размер: 10.1 MB

MySQL is one of the most popular database management systems available, powering everything from Internet powerhouses to individual corporate databases to simple end-user applications, and everything in between. This book will teach you all you need to know to be immediately productive with the latest version of MySQL. By working through 30 highly focused hands-on lessons, your MySQL Crash Course will be both easier and more effective than you'd have thought possible. MySQL is a DBMS; that is, it is database software. MySQL has been around for a long time, and it is now installed and in use at millions of installations worldwide. Why do so many organizations and developers use MySQL? Here are some of the reasons: MySQL is open source, and it is usually free to use and even modify the software; MySQL is fast—make that very fast; MySQL is used by some of the most important and prestigious organizations and sites, all of which entrust it with their critical data. MySQL is easy to install and get up and running. In fact, historically the only real criticism of MySQL has been that it has not always supported the functionality and features offered by other DBMSs. But as new features have been added to each new version, that has changed, and it continues to do so.

Название: Node.js For Beginner: The Ultimade Guide for Intermediate Developer to Unleash the Power of Server Side javascript
Автор: Аmit К.
Издательство: Independently published
Год: 2024
Страниц: 123
Язык: английский
Формат: pdf
Размер: 10.1 MB

Unlock the full potential of Node.js and revolutionize your web and server-side development skills with "Mastering Node.js: The Ultimate Guide for Intermediate Developers to Unleash the Power of Server-Side javascript." Node.js has taken the world of web development by storm, thanks to its speed, scalability, and rich ecosystem. In this comprehensive ebook, we take you on a journey from intermediate to advanced Node.js developer, arming you with the knowledge and skills to tackle complex projects and build high-performance applications. Discover the core concepts of Node.js, from asynchronous programming and event-driven architecture to managing dependencies with npm and Yarn. Dive into the world of web applications with Express.js and explore specialized frameworks for creating RESTful APIs, whether it's building a single-page application or a high-traffic service.

Название: Web Coding & Development All-in-One For Dummies, 2nd Edition
Автор: Раul МсFеdriеs
Издательство: For Dummies
Год: 2024
Страниц: 851
Язык: английский
Формат: pdf (true), epub
Размер: 36.6 MB

Learn the in-demand skills that let you turn lines of code into websites and apps. Web Coding & Development All-in-One For Dummies is a one-stop resource for would-be developers who need guidance on the languages and steps used to build websites and applications. Learn the coding ropes and expand your existing skillset with this easy-to-understand guide. In these complete mini-books, you’ll walk through the basics of web development, structuring a page, building and processing web forms, and beyond. Learn how to build a website or create your very own app with the advice of web coding and development experts. This edition expands javascript and CSS coverage while providing new content on server-side coding and the development stack. In this book, I give you a complete education on web coding and development. You learn how to set up the tools you need, how to use HTML and CSS to design and build your site, how to use javascript to program your pages, and how to use PHP and MySQL to program your web server. I show you that these technologies aren’t hard to learn, and that even the greenest rookie programmers can learn how to put together web pages that will amaze their family and friends (and themselves). This Dummies All-in-One is great for you if want to develop coding skills but don’t have a programming background. It’s also perfect for professionals looking to brush up on their web development skills and get up to date on the latest trends and standards.

Название: Learning PHP, MySQL & javascript: A Step-by-Step Guide to Creating Dynamic Websites, 7th Edition (Early Release)
Автор: Rоbin Niхоn
Издательство: O’Reilly Media, Inc.
Год: 2023-12-05
Страниц: 132
Язык: английский
Формат: pdf, epub, mobi
Размер: 10.8 MB

Build interactive, data-driven websites with the potent combination of open source technologies and web standards, even if you have only basic HTML knowledge. With the latest edition of this popular hands-on guide, you'll tackle dynamic web programming using the most recent versions of today's core technologies: PHP, MySQL, javascript, CSS, HTML5, jQuery, Node.js, and the powerful React library. Web designers will learn how to use these technologies together while picking up valuable web programming practices along the way, including how to optimize websites for mobile devices. You'll put everything together to build a fully functional social networking site suitable for both desktop and mobile browsers.

Название: Hands-On MySQL Administration: Managing MySQL on Premise and on the Cloud (Early Release)
Автор: Аrunjith Аrаvindаn, Jеyаram Аууаlusamy
Издательство: O’Reilly Media, Inc.
Год: 2023-10-12
Язык: английский
Формат: pdf, epub, mobi
Размер: 10.1 MB

Geared to intermediate- to advanced-level DBAs and IT professionals looking to enhance their MySQL skills, this guide provides a comprehensive overview on how to manage and optimize MySQL databases. You'll learn how to create databases and implement backup and recovery, security configurations, high availability, scaling techniques, and performance tuning. Using practical techniques, tips, and real-world examples, authors Arunjith Aravindan and Jeyaram Ayyalusamy show you how to deploy and manage MySQL, Amazon RDS, Amazon Aurora, and Azure MySQL. By the end of the book, you'll have the knowledge and skills necessary to administer, manage, and optimize MySQL databases effectively.

Название: Database-Driven Web Development: Learn to Operate at a Professional Level with PERL and MySQL, 2nd Edition
Автор: Thomas Valentine
Издательство: Apress
Год: 2023
Страниц: 214
Язык: английский
Формат: pdf, epub
Размер: 10.1 MB

This book will teach you the essential knowledge required to be a successful and productive web developer with the ability to produce cutting-edge websites utilizing a database. This updated edition starts with the fundamentals of web development before delving into Perl and MySQL concepts such as script and database modelling, script-driven database interactions, content generation from a database, and information delivery from the server to the browser and vice versa. The only skills required to get the most from this book are basic knowledge of how the Internet works and a novice skill level with Perl and MySQL. The rest is intuitively presented code that most people can quickly and easily understand and employ. An extensive selection of practical, fully functional programming constructs in six different programming languages will give you the knowledge and tools required to create eye-catching, capable, and functionally impressive database-driven websites. Those who already know web development basics and web developers who want to master database-driven web development. The skills required to understand the concepts put forth in this book are a working knowledge of PERL and basic MySQL.

Название: Реляционные базы данных в примерах. Практическое пособие для программистов и тестировщиков
Автор: Kyликoв C.C.
Издательство: EPAM Systems
Год: 26.07.2023 (Версия 1.0.24)
Страниц: 425
Язык: русский
Формат: pdf, djvu
Размер: 16.1 MB

Эта книга посвящена практическому взгляду на реляционную теорию и проектирование реляционных баз данных. Здесь не рассматриваются такие фундаментальные основы, как реляционная алгебра и реляционное счисление, но с множеством примеров и пояснений показаны основные понятия и подходы, необходимые для проектирования баз данных. Все схемы баз данных в этой книге приведены в нотации UML 2.1, созданы с использованием Sparx Enterprise Architect и (если речь идёт об уровнях проектирования, для которых это актуально) ориентированы на MySQL 8.0, Microsoft SQL Server 2019, Oracle 18c. Скорее всего, приведённые решения будут успешно работать на более новых версиях этих СУБД, но не на более старых.

Название: Работа с MySQL, MS SQL Server и Oracle в примерах. 2-е издание. Практическое пособие для программистов и тестировщиков
Автор: Kyликoв C.C.
Издательство: EPAM Systems
Год: 26.07.2023 (Версия 2.0.28)
Страниц: 592
Язык: русский
Формат: pdf
Размер: 10.4 MB

Основное внимание в книге уделено практике использования SQL для решения типовых задач. В ней не рассматривается теория реляционных баз данных (предполагается, что вы с ней знакомы или сможете найти недостающую информацию), но представлено более 500 SQL-запросов: от базового выбора до использования представлений, триггеров, хранимых процедур и функций. Все примеры представлены в виде постановки и решения задач с использованием MySQL, MS SQL Server и Oracle, даны описания и анализ типичных ошибок. Все решения работают на MySQL Community Server 8.x, Microsoft SQL Server Express 2019 и Oracle 18c Express Edition и могут работать с более новыми версиями этих СУБД, но не будут работать со старыми версиями.

Название: MySQL Crash Course, 2nd Edition (Early Release)
Автор: Ben Forta
Издательство: Addison-Wesley Professional
Год: 2023
Страниц: 387
Язык: английский
Формат: pdf, epub
Размер: 10.1 MB

MySQL is one of the most popular database management systems available, powering everything from Internet powerhouses to individual corporate databases to simple end-user applications, and everything in between. And this book will teach you all you need to know to be immediately productive with MySQL. By working through 30 highly focused hands-on lessons, your MySQL Crash Course will be both easier and more effective than you'd have thought possible. The fact that you are reading this book indicates that you, somehow, need to interact with databases, and MySQL specifically. And so, before diving into MySQL and its implementation of the SQL language, it is important that you understand some basic concepts about databases and database technologies. Whether you are aware of it or not, you use databases all the time. Each time you select a name from your email address book, you are using a database. When you browse contacts on your phone, you are using a database. If you conduct a search on an Internet search site, you are using a database.

Название: Data Science Using JDBC And MySQL With Object Oriented Approach and Apache Netbeans IDE
Автор: Vivian Siahaan, Rismon Hasiholan Sianipar
Издательство: Balige Publishing
Год: 2023
Страниц: 734
Язык: английский
Формат: epub
Размер: 18.0 MB

JDBC stands for Java Database Connectivity. JDBC is a Java API to connect and execute the query with the database. It is a part of JavaSE (Java Standard Edition). JDBC API uses JDBC drivers to connect with the database. This book uses the Sakila sample database which is a fictitious database designed to represent a DVD rental store. The 15 tables of the database include film, film_category, actor, customer, rental, payment and inventory among others. The Sakila sample database is intended to provide a standard schema that can be used for examples in books, tutorials, articles, samples, and so forth. You can download the sample database from site. In this project, you will design the form for every table and you will plot: top 10 film distribution by release year; top 10 film distribution by rating; top 10 film distribution by rental duration; top 10 film distribution by language; film distribution by categorized rental rate; film distribution by categorized length; film distribution by categorized replacement cost; top 10 film distribution by actor name; top 10 actor name distribution by average rental rate, etc.