MySQL

GB

Lesebändchen. DVD

Den leichten Einstieg in SQL und die Modellierung von Daten finden Sie hier! Schritt für Schritt führt Sie Michael Laube in diesem Leitfaden durch die SQL-Kommandos und macht Sie mit allen wichtigen Befehlen vertraut. Auf diesem Fundament aufbauend lernen Sie, wie Sie Ihre Daten richtig modellieren, verknüpfen und bearbeiten. Mithilfe dieser Anleitungen wird die Datenmodellierung mit SQL einfach und unkompliziert: So schaffen Sie Ordnung und sorgen für performante Abfragen.Aus dem Inhalt:- Grundlagen kennenlernen und verstehen- Grundfunktionen der Tabellenabfrage- Zeilen einfügen, ändern und löschen (INSERT, UPDATE und DELETE)- Tabellen mit CREATE TABLE anlegen- Mengenoperationen- Datenbanken modellieren- Datenmodelle optimieren- Datenmodelle in Tabellen überführen- Beziehungen zwischen Tabellen: JOINs- Transaktionen- Skalarfunktionen- Bedingungslogik- Mit Zeit und Datum arbeiten- Spaltenwerte mit GROUP BY gruppieren- Unterabfragen- VIEWS: Abfragen in virtuellen Tabellen speichern- Performance optimieren

Was ist Moodle? Moodle (Modular Object Oriented Distance Learning) ist ein Verwaltungssystem zur Erstellung von Online-Kursen. Diese Systeme werden auch als Virtual Learning Environments (VLE) oder Learning Management Systems (LMS) bezeichnet. Moodle ist eine kostenlose Software zur Unterstützung des Lernens und kann auf verschiedenen Plattformen installiert werden, die die php-Sprache ausführen können, wie z.B. Unix, Linux, Windows. MAC OS. Als Datenbanken können MySQL, PostgreSQL, Oracle, Access, Interbase oder ODBC verwendet werden. Moodle wird von einer virtuellen Gemeinschaft von Programmierern, Designern, Administratoren, Lehrern und Benutzern aus der ganzen Welt gemeinsam entwickelt und ist in mehreren Sprachen verfügbar. Moodle wurde zur Unterstützung von Präsenzkursen eingesetzt, so dass die Lehrkräfte nicht mehr gezwungen sind, Material im Kopierer der Hochschule zu hinterlegen oder Dateien an eine große Anzahl von Studenten per E-Mail zu senden, sondern lediglich ein Thema in Moodle erstellen lassen und die Textdateien dort "aufhängen", die die Studenten lesen müssen, um dem Thema zu folgen. Entnommen aus www.moodlelivre.com.br

Embark on a captivating journey through the history of MySQL and the visionary minds who brought it to life, primarily focusing on the brilliance of David Axmark. This unauthorized biography delves into the creation, rise, and transformation of one of the worlds most influential open-source databases. From humble beginnings to facing industry giants, discover the triumphs, controversies, and the enduring impact of MySQL. Explore David Axmarks relentless spirit and unparalleled contribution to the computing world, as well as the broader revolution sparked by open-source software. An inspiring account of technological innovation, collaboration, and the legacy that continues to shape our digital landscape.

With databases lurking in the background of every website, knowing how to manage them with MySQL is a no-brainer. This practical, hands-on introduction teaches readers all they need to know.<BR><BR>MySQL Crash Course is a fast-paced, no-nonsense introduction to relational database development. It’s filled withpractical examples and expert advice that will have you up and running quickly.<BR><BR>You’ll learn the basics of SQL, how to create a database, craft SQL queries to extract data, and work with events,procedures, and functions. You’ll see how to add constraints to tables to enforce rules about permitted data and useindexes to accelerate data retrieval. You’ll even explore how to call MySQL from PHP, Python, and Java.<BR><BR>Three final projects will show you how to build a weather database from scratch, use triggers to prevent errors in anelection database, and use views to protect sensitive data in a salary database.<BR><BR>You’ll also learn how to:<BR><BR>- Query database tables for specific information, order the results, comment SQL code, and deal with null values- Define table columns to hold strings, integers, and dates, and determine what data types to use- Join multiple database tables as well as use temporary tables, common table expressions, derived tables, andsubqueries- Add, change, and remove data from tables, create views based on specific queries, write reusable stored routines, and automate and schedule events<BR>The perfect quick-start resource for database developers, MySQL Crash Course will arm you with the tools you needto build and manage fast, powerful, and secure MySQL-based data storage systems.

Python was recently ranked as today's most popular programming language on the TIOBE index, thanks to its broad applicability to design and prototyping to testing, deployment, and maintenance. With this updated fourth edition, you'll learn how to get the most out of Python, whether you're a professional programmer or someone who needs this language to solve problems in a particular field. Carefully curated by recognized experts in Python, this new edition focuses on version 3.10, bringing this seminal work on the Python language fully up to date on five version releases, including preview coverage of upcoming 3.11 features. This handy guide will help you: - Learn how Python represents data and program as objects - Understand the value and uses of type annotations - Examine which language features appeared in which recent versions - Discover how to use modern Python idiomatically - Learn ways to structure Python projects appropriately - Understand how to debug Python code

Mit diesem Buch lernen Sie schnell und praxisnah, wie Sie dynamische Webseiten mit PHP und MySQL (oder mit MariaDB) entwickeln. Schritt für Schritt zeigt Ihnen unser Autor Thomas Theis anhand leicht nachvollziehbarer und sofort einsetzbarer Beispiele, wie Sie mit PHP programmieren und auf Datenbanken zugreifen. Es werden alle Themen behandelt, die Sie zum Erstellen von Blogs, Webshops, Chats, Foren u. Ä. benötigen. Ein Programmierkurs am Anfang des Buches stellt sicher, dass auch Programmieranfänger problemlos einsteigen können.Aus dem Inhalt:- Grundlagen- PHP-Programmierkurs- Daten senden und auswerten- Datenbanken anlegen- Objektorientiert programmieren- Fortgeschrittene Techniken- Prepared Statements- Constructor Property Promotion- Callbacks- Multibyte-Funktionen- XML und Ajax- Sicherheit erhöhen - Verschlüsselungen- Hilfen- Installation des lokalen Webservers- Hinweise für Windows-, Mac- und Ubuntu-NutzerDie Fachpresse zur Vorauflage:PHPmagazin: 'Wenn Sie einem JavaScript-Jockey schnell Grundkenntnisse von PHP verpassen müssen, führt an der 14. Auflage kein Weg vorbei.'

Welcome to this beginner's guide tailored with college students in mind. Prior familiarity with concepts like file extensions, Web URLs, and major browsers is recommended. This comprehensive textbook serves as your gateway into the world of web programming, equipping you with foundational knowledge to embark on your coding journey.Covering HTML, CSS, Bootstrap, JavaScript, React.JS, PHP, and MySQL at the introductory level, this book distinguishes itself through its focus on pragmatic problem-solving rather than delving into intricate language intricacies. By adopting this approach, readers gain a holistic perspective on web programming, allowing them to comprehend the bigger picture. For more in-depth insights on specific subjects, readers can explore online resources.This book offers a unique hands-on experience, offering a plethora of review questions and practice projects. Through these exercises, readers not only absorb information but also engage in active coding, encountering challenges and relishing the euphoria of triumph as their programs come to life. Emphasizing practicality, this learning journey isn't a quick sprint but rather a fulfilling marathon, spanning approximately 10 hours per week over two months. While not exhaustive in its coverage of any particular topic, this approach ensures you can complete the book within a semester.In this updated edition, you'll find coverage of Bootstrap 5.3.1 and React JS.18, showcasing the latest tools in web development. An informative appendix illustrates the symbiotic relationship between React JS as the frontend and PHP with a backend database. We extend our heartfelt gratitude to Dr. Youlong Zhuang for his invaluable contributions in reviewing this edition.Embark on your web programming voyage with this book and unravel the art of crafting dynamic and interactive digital experiences. Your coding potential awaits-happy learning!

How can you realize MySQL's full power? With High Performance MySQL, you'll learn advanced techniques for everything from setting service-level objectives to designing schemas, indexes, and queries to tuning your server, operating system, and hardware to achieve your platform's full potential. This guide also teaches database administrators safe and practical ways to scale applications through replication, load balancing, high availability, and failover. Updated to reflect recent advances in cloud- and self-hosted MySQL, InnoDB performance, and new features and tools, this revised edition helps you design a relational data platform that will scale with your business. You'll learn best practices for database security along with hard-earned lessons in both performance and database stability. - Dive into MySQL's architecture, including key facts about its storage engines - Learn how server configuration works with your hardware and deployment choices - Make query performance part of your software delivery process - Examine enhancements to MySQL's replication and high availability - Compare different MySQL offerings in managed cloud environments - Explore MySQL's full stack optimization from application-side configuration to server tuning - Turn traditional database management tasks into automated processes

Get the definitive handbook for manipulating, processing, cleaning, and crunching datasets in Python. Updated for Python 3.10 and pandas 1.4, the third edition of this hands-on guide is packed with practical case studies that show you how to solve a broad set of data analysis problems effectively. You'll learn the latest versions of pandas, NumPy, and Jupyter in the process. Written by Wes McKinney, the creator of the Python pandas project, this book is a practical, modern introduction to data science tools in Python. It's ideal for analysts new to Python and for Python programmers new to data science and scientific computing. Data files and related material are available on GitHub. - Use the Jupyter notebook and IPython shell for exploratory computing - Learn basic and advanced features in NumPy - Get started with data analysis tools in the pandas library - Use flexible tools to load, clean, transform, merge, and reshape data - Create informative visualizations with matplotlib - Apply the pandas groupby facility to slice, dice, and summarize datasets - Analyze and manipulate regular and irregular time series data - Learn how to solve real-world data analysis problems with thorough, detailed examples

Apply bestselling author Jon Duckett's engaging and innovative style to learning PHP and MySQLLearn PHP, the programming language used to build sites like Facebook, Wikipedia and WordPress, then discover how these sites store information in a database (MySQL) and use the database to create the web pages. This full-color book is packed with inspiring code examples, infographics and photography that not only teach you the PHP language and how to work with databases, but also show you how to build new applications from scratch. It demonstrates practical techniques that you will recognize from popular sites where visitors can: - Register as a member and log in - Create articles, posts and profiles that are saved in a database - Upload their own images and files - Automatically receive email notifications - Like and comment on posts. To show you how to apply the skills you learn, you will build a complete content management system, enhanced with features that are commonly seen on social networks. Written by best-selling HTML & CSS and JavaScript & jQuery author Jon Duckett, PHP & MySQL: Server-side Web Development uses a unique visual approach, with step-by-step instructions, practical code examples and pro tips that will teach you how to build modern database-driven websites using PHP.

A three-book set for web designers, front-end developers, and full-stack developers This three-book set combines the popular titles - HTML & CSS: Design and Build Web Sites (2011) - JavaScript & jQuery: Interactive Front-End Development (2014) - PHP & MySQL: Server-side Web Development (2022) Together these three books form an ideal platform for anyone who wants to master HTML and CSS, step up to the additional front-end interactivity possible with JavaScript and jQuery, and build back-ends with features like content management and membership using PHP and MySQL. In combination, these skills are commonly referred to as "full-stack development" HTML & CSS covers structure, text, links, images, tables, forms, useful options, adding style with CSS, fonts, colors, thinking in boxes, styling lists and tables, layouts, grids, and even SEO, Google analytics, ftp, and HTML5. JavaScript & jQuery offers an excellent combined introduction to these two technologies starting from how JavaScript changes an HTML page's code and progressing to creating interactivity including sliders, tabbed panels, accordions, and sorting images. PHP & MySQL finishes a self-taught programmer curriculum with data-driven web sites for content management or online shops that use registration, search, sending emails, and tailoring pages to individual users. - A handy three-book set that combines related skills - Highly visual format and accessible language makes these books highly effective learning tools - Perfect for beginning web designers, front-end developers, back-end developers, and full-stack developers - Written by the best-selling author on HTML and JavaScript for the last decade