eVidhya
eVidhya
  • Subjects
  • Tests
  • Jobs
  • Sign in
  • Contact Us
  •  
    Forgot Your Password?
    Not Registered? Login with Google

MySQL

  • 1. Stored Procedures and Functions in MySQL

  • 2. updatable vs. non updatable view

  • 3. updatable vs. non updatable view

  • 4. What is a View

  • 5. UNION, INTERSECTION, and DIFFERENCE

  • 6. foreign key constraints

  • 7. Naming Rules

  • 8. installing and setting up MySQL on Windows, macOS, and Linux

  • 9. RDBMS vs. MySQL

  • 10. What is a Database

  • 11. Aggregate Function

  • 12. count(),avg(),sum() functions

  • 13. Program to create client table

  • 14. Program to create employee table

  • 15. Introduction

  • 16. Installation on Linux and Windows

  • 17. Databases

  • 18. Data Types

  • 19. Types of MySQL Queries

  • 20. Create Table

  • 21. More About Create Table

  • 22. Alter Table

  • 23. Select Query Display Records

  • 24. Insert Query Add New Record

  • 25. Update Query Edit Records

  • 26. Delete Query Remove Records

  • 27. Primary Key & Foreign Key

  • 28. Alias for Table & Columns

  • 29. Concept of JOINS

  • 30. Self Join Queries

  • 31. Inner Join Queries

  • 32. Left Join Queries

  • 33. Right Join Queries

  • 34. Cross Join Queries

  • 35. Union Operator

  • 36. Group By Queries

  • 37. PHP Limit Data Selections From MySQL

  • 38. Exists Queries

  • 39. Unique Constraints

  • 40. Any, All Operators

  • 41. String Library Function

  • 42. Numeric Library Function

  • 43. Date & Time Library Function

  • 44. Aliases

  • 45. Views Part 1: Introduction to Views

  • 46. Views Part 2: Managing Views

  • 47. Views Part 3: Advanced Queries with Views

  • 48. Views Part 4: Updating Data Through Views

  • 49. Views Part 5: Best Practices and Limitations

Quality 4 Education Partners - MyBookx Creative Commons Licence Open Education Consortium

Subjects

Tests

Follow Us instagram youtube
  • FAQ
  • Terms
  • Privacy
  • Refund
  • Articles
  • Webstories
  • People
  • Learn about eVidhya
  • Scholarships
  • Advertise
  • Career
  • Contact
  • whatsapp +91 77957 84918
Copyright © 2025 eVidhya. All Rights Reserved.
xklsv

Sign In

Forgot Your Password?
Login with Google

Sign Up

Login with Google

Forgot Password

Login with Google