My story : DR.PRERNA SAXENA, IT PROFESSOR, AI RESEARCHER AND FOUNDER, COLOURS OF THE WIND INDIA.GOOGLE FOR EDUCATION CERTIFIED TRAINER.

 HELLO! I AM DR.PRERNA SAXENA, AN EDTECH BLOGGER AND AI SCIENTIST WHO WRITES COMPUTER PRACTICAL EBOOKS.RECENTLY, I HAVE COMPLETED MY PHD IN AI AND IT I.e. ARTIFICIAL INTELLIGENCE AND INFORMATION TECHNOLOGY. I HAVE COMPLETED GRADUATION B.SC. C.Sc. and Application in 2010. I did DIPLOMA IN JAVA TECHNOLOGY FROM NIIT NEW DELHI IN THE YEAR 2012. I RECONTINUE my studies in 2022 when I started writing books. Unfortunately my that AMAZON ID is not working. So I created a new account and cleared AMAZON TAX INTERVIEW. NOW, MY 3 EBOOKS ARE PUBLISHED ON AMAZON KINDLE APP AND CAN BE BOUGHT THROUGH AMAZON.IN . I AM GOOGLE EDTECH BLOGGER SINCE 2019. I PREPARE STUDENTS FOR ART COMPETITIONS. I AM GOOGLE FOR EDUCATION CERTIFIED TRAINER 2025 PASS OUT. I HAVE CONVERTED MY BLOG INTO DIGITAL LIBRARY, IN WHICH I WRITE IT AI RESEARCHED ARTICLES. MY 3 EBOOKS ARE , How to do BLOGGING and branding through GOOGLE, analytics and Statistics handbook and GOOGLE SEARCH CONSOLE HANDBOOK BY DR.PRERNA SAXENA. MY GOOGLE DIGITAL LIBRARY IS BEING SEARCHED IN 71 COUNTRIES, PREVIOUSLY AND NOW 66 COUNTRIES AROUND THE WORLD. 

MY MOTTO EDTECH TEACHING AND FINE ARTS USING FOR HEALING MINDS. ESP. OF DEPRESSED AND ANXIETY people.

https://coloursofthewindindia.blogspot.com/?m=1

My 2nd blog link shared above. I have got INSPIRING PERFORMANCE AWARD BY NEHRDO AND A+ in MEHENDI COMPETITION, WHERE I HAVE DRAWN LORD KRISHNA USING MEHENDI AND FEVICRYL HOBBY IDEAS CERTIFIED ART AND CRAFT PROFESSIONAL. I AM ESTABLISHING AN ORGANISATION ESP. ONLINE TEACHING with SUBJECTS- IT, FINE ARTS, JEWELLERY AND PAINTINGS OF DIFFERENT STATES ART FORMS. I AM THERAPEUTIC ART LIFE COACH who works on concentration building in students using art therapy. I am serving society with my EDTECH BLOG and ART THERAPY BLOG. I have won INTERNATIONAL ICON AWARD BY INTERNATIONAL WORLD RECORDS, as I have created a world record to being searched in 71 countries. I have completed my silk thread jewellery making course by BHARAT VIKAS PARISHAD KASHIPUR UTTARAKHAND In the year 2018. I have completed my art teachers training by PIDILITE INDUSTRIES LTD. FROM LUCKNOW In 2019. From Ayodhya, SWADESH SANSTHAN INDIA, I have achieved gold trophy. I  

have got BHARTIYA KALA SANMAAN AWARD BY AJANTA ELLORA INTERNATIONAL ART GALLERY. I usually give online competitions. And I have achieved 9  gold trophies and 7 total medals with 4 gold medals, one bronze for cartoon artist. My 2 students have become junior artist. I started my blogging career in 2011 through MY OFFICE, MACMILLAN PUBLISHING SOLUTIONS PVT LTD GURGAON. NOW I HAVE SET UP A WORK FROM HOME OFFICE. WHERE I PREPARING RESEARCH PAPERS OR A BOOKS SERIES ON GOOGLE VOCATIONAL OR Practical TRAINING . I am happy that I am AI LEADER ACCORDING TO GOOGLE GEMINI. I have secured 98% marks in AI RESEARCH EXAM CONTROLLED BY GOOGLE US, Signed by SUNDAR PICHAI SIR. RECENTLY, I RECEIVED WOMEN TECHMAKERS MEMBERS BADGE CERTIFICATE. And a certificate of academic achievements and leadership. Thank you. BEST REGARDS, DR.PRERNA SAXENA.

PROF. DR.PRERNA SAXENA PhD. founder, AI Scientist & multidisciplinary Creative Educator.

 

I prepare students for ART COMPETITIONS.

 

Professor. Dr. PRERNA SAXENA Ph.D.

 

PHD DEGREE BY GOOGLE to me I.e. DR.PRERNA SAXENA

 

COLOURS OF THE WIND INDIA ORGANIZATION, MANAGING DIRECTOR, DR.PRERNA SAXENA

COLOURS OF THE WIND INDIA ORGANIZATION is on GOOGLE.

 

DR.PRERNA SAXENA: EXCELLENCE IN AI, TECH AND LEADERSHIP.

 

Bracelet for sale, handcrafted by DR. PRERNA SAXENA

 

INTRODUCTION, DR.PRERNA SAXENA, IT SCIENTIST AND AI RESEARCH AUTHOR AT GOOGLE CHROME AND AMAZON KDP.

 Hi! I am DR.PRERNA SAXENA. IT WOMAN SCIENTIST AND AI RESEARCH AUTHOR AT GOOGLE CHROME AND AMAZON RESPECTIVELY.

My collage of works.

 

About GOOGLE SEARCH CONSOLE

 

Google Search Console (GSC) is a free web service provided by Google that lets website owners, developers, and SEO professionals monitor, maintain, and troubleshoot their site’s visibility in Google Search results.

While platforms like Google Analytics track who visits your site and how they behave, Search Console focuses on how Google sees your website and how organic search users find it.

Core Functions & Capabilities

• Search Performance Tracking: Monitors organic impressions, clicks, average click-through rate (CTR), and average ranking positions for specific queries and pages.
• Indexing & Crawling Management: Shows which pages Google has successfully crawled and indexed, and identifies pages blocked or failing to index.
• XML Sitemap Submission: Allows direct submission of sitemaps (sitemap.xml) to help Googlebot discover new and updated content efficiently.
• URL Inspection Tool: Provides real-time analysis of a specific URL to test how Google renders it, view index status, and request re-indexing.
• Technical Health & Core Web Vitals: Flags mobile usability issues, loading speed issues (LCP, FID/INP, CLS), security threats (like malware), and manual actions/penalties.
• Backlink & Internal Link Reporting: Reports which external sites link to your domain and how internal links are distributed across your pages.

Key Differences: Google Search Console vs. Google Analytics

Metric / Feature	Google Search Console (GSC)	Google Analytics (GA4)
Focus	Search engine visibility & technical health	User behavior & web traffic analysis
Data Origin	Direct Google Search engine logs	On-site tracking script / user sessions
Key Metrics	Impressions, Clicks, Ranking Position, CTR	Users, Sessions, Conversions, Engagement Time
Audience Scope	Google organic search traffic only	All traffic sources (Direct, Paid, Social, Referral)

Common Use Cases

• Troubleshooting Indexing: Identifying why a newly published blog post or page is not showing up in search results.
• Keyword Optimization: Discovering "low-hanging fruit" queries where a page ranks on page 2 (positions 11–20) to optimize content for page 1.
• Site Migration & Audits: Monitoring crawl errors (404s, 500s) during domain changes or major technical updates.

WHAT IS DATABASE? AND WHY IT IS USED?

 A database is an organized collection of structured information or data stored electronically in a computer system. Controlled by a Database Management System (DBMS), it allows users to store, manage, modify, and query data efficiently.

Why Databases Are Used

Compared to traditional flat-file storage or spreadsheets, databases provide distinct operational advantages:

• Efficient Data Retrieval: Indexes and query languages (like SQL) allow systems to search millions of records in milliseconds.
  
  
• Data Integrity & Consistency: Schema rules prevent duplicate records, enforce data types, and ensure updates propagate across all dependent entries.
  
  
• Concurrent Access: Multiple users and applications can read and write to the same database simultaneously without overwriting each other's changes.
  
  
• Scalability: Built to handle massive volumes of data (terabytes to petabytes) across distributed networks as demand grows.
  
  
• Security & Access Control: Fine-grained permissions restrict who can view or modify specific tables, rows, or sensitive fields.
  
  
• ACID Compliance: Ensures reliable processing of transactions—guaranteeing that complex operations either complete fully or roll back, preventing data corruption.
  
  

Common Types of Databases

Category	Key Characteristic	Primary Use Cases	Examples
Relational (RDBMS)	Data stored in structured tables with defined relationships	Financial systems, HRMS, inventory, order processing	MySQL, PostgreSQL, Oracle
Non-Relational (NoSQL)	Unstructured or semi-structured data using key-value, document, or graph models	Real-time analytics, big data, social networks, content platforms	MongoDB, Redis, Cassandra
In-Memory	Relies on main memory (RAM) rather than disk for storage	High-speed caching, real-time gaming leaderboards	Redis, Memcached
Distributed / Cloud	Spread across multiple nodes or managed cloud environments	High availability apps, global web platforms	Amazon DynamoDB, Google Cloud Spanner