Thursday, January 29, 2026

Python 26

 File Handling

1.Introduction to File Handling

  •  File Handling allows a program to create, read, write, and manage files.
  • Using file handling, Python programs can read data, write data update data, and work with different file type like text and CSV.

File Handling allows a Python Program to:

Store data :Store data permanently

Read data :Read data from files

Write data: Write data to the files

Update data: Modify or append existing data in files

Handle various files: Work with files like text files, CSV files, logs,reports etc.


2.Basic File Operations

We can do various operations on a file.

First, we need to specify the mode to define what operation we want to perform on the file.

Syntax:

Open(filename,mode) 

Mode Description                     Example

"r"       Read(file must exist)       file = open('data.txt','r') Print(file.read())

"w"     Write(creates/overwrite)  file=open("data.txt","w") file.write("Hello CCIT")

"a"       Append                            file=open("data.txt","a") file.write("\nAWS")

"x"       Create new file                file=open("newfile.txt","x") file.write("New file created")

"rb"      Read binary                     file=open("image.jpg","rb") print(file.read())

"wb"     Write binary                    file=open('copy.bin","wb") file.write(b"binarydata")

"r+"      Read and write                file =open("data.txt" ,r+)  print(file.read()) file.write("\nNewcontext")

If you use with advantage is , you don't want explicitly mention file.close() 

Task1:

with open("data.txt","r") as file:
    print(file.read())

 If you are not using with need to mention file.close() mandatory   

Task2:

file =open('data.txt',"a")
file.write("\n We greate to Learning Full Stack")
#print(file.read())
file.close()

Best Practice to use with 

Task3: Seek advantage of position to tell

file =open('data.txt',"r+")
file.write("Data testing")
file.seek(0)
print(file.read())
file.close()

Output:

with out seek

PS C:\Users\Administrator\Desktop\CCIT\PythonCourse\Day26> python app.py

 Learning Full Stackeate to Learning Full Stack.

with seek

PS C:\Users\Administrator\Desktop\CCIT\PythonCourse\Day26> python app.py

Data testing Learning Full Stackeate to Learning Full Stack.

Task4: append +

file =open('data.txt',"a+")
file.write("CCIT Devops")
file.seek(0)
print(file.read())
file.close()

Output:

PS C:\Users\Administrator\Desktop\CCIT\PythonCourse\Day26> python app.py

Data testing Learning Full Stackeate to Learning Full Stack.CCIT Devops

Task5: Override

file =open('data.txt',"w+")
file.write("AWS Devop Engineer")
file.seek(0)
print(file.read())
file.close()

Output:

PS C:\Users\Administrator\Desktop\CCIT\PythonCourse\Day26> python app.py

AWS Devop Engineer

Task6:

file =open('Women.png',"rb")
print(file.read())
file.close()

Output:PS C:\Users\Administrator\Desktop\CCIT\PythonCourse\Day26> python app.py

b'\x89PNG\r\n\x1a\n\x00\x00\x00\rIHDR\x00\x00\x00\xb8\x00\x00\x00\

3.Handling File Errors and Exceptions

File errors are common, each error has a specific exception.

We must handle them explicitly with standard exception-handling constructs(try-except-finally)

If the file is not available at the specified path a FileNotFoundError is raised

Task7: for try must should except block is required

try:
    with open('data.txt',"r") as file:
     print(file.read())
except FileNotFoundError:
   print("File does not exist")
finally:
   print("Execution completed.")

Output:

PS C:\Users\Administrator\Desktop\CCIT\PythonCourse\Day26> python app.py

File does not exist

Execution completed.

 Task 7: File permission issue 

try:
    with open('data.txt',"r") as file:
     print(file.read())
except FileNotFoundError:
   print("File does not exist")
except PermissionError:
   print("You does not have permission")
except:
   print("There is problem")
finally:
   print("Execution completed.")

Output:PS C:\Users\Administrator\Desktop\CCIT\PythonCourse\Day26> python app.py

You does not have permission

Execution completed.

4.Difference between read(),readline() and  and readliness()

read(),readline() and readlines() are the multiple file reading methods in python.

Type are for different needs based on the context 

read()

read the entire file content at once ,returns one single string 

Key points: Loads full file into memory, not suitable for large files

readline() Each time execute one line only not loaded full file

Task 8:

file= open('data.txt',"r")
print(file.readline())
print(file.readline())
print(file.readline())
file.close()

Output:PS C:\Users\Administrator\Desktop\CCIT\PythonCourse\Day26> python app.py

AWS Devop Engineer

HTML Developer

Java Developer

Task 9: readlines it will gave list 
file= open('data.txt',"r")
print(file.readlines())
file.close()

Output:

PS C:\Users\Administrator\Desktop\CCIT\PythonCourse\Day26> python app.py

['AWS Devop Engineer\n', 'HTML Developer\n', 'Java Developer\n', 'DotNet Developer']


Task10: tells the cursor where to start from ,first word "AWS Devop Engineer" start from 10th Position of the word.

data.txt (file)

AWS Devop Engineer

HTML Developer

Java Developer

DotNet Developer

file= open('data.txt',"a+")
file.seek(10)
print(file.tell())
print(file.read())
file.close()

Output:

PS C:\Users\Administrator\Desktop\CCIT\PythonCourse\Day26> python app.py

10

Engineer

HTML Developer

Java Developer

DotNet Developer


Task: Next class

Reading and writing comma-separated values(CSV)

Navigation the File system.

--Thanks 




Python 25

 Exception Handling

1. Introduction to Errors and Exceptions

 When  a Python program runs, two kinds of problems can occur:

Syntax Errors:

Errors caused by incorrect python syntax

detected before execution

Forex:  x=10

           If x>5     -->missing colon(:)

             print (x);

Exceptions

Errors that occur during execution ,even if syntax is correct 

Print(10/0) //cause zero division error 

2. Types of Errors and Exceptions

Common Built-in Exceptions       Cause                 Example

ZeroDivisionError                   Divide by zero      10/0

ValueError                               Invalid value          int("abc")

TypeError                               Wrong data type      "10" + 5 

NameError                             Variable not defined  print(x)

IndexError                               Invalid index            list[5]

KeyError                                 Missing dictionary key  dict["x"] 

FileNotFoundError                 File not found                 open("a.txt")

3.Exception Handling

  Introduction to try and Except

  Python uses try-except to handle exceptions gracefully 

  Basic Syntax Errors

 try: 

     # Code that may cause an error 

 except:

   # Code that runs if errors occurs 

 Finally: # Optional

   # Code that runs on fail or success 

Example Handling division by  zero

try:
    x = int(input("Enter a number:"))
    print(10/x)
except:
    print("Error: There is some problem in  your code, Zero Divided By")
finally:
    print("completed")

Output:

PS C:\Users\Administrator\Desktop\CCIT\PythonCourse\Day25> python app.py

Enter a number:0

Error: There is some problem in  your code, Zero Divided By

completed

Task2:

try:
    x = "abc"
    y = 5
    m = int(x)
    print (m/y)
except BaseException as e:
    print("Error: There is some problem in  your code:", e)

PS C:\Users\Administrator\Desktop\CCIT\PythonCourse\Day25> python app.py

Error: There is some problem in  your code: invalid literal for int() with base 10: 'abc'

Task3:

try:
    x = "abc"
    y = 5
    m = int(x)
    print (m/y)
except ValueError as e:
    print("Error:Invalid value supplied")

PS C:\Users\Administrator\Desktop\CCIT\PythonCourse\Day25> python app.py

Error:Invalid value supplied

Task4:

try:
    x = 10
    y = 0
    m = int(x)
    print (m/y)
except ValueError as e:
    print("Error:Invalid value supplied")
except ZeroDivisionError:
    print("Wrong Value supplied By", +y)

PS C:\Users\Administrator\Desktop\CCIT\PythonCourse\Day25> python app.py

Wrong Value supplied By 0

Task5:

try:
    x = "abc"
    y = 0
    m = int(x)
    print (m/y)
#except ValueError as e:
 #   print("Error:Invalid value supplied")
except ZeroDivisionError:
    print("Wrong Value supplied By", +y)
except:
     print("Universal Exception block: Wrong Value supplied")

PS C:\Users\Administrator\Desktop\CCIT\PythonCourse\Day25> python app.py

Universal Exception block: Wrong Value supplied

Task6:

try:
    x = "abc"
    y = 0
    m = int(x)
    print (m/y)
#except ValueError as e:
 #   print("Error:Invalid value supplied")
except ZeroDivisionError:
    print("Wrong Value supplied By", +y)
except TypeError:
    print("Wrong Type supplied By")
except:
     print("Universal Exception block: Wrong Value supplied")
finally:
    print("Execution completed")

PS C:\Users\Administrator\Desktop\CCIT\PythonCourse\Day25> python app.py

Universal Exception block: Wrong Value supplied

Execution completed

Exception Hierarchy 

All exceptions inherit from BaseException

BaseException 

   Exception 

           ValueError

            TypeError

            ZeroDivisionError

            FileNotFoundError


--Thanks


  


Python 31

  • JavaScript Syntax and variables
  • JavaScript Operators
  • JavaScript Conditional statements
  • JavaScript Loops
  • JavaScript Functions
  • JavaScript Interactions with HTML

JavaScript Syntax and Variables

What is JavaScript Syntax?

Syntax means the rules of  writing JavaScript code so that the browser can understand it(Just loke English has grammar,JavaSript has syntax)

Basic JavaScript syntax Rules

1.Statements end with semicolon ;

Forex:- alert("Hello JavaScript");

2.JavaScript is case-sensitive 

let name="Ravi";

let Name="Kiran";  // both are different variables

3.Comments in JavaScript 

// This is a comment 

 /*multi liner comment */

4.Blocks use {}

  if(true){ console.log("Inside block"); }

What is a variable??

A variable is used to store data that can be used later(Variable=Container for data)

JavaScript provides 3 keywords:

How to Declare variables in JavaScript 

 1.var(old-avoid)   for ex:- var city="Hyd" --old style avoid

2.let(recommended) for ex:- let age =25; 

3.Const(Constant) for ex:- const country="India";

  • JavaScript Operators
Operator are symbols used to perform operations on values.

A.Arithmetic Operators
let a=10;
let b=5;
console.log(a+b); //15
console.log(a-b); //5
console.log(a/b); //2    
console.log(a%b);//0
B.Assigment Operators
let x=10;
x+=5; // x=x+5;
console.log(x); //15
C.Comparison Operator
console.log(10>5) //true
console.log(10<5)//false
console.log(10=="10") //true
console.log(10==="10");//false
==compares value
===compares value and type (recommended)
D.Logical Operator
let age=20;
console.log(age>18 && age <60);  //true  && and  ! NOT  || or

  • JavaScript Conditional statements
A.If statement
 let marks =80
if (marks>=35){
   alert("pass");

 }
B. if else 
  let marks=30;
 if (marks >=35) {
alert("pass");
}
else {
alert("Fail");

}

C.else if 
let mark = 85;
 if (marks >=90) {
 alert("Grade A");
 }else if (marks>=75){
  alert("Grade B"); 
} else{
 alert ("Grade C")    
}

D. Switch
let day =2;
Switch(val){
 case 1:
   alert("monday");
   break;
case 2:
  alert("Tuesday");
 break;
default:
 alert("Invalid day");
}

Loop

While 

  let i=1;
        while (i<=val1){
           alert('message'+i)
           i++;

For

 for (let i=1;i<=5;i++){
           alert('message:' +i);
        }
         

Do while Loop

  let i=1;
        do {
           alert('message:' +i);
           i++;
        } while (i<=5)


JavaScript Function 

A function is a block of code that performs a task and can be reused 

A .Simple function

 function greet() {

  alert('Hello');

}

greet();

B. Function with parameters

function add(a,b){

return a+b;

}

Console.log(add(10,5) //15

C. Arrow function(intro)

Const multiply =(a,b) => a*b;

console.log(multiply(4,5)); //20


--Thanks


Wednesday, January 28, 2026

Python 30

Controls in HTML

  • HTML Controls are user interface elements used to collect and submit data 
  • HTML Provides various controls for entering, selecting and transferring data  
1.<Text Box

<input type="text">

Use: Enter Single-line text(name, username)

2.Password Box

 <input type="Password">

Use: Enter Sensitive data (character are hidden)

3.Number Box

<input type="number">

4.Email Box

<input type="email">

Use :Enter email address(Browser validates format automatically).

5.Radio Button

<input type="radio" name="btn">

Use: Select only one Option(same name attribute is required)

6.Check box

 <input type="checkbox">

Use:Select multiple options

7.Drop down 

 <select>

   <option>Select County</option>

  <option>India</option>

 <option>USA</option>

</select>

8.Button

 <button>click me</button>

9.Text area 

<textarea row="4" cols="30"> </textarea>

Use:Enter multi-line text(address,comments)

10.Submit Button

 <input type="submit" value="Submit">

11.Reset Button

<input type="reset" value="clear">

Use: Clear all form fields

12. File Upload Control

 <input type="file">

Use:Upload files(images,documents)

13. Data picker

 <input type="date">

Use:Select a data using calendar

14.Label

 <label>Name:</label>

 <input type="text">

Use: Describes input fields

Introduction to JavaScript

What is Java Script?

 JavaScript is a programming language used to make webpages interactive 

HTML -->Structure

CSS-->Design 

  JavaScript-->Behaviour

1. Why JavaScript?

 Without JavaScript: Website are static ,No user interaction 

 With JavaScript: Button clicks, Form validation, Dynamic content ,Alert and messages

2.Using JavaScript in an HTML Page

 What does  "Using JavaScript in HTML" Mean?

 Connecting JavaScript code with a HTML page so that page can react to user actions

 Examples of reaction 

 Button Click

 Form Validation

 Changing Text or color 

 Showing messages 

 Fetching data

There are 3 ways to use JavaScript 

 1. Inline JavaScript

 2.Internal JavaScript

 3.External JavaScript(Best practice)

1.Inline JavaScript: 

  Writing Java Script code directly inside an HTML tag using attributes like onclick, onchange, etc.

 <button onclick="alert('hello')">Click </button> --Easy not recommended large proj

What happens?

User clicks the button 

JavaScript runs immediately 

An alert box is shown 

Common JavaScript inline Events 

Event                When it runs 

Onclick             When elements is clicked

OnChange        When value change

Onkeyup           When key is released

Onload              When page loads

Onsubmit          When form is submited 

 When click button is called key down, when leave the button is call key up

2. Internal JavaScript

 Writing JavaScript code inside the  HTML file using the <script>tag(The JavaScript code is not inside HTML tags(like inline JS),but still lives within same HTML page.)

For ex:-

<script>
     function buttonclik()
      {
        alert("Submitted")
      }
   </script>

3.External JavaScript(Best practice)

Writing JavaScript code in a separate.js file and linking it to an HTML page(HTML and  JavaScript live in different files).

 Why Is External JavaScript "Best Practice"?

 Because it follow Separation of concerns:

 HTML -->Structure

 CSS -->Design

JavaScript-->Logic

<script  scr="script.js"></script>

This makes code: Clean,Reuable,mainrainable,professional


  • Comparison :Inline vs internal Vs External 
Type             Local                             Best For 
Inline         Inside HTML tag           Small demos 
Internal    <script> in HTML          Learning
External    Separate.js fie                 Real Projects

JavaScript Syntax and variables 

( Python 31)

Full stack developer means:

Front-end (html/JS/JQ/CSS)

Backend(Python/Dotnet/Java)

Database(mysql/Sqlserver..)

Websites Types

Statics ( page not change)

Dynamic (static change the data)

Task:

images/download.ipg

Style.css

 body {
          font-family: Arial;
          line-height:1.6;
          width:80%;
          background-color: #f4f6f8;
          margin:30x; padding:25px;
          border-radius:60px;
     }
     main {
          font-family: Arial;
          line-height:1.6;
          width:80%;
          background-color: #f4f6f8;
          margin:30x; padding:25px;
          border-radius:60px;
     }
     header{
      background-color: #2c3e50;
         color: white;
         padding:20px;
         text-align:center;
     }
     section{
      margin-bottom:25px;
     
     }
      h1{
      background-color: #2c3e50;
      padding: 5px;
    }
     h2{
      background-color: #f4f6f8;
      border-bottom:2px solid  #ddd;
      padding: 5px;
    }
   
    ul{
     margin-left:20px;
    }
    footer{
     text-align:left;
     padding:25px;
     background-color: #2c3e50;
     color:white;
     margin:60px; padding: 30px;
     border-radius:80px;  
     
    }
    footer a {
      color:#ffd700;
    }
    nav{
        background-color: #2c3e50;
    }
    .menu{
        list-style: none;
        margin: 0;
        padding:0;
        display:flex;
    }
    .menu li{
        margin:0;
    }
    .menu li a{
        display: block;
        padding: 14px 20px;
        color: white;
        text-decoration: none;
        font-weight:bold;

    }
    .menu li a:hover{
        background-color:#1a252f;
    }

script.js

     function buttonclik()
      {
        alert("Submitted")
      }

index.html

<!DOCTYPE html>
<html>
<head>
  <meta charset="UTF-8">
  <title> My First page </title>
   <link rel="Stylesheet" href="style.css">
</head>
<body>
    <nav>
        <ul class="menu">
            <li><a href="index.html">Home page</a></li>
            <li><a href="/Student.html">Student</a> </li>
    </nav>
  <header>
    <section> <h1> Learning SQL </h1><img src="images/download.jpg" style="height:80px; width:150px;"></section>
  </header>
  <main>
    <section>
     SQL is a standard language for storing, manipulating and retrieving data in databases.
    </section>
    <section>
      <p>
      <h2>SQL Tutorial</h2>
      <h2>Our SQL tutorial will teach you how to use SQL in: </h2>
      <ul">
        <li>MySQL</li>
        <li>SQL Server</li>
        <li>MS Access</li>
        <li>Oracle</li>
        <li>Sybase</li>
        <li>Informix</li>
        <li>Postgres</li>
      </ul>
      </p>
    </section>
      <section>
        <h2> SQL Exercises </h2>
        Many chapters in this tutorial end with an exercise where you can check your level of knowledge.
       <p>
        Which SQL statement is used to select all records from a table named 'Customers'?
           <br>
           <ul>
          <li> SELECT * FROM Customers; </li>
          <li> SELECT ALL FROM Customers; </li>
          <li> SELECT FROM Customers; </li>
           </ul>
       </p>
      </section>
      <footer>
        <p>Regards,</p>
        <p><a href="https://oracleask.blogspot.com/2026/01/python-39.html" target="_blank">Please Visit our blog</a> </p>
      </footer>
  </main>
</body>
</html>

student.html

<!DOCTYPE html>
<html>
<head>
  <meta charset="UTF-8">
  <title> My First page </title>
   <link rel="Stylesheet" href="style.css">
   <script src="script.js"></script>
</head>
<body>
     <nav>
        <ul class="menu">
            <li><a href="index.html">Home page</a></li>
            <li><a href="/Student.html">Student</a> </li>
    </nav>
   
  <header>
    <!-- <h1> Learning SQL </h1>-->
   <section> <h1> Learning SQL </h1><a href="/index.html" ><img src="images/download.jpg" style="height:80px; width:150px;"></a></section>
   
  </header>
  <main style="background-color: bisque;">
    <form>
     <table>
        <tr><td><label>Student Name:</label></td><td><input type="text" placeholder="StudentName"></td></tr>
        <tr><td><label>Mobile Number</label></td><td><input type="number" placeholder="Mobileno"></td></tr>
        <tr><td><label>Email ID:</label></td><td><input type="email" placeholder="Emailid"></td></tr>
        <tr><td><label>DOB:</label></td><td><input type="date"></td></tr>
        <tr><td><label>Location:</label></td><td><input type="text" placeholder="Location"></td></tr>
        <tr><td>Gender:</td><td><input type="radio" name="gen">Male<input type="radio" name="gen">FeMale<input type="radio" name="gen">Others</td></tr>
        <tr><td>Skills:</td><td><input type="checkbox" name="gen">AWS<input type="checkbox" name="gen">Java<input type="checkbox" name="gen">DotNet</td></tr>
        <tr><td>Country:</td>
            <td><select onchange="alert('item selected')">
            <option>select Country</option>
            <option>India</option>
            <option>USA</option>
            <option>UK</option>
            <option>Canda</option>
        </select></td></tr>
        <tr><td>Student image</td> <td><input type="file" > </td> </tr>
        <tr><td>Message:</td><td><textarea></textarea></td>
        <tr Style="text-align:center;"></td><td colspan="2"><button onclick="buttonclik()">Submit</button></td></tr>
       
     </table>
     </form>
       </main>
      <footer>
        <p>Regards,</p>
        <p><a href="https://oracleask.blogspot.com/2026/01/python-39.html" target="_blank">Please Visit our blog</a> </p>
      </footer>

</body>
</html>

Output:



--Thanks 

Tuesday, January 27, 2026

Python 29

 Web Development Basics

  • Introduction to HTML and CSS
  • Basic HTML page Structure
  • HTML Elements and Tags(Part 1)
  • HTML Elements and Tags(Part 2)
  • Introduction to CSS
  • CSS selector and properties 
Introduction to HTML and CSS 
HTML(HyperText Markup Language)
  •     Used to create the structure of a webpage 
  •     Define what content appears on the page 
  •     Example headings ,paragraphs, images, forms
Think of HTML as the skeleton of a webpage.

Collection of Tags
  We use various HTML tags to structure, organize and display content in different formats.
   HTML is like a building which is properly constructed but not decorated with any interior or paintings
   HTML is mainly used to create static structure. Dynamic behavior is  added using JavaScript.
  
 Basic HTML Page Structure

 Every Page follows a fixed structure:

index.html

<!DOCTYPE html>
 <html>
<head>
  <title> My First page </title>
</head>
<body>
 <h1> Hello World</h1>
</body>
</html>

Output:

Explanation:

  1. Read <!DOCTYPE html>-->Uses HTML5 Standards mode
  2. Enters <html> -->starts webpage
  3. Reads<head>--> Get Page info
  4. Sets browser tab title
  5. Read <body> -->Display content
Tag                                      Purpose 
<h1>--</h1>        To Present the data in different heading formats.
<p>--</p>            To Present the data in paragraph formats 
<br/>                    To Put a line break
<hr>                     To draw a horizontal line.
<b>/</strong>      To Present the data in bold format 
<i>/<em>              To Present the data in italic format
Note: Every tag must be closed properly(Except Some tags like <br>,<hr>,<img> do not need closing tags>

  • HTML Elements and Tags(Part 1)

 What are tags and why are they used ?

Tags are used to present the data in proper order in  a web-page 

  • Headings, Sub-headings
  • Paragraphs
  • Strong
  • Emphasize
  • Break
  • Horizontal line
We can present page titles, sub-titles, images, links etc..in the web pages.


Tag                            Full form                                Purpose 
<!DOCTYPE html>,Document type Declaration ,Tells the browser that the doc is written in HTML5
<html>,Hypertext markup language ,Root element that wraps the entire HTML document 
<head>,Head section ,Contains metadata(not visible on the page) like title,charset,styles
<meta>,metadata,Provides information about the page(encodingm,viewport,SEO..etc)
<meta charset="UTC-8">,character set ,Ensures correct display of all languages and symbols
 <meta name='viewport">,Viewport meta tag,Makes the webpage responsive on mobile devices 
<title>,Title,sets the browser tab title
<style>,Style sheet,Used to write internal CSS for styling the page
<body>,Body section,contains all visible content shown to the user 
<header>,Header section,Represents the top section of the page (title,intro,logo)
<h1>Heading1 ,main heading of the page (highest priority)
<h2>Heading2,Subheading of the page (highest priority)
<p>Paragraph,Used to display blocks of text 
<main>Main content ,Holds the primary content of the page 
<section>section,Group content together logically
<u1>unorder list,Displays list where order does not matter 
<lit>list, represents an individual item display the list
<footer> footer,represents botton section of the page 
<a> Anchor ,Create a clickable link to another page 


Task1:
RGB(211, 211, 211) for  each Color had their own code, that is  RCB code and Hex formatted code .
Padding adjustment for particular side, padding all side padding:20px;
padding-left:20px;padding-right:20px; padding-top:20px; padding-bottom:20px;

  •    Structure tags: --><html>,<head>,<body>
  •    Content tags:--><h1>,<p>,<ul>,<li>
  •    Layout tags:--><header>,<main>,<section>,<footer>
  •    Style tag: --><style>
  •   Utility tag:--><a>,<meta>

 CSS

Introduction CSS

CSS(cascading Style sheet)

Used to design and style HTML elements 

Controls colors ,fonts, layout,spacing,resposiveness

Thinks CSS is clothes and appearance of the skeleton 


Task1:

index1.html

<!DOCTYPE html>
<html>
<head>
  <meta charset="UTF-8">
   <title> My Second page </title>
  <link rel="Stylesheet" href="style.css">
<style>
     #sec1{
        background-color: gold;
     }
     
     .ccit{
        background-color: rgb(128, 0, 255);
        font-weight: 600;
     }
</style>
<body style="background-color:blanchedalmond!important;">
  <main>
     <header>
     <h1>SQL Statements</h1>
    </header>
    <h2>
    Most of the actions you need to perform on a database are done with SQL statements.
    </h2>
    <section id="sec1">
    SQL statements consist of keywords that are easy to understand.
    </section>  
    <section>
      <p>
      <h2>SQL Tutorial</h2>
      <h2>Our SQL tutorial will teach you how to use SQL in: </h2>
      <ul class="ccit">
        <li>MySQL</li>
        <li>SQL Server</li>
        <li>MS Access</li>
        <li>Oracle</li>
        <li>Sybase</li>
        <li>Informix</li>
        <li>Postgres</li>
      </ul>
      </p>
    </section>
    <button type="button" id="btn1" > Button</button>
    <p>
    The following SQL statement returns all records from a table named "Customers":
    </p>
      <footer>
        <p>Regards,</p>
        <p><a href="https://oracleask.blogspot.com/2026/01/python-39.html" target="_blank">Please Visit our blog</a> </p>
      </footer>
  </main>
</body>
</html>


Output:






Task2:

index.html

<!DOCTYPE html>
<html>
<head>
  <meta charset="UTF-8">
  <title> My First page </title>
   <link rel="Stylesheet" href="style.css">
</head>
<body>
  <header>
    <h1> Learning SQL </h1>
  </header>
  <main>
    <section>
     SQL is a standard language for storing, manipulating and retrieving data in databases.
    </section>
    <section>
      <p>
      <h2>SQL Tutorial</h2>
      <h2>Our SQL tutorial will teach you how to use SQL in: </h2>
      <ul">
        <li>MySQL</li>
        <li>SQL Server</li>
        <li>MS Access</li>
        <li>Oracle</li>
        <li>Sybase</li>
        <li>Informix</li>
        <li>Postgres</li>
      </ul>
      </p>
    </section>
      <section>
        <h2> SQL Exercises </h2>
        Many chapters in this tutorial end with an exercise where you can check your level of knowledge.
       <p>
        Which SQL statement is used to select all records from a table named 'Customers'?
           <br>
           <ul>
          <li> SELECT * FROM Customers; </li>
          <li> SELECT ALL FROM Customers; </li>
          <li> SELECT FROM Customers; </li>
           </ul>
       </p>
      </section>
      <footer>
        <p>Regards,</p>
        <p><a href="https://oracleask.blogspot.com/2026/01/python-39.html" target="_blank">Please Visit our blog</a> </p>
      </footer>
  </main>
</body>
</html>

Style.css

 body {
          font-family: Arial;
          line-height:1.6;
          width:80%;
          background-color: #f4f6f8;
          margin:30x; padding:25px;
          border-radius:60px;
     }
     main {
          font-family: Arial;
          line-height:1.6;
          width:80%;
          background-color: #f4f6f8;
          margin:30x; padding:25px;
          border-radius:60px;
     }
     header{
      background-color: #2c3e50;
         color: white;
         padding:20px;
         text-align:center;
     }
     section{
      margin-bottom:25px;
     
     }
     h2{
      background-color: #f4f6f8;
      border-bottom:2px solid  #ddd;
      padding: 5px;
    }
   
    ul{
     margin-left:20px;
    }
    footer{
     text-align:left;
     padding:15px;
     background-color: #2c3e50;
     color:white;
    }
    footer a {
      color:#ffd700;
    }


Output:



--Thanks