3.1 MYSQL

-

 Introduction to MySQL:

  • MySQL is one of the most popular Relational Database Management Systems (RDBMS).
  • It is used to store, manage, and retrieve structured data in the form of tables with rows and columns. Rows are referred to as records, columns are referred to as fields.
  • MySQL uses SQL (Structured Query Language) for querying and managing databases.
  • It supports operations like creating, inserting, updating, deleting, and retrieving data.
  • It is widely used in web applications, software, and data management systems.

            Examples: Banking systems, e-commerce sites, student databases.

 

Features of MYSQL: -

  1. Open Source
  2. Relational Database Management System (RDBMS)
  3. Cross-Platform Support
  4. Follows Client-Server Architecture
  5. High Performance
  6. Scalability & Flexibility
  7. Security Features
  8. ACID properties
  9. Integration with programming languages
  10. Community and support

 

1) Open Source: -

  • MySQL is free to use under the GNU General Public License and open-source.
  • The source code can be modified and redistributed.

 

2) Relational Database Management System (RDBMS): -

  • It stores data in tables (rows and columns).
  • It supports relations between tables using primary keys and foreign keys.

 

3) Cross-Platform Support: -

  • It runs on multiple operating systems:

                    Windows,

                    Linux,

                    macOS,

                    Solaris and many other operating systems.

 

4) Follows Client-Server Architecture: -

  • The database runs as a server.
  • Applications like Python, PHP, and Java act as clients connecting to it.

 

5) High Performance: -

  • It handles large volumes of data efficiently.
  • It uses indexing and optimized queries for speed.

 

6) Scalability & Flexibility: -

  • It is suitable for small applications and large enterprise systems.
  • It can handle thousands of concurrent users, i.e, Multiple users can access and work on the database at the same time

 

7) Security Features: -

  • It provides user authentication, access control, and SSL encryption.
  • It protects data from unauthorized access.

 

8) ACID properties: -

  • It ensures data reliability and integrity with:

                Atomicity - All operations complete or none.

                Consistency - Database remains valid.

                Isolation - Transactions don’t affect each other.

                Durability - Data is safe even after system failure.

 

9) Integration with Programming Languages: -

  • It works with Python, Java, PHP, C, C++, etc, and commonly used in web development (e.g., with PHP in WordPress).
  • It uses Stored Procedures, Triggers & Views

 

10) Community & Support: -

  • Large community, tutorials, and professional support available.

 

Popular posts from this blog

operators in c programming

-
Image
v Operators: - An operator is a symbol that tells or intimates to the compiler to perform specific calculations or manipulations on one or more operands. Operators are essential for performing computations and making decisions in programs.   a + b is an operation a & b are operands + is an operator   Based on number of operands involved: 1.      Unary operators: - unary operators can be applied on only one operator. Example: -   ++ , -- , - (unary minus) , sizeof , ~ (compliment) , ! (not).   2.      Binary operators: - binary operators can be applied on two operands. Example: -   + , -,   * , / , etc.   3.    Ternary operators: - Ternary operator can be applied on three operands. Example: -   ?: (ternary conditional operator).   C supports several operators, can be classified into following...
Read more

Variables in c

-
Image
  Variables: - A variable is a data name or an identifier which stores a value that can be changed during the program execution.  Every variable might belong to any of the data types, like int, float, char, etc.  The name of a variable can be composed of letters, digits, and the underscore character. It must begin with either a letter or an underscore.  Variables are case-sensitive because uppercase and lowercase letters are distinct. C programming language also allows defining various other types of variables, like numeric array, character array, pointer, Structure, Union, Enumeration and etc.               Example: - sum, height, _value Declaring a variable in C: - Variable declaration means telling the compiler about the name and type of a variable before using it in the program. Variable declaration is the process of reserving a memory location and defining the type of data that will be stored in that locatio...
Read more

Cloud Storage and Local Storage: Applications in Business

-
  Cloud Storage and  Local Storage: Applications in Business: -   Local Storage: - Local storage refers to storing data such as text, audio, video, graphics, animation, special characters, constants, mathematical expressions and numeric data on physical devices in our computer or other electronic devices. Local storage in business refers to storing business data such as customer contact information, sales records, financial statements, employee data, market research, operational metrics, raw information like customer feedback.  It can also stores the structured data, such as in spreadsheets, or unstructured, like text from surveys or social media post on physical devices like hard drives, SSDs, or company servers within the organization’s premises.  The business owns and manages the storage hardware.  Local storage provides faster access to large files, which is helpful for tasks like video editing, 3D rendering, and engineering design projects. It o...
Read more