.

SQL THINGS TO REMEMBER

SQL SELECT

SELECT TO_CHAR(DT.FULL_DATE, 'YYYY-MM-DD') "FullDate"

Tell me what is the table name? answer DT; What is the column name in table DT? answer FULL_DATE; Explain the TO_CHAR() function. answer it converts numbers or dates into string(text) format. Explain this "FullDate". The original column name FULL_DATE will be rename as "FullDate"



Example with Dates: Let's say your database store a date like this: 2025-04-23 20:49:00. But you just want to show April 23, 2025. You would use SELECT TO_CHAR(DT.FULL_DATE, 'Month DD, YYYY'). This turns 2025-04-23 20:49:00 into "April 23, 2025"



Examples with Numbers: Let's say your database store a price like this: 12345.678 but you want it to look like $12,345.68. You would use SELECT TO_CHAR(price_column, '$99,999.99') FROM table_name;



TO_NUMBER() function. It converts text (string) into a number format so you can perform calculations on it. Let'say your database store a number as text, like '12345.67'. You want to change it back into a number so you can do calculation. You would use SELECT TO_NUMBER(TextNumber_Column, '99999.99') FROM table_name;



LIMIT() function. It is used to limit the number of rows returned in a query. Imagine you have a table name customers with thousands of rows, but you only wants to see the first 5 customers. Write the SQL code. answer if the database is MySQL, PostgreSQL, SQLite.

SELECT * FROM customers LIMIT 5;

If the database is Oracle: SELECT * FROM customer FETCH FIRST 5 rows only;

If the database is SQL Server: SELECT TOP 5 * FROM customer;

🧠 Power BI Uses by Default

Azure OpenAI Service: This allows integration with OpenAI models like GPT-4.

Microsoft Copilot: Embedded in Power BI and other Microsoft 365 tools, Copilot uses LLMs hosted on Azure, which may include OpenAI models.

🔍 Core Azure AI Services Used in Power BI

Azure OpenAI Service Integrates large language models (like GPT) for natural language queries, summaries, and insights

Azure Cognitive Services Adds capabilities like image recognition, sentiment analysis, language translation, and more

Azure Machine Learning Enables custom ML models for predictive analytics, anomaly detection, and classification

Azure Bot Service Powers conversational interfaces and chatbots within Power BI dashboards

🔗 Example 1: Customers and Orders

Scenario: You have two tables:

Customers (CustomerID, Name, City)

Orders (OrderID, CustomerID, OrderDate, Amount)

Relationship Setup:

Go to Model view in Power BI Desktop.

Drag CustomerID from the Customers table to CustomerID in the Orders table.

This creates a one-to-many relationship: one customer can have many orders.

📦 Example 2: Products and Sales

Scenario: You have:

Products (ProductID, Name, Category)

Sales (SaleID, ProductID, Quantity, Revenue)

Relationship Setup:

Link ProductID in Products to ProductID in Sales.

This allows you to analyze sales by product category or name.

Bonus Tip: Rename columns to intuitive names like “Product Name” instead of “Name” to improve Q&A accuracy.

🧠 Example 3: Teaching Q&A with Synonyms

Scenario: Your table is named CustomerSummary, but users ask “List customers in New York.”

Fix:

Use the Q&A setup tool to add a synonym: map “CustomerSummary” to “Customers.”

Now Q&A understands that “customers” refers to that table.

.

.

How can IN-V-BAT-AI be used in classrooms ?

IN-V-BAT-AI is a valuable classroom tool that enhances both teaching and learning experiences. Here are some ways it can be utilized:

☑️ Personalized Learning : By storing and retrieving knowledge in the cloud, students can access tailored resources and revisit concepts they struggle with, ensuring a more individualized learning journey.

☑️ Memory Support : The tool helps students recall information even when stress or distractions hinder their memory, making it easier to retain and apply knowledge during homework assignments or projects.

☑️ Bridging Learning Gaps : It addresses learning loss by providing consistent access to educational materials, ensuring that students who miss lessons can catch up effectively.

☑️ Teacher Assistance : Educators can use the tool to provide targeted interventions to support learning.

☑️ Stress Reduction : By alleviating the pressure of memorization, students can focus on understanding and applying concepts, fostering a deeper engagement with the material.

🧠 IN-V-BAT-AI vs. Traditional EdTech: Why "Never Forget" Changes Everything

📚 While most EdTech platforms focus on delivering content or automating classrooms, IN-V-BAT-AI solves a deeper problem: forgetting.

✨Unlike adaptive learning systems that personalize what you learn, IN-V-BAT-AI personalizes what you remember. With over 504 pieces of instantly retrievable knowledge, it's your cloud-based memory assistant—built for exam prep, lifelong learning, and stress-free recall.

• ✅ One-click access to formulas, calculators, and concepts
• 📧 No coding, no hosting—just email what you want to remember
• 📱 Live within 24 hours, optimized for mobile and voice search
• 💸 $30/year for 504 personalized memory sites (just 6¢ each)

"🧠 Forget less. Learn more. Remember on demand."
That's the IN-V-BAT-AI promise.

Personal Augmented Intelligence (AI) Explanation

🧠 Augmented Intelligence vs Artificial Intelligence

Understanding the difference between collaboration and automation

🔍 Messaging Contrast

Augmented Intelligence is like a co-pilot: it accelerates problem-solving through trusted automation and decision-making, helping you recall, analyze, and decide — but it never flies solo.

Artificial Intelligence is more like an autopilot: designed to take over the controls entirely, often without asking.

💡 Why It Matters for IN-V-BAT-AI

IN-V-BAT-AI is a textbook example of Augmented Intelligence. It empowers learners with one-click recall, traceable results, and emotionally resonant memory tools. Our “Never Forget” promise isn't about replacing human memory — it's about enhancing it.

Note: This is not real data — it is synthetic data generated using Co-Pilot to compare and contrast IN-V-BAT-AI with leading EdTech platforms.

.

.

.