Reading Time: 12 minutes
In this article, we will review the Nmap software program and multiple commands. Nmap is an open-source mainstream tool used by network administrators to scan ports and map networks. Nmap commands are primarily used to identify which ports certain software is running on our system. It is also used to discover available hosts and what services they are offering and detecting potential security risks. Using Nmap, you can check a single host or a complete network. In this tutorial, we will cover several basic as well as advanced Nmap commands in the “Pro Tips and Tricks” section of the article.
Continue reading “Using Nmap: Pro Tips and Tricks”
Reading Time: 2 minutes
In this tutorial, we will explore how to run SQL queries on a database within PhpMyAdmin. SQL stands for Structured Query Language. SQL statements or queries are used to perform database tasks such as searching, updating, or retrieving data from a database.
Continue reading “Running SQL Queries on a Database with PhpMyAdmin”
Reading Time: 6 minutes
Data in a MySQL/MariaDB database is stored in tables. A simple way of thinking about indexes is to imagine an extensive spreadsheet. This type of system is not always conducive to quick searching; that’s where an index becomes essential. If there is no index, then the database engine has to start at row one and browse through all the rows looking for the corresponding values. If this is a small table, then it is no big deal, but in larger tables and applications where there can be tables with millions and even billions of rows, it becomes problematic. As you can imagine, searching through those rows one by one will be time-consuming, even on the latest hardware. The solution is to create an INDEX (or more than one) for your data.
Continue reading “MySQL Performance: MySQL/MariaDB Indexes”
Reading Time: 7 minutes
The SQLAlchemy Toolkit and Object Relational Mapper is an extensive set of utilities for working with Python and databases. This toolkit provides a package full of popular persistence patterns, designed for economical and robust database accessibility. SQLAlchemy allows a developer to use simple SQL statements (unlike other Object Relational Mapping tools) which provide a helpful method to connect database tables with user-defined Python classes. The SQLAlchemy Object Relational Mapping tool is primarily centered on using the SQL Expression language.
Continue reading “How To Install SQLAlchemy”
Reading Time: 5 minutes
In this article, we will learn the basics of joining tables in SQL. We will learn about Left, Right, Inner, and Outer joins and give examples of how to use them.
Data in an RDBMS (Relational Database Management System) is grouped into tables. These tables have a rigid definition of the type of data that can be stored in them. To connect different tables, and thus different types of data that may relate to each other, we will use the JOIN clause.
Continue reading “MySQL Performance: Intro to JOINS in SQL”
Reading Time: 3 minutes
In this article, we will discuss what the SQuirreL SQL Client is, some of its features, the supported database types, and how to install the client.
What is SQuirreL SQL Client?
The SQuirreL SQL Client is an open-source, graphical Java database administration tool that will allow you to review the structure of a JDBC compliant database, browse the data in tables, and issue SQL commands.
Continue reading “How to Install SQuirrel SQL Client”