ADVERTISEMENT

Sitemap

Explore our organized list of categories and posts for easy navigation.

Artificial Intelligence

  1. How to Protect Your Career in the Age of AI?
  2. Cybersecurity in the AI Era: New Threats and Defenses
  3. The Rise of Edge AI: Transforming Real-Time Applications
  4. AI in Cybersecurity: Enhancing Protection Against Attacks
  5. Top AI-Powered Tools for Developers in 2025
  6. Generative AI and Its Impact on Creative Industries
  7. The Metaverse: Opportunities, Challenges, and Ethics
  8. Is AI Dangerous for the Oracle DBA Role?
  9. DeepSeek vs. ChatGPT: How Does the New AI Rival Stack Up Against OpenAI?
  10. AI Is a Tool, Not a Thinker: Why Critical Thinking Matters More
  11. Deepfakes & AI Manipulation: Can You Trust What You See?
  12. How Students Should Use AI for Learning and Education
  13. Ghibli Art: Beautiful Anime or a Data Trap? Let’s Find Out
  14. AI vs ML vs DL: What’s the Difference?
  15. Top 10 AI Careers in 2025 & How to Learn Them Fast
  16. Everyone Talks About AI… But How Do You Actually Use It in Your System?
  17. Feeling Worried About AI and Your Job? Here’s How to Not Just Survive, But Thrive!
  18. AI for Everyone: It’s Not Just for Tech Geniuses
  19. How AI Agents Are Boosting Productivity in India (2025)

Blog

  1. Database vs. DBMS: Key Differences Explained
  2. Oracle DBA Roles and Responsibilities
  3. Oracle Data Pump Export (EXPDP): A Complete Guide
  4. Oracle Data Pump Import (IMPDP): A Complete Guide
  5. How to Monitor Archive Log Generation in Oracle: Best Practices
  6. How to Create an Oracle Directory for Export/Import
  7. How to Monitor and Identify Failed Login Attempts in Oracle
  8. What are Oracle Restore Points and How to Use Them
  9. What is Proxy Access in Oracle and How to Use It
  10. How to Keep Processes Running in the Background with nohup
  11. SQL Query to Check Object Count in Oracle Schema
  12. Oracle PFILE vs SPFILE: Key Differences and Usage Guide
  13. How to Recompile Invalid Schema Objects in Oracle
  14. A Comprehensive Guide to Fast Recovery Area (FRA) in Oracle
  15. How to Get DDL for Oracle Objects
  16. How to Create an SQL Baseline for a Specific SQL_ID
  17. Fixing Index Ownership Issues in Oracle
  18. How to Fix ORA-01536: Space Quota Exceeded Error in Oracle
  19. Backing Up Oracle Directories and Grants
  20. How to Find When a User’s Password Was Last Changed in Oracle
  21. How to Resolve ORA-01653: Unable to Extend Table in Tablespace
  22. What is a .PAR File and How It Works
  23. Identify and Terminate Active Statistics Collection Job in Database
  24. Kill or Disconnect Oracle Session in Single Instance & RAC
  25. Script to Track Top 10 CPU-Consuming Oracle Sessions
  26. Understanding the oratab File in Oracle: Role and Usage
  27. What is Sudo Access for Oracle DBAs and Why It’s Important
  28. Understanding Oracle DB Character Set (CHARSET)
  29. Retrieve All Key Oracle Database Information with a Single Query
  30. OPatch Command Usage for Oracle Patch Management
  31. Is ChatGPT Replacing Google Search? How It Changes Search
  32. Everything You Need to Know About Oracle NLS_DATE_FORMAT
  33. How to Write the Perfect Email: A Complete Guide
  34. How to Write the Perfect Email: A Complete Guide
  35. Oracle DATAPUMP EXPDP/IMPDP Monitoring Scripts
  36. SQL Query to Check User-wise INACTIVE Session Count in Oracle
  37. Understanding SQL>@?/rdbms/admin/sqltrpt.sql: A Detailed Guide
  38. Monitor Long Operations in Oracle
  39. Oracle Tablespace Quota Management Script
  40. Step-by-Step Guide to Creating and Executing a SQL Tuning Task
  41. How to Check Hidden Parameters in Oracle
  42. How to Export & Import Statistics in Oracle Database
  43. How to Fix ORA-39095: Dump File Space Has Been Exhausted
  44. Oracle RMAN: Scripts to Monitor Backup Progress
  45. Understanding the Find Command
  46. Generate AWR, ASH, ADDM Reports from SQL Prompt
  47. What is an SSH Key and How to Add One in Oracle
  48. How to Resolve a Hung AWR Process in Oracle
  49. Monitoring Oracle Database Growth and Space Utilization
  50. How to Find Oracle Database Size
  51. Oracle Database Patching: Common Steps
  52. Crontab in Linux: Examples and Useful Commands
  53. How to Choose the Best Laptop: Tips to Keep in Mind Before Buying
  54. Oracle SQL Scripts for User Password, Account Info, and History
  55. API Economy: How APIs are Changing the Digital Landscape
  56. Low-Code vs. No-Code: Revolutionizing Application Development
  57. CBSE Practical Exams: Essential Tips for Students and Teachers
  58. Privacy-First Technologies: How Big Tech Is Adapting
  59. Ransomware Attacks: How to Protect Your Data
  60. What Is ORA-01720: ‘Grant Option Does Not Exist’ and How Do You Fix It?
  61. How to Backup User Passwords in Oracle
  62. Your Guide to Living Sustainably in 2025: Simple Changes with Big Impact
  63. How to Kill Oracle Export/Import Jobs
  64. What Are Internet Cookies and Why Do They Matter?
  65. ChatGPT vs Google Gemini vs Microsoft Copilot
  66. Exploring Access Control Lists (ACL) Privileges in Oracle
  67. How to Manage Restricted Mode in Oracle Database
  68. How to Resolve In-Doubt 2PC Transactions in Oracle Database
  69. How to Fix ORA-01017: invalid username/password; logon denied
  70. Resolving RMAN-06617 Error in RMAN Duplicate Command
  71. Google Maps: How It Works and Why It’s Accurate
  72. Why Google Offers Free 15GB Storage on Google Photos
  73. How to Create a Mobile App for Your Website
  74. Managing Database Links in Oracle: A Step-by-Step Guide
  75. Beyond Gaming: How AR and VR Are Transforming Industries
  76. Start and Stop MRP in Oracle Data Guard
  77. Oracle Data Guard: Features, Configuration & Best Practices
  78. What is UNDO_RETENTION: How It Works and Why It Matter
  79. How to Boost WordPress Website Speed: Best Practices & Tools
  80. How to Check Resource Limits and Utilization History in Oracle
  81. Flashback Recovery Info in Oracle: A Complete Guide
  82. Fixing ORA-39173: Exporting Encrypted Data Without Encryption
  83. Setting Up UTL_MAIL in Oracle Database: A Step-by-Step Guide
  84. Understanding the Ping Command: A Complete Guide
  85. The Ultimate Guide to the Telnet Command
  86. Complete Guide to ipconfig with Examples
  87. How to Resolve RMAN Duplicate Failure Due to Wallet Not Open
  88. How to Disable Oracle Scheduler Jobs: Job Queue Processes, Memory, SPFILE, RAC, and Non-SYS Jobs
  89. How Tech Professionals Can Make Extra Income in 2025
  90. Linux Commands Cheat Sheet: A Quick Reference Guide
  91. What is Ads.txt? How It Improves Ad Revenue and Prevents Fraud
  92. UPI Transactions With Special Characters Will Be Blocked From Feb 1 – What You Need to Know
  93. Are WordPress Plugins Safe? The Risks No One Talks About!
  94. How to Grant All Privileges to a User in Oracle
  95. Revoke All Privileges from a User in Oracle
  96. Phishing vs. Legitimate URLs: How to Spot the Difference
  97. How to Detect Phishing Emails: A Complete Guide with Examples
  98. Oracle ACID Properties Explained with Examples
  99. How to Connect to Oracle Database Using SQL*Plus
  100. Must-Have WordPress Plugins for Every Website
  101. Google Search Console: Domain vs. URL Prefix – Which One to Use?
  102. Google AdSense Approval: Essential Requirements You Must Meet
  103. DBMS_SHARED_POOL.PURGE Not Working? Here’s the Fix
  104. How to Assign a Dedicated Temporary Tablespace to a User in Oracle
  105. How to Fix “NtCreateFile(\Device\VBoxDrvStub) Failed” Error in VirtualBox 7.1.6 on Windows
  106. Automate Oracle DBA Login with a Custom Alias on Linux
  107. How to Access Your Virtual Machine on VirtualBox Using MobaXterm
  108. How to Install Oracle 19c on Amazon Linux 2 (2025) | Step-by-Step Guide
  109. How to Download and Install Oracle 19c on Oracle Linux 8.10 (x86_64) in VirtualBox VM
  110. Oracle Manual DB Switchover: Primary to Standby with DGMGRL
  111. How to Remove a Cached SQL Execution Plan in Oracle
  112. How to Use Oracle SQL Developer Extension in VS Code
  113. HTTP Methods in Postman: Practical Guide
  114. Get Oracle User Privileges: App, Custom, Default & All Users
  115. Domain Extensions Explained: Which One Fits Your Website?
  116. Troubleshooting Inter-Node Network Issues in Oracle RAC
  117. Top Network Ports Every IT Pro Should Remember
  118. Purge Unified Audit Trail in Oracle to Free Up SYSAUX Space
  119. Test Network Latency Using ping -c 900 Command
  120. How to Open the Standby Database When the Primary Is Lost
  121. How to Delete Multiple Lines in vi Editor
  122. Mastering Multi-Region EC2 Deployment for High Availability
  123. What is Blockchain?
  124. Dijkstra Algorithm Defeated: Fastest Pathfinding Breakthrough

Career

  1. How to Protect Your Career in the Age of AI?
  2. Top 10 AI Careers in 2025 & How to Learn Them Fast
  3. Top 10 Tips for Your Job Search, Career, and Salary
  4. 7 Career Mistakes to Avoid Before It’s Too Late
  5. Why Most Job Seekers Fail at Interviews (And How to Succeed)
  6. The Secret Career Hack Nobody Told You in College
  7. 10 Skills That Will Be More Valuable Than a Degree by 2030
  8. Want to Double Your Salary? Start With This One Habit
  9. Why Recruiters Ignore Your Resume (Even When You’re Qualified)
  10. 10 Bill Gates Quotes That Will Change How You See Success
  11. Top Skills Employers Will Look for in 2025

CSS Tutorial

  1. CSS Introduction
  2. How to Add CSS to HTML
  3. CSS Selectors Basics
  4. CSS Comments
  5. CSS Properties and Values
  6. CSS Units
  7. CSS Colors
  8. CSS !important
  9. CSS Selector Types
  10. CSS Universal Selector
  11. CSS Combinators
  12. CSS Attribute Selectors
  13. CSS Pseudo-Classes
  14. CSS Pseudo-Elements
  15. CSS Text & Fonts
  16. CSS Box Model & Layout Basics
  17. CSS Backgrounds & Borders
  18. CSS Dimensions & Spacing
  19. CSS Advanced Layout
  20. CSS Responsive Design
  21. CSS Transitions and Animations
  22. CSS Visual Effects
  23. CSS Variables & Functions
  24. CSS Best Practices
  25. CSS Tools and Frameworks
  26. Final Project + Wrap Up

Data Guard

  1. What is Oracle Data Guard
  2. Primary Database
  3. Types of Standby Databases in Oracle Data Guard
  4. Far Sync Instances in Oracle Data Guard
  5. Oracle Data Guard Protection Modes
  6. Redo Transport Services in Oracle Data Guard
  7. Apply Services in Oracle Data Guard
  8. Role Transitions in Oracle Data Guard
  9. Starting & Shutting Down a Physical Standby Database
  10. Opening a Physical Standby Database

EMRS Tier-1: PGT & TGT Exam

  1. Puzzles & Seating Arrangement
  2. Data Sufficiency
  3. Statement Based Questions (Verbal Reasoning)
  4. Inequality (Logical Reasoning)
  5. Blood Relations (Logical Reasoning)
  6. Sequences and Series
  7. Direction Test
  8. Assertion and Reason
  9. Venn Diagrams

Excel Insights

  1. Master Excel’s XLOOKUP for Effortless Data Retrieval
  2. The Future of Excel: How AI and Copilot Are Changing Data Work
  3. Excel vs. Google Sheets in 2025: Which One Should You Choose?
  4. Top 10 Excel Features You Didn’t Know Existed (But Should in 2025)
  5. Is Excel Still Relevant in the Era of Data Science & BI Tools?

Getting Started with Oracle DBA

  1. Introduction
  2. Oracle DBA Role Explained
  3. What Is a Database?
  4. Database vs Spreadsheet
  5. DBMS
  6. Types of Databases
  7. DBMS and OS
  8. Oracle DB: Editions & Versions
  9. Database Server
  10. Database Instance
  11. System Global Area
  12. Program Global Area
  13. Background Processes
  14. Shared Pool
  15. Large Pool
  16. Database Buffer Cache
  17. In-Memory Area
  18. Container Database (CDB)
  19. Application Containers
  20. Database Storage Structures
  21. Tablespaces
  22. Schemas and Schema Objects
  23. Database System Files
  24. Automatic Diagnostic Repository (ADR)
  25. Backup Files
  26. Process Monitor (PMON)
  27. Process Manager (PMAN)
  28. Listener Registration Process (LREG)
  29. SMON – System Monitor Process
  30. Database Writer Process (DBWn)
  31. Checkpoint Process (CKPT)
  32. MMON & MMNL (Manageability Monitor Processes)
  33. Recover Process (RECO)
  34. Log Writer Process (LGWR)
  35. Archiver Process (ARCn)
  36. Job Queue Coordinator Process (CJQ0)
  37. Recovery Writer Process (RVWR)
  38. Flashback Data Archiver Process (FBDA)
  39. Space Management Coordinator Process (SMCO)
  40. Dispatcher Process (Dnnn) & Shared Server Process (Snnn)

HTML Tutorial

  1. HTML Introduction
  2. HTML Basic Structure
  3. HTML First Page
  4. HTML Editors and Tools
  5. HTML Tags Elements Attributes
  6. HTML Page Title and Metadata
  7. HTML Headings
  8. HTML Paragraphs and Line Breaks
  9. HTML Comments
  10. HTML Text Formatting
  11. HTML Abbr, Quotes, and Cite
  12. HTML Code, Pre, and KBD Tags
  13. HTML Mark, Time, Sup and Sub Tags
  14. HTML Address and Editorial Tags
  15. HTML Entities
  16. HTML Lists – Ordered, Unordered, and Description
  17. HTML Links and Navigation
  18. HTML Images and Media
  19. HTML Tables
  20. HTML Forms
  21. HTML Div, Span & Layout Basics
  22. Semantic HTML Elements
  23. HTML Meta Tags
  24. HTML Accessibility (ARIA, Labels, Roles)
  25. HTML Advanced Topics
  26. HTML Wrap-Up

JavaScript Tutorial

  1. What is JavaScript?
  2. JavaScript Execution: Browser vs Node.js
  3. How to Install Node.js
  4. Writing Your First JavaScript Program
  5. JavaScript Variables and Data Types
  6. JavaScript Operators and Expressions
  7. JavaScript Control Statements
  8. Loops in JavaScript
  9. JavaScript Functions
  10. Working with Data
  11. JavaScript DOM Manipulation
  12. JavaScript Browser Objects
  13. Object-Oriented JavaScript (OOP)

News

  1. Google Introduces Restricted Access Features (RAFs) for AdSense for Search
  2. Make Money from Empty Ad Spaces in AdSense
  3. 🚨 Big News: OpenAI & Oracle Team Up to Build Massive AI Infrastructure
  4. Oracle Database@AWS: All You Need to Know
  5. FASTag Annual Pass 2025: Eligibility, Benefits & How to Apply
  6. Oracle Layoffs 2025: 150 Cloud Jobs Cut as AI Spending Soars
  7. ChatGPT Go in India: ₹399 AI Plan You Should Know About
  8. Gemini 2.5 Flash Nano Banana: Image Editing Just Got a Whole Lot Smarter
  9. Get Ready for Tomorrow: Top Tech Trends for 2025 You Need to Know About!
  10. How Unsafe Downloads Put You at Risk
  11. How Google Photos Fits So Many Photos in 15GB
  12. iPhone 17 Pro: Apple’s New Benchmark for Power and Creativity
  13. Spotify Finally Delivers: Lossless Audio Rolls Out on Premium
  14. Nothing OS: Full Review — How It Compares to Android & iOS
  15. Top 10 Gemini Nano Banana Saree Prompts
  16. Nothing OS 4.0 Lands with Exclusive Android 16 Preview!
  17. The H-1B Visa Fee: America Just Put a $100,000 Price on the Dream
  18. Sam Altman Warns: AI Could Replace Customer Support Jobs
  19. How to Check Aadhaar Status Online Using Enrollment Number
  20. Zoho Arattai App: India’s Privacy-First Alternative to WhatsApp
  21. Google to Invest $15 Billion in AI Hub at Visakhapatnam

Oracle

  1. How to Copy Data from Prod to Test via DB Link
  2. What is SET TIME ON and SET TIMING ON in Oracle?
  3. Oracle DB Startup Steps on Linux
  4. Oracle DB Shutdown Steps on Linux
  5. How to Perform Tablespace-Level Export/Import Within the Same Oracle Database
  6. How to Perform Tablespace-Level Export/Import Between Two Oracle Databases
  7. Why Fast Queries Suddenly Slow Down — And What Causes Execution Plan Changes in Oracle
  8. How to Backup and Restore ORACLE_HOME Binaries and Oracle Inventory Before Patching
  9. How to Backup Oracle oratab, .bash_profile, and Environment Variables
  10. Automate ORACLE_HOME and Oracle Inventory Backup (with One-Click Restore) Before Patching
  11. How to Check If Your Oracle Database Is Multitenant (CDB or non-CDB)
  12. How to Fix ORA-31696 When Using DIRECT_PATH Import in Oracle Data Pump
  13. How to Fix “ORA-28011: the account will expire soon; change your password now”
  14. How to Fix ORA-39142: Incompatible Dump File Version in impdp
  15. How to Fix ORA-00959: Tablespace ‘TEST_TBS’ Does Not Exist
  16. How to Fix ORA-00059: Maximum Number of DB_FILES Exceeded in Oracle
  17. ORA-00020: Maximum Number of Processes Exceeded — What It Means and How to Fix It
  18. How to Fix ORA-00054: Resource Busy and Acquire with NOWAIT Specified or Timeout Expired
  19. How to Disable AutoTask in Oracle
  20. How to Fix ORA-19687: SPFILE Not Found in Backup Set
  21. Optimize Your SQL Queries with ChatGPT
  22. How Oracle DBAs Can Leverage AI in 2025
  23. Should You Use “@” in Oracle Passwords? Risks, Errors & Fixes
  24. ORA-14451: Unsupported Feature with Temporary Table
  25. ORA-00030: User Session ID Does Not Exist

Oracle DBA D2D Tasks

  1. Overview
  2. Install Oracle 19c on Amazon Linux 2 (GUI-Based)
  3. Oracle 19c Silent Install & DB Creation on Oracle Linux 8
  4. Connect to Database
  5. Check Database Status
  6. Oracle Database Start and Stop
  7. Oracle User Management
  8. Clone Oracle User with user_profile.sql Script
  9. Oracle Tablespace Management
  10. Oracle Session Management
  11. Archive Log Generation in Oracle
  12. Oracle Access Control Lists (ACLs)
  13. Oracle Manual Switchover (Primary ➝ Standby) – DGMGRL
  14. Start & Stop MRP Process in Oracle Data Guard
  15. Disable Oracle Scheduler Jobs: Job Queue, Memory, SPFILE, RAC, Non-SYS Jobs
  16. SCP File Transfer
  17. Create Directory
  18. .par File in Oracle Data Pump
  19. Oracle Table Refresh
  20. Oracle Schema Refresh
  21. Full DB Refresh
  22. Schema Object Count
  23. Extract DDL for Oracle Objects
  24. Transfer Schema Statistics from Source to Target Database
  25. Oracle Restore Points
  26. File System Housekeeping with find Command
  27. Fast Recovery Area (FRA)
  28. Oracle DB Patching: Key Steps
  29. Oracle GoldenGate GGSCI Commands
  30. Oracle SRVCTL Commands
  31. Oracle CRSCTL Commands
  32. Oracle RMAN Commands
  33. Linux Commands for Oracle DBA
  34. ASMCMD Commands for Oracle ASM
  35. Oracle DBMS_SCHEDULER Commands
  36. Oracle Data Guard Broker (DGMGRL) Commands
  37. Oracle Flashback Commands
  38. ADRCI Commands
  39. Recompile Invalid Schema Objects in Oracle
  40. Generate AWR, ASH, ADDM Reports from SQL Prompt
  41. Oracle Index Management
  42. Oracle Kill Session – ALTER SYSTEM KILL Session

Oracle DBA Interview Q&A

  1. Oracle DBA Interview Basics
  2. Oracle Database Architecture
  3. Oracle Database Startup and Shutdown
  4. Oracle User and Security Management
  5. Oracle Tablespace & Storage Management
  6. Oracle RMAN Backup & Recovery
  7. Oracle Data Pump Export & Import
  8. Oracle Data Guard
  9. Oracle RAC (Real Application Clusters)
  10. Oracle GoldenGate
  11. Oracle Performance Tuning & Monitoring

Performance Tuning

  1. Oracle Performance Tuning Overview
  2. What Is a Bad SQL Query? (And Why It Slows Everything Down)
  3. Purge SQL Plan from Shared Pool in Oracle
  4. Create a SQL Plan Baseline in Oracle
  5. restore_tables_stats_v1.sql
  6. table_stats_sqlid_v1.sql
  7. sql_ash_exec_hist_v1.sql

PostgreSQL

  1. PostgreSQL Introduction
  2. Install PostgreSQL on Windows
  3. Install PostgreSQL Linux
  4. CREATE DATABASE
  5. ALTER DATABASE

SEO

  1. 10 On-Page SEO Tips to Improve Your Website’s Rankings in 2025
  2. How to Choose the Best SEO-Friendly WordPress Theme for Top Rankings
  3. SEO Blog Writing: Easy Tips to Rank Higher & Engage Readers
  4. How Google Ranks Pages: The Secret Behind Your Rankings
  5. How to Do Keyword Research Like a Pro: A Step-by-Step Guide
  6. On-Page SEO Checklist for Better Rankings
  7. Backlink Strategy 2025: How to Build High-Quality Links for SEO
  8. Key Technical SEO Fixes for Better Performance and Rankings
  9. What is Robots.txt? Why It’s Important for SEO
  10. Google Algorithm Updates: Staying Ahead of SEO Change
  11. How AI is Revolutionizing SEO for Better Rankings
  12. What is an XML Sitemap and How is it Important for SEO
  13. How Cloudflare Boosts Website Speed Without Hosting
  14. What Is a DoS Attack? How It Works and Impacts Websites

Shell Scripts

  1. Shell Scripts Overview
  2. GoldenGate Process Monitor
  3. Monitoring Standby Apply Lag with Shell Script
  4. Automate Deletion of Old Archive Logs Using RMAN
  5. Monitoring Blocking Sessions in Oracle (RAC & Single Instance)
  6. Monitor ASM Diskgroup Usage
  7. Monitor Failed Login Attempts
  8. Filesystem & ZFS Usage Alert Script for Unix/Linux
  9. Automatically Archive and Compress Oracle Alert Logs
  10. Oracle Tablespace Usage Monitor with Email Alerts
  11. Oracle Alert Log Monitoring with ORA- Error Notifications

SQL Tutorial

  1. SQL Overview
  2. SQL Syntax
  3. SQL Statements
  4. SQL Comments
  5. SQL Data Types
  6. SQL SELECT
  7. SQL SELECT DISTINCT
  8. SQL WHERE
  9. SQL AND / OR / NOT
  10. SQL Comparison Operators
  11. SQL LIKE & Wildcards
  12. SQL ORDER BY
  13. SQL LIMIT / TOP / FETCH FIRST
  14. SQL INSERT
  15. SQL INSERT SELECT
  16. SQL UPDATE
  17. SQL DELETE
  18. SQL COUNT / SUM / AVG / MIN / MAX
  19. SQL GROUP BY
  20. SQL HAVING
  21. SQL CASE
  22. SQL INNER JOIN
  23. SQL LEFT JOIN
  24. SQL RIGHT JOIN
  25. SQL FULL JOIN
  26. SQL SELF JOIN
  27. SQL CROSS JOIN
  28. SQL UNION / UNION ALL
  29. SQL Aliases
  30. SQL Subqueries
  31. SQL EXISTS / ANY / ALL
  32. SQL SELECT INTO
  33. SQL Window Functions
  34. SQL CREATE DATABASE
  35. SQL DROP DATABASE
  36. SQL CREATE TABLE
  37. SQL ALTER TABLE (Add, Drop, Modify)
  38. SQL DROP TABLE
  39. SQL NOT NULL / DEFAULT
  40. SQL UNIQUE
  41. SQL PRIMARY KEY
  42. SQL FOREIGN KEY
  43. SQL CHECK
  44. SQL AUTO_INCREMENT / IDENTITY
  45. SQL INDEX
  46. SQL VIEW
  47. SQL Injection (Prevention Tips)
  48. SQL GRANT / REVOKE (Permissions)
  49. SQL NULL Handling
  50. SQL Date & Time Functions
  51. SQL String Functions
  52. SQL Math Functions
  53. SQL Stored Procedures
  54. SQL Triggers
  55. SQL Transactions (BEGIN, COMMIT, ROLLBACK)
  56. SQL Error Handling (TRY/CATCH / Exception blocks)
  57. SQL Operators List

ADVERTISEMENT