DATABASE (DB)

A database is an organized collection of data that is stored and accessed electronically. Databases are used to store and manage data for a variety of applications, including websites, mobile apps, and enterprise systems.

Types of Databases

There are several types of databases, each with their own strengths and weaknesses. Here are some common types of databases:

• Relational Databases: These databases store data in tables with rows and columns. Examples include MySQL, PostgreSQL, and SQLite.
• NoSQL Databases: These databases do not use the traditional table-based structure of relational databases. Instead, they use a variety of data models, such as key-value pairs or document-based data. Examples include MongoDB, Cassandra, and Redis.
• Graph Databases: These databases are designed to store and manage highly interconnected data, such as social networks or recommendation engines. Examples include Neo4j and OrientDB.

Security

Security is an important consideration when using databases. You should take steps to secure your database environment by implementing firewalls, access controls, and other security measures.

Documentation

Each database management system will have its own documentation and support resources available. This site mostly cover the MySQL Database.

• What are KEYS?
• Get Data From Database As a Json Jbject

MySQL

MySQL is an open-source relational database management system. Its name is a combination of “My”, the name of co-founder Michael Widenius’s daughter My, and “SQL”, the acronym for Structured Query Language.

• SQL Tutorial for Beginners
• Increase Maximum Upload File Size
• What is SQL
• Basic MySQL Command Examples
• MySQL String Commands
• MySQL Time Functions
• MySQL Funtions
• What is Union?
• Top 27 SQL Syntax for Developers
• SQLi (SQL Injection Weakness)
• SQL Foreign Key Constraint
• MySQL Foreign Key
• MySQL Engines
• Import Text File to MySQL
• Import Multiple gzip/gz/sql Files into MySQL Database
• CLI Connection Without Password
• Merge Rows in MySQL
• MySQL Slow Log Analyze
• Creating a Read-Only User for MySQL Backups
• JSON Columns in MySQL
  • Don’t Use JSON Columns in MySQL Here’s Why
  • How to Work with JSON Data in MySQL
  • Fearlessly Using JSON in MySQL
  • JSON in MySQL Example

Basic MySQL

• Basic SQL Commands
• Select
• Inser Into
• Update
• Delete
• Join
• Join Examples
• View Concat Coalesce
• Index

Examples

• Wordle
• Referendum
• Sakila

Examples with Socratica

Socratica is a kind of usefull channel which can be followed by anyone who wants to learn something. You can watch the video series prepared for SQL.

• Earthquake
• Martian
• Person
• Song
• Bonus: How to Create 10000 Data with Python

SQLite

SQLite is a database engine written in the C programming language. It is not a standalone app; rather, it is a library that software developers embed in their apps. As such, it belongs to the family of embedded databases.

• Install SQLite Browser on Ubuntu
• How to Change Date Format (SQL File)
• Lux Temperature Humidity Example

Useful Links

• Intro to SQL - KhanAcademy
• Introduction to SQL
• SQL Tutorial - SQLZOO
• Introduction to SQL - SQLBolt
• Select Start SQL
• Schemaverse
• Intro to Relational Databases - Udacity
• Uygulamalarla SQL Öğreniyorum - BTK Akademi