Data Analyst Interview Resources

🚀 𝗧𝗼𝗽 𝟯 𝗦𝗸𝗶𝗹𝗹𝘀 𝗧𝗼 𝗗𝗼𝗺𝗶𝗻𝗮𝘁𝗲 𝟮𝟬𝟮𝟱 😍 Start learning the most in-demand tech skills with FREE certifications 👇 ✅ AI & ML → https://pdlink.in/3U3eZuq ✅ Data Analytics → https://pdlink.in/4lp7hXQ ✅ Data Science, Fullstack & More → https://pdlink.in/3ImMFAB 🎓 100% FREE | Learn Anywhere, Anytime 💡 Don’t just keep up with 2025, stay ahead of it!

Trading profits while you sleep? Over 40,000 traders trust THE FOREX SKYLINE COMMUNITY. AI handles your trades 24/7—zero guesswork, no fees, just real results. See daily wins, user stories, and step-by-step guidance, all for FREE. Ready for your first automated profit? Join now—spots fill up fast! #ad InsideAds

The Only SQL You Actually Need For Your First Job DataAnalytics The Learning Trap: * Complex subqueries * Advanced CTEs * Recursive queries * 100+ tutorials watched * 0 practical experience Reality Check: 75% of daily SQL tasks: * Basic SELECT, FROM, WHERE * JOINs * GROUP BY * ORDER BY * Simple aggregations * ROW_NUMBER Like for detailed explanation ❤️ #sql

🚀 Join the EG Investment Team! 🚀 💵 We invest USDT with high returns – 55–65 days to double your capital! One-time investment is enough to start working with the team. Minimum entry – 300 USDT, recommended – from 1000 USDT. 🔥 High income = high risk This is passive income with no special knowledge required. Yes, you’ll need to do small daily actions on the exchange, but don’t worry – it’s simple. 📊 In my channel you’ll find: ✔️ History and daily updates on my own deposit ✔️ Bonuses for new members of my team 💬 Want to join? Join the group, send me a DM, and become part of the team – your capital could start working today! P.S. Investments always carry risk. Only invest what you are ready to lose. #ad InsideAds

🔥 𝗧𝗵𝗲 𝗦𝗸𝗶𝗹𝗹𝘀 𝗬𝗼𝘂 𝗡𝗲𝗲𝗱 𝗶𝗻 𝟮𝟬𝟮𝟱 → 𝗙𝗢𝗥 𝗙𝗥𝗘𝗘 😍 📚 FREE Courses in: ✅ AI & GenAI ✅ Python & Data Science ✅ Cloud Computing ✅ Machine Learning ✅ Cyber Security & More 💻 Learn Online | 🌍 Learn Anytime 𝐋𝐢𝐧𝐤 👇:-  https://pdlink.in/4ovjVWY Enroll for FREE & Get Certified 🎓

Ever wondered how top creators never miss trends? “My posts blew up—thanks to a tool no one talks about.” Discover the AI calendar that predicts viral moments, writes content & does the busywork for you. Ready to level up? See what you’re missing #ad InsideAds

SQL Cheatsheet ✅

𝗙𝗥𝗘𝗘 𝗗𝗲𝗺𝗼 𝗢𝗻 𝗙𝘂𝗹𝗹𝘀𝘁𝗮𝗰𝗸 𝗗𝗲𝘃𝗲𝗹𝗼𝗽𝗺𝗲𝗻𝘁 𝗜𝗻 𝗛𝘆𝗱𝗲𝗿𝗮𝗯𝗮𝗱/𝗣𝘂𝗻𝗲😍 Learn from the Top 1% of the tech industry— exceptional professionals from top MNCs who have not only taught thousands but transformed their careers! 💻✨ 👨‍🏫 Get hands-on coding experience 📈 Placement assistance with over 60+ hiring drives each month ✅ 500+ Hiring Partners 𝗕𝗼𝗼𝗸 𝗮 𝗙𝗥𝗘𝗘 𝗗𝗲𝗺𝗼👇:- 🔹 Hyderabad :- https://pdlink.in/4cJUWtx 🔹 Pune :- https://pdlink.in/3YA32zi Hurry Up🏃‍♂️.....Limited Slots Available

DSA in Python 👆👆

𝟒 𝐁𝐞𝐬𝐭 𝐏𝐨𝐰𝐞𝐫 𝐁𝐈 𝐂𝐨𝐮𝐫𝐬𝐞𝐬 𝐢𝐧 𝟐𝟎𝟐𝟓 𝐭𝐨 𝐒𝐤𝐲𝐫𝐨𝐜𝐤𝐞𝐭 𝐘𝐨𝐮𝐫 𝐂𝐚𝐫𝐞𝐞𝐫😍 In today’s data-driven world, Power BI has become one of the most in-demand tools for businesses〽️📊 The best part? You don’t need to spend a fortune—there are free and affordable courses available online to get you started.💥🧑‍💻 𝐋𝐢𝐧𝐤👇:- https://pdlink.in/4mDvgDj Start learning today and position yourself for success in 2025!✅️

Top 10 Advanced SQL Queries for Data Mastery 1. Recursive CTE (Common Table Expressions) Use a recursive CTE to traverse hierarchical data, such as employees and their managers.

WITH RECURSIVE EmployeeHierarchy AS (
  SELECT employee_id, employee_name, manager_id
  FROM employees
  WHERE manager_id IS NULL
  UNION ALL
  SELECT e.employee_id, e.employee_name, e.manager_id
  FROM employees e
  JOIN EmployeeHierarchy eh ON e.manager_id = eh.employee_id
)
SELECT * 
FROM EmployeeHierarchy;

2. Pivoting Data Turn row data into columns (e.g., show product categories as separate columns).

SELECT *
FROM (
    SELECT TO_CHAR(order_date, 'YYYY-MM') AS month, product_category, sales_amount
    FROM sales
) AS pivot_data
PIVOT (
    SUM(sales_amount)
    FOR product_category IN ('Electronics', 'Clothing', 'Books')
) AS pivoted_sales;

3. Window Functions Calculate a running total of sales based on order date.

SELECT 
  order_date, 
  sales_amount, 
  SUM(sales_amount) OVER (ORDER BY order_date) AS running_total
FROM sales;

4. Ranking with Window Functions Rank employees’ salaries within each department.

SELECT 
  department, 
  employee_name, 
  salary,
  RANK() OVER (PARTITION BY department ORDER BY salary DESC) AS salary_rank
FROM employees;

5. Finding Gaps in Sequences Identify missing values in a sequential dataset (e.g., order numbers).

WITH Sequences AS (
  SELECT MIN(order_number) AS start_seq, MAX(order_number) AS end_seq
  FROM orders
)
SELECT start_seq + 1 AS missing_sequence
FROM Sequences
WHERE NOT EXISTS (
  SELECT 1
  FROM orders o
  WHERE o.order_number = Sequences.start_seq + 1
);

6. Unpivoting Data Convert columns into rows to simplify analysis of multiple attributes.

SELECT 
  product_id, 
  attribute_name, 
  attribute_value
FROM products
UNPIVOT (
  attribute_value FOR attribute_name IN (color, size, weight)
) AS unpivoted_data;

7. Finding Consecutive Events Check for consecutive days/orders for the same product using LAG().

WITH ConsecutiveOrders AS (
  SELECT 
    product_id, 
    order_date,
    LAG(order_date) OVER (PARTITION BY product_id ORDER BY order_date) AS prev_order_date
  FROM orders
)
SELECT product_id, order_date, prev_order_date
FROM ConsecutiveOrders
WHERE order_date - prev_order_date = 1;

8. Aggregation with the FILTER Clause Calculate selective averages (e.g., only for the Sales department).

SELECT 
  department,
  AVG(salary) FILTER (WHERE department = 'Sales') AS avg_salary_sales
FROM employees
GROUP BY department;

9. JSON Data Extraction Extract values from JSON columns directly in SQL.

SELECT 
  order_id, 
  customer_id,
  order_details ->> 'product' AS product_name,
  CAST(order_details ->> 'quantity' AS INTEGER) AS quantity
FROM orders;

10. Using Temporary Tables Create a temporary table for intermediate results, then join it with other tables.

-- Create a temporary table
CREATE TEMPORARY TABLE temp_product_sales AS
SELECT product_id, SUM(sales_amount) AS total_sales
FROM sales
GROUP BY product_id;

-- Use the temp table
SELECT p.product_name, t.total_sales
FROM products p
JOIN temp_product_sales t ON p.product_id = t.product_id;

Why These Matter Advanced SQL queries let you handle complex data manipulation and analysis tasks with ease. From traversing hierarchical relationships to reshaping data (pivot/unpivot) and working with JSON, these techniques expand your ability to derive insights from relational databases. Keep practicing these queries to solidify your SQL expertise and make more data-driven decisions! Here you can find essential SQL Interview Resources👇 https://whatsapp.com/channel/0029VanC5rODzgT6TiTGoa1v Like this post if you need more 👍❤️ Hope it helps :) #sql #dataanalyst

📊 𝗗𝗮𝘁𝗮 𝗔𝗻𝗮𝗹𝘆𝘁𝗶𝗰𝘀 𝗙𝗥𝗘𝗘 𝗖𝗲𝗿𝘁𝗶𝗳𝗶𝗰𝗮𝘁𝗶𝗼𝗻 𝗖𝗼𝘂𝗿𝘀𝗲𝘀 😍 🎓 Get certified & boost your resume 💡 Beginner-friendly & industry recognized ✅ 100% Free Enrollment 👉 Don’t miss out – Upskill for 2025 now! 𝐋𝐢𝐧𝐤 👇:-    https://pdlink.in/4lp7hXQ   🎓 Enroll Now & Get Certified

Steps to 𝐆𝐞𝐭 𝐈𝐧𝐭𝐞𝐫𝐯𝐢𝐞𝐰 𝐂𝐚𝐥𝐥𝐬 from LinkedIn: 1. 𝐀𝐩𝐩𝐥𝐲 𝐃𝐚𝐢𝐥𝐲: Submit applications for 30-40 jobs daily to increase visibility. 2. 𝐃𝐢𝐯𝐞𝐫𝐬𝐢𝐟𝐲 𝐀𝐩𝐩𝐥𝐢𝐜𝐚𝐭𝐢𝐨𝐧𝐬: Apply for various job types, not just "easy apply" options. 3. 𝐀𝐩𝐩𝐥𝐲 𝐏𝐫𝐨𝐦𝐩𝐭𝐥𝐲: Turn on job alerts and apply as soon as positions are posted. 4. 𝐒𝐞𝐞𝐤 𝐑𝐞𝐟𝐞𝐫𝐫𝐚𝐥𝐬: For dream companies, quickly request referrals from employees. Connect with several people for better chances. 5. 𝐁𝐞 𝐃𝐢𝐫𝐞𝐜𝐭 𝐟𝐨𝐫 𝐑𝐞𝐟𝐞𝐫𝐫𝐚𝐥s: Don't start with "Hi" or "Hello". Send a cold message (short and crisp) with what you need and the job link. If you get a response, you can share your resume for referral. Follow up after one day if needed. 6. 𝐀𝐩𝐩𝐥𝐲 𝐖𝐢𝐭𝐡𝐢𝐧 𝐄𝐥𝐢𝐠𝐢𝐛𝐢𝐥𝐢𝐭𝐲: Only apply or seek referrals for roles where you meet the qualifications (or close enough). 7. 𝐎𝐩𝐭𝐢𝐦𝐢𝐳𝐞 𝐘𝐨𝐮𝐫 𝐏𝐫𝐨𝐟𝐢𝐥𝐞: Build a network of 500+ connections, update experiences, use a professional photo, and list relevant skills. 8. 𝐂𝐨𝐧𝐧𝐞𝐜𝐭 𝐰𝐢𝐭𝐡 𝐑𝐞𝐜𝐫𝐮𝐢𝐭𝐞𝐫𝐬: After applying, connect with job posters and recruiters, and send your CV with a cold message (short and crisp). 9. 𝐄𝐧𝐡𝐚𝐧𝐜𝐞 𝐕𝐢𝐬𝐢𝐛𝐢𝐥𝐢𝐭𝐲: Keep your profile visible, send connection requests, and share relevant content. 10. 𝐏𝐞𝐫𝐬𝐨𝐧𝐚𝐥𝐢𝐳𝐞 𝐂𝐨𝐧𝐧𝐞𝐜𝐭𝐢𝐨𝐧 𝐑𝐞𝐪𝐮𝐞𝐬𝐭𝐬: Customize requests to explain your interest. 11. 𝐄𝐧𝐠𝐚𝐠𝐞 𝐰𝐢𝐭𝐡 𝐂𝐨𝐧𝐭𝐞𝐧𝐭: Like, comment, and share posts to stay visible and expand your network. 12. 𝐒𝐡𝐨𝐰𝐜𝐚𝐬𝐞 𝐄𝐱𝐩𝐞𝐫𝐭𝐢𝐬𝐞: Publish articles or posts about your field to attract potential employers. 13. 𝐉𝐨𝐢𝐧 𝐆𝐫𝐨𝐮𝐩𝐬: Participate in industry-related LinkedIn groups to engage and expand your network. 14. 𝐔𝐩𝐝𝐚𝐭𝐞 𝐇𝐞𝐚𝐝𝐥𝐢𝐧𝐞 𝐚𝐧𝐝 𝐒𝐮𝐦𝐦𝐚𝐫𝐲: Reflect your current role, skills, and aspirations with relevant keywords. 15. 𝐑𝐞𝐪𝐮𝐞𝐬𝐭 𝐑𝐞𝐜𝐨𝐦𝐦𝐞𝐧𝐝𝐚𝐭𝐢𝐨𝐧𝐬: Get endorsements from colleagues, managers, and clients. 16. 𝐅𝐨𝐥𝐥𝐨𝐰 𝐂𝐨𝐦𝐩𝐚𝐧𝐢𝐞𝐬: Stay updated on job openings and company news by following your target companies.

𝗕𝗲𝗰𝗼𝗺𝗲 𝗮 𝗗𝗮𝘁𝗮 𝗔𝗻𝗮𝗹𝘆𝘀𝘁 𝗶𝗻 𝟮𝟬𝟮𝟱: 𝗧𝗵𝗲 𝗨𝗹𝘁𝗶𝗺𝗮𝘁𝗲 𝗕𝗲𝗴𝗶𝗻𝗻𝗲𝗿’𝘀 𝗟𝗲𝗮𝗿𝗻𝗶𝗻𝗴 𝗣𝗮𝘁𝗵😍 If you’ve been dreaming of a career in data analytics but don’t know where to start, this Data Analyst Learning Path is the perfect place to begin.〽️🧑‍🎓 You’ll progress from Excel essentials to data visualization with Power BI, SQL mastery, and Tableau expertise—all through a guided, step-by-step structure.📊📚 𝐋𝐢𝐧𝐤👇:- https://pdlink.in/45R8Hoo Apply for your first analytics role and stand out in the job market✅️

📊 Top 10 Data Analytics Concepts Everyone Should Know 🚀 1️⃣ Data Cleaning 🧹 Removing duplicates, fixing missing or inconsistent data. 👉 Tools: Excel, Python (Pandas), SQL 2️⃣ Descriptive Statistics 📈 Mean, median, mode, standard deviation—basic measures to summarize data. 👉 Used for understanding data distribution 3️⃣ Data Visualization 📊 Creating charts and dashboards to spot patterns. 👉 Tools: Power BI, Tableau, Matplotlib, Seaborn 4️⃣ Exploratory Data Analysis (EDA) 🔍 Identifying trends, outliers, and correlations through deep data exploration. 👉 Step before modeling 5️⃣ SQL for Data Extraction 🗃️ Querying databases to retrieve specific information. 👉 Focus on SELECT, JOIN, GROUP BY, WHERE 6️⃣ Hypothesis Testing ⚖️ Making decisions using sample data (A/B testing, p-value, confidence intervals). 👉 Useful in product or marketing experiments 7️⃣ Correlation vs Causation 🔗 Just because two things are related doesn’t mean one causes the other! 8️⃣ Data Modeling 🧠 Creating models to predict or explain outcomes. 👉 Linear regression, decision trees, clustering 9️⃣ KPIs & Metrics 🎯 Understanding business performance indicators like ROI, retention rate, churn. 🔟 Storytelling with Data 🗣️ Translating raw numbers into insights stakeholders can act on. 👉 Use clear visuals, simple language, and real-world impact ❤️ React for more

Data Analyst Interview Questions 👇 1.How to create filters in Power BI? Filters are an integral part of Power BI reports. They are used to slice and dice the data as per the dimensions we want. Filters are created in a couple of ways. Using Slicers: A slicer is a visual under Visualization Pane. This can be added to the design view to filter our reports. When a slicer is added to the design view, it requires a field to be added to it. For example- Slicer can be added for Country fields. Then the data can be filtered based on countries. Using Filter Pane: The Power BI team has added a filter pane to the reports, which is a single space where we can add different fields as filters. And these fields can be added depending on whether you want to filter only one visual(Visual level filter), or all the visuals in the report page(Page level filters), or applicable to all the pages of the report(report level filters) 2.How to sort data in Power BI? Sorting is available in multiple formats. In the data view, a common sorting option of alphabetical order is there. Apart from that, we have the option of Sort by column, where one can sort a column based on another column. The sorting option is available in visuals as well. Sort by ascending and descending option by the fields and measure present in the visual is also available. 3.How to convert pdf to excel? Open the PDF document you want to convert in XLSX format in Acrobat DC. Go to the right pane and click on the “Export PDF” option. Choose spreadsheet as the Export format. Select “Microsoft Excel Workbook.” Now click “Export.” Download the converted file or share it. 4. How to enable macros in excel? Click the file tab and then click “Options.” A dialog box will appear. In the “Excel Options” dialog box, click on the “Trust Center” and then “Trust Center Settings.” Go to the “Macro Settings” and select “enable all macros.” Click OK to apply the macro settings.

Scenario based  Interview Questions & Answers for Data Analyst 1. Scenario: You are working on a SQL database that stores customer information. The database has a table called "Orders" that contains order details. Your task is to write a SQL query to retrieve the total number of orders placed by each customer.   Question:   - Write a SQL query to find the total number of orders placed by each customer. Expected Answer:     SELECT CustomerID, COUNT(*) AS TotalOrders     FROM Orders     GROUP BY CustomerID; 2. Scenario: You are working on a SQL database that stores employee information. The database has a table called "Employees" that contains employee details. Your task is to write a SQL query to retrieve the names of all employees who have been with the company for more than 5 years.   Question:   - Write a SQL query to find the names of employees who have been with the company for more than 5 years. Expected Answer:     SELECT Name     FROM Employees     WHERE DATEDIFF(year, HireDate, GETDATE()) > 5; Power BI Scenario-Based Questions 1. Scenario: You have been given a dataset in Power BI that contains sales data for a company. Your task is to create a report that shows the total sales by product category and region.     Expected Answer:     - Load the dataset into Power BI.     - Create relationships if necessary.     - Use the "Fields" pane to select the necessary fields (Product Category, Region, Sales).     - Drag these fields into the "Values" area of a new visualization (e.g., a table or bar chart).     - Use the "Filters" pane to filter data as needed.     - Format the visualization to enhance clarity and readability. 2. Scenario: You have been asked to create a Power BI dashboard that displays real-time stock prices for a set of companies. The stock prices are available through an API.   Expected Answer:     - Use Power BI Desktop to connect to the API.     - Go to "Get Data" > "Web" and enter the API URL.     - Configure the data refresh settings to ensure real-time updates (e.g., setting up a scheduled refresh or using DirectQuery if supported).     - Create visualizations using the imported data.     - Publish the report to the Power BI service and set up a data gateway if needed for continuous refresh. 3. Scenario: You have been given a Power BI report that contains multiple visualizations. The report is taking a long time to load and is impacting the performance of the application.     Expected Answer:     - Analyze the current performance using Performance Analyzer.     - Optimize data model by reducing the number of columns and rows, and removing unnecessary calculations.     - Use aggregated tables to pre-compute results.     - Simplify DAX calculations.     - Optimize visualizations by reducing the number of visuals per page and avoiding complex custom visuals.     - Ensure proper indexing on the data source. Free SQL Resources: https://whatsapp.com/channel/0029VanC5rODzgT6TiTGoa1v Like if you need more similar content Hope it helps :)

[ YouCine App V1.16.5 ]- Your Ultimate Entertainment Hub! 📺 Access over 1 million TV shows, movies, anime, Disney and kids' content from around the globe! Plus, enjoy FREE live streaming of NBA basketball and soccer matches. 📢 Mobile Download Link🚀🚀🚀 https://ycapp.co/xtiveyc https://ycapp.co/xtiveyc ✨Over 1 million movies and TV shows. ❤️ Multiple languages 🇺🇸🇵🇹🇪🇸❤️ Enjoy AD-FREE channels for a seamless experience. ❤️ Access unlimited free content anytime.❤️ Secure, ad-free and virus-free.❤️ Watch live football matches including the Premier League, La Liga, Champions League, and more! 🏆⚽️ 📢TV Download Link🚀🚀🚀 https://ycapp.co/xtivetv

🎁 New users can download and register to join YouCine now and get a free 7-day VIP trial! 🎉Netflix!x, Pr!me video, D!sney+, Crunchyroll content also available

35 Important SQL Interview Questions with Detailed Answers: 1. Explain order of execution of SQL. Order: FROM → JOIN → ON → WHERE → GROUP BY → HAVING → SELECT → DISTINCT → ORDER BY → LIMIT. SQL queries are processed in this logical sequence, not the way they are written. 2. What is difference between WHERE and HAVING? WHERE filters rows before aggregation, while HAVING filters groups after aggregation. 3. What is the use of GROUP BY? GROUP BY aggregates data across rows with the same values in specified columns, commonly used with aggregate functions. 4. Explain all types of joins in SQL? INNER JOIN: Returns matching rows from both tables. LEFT JOIN: All rows from the left, matched rows from right. RIGHT JOIN: All rows from the right, matched rows from left. FULL JOIN: All rows from both, with NULLs where no match. SELF JOIN: Joins table to itself. CROSS JOIN: Cartesian product of both tables. 5. What are triggers in SQL? Triggers are procedural code executed automatically in response to certain events on a table or view (INSERT, UPDATE, DELETE). 6. What is stored procedure in SQL? A stored procedure is a set of SQL statements saved and executed on demand, useful for modularizing code. 7. Explain all types of window functions? RANK(): Gives rank with gaps. DENSE_RANK(): Ranks without gaps. ROW_NUMBER(): Unique row index. LEAD(): Access next row. LAG(): Access previous row. 8. What is difference between DELETE and TRUNCATE? DELETE: Row-wise deletion, can have WHERE clause, logs each row. TRUNCATE: Deletes all rows, faster, minimal logging, cannot rollback easily. 9. What is difference between DML, DDL and DCL? DML: Data Manipulation Language (SELECT, INSERT, UPDATE, DELETE). DDL: Data Definition Language (CREATE, ALTER, DROP). DCL: Data Control Language (GRANT, REVOKE). 10. What are aggregate functions? Functions that return a single value: SUM(), AVG(), COUNT(), MIN(), MAX(). 11. Which is faster: CTE or Subquery? Performance depends on context, but subqueries are sometimes faster as CTEs may be materialized. 12. What are constraints and types? Rules to maintain data integrity. Types: NOT NULL, UNIQUE, PRIMARY KEY, FOREIGN KEY, CHECK, DEFAULT. 13. Types of Keys? Primary Key Foreign Key Unique Key Composite Key Candidate Key 14. Different types of Operators? Arithmetic: +, -, *, / Comparison: =, <>, >, <, >=, <= Logical: AND, OR, NOT Bitwise, LIKE, IN, BETWEEN 15. Difference between GROUP BY and WHERE? WHERE filters before aggregation. GROUP BY groups after filtering. 16. What are Views? Virtual tables based on SQL queries. They store only query definition. 17. What are different types of constraints? Same as Q12: NOT NULL, UNIQUE, PRIMARY KEY, FOREIGN KEY, CHECK, DEFAULT. 18. What is difference between VARCHAR and NVARCHAR? VARCHAR: ASCII, 1 byte per char. NVARCHAR: Unicode, 2 bytes per char, supports multiple languages. 19. Similarity for CHAR and NCHAR? CHAR: Fixed-length ASCII. NCHAR: Fixed-length Unicode. 20. What are indexes and their types? Used for faster retrieval. Types: - Clustered - Non-clustered - Unique - Composite - Full-text 21. What is an index? Explain its types. Same as above. Indexes speed up queries by creating pointers to data. 22. List different types of relationships in SQL. One-to-One One-to-Many Many-to-Many 23. Differentiate between UNION and UNION ALL. UNION: Removes duplicates. UNION ALL: Includes duplicates. 24. How many types of clauses in SQL? Common clauses: SELECT, FROM, WHERE, GROUP BY, HAVING, ORDER BY, LIMIT, OFFSET, JOIN, ON. 25. What is the difference between UNION and UNION ALL in SQL? Same as Q23. 26. What are various types of relationships in SQL? Same as Q22. 27. Difference between Primary Key and Secondary Key? Primary Key: Uniquely identifies rows. Secondary Key: May not be unique, used for lookup. Credits: https://whatsapp.com/channel/0029VanC5rODzgT6TiTGoa1v/1000