🔥 Trending Repository: data-engineer-handbook

📝 Description: This is a repo with links to everything you'd ever want to learn about data engineering

🔗 Repository URL: https://github.com/DataExpert-io/data-engineer-handbook

📖 Readme: https://github.com/DataExpert-io/data-engineer-handbook#readme

📊 Statistics:
🌟 Stars: 36.3K stars
👀 Watchers: 429
🍴 Forks: 7K forks

💻 Programming Languages: Jupyter Notebook - Python - Makefile - Dockerfile - Shell

🏷️ Related Topics:

#data #awesome #sql #bigdata #dataengineering #apachespark

==================================
🧠 By: https://t.iss.one/DataScienceM

🔥 Trending Repository: leantime

📝 Description: Leantime is a goals focused project management system for non-project managers. Building with ADHD, Autism, and dyslexia in mind.

🔗 Repository URL: https://github.com/Leantime/leantime

🌐 Website: https://leantime.io

📖 Readme: https://github.com/Leantime/leantime#readme

📊 Statistics:
🌟 Stars: 5.8K stars
👀 Watchers: 69
🍴 Forks: 671 forks

💻 Programming Languages: PHP - JavaScript - CSS - Blade - Twig - HTML

🏷️ Related Topics:

#php #trello #jira #sql #agile #calendar #projects #project_management #kanban #scrum #lean #strategy #timesheets #asana #gantt #hacktoberfest #notion #retrospective #clickup #leantime

==================================
🧠 By: https://t.iss.one/DataScienceM

🔥 Trending Repository: budibase

📝 Description: Create business apps and automate workflows in minutes. Supports PostgreSQL, MySQL, MariaDB, MSSQL, MongoDB, Rest API, Docker, K8s, and more 🚀 No code / Low code platform..

🔗 Repository URL: https://github.com/Budibase/budibase

🌐 Website: https://budibase.com

📖 Readme: https://github.com/Budibase/budibase#readme

📊 Statistics:
🌟 Stars: 25.5K stars
👀 Watchers: 218
🍴 Forks: 1.8K forks

💻 Programming Languages: TypeScript - Svelte - JavaScript - CSS - Shell - Handlebars

🏷️ Related Topics:

#open_source #internal_tools #workflow_engine #crud_application #workflow_automation #low_code #no_code #rest_api_framework #crud_app #no_code_platform #data_apps #low_code_platform #ai_applications #data_application #workflow_apps #low_code_no_code #sql_gui #ai_app_builder #it_workflows

==================================
🧠 By: https://t.iss.one/DataScienceM

🔥 Trending Repository: budibase

📝 Description: Create business apps and automate workflows in minutes. Supports PostgreSQL, MySQL, MariaDB, MSSQL, MongoDB, Rest API, Docker, K8s, and more 🚀 No code / Low code platform..

🔗 Repository URL: https://github.com/Budibase/budibase

🌐 Website: https://budibase.com

📖 Readme: https://github.com/Budibase/budibase#readme

📊 Statistics:
🌟 Stars: 25.9K stars
👀 Watchers: 218
🍴 Forks: 1.9K forks

💻 Programming Languages: TypeScript - Svelte - JavaScript - CSS - Shell - Handlebars

🏷️ Related Topics:

#open_source #internal_tools #workflow_engine #crud_application #workflow_automation #low_code #no_code #rest_api_framework #crud_app #no_code_platform #data_apps #low_code_platform #ai_applications #data_application #workflow_apps #low_code_no_code #sql_gui #ai_app_builder #it_workflows

==================================
🧠 By: https://t.iss.one/DataScienceM

🔥 Trending Repository: leantime

📝 Description: Leantime is a goals focused project management system for non-project managers. Building with ADHD, Autism, and dyslexia in mind.

🔗 Repository URL: https://github.com/Leantime/leantime

🌐 Website: https://leantime.io

📖 Readme: https://github.com/Leantime/leantime#readme

📊 Statistics:
🌟 Stars: 6.8K stars
👀 Watchers: 74
🍴 Forks: 715 forks

💻 Programming Languages: PHP - JavaScript - CSS - Blade - Twig - HTML

🏷️ Related Topics:

#php #trello #jira #sql #agile #calendar #projects #project_management #kanban #scrum #lean #strategy #timesheets #asana #gantt #hacktoberfest #notion #retrospective #clickup #leantime

==================================
🧠 By: https://t.iss.one/DataScienceM

🔥 Trending Repository: chartdb

📝 Description: Database diagrams editor that allows you to visualize and design your DB with a single query.

🔗 Repository URL: https://github.com/chartdb/chartdb

🌐 Website: https://chartdb.io

📖 Readme: https://github.com/chartdb/chartdb#readme

📊 Statistics:
🌟 Stars: 18.1K stars
👀 Watchers: 61
🍴 Forks: 968 forks

💻 Programming Languages: TypeScript

🏷️ Related Topics:

#react #visualization #mysql #editor #schema_migrations #typescript #sql #database #sqlite #postgresql #mariadb #db #mssql #erd #db_migration #react_flow #xyflow

==================================
🧠 By: https://t.iss.one/DataScienceM

🔥 Trending Repository: WrenAI

📝 Description: ⚡️ GenBI (Generative BI) queries any database in natural language, generates accurate SQL (Text-to-SQL), charts (Text-to-Chart), and AI-powered insights in seconds.

🔗 Repository URL: https://github.com/Canner/WrenAI

🌐 Website: https://getwren.ai/oss

📖 Readme: https://github.com/Canner/WrenAI#readme

📊 Statistics:
🌟 Stars: 10.1K stars
👀 Watchers: 70
🍴 Forks: 1K forks

💻 Programming Languages: TypeScript - Python - Go - JavaScript - Less - Dockerfile

🏷️ Related Topics:

#agent #bigquery #charts #sql #postgresql #bedrock #business_intelligence #openai #spreadsheets #vertex #genbi #text_to_sql #rag #text2sql #duckdb #llm #anthropic #sqlai #text_to_chart

==================================
🧠 By: https://t.iss.one/DataScienceM

Top 100 Data Analyst Interview Questions & Answers

#DataAnalysis #InterviewQuestions #SQL #Python #Statistics #CaseStudy #DataScience

Part 1: SQL Questions (Q1-30)

#1. What is the difference between DELETE, TRUNCATE, and DROP?
A:
• DELETE is a DML command that removes rows from a table based on a WHERE clause. It is slower as it logs each row deletion and can be rolled back.
• TRUNCATE is a DDL command that quickly removes all rows from a table. It is faster, cannot be rolled back, and resets table identity.
• DROP is a DDL command that removes the entire table, including its structure, data, and indexes.

#2. Select all unique departments from the employees table.
A: Use the DISTINCT keyword.

SELECT DISTINCT department
FROM employees;

#3. Find the top 5 highest-paid employees.
A: Use ORDER BY and LIMIT.

SELECT name, salary
FROM employees
ORDER BY salary DESC
LIMIT 5;

#4. What is the difference between WHERE and HAVING?
A:
• WHERE is used to filter records before any groupings are made (i.e., it operates on individual rows).
• HAVING is used to filter groups after aggregations (GROUP BY) have been performed.

-- Find departments with more than 10 employees
SELECT department, COUNT(employee_id)
FROM employees
GROUP BY department
HAVING COUNT(employee_id) > 10;

#5. What are the different types of SQL joins?
A:
• (INNER) JOIN: Returns records that have matching values in both tables.
• LEFT (OUTER) JOIN: Returns all records from the left table, and the matched records from the right table.
• RIGHT (OUTER) JOIN: Returns all records from the right table, and the matched records from the left table.
• FULL (OUTER) JOIN: Returns all records when there is a match in either the left or right table.
• SELF JOIN: A regular join, but the table is joined with itself.

#6. Write a query to find the second-highest salary.
A: Use OFFSET or a subquery.

-- Method 1: Using OFFSET
SELECT salary
FROM employees
ORDER BY salary DESC
LIMIT 1 OFFSET 1;

-- Method 2: Using a Subquery
SELECT MAX(salary)
FROM employees
WHERE salary < (SELECT MAX(salary) FROM employees);

#7. Find duplicate emails in a customers table.
A: Group by the email column and use HAVING to find groups with a count greater than 1.

SELECT email, COUNT(email)
FROM customers
GROUP BY email
HAVING COUNT(email) > 1;

#8. What is a primary key vs. a foreign key?
A:
• A Primary Key is a constraint that uniquely identifies each record in a table. It must contain unique values and cannot contain NULL values.
• A Foreign Key is a key used to link two tables together. It is a field (or collection of fields) in one table that refers to the Primary Key in another table.

#9. Explain Window Functions. Give an example.
A: Window functions perform a calculation across a set of table rows that are somehow related to the current row. Unlike aggregate functions, they do not collapse rows.

-- Rank employees by salary within each department
SELECT
    name,
    department,
    salary,
    RANK() OVER (PARTITION BY department ORDER BY salary DESC) as dept_rank
FROM employees;

#10. What is a CTE (Common Table Expression)?
A: A CTE is a temporary, named result set that you can reference within a SELECT, INSERT, UPDATE, or DELETE statement. It helps improve readability and break down complex queries.