Learning Center - sql
https://codingchoice.com/learn/
2026-05-03T10:37:43+00:00Learning Center
https://codingchoice.com/learn/
https://codingchoice.com/learn/_media/logo.pngtext/html2025-02-12T01:53:16+00:00Anonymous (anonymous@undisclosed.example.com)database_security
https://codingchoice.com/learn/sql/database_security?rev=1739325196&do=diff
Database Security
Best Practices for Database Security
Use Strong Authentication – Implement strong passwords and multi-factor authentication.
Limit User Privileges – Follow the principle of least privilege.
Encrypt Sensitive Data – Use encryption to protect data.text/html2025-02-12T01:43:36+00:00Anonymous (anonymous@undisclosed.example.com)getting_started
https://codingchoice.com/learn/sql/getting_started?rev=1739324616&do=diff
Setting Up a SQL Environment
Installing a Database Management System (DBMS)
Popular DBMSs include:
* MySQL – Open-source and widely used
* PostgreSQL – Advanced open-source DBMS
* Microsoft SQL Server – Enterprise-level DBMS
* Oracle Databasetext/html2025-02-12T01:39:06+00:00Anonymous (anonymous@undisclosed.example.com)introduction
https://codingchoice.com/learn/sql/introduction?rev=1739324346&do=diff
Introduction to SQL
What is SQL?
Structured Query Language (SQL) is a standard programming language used to manage and manipulate relational databases. SQL is essential for tasks such as querying data, updating records, managing access control, and defining database structures.text/html2025-02-12T01:47:52+00:00Anonymous (anonymous@undisclosed.example.com)joins
https://codingchoice.com/learn/sql/joins?rev=1739324872&do=diff
JOIN Operations
INNER JOIN
Retrieves matching records from both tables.
SELECT employees.name, departments.department_name
FROM employees
INNER JOIN departments ON employees.department_id = departments.id;
LEFT JOIN
Retrieves all records from the left table and matching records from the right table.text/html2025-02-12T01:45:26+00:00Anonymous (anonymous@undisclosed.example.com)querying_data
https://codingchoice.com/learn/sql/querying_data?rev=1739324726&do=diff
Querying Data
SELECT Statement
Retrieves data from a table.
SELECT name, salary FROM employees;
WHERE Clause
Filters records based on a condition.
SELECT * FROM employees WHERE department = 'HR';
ORDER BY Clause
Sorts query results.
SELECT * FROM employees ORDER BY salary DESC;text/html2025-02-12T01:57:50+00:00Anonymous (anonymous@undisclosed.example.com)sidebar
https://codingchoice.com/learn/sql/sidebar?rev=1739325470&do=diff
* Introduction
* Getting Started
* Querying Data
* Joins
* Stored Procedures
* Transactions
* Database Security
* SQL Optimizationtext/html2025-02-12T01:56:29+00:00Anonymous (anonymous@undisclosed.example.com)sql_optimization
https://codingchoice.com/learn/sql/sql_optimization?rev=1739325389&do=diff
SQL Optimization
Techniques for Query Optimization
Use Indexing – Indexes improve search performance.
Optimize Joins – Use proper indexing in joins.
Avoid SELECT * – Retrieve only necessary columns.
Use Proper Data Types – Reduce storage and improve performance.text/html2025-02-12T01:49:34+00:00Anonymous (anonymous@undisclosed.example.com)stored_procedures
https://codingchoice.com/learn/sql/stored_procedures?rev=1739324974&do=diff
Stored Procedures
Stored procedures are reusable SQL code blocks that improve efficiency and security.
Example: Creating a Stored Procedure
DELIMITER $$
CREATE PROCEDURE GetEmployees()
BEGIN
SELECT * FROM employees;
END $$
DELIMITER;
Example: Executing a Stored Proceduretext/html2025-02-12T01:51:34+00:00Anonymous (anonymous@undisclosed.example.com)transactions
https://codingchoice.com/learn/sql/transactions?rev=1739325094&do=diff
Transactions
Transactions ensure data integrity by treating multiple SQL statements as a single unit.
Example: Using Transactions
START TRANSACTION;
UPDATE employees SET salary = 75000 WHERE id = 1;
COMMIT;
Example: Rolling Back a Transaction
START TRANSACTION;
DELETE FROM employees WHERE id = 2;
ROLLBACK;