11.SQL in the Cloud: Platforms, Web Integration & NoSQL Comparison
1. SQL in Cloud Platforms
AWS RDS Example
CREATE TABLE employees (
id INT PRIMARY KEY,
name VARCHAR(100),
department VARCHAR(50)
);
INSERT INTO employees VALUES (1, ‘Alice’, ‘HR’), (2, ‘Bob’, ‘IT’);
SELECT * FROM employees;
Azure SQL Example
SELECT TOP 5 name, salary FROM employees ORDER BY salary DESC;
BigQuery Example
SELECT department, COUNT(*) AS total
FROM `project.dataset.employees`
GROUP BY department;
2.SQL for Web Development
SQL is commonly used in backend development to interact with databases. Example using Python and Flask:
@app.route(‘/employees’)
def get_employees():
cursor.execute(“SELECT * FROM employees”)
return jsonify(cursor.fetchall())
3. SQL vs NoSQL Comparison
| Feature | SQL | NoSQL |
|---|---|---|
| Data Model | Relational | Document/Key-Value |
| Schema | Fixed | Flexible |
| Scalability | Vertical | Horizontal |
| Examples | MySQL, PostgreSQL | MongoDB, Cassandra |
4.SQL vs NoSQL Comparison
| Feature | SQL | NoSQL |
|---|---|---|
| Data Model | Relational | Document/Key-Value |
| Schema | Fixed | Flexible |
| Scalability | Vertical | Horizontal |
| Examples | MySQL, PostgreSQL | MongoDB, Cassandra |
Practice Exercises
- Create a table in AWS RDS and insert sample data.
- Write a query in BigQuery to summarize sales by region.
- Build a Flask route to fetch data from Azure SQL.
- Compare SQL and NoSQL for a blogging platform.
Real-World Project: Cloud-Based Inventory System
Design a system using AWS RDS for storing product data, integrate with a web backend, and visualize inventory using BI tools.
CREATE TABLE products (
id INT PRIMARY KEY,
name VARCHAR(100),
quantity INT,
price DECIMAL(10,2)
);
FAQs
What is AWS RDS?
AWS RDS is a managed relational database service that supports several SQL engines like MySQL, PostgreSQL, and SQL Server.
How does SQL integrate with web development?
SQL is used in backend code to query and manipulate data, often through server-side languages like Python, PHP, or Node.js.
What are the key differences between SQL and NoSQL?
SQL uses structured schemas and relational models, while NoSQL offers flexible schemas and is optimized for scalability and performance in distributed systems.