HIMS 645 ASS 6

Review the  Python Tutorial (  Python Tutorial (w3schools.com)   or  https://www.w3schools.com/python/python_mongodb_getstarted.asp  for creating MySQL database and write  syntaxes  used for the following actions:

1. Create  a Database named  mydatabse.

2. Create  a Table within mydatabse named  Customers

3. Insert  data in the  Customers table.

4. Select  all records from the  Customers table

5. Sort  the results of the  Customer table in  Ascending and  Descending order

6. Delete  a record from the  Customer table

7. Update existing records in the  Customer table

8. Join one or more tables.

9. Query  Customer database for the selected records

10. Delete  the Customer Table

11. Compare Python with SQL for creating databases with respect to ease of learning and application. Which one do you prefer? Why?

 Your APA formatted assignment comprising 2-4, double-spaced, typed in 12-point Times New Roman (or 11- point Calibri) excluding the Cover and Reference pages should be submitted by Tuesday mid-night. 2 credible sources should be used to support your ideas. Follow APA 7