An organized collection of data that can be easily accessed, managed, and updated., Database, In most databases, information is stored in tables. Each table contains rows and columns., Data organization, Represents a single record, such as one student or one product., Row, Represents a specific detail or attribute, such as a name, ID number, or price., Column, Different tables can be connected to each other to reduce repeated information and keep data organized., Relationships between data, Ensures that the data stored in the database is accurate and consistent., Data integrity, Rules that define user permissions — some users may only view data, while others can add or update records., Security and access control, The complete setup required for MySQL to function. It includes the MySQL server, client programs, graphical tools, and configuration settings that allow users to manage and interact with databases., MySQL environment, An open source Relational Database Management System (RDBMS) used to store, organize, and manage data in structured tables., MySQL, A standard programming language used to create, manage, and manipulate data in relational databases such as MySQL. It allows users to perform operations like retrieving, inserting, updating, and deleting data stored in database tables., SQL (Structured Query Language), The main program that manages the databases. It is responsible for storing data, processing SQL commands, and controlling access to the database., MySQL Server, A program that allows users to communicate with the MySQL server. Through the client, users can send SQL commands, view results, and manage database structures., MySQL Client, A text-based interface used to connect to the MySQL server and execute SQL commands directly., MySQL Command-Line Client, An advanced command-line tool that supports SQL, JavaScript, and Python for database management and automation., MySQL Shell, A comprehensive tool used for database design, SQL development, and server administration. It allows users to visually design database schemas, execute SQL queries, and manage database connections., MySQL Workbench, A web-based tool used to manage MySQL databases through a browser interface. It is commonly used in web hosting environments and allows users to create databases, run SQL queries, import and export data, and manage users., phpMyAdmin, The command-line interface that allows users to connect to the MySQL server and execute SQL statements directly. Useful for scripting, automation, and troubleshooting database issues., MySQL Command-Line Tool, Settings that determine how the MySQL server operates. They control aspects such as memory usage, network connections, storage engines, and security options., Configuration settings, Defines how data is stored, organized, and retrieved in MySQL tables., Storage engine, A storage engine that supports transactions and foreign keys and is commonly used in modern database systems., InnoDB, A storage engine known for fast read operations but does not support transactions., MyISAM (MySQL Indexed Sequential Access Method), A storage engine that stores data in memory for faster access but the data is temporary., MEMORY, A command that tells MySQL to create a new container where tables and data will be stored., CREATE DATABASE statement, A command used to select a database so that all tables created afterward will belong to it., USE statement, A command used to create tables. Requires the table name, column names, data types for each column, and optional constraints., CREATE TABLE statement, A query used to check the tables inside the selected database., SHOW TABLES, Removes the database and all its tables permanently., DROP DATABASE, Removes only a specific table from the database., DROP TABLE, Ensures you don't get an error when creating something that already exists., IF NOT EXISTS, Ensures you don't get an error when dropping something that doesn't exist., IF EXISTS, Used to remove all records from a table without deleting the table itself. Faster than DELETE because it doesn't log individual row deletions., TRUNCATE, A very popular open source relational database. It is widely used in web applications and websites. Many systems that use PHP also use MySQL for storing data., MySQL, A powerful commercial database developed by Oracle Corporation. It is commonly used by large businesses and enterprises that require high performance and advanced features., Oracle Database, A database system developed by Microsoft. It is widely used in enterprise applications and systems that run on Windows servers., Microsoft SQL Server, An advanced open source relational database known for reliability, strong data integrity, and powerful features. Many developers use it for complex applications., PostgreSQL, A lightweight database stored in a single file. It is commonly used in mobile apps, desktop software, and small systems that do not require a full database server., SQLite, A NoSQL database that stores data in flexible document like formats instead of traditional tables. It is often used in modern web applications and large-scale systems., MongoDB, A community developed version of MySQL. It is compatible with MySQL but offers additional performance improvements and features., MariaDB, Provide a visual interface for database management. Most popular: MySQL Workbench and phpMyAdmin., Graphical Management Tools, Determine how the MySQL server operates (memory usage, network connections, storage engines, security options)., Configuration Settings, Define how data is stored, organized, and retrieved in MySQL tables. Commonly used: InnoDB, MyISAM, MEMORY., Storage Engines, Key features: Visual database modeling, SQL query editor, Database administration tools, Server performance monitoring., MySQL Workbench, Web-based tool: create databases, run SQL queries, import and export data, manage users., phpMyAdmin, Useful for scripting, automation, and troubleshooting database issues., MySQL Command-Line Tool, Specify the kind of value that can be stored in a column of a table. They define the format, size, and possible range of values for the column., MySQL Data Types, Rules applied to table columns to restrict the type of data that can be inserted into the database. These rules help maintain data integrity and accuracy., Constraints, Ensures that a column cannot contain NULL values., NOT NULL, Ensures that all values in a column are different., UNIQUE, Uniquely identifies each record in a table. It cannot contain NULL values and must always be unique., PRIMARY KEY, A key used to link one table with another table., FOREIGN KEY, Automatically generates a unique number whenever a new record is inserted., AUTO_INCREMENT, Sets a default value for a column if no value is specified., DEFAULT, Ensures that all values in a column satisfy a specific condition., CHECK, Adds new records into a table., INSERT INTO, Retrieves data from one or more tables., SELECT, Modifies existing records in a table., UPDATE, Removes records from a table., DELETE, Filters records based on a condition., WHERE, Sorts query results in ascending or descending order., ORDER BY, Ascending order., ASC, Descending order., DESC, Restricts the number of rows returned by a query., LIMIT, Used for pattern matching in text values., LIKE, Represents zero, one, or many characters., %, Represents a single character., _, Combines rows from two or more tables based on a related column., JOIN, Returns only matching rows from both tables., INNER JOIN, Returns all rows from the left table and matching rows from the right table., LEFT JOIN, Returns all rows from the right table and matching rows from the left table., RIGHT JOIN, Returns all rows when there is a match in either table., FULL JOIN, A query inside another query., Subquery, Functions that perform calculations on multiple rows and return one result., Aggregate Functions, Counts rows., COUNT(), Adds values., SUM(), Calculates average., AVG(), Returns largest value., MAX(), Returns smallest value., MIN(), Groups rows with the same values., GROUP BY, Filters groups after grouping., HAVING, The process of organizing data to reduce redundancy and improve integrity., Normalization, Each column contains atomic values and no repeating groups., First Normal Form (1NF), Meets 1NF and all non-key attributes depend on the whole primary key., Second Normal Form (2NF), Meets 2NF and has no transitive dependency., Third Normal Form (3NF), A server-side scripting language used for web development., PHP, A local server package containing Apache, MySQL/MariaDB, PHP, and phpMyAdmin., XAMPP, A web server software that serves web pages to users., Apache, The local computer acting as a server., localhost, The default PHP file loaded in a folder., index.php, Outputs text or variables to the browser., echo, Outputs text similar to echo., print, A container for storing data values., Variable, Text data enclosed in quotes., String, Whole number data type., Integer, Decimal number data type., Float, Represents TRUE or FALSE., Boolean, A variable that can store multiple values., Array, Combining strings together using a dot (.)., Concatenation, Executes code if a condition is true., if statement, Executes code if the if condition is false., else statement, Adds another condition if previous condition is false., elseif.

WEB DEV 2

द्वारा
प्रिंट
एम्बेड

लीडरबोर्ड

दृश्य शैली

विकल्प

टेम्पलेट स्विच करें

)
ऑटो-सेव पुनःस्थापित करें: ?