# Database Journal > DatabaseJournal.com publishes relevant, up-to-date and pragmatic articles on the use of database hardware and management tools and serves as a forum for professional knowledge about proprietary, open source and cloud-based databases--foundational technology for all IT systems. We publish insightful articles about new products, best practices and trends; readers help each other out on various database questions and problems. Database management systems (DBMS) and database security processes are also key areas of focus at DatabaseJournal.com. DatabaseJournal.com publishes relevant articles on database hardware and management tools. Read our expert guides and best practices for professionals. ## Topics - [Database News](https://www.databasejournal.com/database-news/) - [Features](https://www.databasejournal.com/features/) - [Scripts](https://www.databasejournal.com/scripts/) - [Mysql](https://www.databasejournal.com/mysql/) - [MS SQL](https://www.databasejournal.com/ms-sql/) - [Oracle](https://www.databasejournal.com/oracle/) - [MS Access](https://www.databasejournal.com/ms-access/) - [DB2](https://www.databasejournal.com/db2/) - [PostgreSQL](https://www.databasejournal.com/postgresql/) - [SAP](https://www.databasejournal.com/sap/) - [PHP](https://www.databasejournal.com/php/) ## Recent articles - [SQL SORT BY Statement](https://www.databasejournal.com/features/sql-sort-by-statement.md): In relational databases, the SQL ORDER BY statement is a powerful tool for sorting data in a table. The statement is used to arrange queried data into rows in a specific order, based upon one or more columns. In this database programming tutorial, we will learn how to use the SQL ORDER BY statement to […] - [Working with NULL Values in SQL](https://www.databasejournal.com/features/sql-null-values.md): In SQL and relational databases, NULL values are an important part of managing data and information stored in SQL tables. A NULL value is used as a placeholder for missing values or values that are unknown in a database column or cell. Understanding how to handle NULL values is important for database developers who want […] - [Working with SQL AND, OR, and NOT Operators](https://www.databasejournal.com/features/sql-and-or-not-operator.md): In a previous tutorial, we learned how to work with the WHERE clause in SQL, which database developers can use when they wish to retrieve a group of records that meet a certain criteria or condition. For instance, a database administrator may wish to find every instance in a database where a user’s name is […] - [How to Use Databases With Python](https://www.databasejournal.com/features/python-databases.md): Python allows developers to interact with various relational databases (such as Oracle, SQLite, and MySQL) and relational database systems (RDBMS) through several different libraries, which must conform to standards defined in PEP 249. In this database programming tutorial, we will discuss how to connect to a MySQL database using Python and make database queries. You […] - [SQL Data Types](https://www.databasejournal.com/features/sql-data-types.md): In SQL, data types help to define the type of value that can be stored in a database cell, or, more specifically, in a column. There are many kinds of data types in SQL and in this database programming and administration tutorial, we will look at each one and learn their syntax, how to use […] - [How to Use SQL WHERE Clause](https://www.databasejournal.com/features/sql-where-clause.md): When querying a relational database, database programmers and administrators will often need to filter the records returned or extract specific records that meet a given criteria. In this database programming tutorial, we will look at the SQL WHERE clause, learn its syntax, and preview several code examples showing its use. Read: How to Use the […] - [What is PostgreSQL?](https://www.databasejournal.com/features/what-is-postgresql.md): PostgreSQL is one of the world’s most widely used database systems in the world, offering support for not only structured query language (SQL), but JSON as well, making it a great choice for database-driven enterprise applications. In this database programming and database administration tutorial, we discuss what PostgreSQL is, its relation to SQL, and the […] - [How to Prevent SQL Injections](https://www.databasejournal.com/features/prevent-sql-injections.md): An SQL injection is an attack on a database server where a malicious actor enters – or injects – some nefarious input in a form, other than the expected input. The attack can be used to gain access to restricted data, wipe out databases, and examine the server info, among other things. In this database […] - [What is a Relational Database Management System](https://www.databasejournal.com/features/relational-database-management-system.md): If you are new to database administration or database development, you have no doubt heard the phrase “relational database management system” being tossed around. As database programmers or those that work with databases, we tend to think of database systems in terms of languages or platforms, like SQL, MySQL, or T-SQL. In today’s database programming […] - [SQL Best Practices](https://www.databasejournal.com/features/sql-best-practices.md): Structured Query Language (SQL) is a simple, yet powerful database programming and administration language used to manipulate data stored in a relational database or relational database management system (RDBMS). It is easy to learn compared to a lot of traditional programming languages. While that is great for both new database developers and veterans alike, it […] - [How To Comment in SQL](https://www.databasejournal.com/features/sql-comments.md): Regardless of the programming language you operate in, code can quickly become cluttered, unreadable, and difficult to understand. This issue is particularly compounded when you consider that every programmer has their own unique coding style and “best practices”, so the logic one developer uses (and thus, how they code things) might be different than your […] - [How to Use the SQL SELECT DISTINCT Statement](https://www.databasejournal.com/features/sql-select-distinct.md): In a previous tutorial, we discussed how to use the SQL SELECT statement to return values from a table. In today’s database programming tutorial, we will learn how to use the SELECT DISTINCT statement to return only distinct – or unique – values from a table. You can read about regular SELECT SQL statements in […] - [What is MySQL?](https://www.databasejournal.com/mysql/what-is-mysql.md): In this database programming and database administration tutorial, we are going to answer the commonly asked question: What is MySQL? We will discuss its features, pros and cons, benefits, and how it fits into the mold of traditional relational database management systems (RDBMS). Looking to learn MySQL in an online class or online course environment? […] - [What is SQL?](https://www.databasejournal.com/features/what-is-sql.md): Database administrators – or those that handle the administrative tasks associated with running a database system, rely on a database programming language to issue queries to retrieve and manipulate data from their respective database. Database programmers, data analysts, data modelers, and anyone who needs to access the information stored in a relational database management system […] - [How to Use the SQL SELECT Statement](https://www.databasejournal.com/features/sql-select.md): When working with databases, one common function is to create a query whereby a database programmer or administrator needs to select some data from from a table within a database. In SQL (Structure Query Language), this is accomplished by using the SQL SELECT statement. And that is the topic of today’s database programming tutorial. Read: […] - [Best Certifications for Database Administrators](https://www.databasejournal.com/mysql/database-administrator-certifications.md): Database administrators are responsible for the day to day management of database environments, including relational databases management systems, cloud databases, or those used for database-driven web applications. Database administration is a great career choice, with plenty of employment options and (typically) a great salary. The competition for DBA jobs can be fierce, however, and, as […] - [Best Online Courses to Learn SQL](https://www.databasejournal.com/features/sql-courses-online.md): Structured Query Language – also known as SQL – is one of the most widely used programming languages in the world. Without a doubt, it is the most widely used language for querying relational database management systems (RDBMS) around the globe. As languages go, SQL is fairly straightforward to learn, with concise and clear-cut syntax […] - [mariadb vs. MySQL](https://www.databasejournal.com/mysql/mariadb-vs-mysql.md): Data management and storage are important features when considering the software options for developing a website or e-commerce store. MySQL and MariaDB both offer support features to match a user’s website design needs and to aid in performance and security. The abilities of these two relational database management systems (RDBMS) – and whether they are […] - [Project Management Software For Database Developers](https://www.databasejournal.com/features/project-management-software-database.md): Solid project management software could make your life as a database developer much easier while helping you become more efficient and productive at your craft. But, with so many PM software solutions to choose from, you may be wondering where to start. Use this list of the top project management software for database developers as […] - [Online Courses to Learn PHP](https://www.databasejournal.com/php/php-courses.md): PHP is one of the top programming languages in the world, particularly known for its beneficial features for website design, e-commerce, and database programming. It is a great choice for WordPress developers and also plays well with other content management systems (CMS), such as Drupal. Programming and scripting languages like HTML and JavaScript also play […] - [Best Courses for Database Administrators](https://www.databasejournal.com/ms-sql/database-administrator-courses.md): Database professionals are in high demand. If you already work as one, you probably know this. And if you are looking to become a database administrator, that high demand and the commensurate salary may be what is motivating you to make this career move. How can you advance your career as a database administrator? By […] - [mongoDB vs. MySQL](https://www.databasejournal.com/mysql/mongodb-vs-mysql-database-journal.md): Changes in customer behavior have caused a new focus for the structure of commercial databases. The flexibility of data storage is essential in fulfilling the demands of customer needs and predicting future business. MongoDB and MySQL are both valuable database solutions that align to this shift in commercial objectives in database management systems. The difference […] - [Best Online Courses to Learn MySQL](https://www.databasejournal.com/mysql/mysql-courses-online.md): There are many ways for a database administrator to learn how to use a database programming language, including a book or tutorial, such as the one you are reading now. Some people prefer that method and everyone learns differently. If you are the type of student that learns more in a classroom type of environment […] - [PostgreSQL vs. MySQL: Which Is Best?](https://www.databasejournal.com/mysql/postgresql-vs-mysql-which-is-best.md): PostgreSQL and MySQL are open-source DBs for data analytics for commercial enterprises. A user can use either database management system, but one question remains. PostgreSQL vs. MySQL: Which is best? The choice between PostgreSQL and MySQL depends on the needed scalability and reliability of data management functions. PostgreSQL offers relational and non-relational solutions with high […] - [Top Common MySQL Queries](https://www.databasejournal.com/mysql/the-10-most-common-mysql-queries.md): MySQL queries are usually written once and then wrapped in class functions to minimize code repetition. This article lists the 10 queries used most often in MySQL. A Query is essentially a request for information to be retrieved from a database table or a combination of tables. There are many query languages that can be […] ## Popular articles - [Top Common MySQL Queries](https://www.databasejournal.com/mysql/the-10-most-common-mysql-queries.md) - [Working with NULL Values in SQL](https://www.databasejournal.com/features/sql-null-values.md) - [How to Use Databases With Python](https://www.databasejournal.com/features/python-databases.md) - [Top Ten MySQL GUI Tools](https://www.databasejournal.com/features/top-10-mysql-gui-tools.md) - [Working with SQL AND, OR, and NOT Operators](https://www.databasejournal.com/features/sql-and-or-not-operator.md) ## Feeds - [RSS](https://databasejournal.com/feed/) - [Sitemap](https://www.databasejournal.com/sitemap_index.xml)