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 or tuples, columns are referred to as fields or attributes.
  • 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

2.1 Control statements in C programming (sequential & conditional)

-
Image
Control statements in C: - C is a structure-orientated programming language; the statements that are used to control the flow of execution of a program are called control structures. The statements provide a specific order to execute the C program. In C programming, we have four types of control structures. Sequential control structures Conditional control structures Iterative control structures Jumping control structures   1) Sequential control structures: - The C program is a collection of instructions or set of statements which are executed sequentially in a user-specific order. No statement is slipped, and no statement is executed more than once.                   Syntax: -                Flow chart: -                Example: - Output: - 1) Conditional control structures: - It is also known as selection, branchi...
Read more

2.4 Arrays in c programming

-
Image
  Arrays: - An array is a collection of elements of the same data type stored in contiguous memory locations. It is a derived data type and a homogenous data structure. It is a variable which can store multiple values of the same type under a single variable name, making it easier to manage and manipulate related data. The size of an array is fixed. To access the elements of an array, we use indexes or subscripts accordingly. array index or subscript is used to identify array elements address. Array index or subscript starts with 0 to n-1.   Declaration of an array: - The declaration of an array means telling the compiler to create an array variable and reserving memory for a fixed number of elements of the same data type. Initialization of an array: - Initializing an array means assigning initial values to its elements. Types of arrays: - Arrays are classified based on the number of dimensions they have:             ...
Read more

3.5 Parameter passing techniques in C

-
Image
Parameter passing techniques: - Parameters are the values or variables that are passed to a function when it is called. These parameters allow data to be shared between the calling function (main) and the called function (sub function). There are mainly two types of parameter passing techniques in C:                         1.  Call by Value                         2.  Call by Reference 1)    Call- by-value: - Call by value is a method of passing arguments to a function in which a copy of the actual variable’s value is passed to the function. Any changes made inside the function do not affect the original variable outside the function.                Example: -                Output: - 2) Call-by-reference: - Call by addr...
Read more