![Apple C1 vs Qualcomm Modem Performance [Speedtest]](https://www.iclarified.com/images/news/96767/96767/96767-640.jpg)
![Apple Studio Display On Sale for $1249 [Lowest Price Ever]](https://www.iclarified.com/images/news/96770/96770/96770-640.jpg)
![[Fixed] Chromecast (2nd gen) and Audio can’t Cast in ‘Untrusted’ outage](https://i0.wp.com/9to5google.com/wp-content/uploads/sites/4/2019/08/chromecast_audio_1.jpg?resize=1200%2C628&quality=82&strip=all&ssl=1)
![[The AI Show Episode 139]: The Government Knows AGI Is Coming, Superintelligence Strategy, OpenAI’s $20,000 Per Month Agents & Top 100 Gen AI Apps](https://www.marketingaiinstitute.com/hubfs/ep%20139%20cover-2.png)
![[The AI Show Episode 138]: Introducing GPT-4.5, Claude 3.7 Sonnet, Alexa+, Deep Research Now in ChatGPT Plus & How AI Is Disrupting Writing](https://www.marketingaiinstitute.com/hubfs/ep%20138%20cover.png)
![Is XMPP a good option for a messaging system in an app? [closed]](https://cdn.sstatic.net/Sites/softwareengineering/Img/apple-touch-icon@2.png?v=1ef7363febba)
PSQL DAY 2
Here are some essential SQL commands with example syntax: CREATE DATABASE – Creates a new database CREATE DATABASE mydatabase; USE DATABASE – Selects a database USE mydatabase; CREATE TABLE – Creates a new table CREATE TABLE employees ( id INT PRIMARY KEY, name VARCHAR(50), age INT, department VARCHAR(50) ); INSERT INTO – Inserts data into a table INSERT INTO employees (id, name, age, department) VALUES (1, 'Alice', 30, 'HR'); SELECT – Retrieves data from a table SELECT * FROM employees; SELECT name, age FROM employees WHERE department = 'HR'; UPDATE – Modifies existing records UPDATE employees SET age = 31 WHERE id = 1; DELETE – Deletes records from a table DELETE FROM employees WHERE id = 1; DROP TABLE – Deletes a table DROP TABLE employees; ALTER TABLE – Modifies an existing table Add a column: ALTER TABLE employees ADD salary DECIMAL(10,2); Modify a column: ALTER TABLE employees MODIFY COLUMN age SMALLINT; Drop a column: ALTER TABLE employees DROP COLUMN salary; JOIN – Combines rows from two or more tables SELECT employees.name, departments.department_name FROM employees INNER JOIN departments ON employees.department = departments.id; GROUP BY & HAVING – Groups data and filters groups SELECT department, COUNT() as total_employees FROM employees GROUP BY department HAVING COUNT() > 5; ORDER BY – Sorts results SELECT * FROM employees ORDER BY age DESC; LIMIT – Restricts the number of results SELECT * FROM employees LIMIT 5; UNION – Combines results of multiple queries SELECT name FROM employees UNION SELECT name FROM managers; EXISTS – Checks for existence of data SELECT name FROM employees WHERE EXISTS ( SELECT 1 FROM departments WHERE department_name = 'IT' );
Here are some essential SQL commands with example syntax:
- CREATE DATABASE – Creates a new database
CREATE DATABASE mydatabase;
- USE DATABASE – Selects a database
USE mydatabase;
- CREATE TABLE – Creates a new table
CREATE TABLE employees (
id INT PRIMARY KEY,
name VARCHAR(50),
age INT,
department VARCHAR(50)
);
- INSERT INTO – Inserts data into a table
INSERT INTO employees (id, name, age, department)
VALUES (1, 'Alice', 30, 'HR');
- SELECT – Retrieves data from a table
SELECT * FROM employees;
SELECT name, age FROM employees WHERE department = 'HR';
- UPDATE – Modifies existing records
UPDATE employees
SET age = 31
WHERE id = 1;
- DELETE – Deletes records from a table
DELETE FROM employees WHERE id = 1;
- DROP TABLE – Deletes a table
DROP TABLE employees;
-
ALTER TABLE – Modifies an existing table
Add a column:
ALTER TABLE employees ADD salary DECIMAL(10,2);
Modify a column:
ALTER TABLE employees MODIFY COLUMN age SMALLINT;
Drop a column:
ALTER TABLE employees DROP COLUMN salary;
- JOIN – Combines rows from two or more tables
SELECT employees.name, departments.department_name
FROM employees
INNER JOIN departments ON employees.department = departments.id;
- GROUP BY & HAVING – Groups data and filters groups
SELECT department, COUNT() as total_employees
FROM employees
GROUP BY department
HAVING COUNT() > 5;
- ORDER BY – Sorts results
SELECT * FROM employees ORDER BY age DESC;
- LIMIT – Restricts the number of results
SELECT * FROM employees LIMIT 5;
- UNION – Combines results of multiple queries
SELECT name FROM employees
UNION
SELECT name FROM managers;
- EXISTS – Checks for existence of data
SELECT name FROM employees WHERE EXISTS (
SELECT 1 FROM departments WHERE department_name = 'IT'
);
