OWASP Bricks - Web Application Security Learning Platform
OWASP Bricks is a web application security learning platform built with PHP and MySQL. It offers a simple, clean, and friendly interface where users can break the bricks and learn security concepts. The platform is open source, free to use, and almost all levels can be solved using the OWASP Mantra
1 views • 10 slides
Guide to MySQL Operations on Turing Server
This guide provides step-by-step instructions on working with MySQL on Turing server at turing.csce.uark.edu. It includes logging in via SSH, connecting to the server, changing MySQL passwords, and performing operations on tables. Learn how to create tables, change passwords, and more with detailed
2 views • 21 slides
Understanding Database Management Systems (DBMS)
A Database Management System (DBMS) is a crucial tool for organizing, storing, and managing data efficiently. It allows users to create, update, retrieve, and delete data effectively, ensuring data consistency and security. DBMS software like MySQL and Oracle provide interfaces for various database
0 views • 21 slides
Interactive Hololens Tour Project Overview
This project involves creating a Microsoft Hololens heads-up display for an interactive tour of the ASU campus. It includes showcasing landmarks and a Twitter feed displaying geo-tagged tweets. The motivation stems from enhancing self-guided tour experiences for prospective students, potentially aid
1 views • 15 slides
Python Interface with MySQL: Database Programming Basics
Python provides powerful features for database programming, allowing interaction with databases like MySQL, Oracle, and more. The Python DB API is a widely used module that enables creating, accessing, and manipulating data. An interface acts as a bridge between applications and systems, facilitatin
3 views • 80 slides
Importing and Exporting Data Between CSV Files, MySQL, and Pandas
In this chapter, we explore how to transfer data between CSV files, MySQL databases, and Pandas using Python. We learn about the CSV file format, creating CSV files, and reading data from CSV files into Dataframes. This chapter provides insights into efficient data management techniques using Pandas
1 views • 11 slides
Overview of C Programming Language
C programming language, developed in 1972 by Dennis M. Ritchie, is widely used for software development due to its efficiency, low-level capabilities, and portability across platforms. Learning C is essential for aspiring software engineers as it forms the foundation for many modern technologies suc
0 views • 6 slides
Comprehensive Overview of SQL Commands and Language Categories
In this detailed guide, you will learn about Structured Query Language (SQL) including its various commands such as Data Definition Language (DDL), Data Manipulation Language (DML), Data Control Language (DCL), and Transaction Control Language (TCL). Explore how SQL is used in Database Management Sy
0 views • 15 slides
Real-World Concurrency Bugs and Detection Strategies
Explore the complexities of real-world concurrency bugs through a study of 105 bugs from major open-source programs. Learn about bug patterns, manifestation conditions, diagnosing strategies, and fixing methods to improve bug detection and avoidance. Gain insights from methodologies evaluating appli
0 views • 20 slides
Understanding Many-to-Many Relationships in Relational Databases
Exploring the intricacies of many-to-many relationships in database design through the use of associative entities. Learn why a third entity is essential, how to create relational databases with foreign keys, and the importance of identifying relationships. Dive into MySQL Workbench symbols and the
0 views • 26 slides
Getting Started with PHP MySQL - Connecting and Manipulating Databases
PHP allows you to connect to MySQL databases for efficient data manipulation. Discover what MySQL is, how it works, and ways to establish a connection using MySQLi and PDO extensions. Learn about storing data in tables and executing code examples for seamless database interaction.
0 views • 24 slides
Web Security and Database Connections
Explore the importance of storing persistent states in web applications and the various methods to do so efficiently. Discover the LAMP stack and the role of MySQL as the second-most used open-source relational database. Learn about Structured Query Language and its significance in interacting with
0 views • 29 slides
E-Commerce Web Application Development Prototype for an Online Store
Develop an e-commerce web application allowing users to browse and purchase products, create accounts, and manage a shopping cart. Implement admin functionalities for adding, updating, and deleting items. The project involves front-end development using HTML & CSS, back-end development with Java Ser
0 views • 24 slides
Exploring Three-Tiered Architectures and Web Development Tools
This collection of reviews covers topics such as PHP programming, interpreting languages, connecting to MySQL databases, and selecting data from tables. It delves into the fundamentals of internet technologies including HTTP requests, JavaScript, AJAX, and more. Each review provides insights and pra
0 views • 54 slides
Overview of PHP-Fusion: A Lightweight CMS with Comprehensive Features
PHP-Fusion is an open-source CMS written in PHP, utilizing a MySQL database for content storage. It offers a simple yet complete administration system and features like News, Categories, Articles, Web Links, and more. Learn about its installation process, functionality, and admin panel.
0 views • 14 slides
Seamless MySQL to Redshift Migration Your Essential Guide
Migrating your data from MySQL to Redshift can seem like a daunting task, especially if you're managing large datasets or complex schemas. However, with the right tools and strategies, this process can be simplified significantly. Ask On Data stands
0 views • 4 slides
Retro Cataloguing Tool for Efficient Encoding of Older Book Items at University of Liege Library
The University of Liege Library has developed a PHP/MySQL application called Scriptorium to efficiently catalog older print volumes published before 1970. With Scriptorium, non-catalogers can quickly encode books, reducing the time and cost of traditional cataloging methods. The library's extensive
0 views • 28 slides
Cat-Brain Database Project Overview and Development Process
The Cat-Brain Database Project led by Dr. Irina Beloozerova aims to facilitate data sharing among research laboratories. It follows a modified Agile development methodology with rapid prototyping and iterative design. Tools such as Trello and MySQL were utilized. Lessons were learned from Francesca,
0 views • 14 slides
Understanding the Difference Between Oracle PL/SQL and MySQL
Explore the distinctions between Oracle PL/SQL and MySQL, such as their control statements, introduction, block structure, and types of blocks. Learn through examples and visuals the differences in syntax, features, and capabilities between these two popular database languages.
0 views • 17 slides
Accessing MySQL Database Using PHP and PDO
Learn how to access a MySQL database using PHP through PDO (Portable Data Objects) with step-by-step examples for connecting to MySQL, selecting and displaying data in a web application. PDO provides a flexible and secure way to interact with databases in PHP programming.
0 views • 22 slides
Bonrix SMPP Gateway 1.0.1 Overview
Bonrix SMPP Gateway 1.0.1 is a J2EE web application that allows clients to connect via TCP-IP or HTTP API. It provides an administrative web interface for managing users, SMS termination settings, and offers various SMS termination mechanisms. The system uses MySQL and MongoDB as database servers an
0 views • 24 slides
Tutorial: Accessing Hacker Web Forums and Shodan Data
Discover how to access Hacker Web forums hosted by a MySQL database, explore table structures, learn to use MySQL clients, and access data programmatically via Java. Additionally, learn about Shodan for further data exploration.
0 views • 23 slides