💻 Run Python Code Online

🚀 In this video, you will learn how to use SQLite Browser and write SQL queries step by step in Tamil. Perfect for beginners!

🔹 Topics Covered:
✔️ How to Install SQLite Browser
✔️ How to Create a Database & Tables
✔️ Insert, Update, Delete Queries
✔️ Using SQL Operators (>, <, =, AND, OR)
✔️ Group By & Order By Usage
✔️ Aggregate Functions (SUM, COUNT, AVG, MAX, MIN)

📌 Watch the full video:
🎥

How Download and Install SQLite Browser
You can download the latest version of SQLite Browser from the official website:

👉 Download SQLite Browser OR, you can search for SQLite Browser on Google:

1. 👉 Follow the Steps 1 to 11 to Install Sqlite Browser
கீழே கொடுக்கப்பட்டுள்ள 1 முதல் 11 வரையிலான Step ஐ பயன்படுத்தி SQLite Browser நிறுவலாம்.

If you found this helpful, Like, Comment, and Subscribe for more tutorials!
📢 Share this with your friends!

🎯 Objective

Learn what SQLite is, why it’s useful, and how to use it. By the end of this lesson, you will have created your first SQLite database!

What is SQLite? 📦✨

SQLite is a database, which is like a container for storing and organizing information.

🛠️ What Makes SQLite Special?

• 🚫 No server needed: Unlike other databases, SQLite doesn’t need extra software or servers.
• 📂 All in one file: Everything is saved in a single file on your device.
• 🌟 Easy to use: Perfect for beginners and small projects.

Why Use SQLite? ✅🎉

1. 🛠️ Simple: Just download it and start using it.
2. 📏 Lightweight: Small but powerful.
3. 🚚 Portable: Easily move the database file anywhere.
4. ⚡ Fast: Ideal for small to medium-sized tasks.

Where Is SQLite Used? 🌍

• 📱 Mobile Apps: Stores data like app settings or game progress.
• 🌐 Web Browsers: Chrome and Firefox use SQLite for saving history and bookmarks.
• 🛠️ Smart Devices: Found in smart TVs, washing machines, and other devices.

What is SQL? 💬✨

SQL stands for Structured Query Language, the language used to talk to databases.

Here’s what you can do with SQL:

• 🧐 Ask questions: “Show me the list of students in a class.”
• ➕ Add new data: “Add a new student to the database.”
• ✏️ Update data: “Change a student’s phone number.”
• ❌ Delete data: “Remove a student from the list.”

Hands-On Activity 🖐️💻

Let’s set up SQLite and create your first database!

Step 1: Download SQLite 📥

For Windows 10 Follow the Steps :

1. Press Win + R, type msinfo32, and hit Enter.

2) Look for System Type:
If it says x86-based PC, your system is 32-bit.
If it says x64-based PC, your system is 64-bit.

So My System says x64-based PC, My system is 64-bit.

3) Visit the official SQLite website.

4) For 64-bit Windows (x64)> Right Click sqlite-tools-win64-3480000.zip> Save into D:\ (or) E:\ your choice

5) Extract the Folder as per below screen

6) Right Click the following folder Rename it named sqlite

7) Now Folder Path : d:\sqlite

8) Now Press Windows Key + S > Type environ

9) Click Here Edit the System Environment Variable

10)Click Here Environment Variables

11) Click Path 12) Click Edit

13) Click New

14) Enter D:\sqlite > Click OK in Edit Environment Variable Screen

15) Again OK in Environment Variables Screen
16) Again OK in System Properties Window

17) Now Press Win Key + R (to Open Run Window)

18)To Check SQLite Installation ✅ :
Type CMD and Press Enter or Click OK to Open Command Prompt

19) Now Type: sqlite3 in Command Prompt
If you see sqlite> you’ve installed SQLite successfully! 🎉
to Exit SQLite by typing: .exit

20) To Create Your First Database 📂

• Now Create a New Folder named mydb in D:\ or E:\ or F:\ your choice any drive

21) Now go to command prompt >

22) Next Enter sqlite3 myschool.db (This line create the Database)

23)
To Create Table follow the steps;;

sqlite> create table students(id,name,age); (Press Enter)

To Insert Records
sqlite> insert into students(id,name,age) values(101,’Raja’,20); (Press Enter)

sqlite> insert into students(id,name,age) values(102,’Kumar’,21);

To View Records

sqlite> select * from students;

Key Points to Remember 🧠✨

• SQLite is a simple, portable database system that works without a server.
• It’s lightweight and perfect for small projects like apps or personal data.
• SQL is the language we use to give instructions to the database.

🎉 By the end of today, you’ve created your first SQLite database. Great job! Keep practicing and exploring more about SQLite!

1. Inspect Table Code

Sub InspectTableStructure()
    Dim pres As Object
    Dim slide As Object
    Dim tableShape As Object
    Dim row As Integer
    Dim col As Integer
    Dim cellText As String
    
    
    Set pres = Application.ActivePresentation

    
    Set slide = pres.Slides(1)

   
    Set tableShape = Nothing
    Dim shp As Object
    For Each shp In slide.Shapes
        If shp.HasTable Then
            Set tableShape = shp
            Exit For
        End If
    Next shp

    If tableShape Is Nothing Then
        MsgBox "No table found on the slide!", vbExclamation
        Exit Sub
    End If

   
    Debug.Print "Inspecting table structure:"
    Debug.Print "Total rows: " & tableShape.Table.Rows.Count

    For row = 1 To tableShape.Table.Rows.Count
        Debug.Print "Row " & row & ":"
        
      
        For col = 1 To tableShape.Table.Rows(row).Cells.Count
            On Error Resume Next
            cellText = tableShape.Table.Cell(row, col).Shape.TextFrame.TextRange.Text
            If Err.Number = 0 Then
                Debug.Print "    Column " & col & " - Text: " & cellText
            Else
                Debug.Print "    Column " & col & " - Error: Cell not accessible."
            End If
            On Error GoTo 0
        Next col
    Next row

    MsgBox "Table structure inspection complete! Check the Immediate Window (Ctrl+G) for details.", vbInformation
End Sub

2. Merge Code

Sub PopulateExistingTable()
    Dim pptApp As Object
    Dim pres As Object
    Dim slide As Object
    Dim tableShape As Object
    Dim excelApp As Object
    Dim excelWorkbook As Object
    Dim excelSheet As Object
    Dim row As Integer
    Dim tableRow As Integer
    Dim tableColumn As Integer

   
    Dim excelFilePath As String
    excelFilePath = "F:\31.12.2024\combine\MyData1.xlsx" 

   
    Set excelApp = CreateObject("Excel.Application")
    excelApp.Visible = False
    Set excelWorkbook = excelApp.Workbooks.Open(excelFilePath)
    Set excelSheet = excelWorkbook.Sheets(1)

 
    Set pptApp = CreateObject("PowerPoint.Application")
    pptApp.Visible = True

  
    If pptApp.Presentations.Count > 0 Then
        Set pres = pptApp.ActivePresentation
    Else
        MsgBox "No PowerPoint presentation is open!", vbExclamation
        Exit Sub
    End If

   
    row = 2 
    Do While excelSheet.Cells(row, 1).Value <> ""
        
        Dim newSlide As Object
        Set newSlide = pres.Slides(1).Duplicate 
        newSlide.MoveTo pres.Slides.Count      

        
        Set slide = pres.Slides(pres.Slides.Count)

     
        Set tableShape = Nothing
        Dim shp As Object
        For Each shp In slide.Shapes
            If shp.HasTable Then
                Set tableShape = shp
                Exit For
            End If
        Next shp

        If Not tableShape Is Nothing Then
            
            tableShape.Table.Cell(1, 12).Shape.TextFrame.TextRange.Text = excelSheet.Cells(row, 4).Value
           
           
        Else
            MsgBox "No table found on the slide!", vbExclamation
            Exit Sub
        End If



'-----------------------------------------
      imagePath = excelSheet.Cells(row, 23).Value 
        If Len(imagePath) > 0 And Dir(imagePath) <> "" Then
          
            On Error Resume Next
            Set imageRectangle = slide.Shapes("ImageRectangle")
            On Error GoTo 0
            
            If Not imageRectangle Is Nothing Then
             
                imageRectangle.Fill.UserPicture imagePath
            Else
                MsgBox "Rectangle shape not found!", vbExclamation
            End If
        Else
            MsgBox "Invalid image path for row " & row, vbExclamation
        End If
     
'-----------------------------------------
        row = row + 1
    Loop

 
    excelWorkbook.Close False
    excelApp.Quit


    Set excelSheet = Nothing
    Set excelWorkbook = Nothing
    Set excelApp = Nothing

    MsgBox "Slides created and populated successfully!", vbInformation
End Sub