Python with MySQL

Home Python with MySQL MySQL

MySQL

15 hours 0 mins

Python with MySQL

  1. List the features of MySQL.
  2. State the advantages of MySQL over other RDBMS.
  3. Compare MySQL with other RDBMS.
  4. State the advantages of PHP in MySQL.
  5. Explain open source software licenses.
  6. Explain the various distribution options of MySQL.
  7. Explain the installation process of MySQL on Microsoft Windows.
  8. Explain the installation process of MySQL on Red Hat Enterprise Linux.
  9. Explain the configuration process of MySQL using Scripts.
  10. Explain initialization of MySQL at startup.
  11. Explain database.
  12. Explain the data types.
  13. Identify the different types of data.
  14. Explain the creation of a table.
  15. Explain Normalization.
  16. Identify the different forms of normalization.
  17. Explain Indexes and Referential Integrity.
  18. Describe the commands to view and alter a database.
  19. Explain the commands to retrieve data from a table.
  20. Describe the commands to modify the table definitions.
  21. Describe the commands to delete the table definitions.
  22. Explain the use of keys in a table
  23. Explain the use of indexes in a table
  24. Explain modification of tables
  25. Explain the use of the ORDER BY command
  26. Explain the use of the GROUP BY command
  27. Explain the different types of table joins in MySQL
  28. Explain the use of Equi-Join
  29. Explain the use of Inner Join
  30. Explain the use of Outer-Join
  31. Explain the use of Self-Join
  32. Explain the use of multiple SELECT queries in a single SELECT query
  33. Explain the use of UNION with the query
  34. Use the Aggregate functions in MySQL.
  35. Use the Mathematical functions in MySQL.
  36. Describe the use of Date functions in MySQL.
  37. Describe the use of String functions in MySQL.
  38. Describe the use of System Information functions in MySQL.
  39. Describe the creation of user accounts in MySQL.
  40. Identify the privileges in MySQL.
  41. Explain the privileges present in MySQL.
  42. Explain the commands for setting up of restrictions in MySQL.
  43. Describe the new features and enhancements added to MySQL 5.7.
  44. Explain Geospatial data and how to use it in MySQL.
  45. List and describe spatial data types in MySQL.
  46. Identify JSON Data types.
  47. Describe Stored Procedures.
  48. Explain transactions and how to handle them.
  49. Explain the impact of transactions on performance.
  50. Describe MySQL support for different languages and timezone.
  51.  Describe Performance Optimization.
  52.  Describe Query related functions.
  53.  Explain capability of MySQL for scaling and availability.
  54.  Explain replication in MySQL.
  55.  Explain how to perform data management using replication.
  56.  Describe concepts of partitioning in MySQL.
  57.  Describe concepts of Storage Systems and Management.
Python Session 12: Code Introspection and Testing (Prev Lesson)
Back to Python with MySQL

No Comments

Give a comment

Course Curriculum

×