Analytics Engineering
Start free
← All topics

Python: SQL Integration With Python

20 exercises3 free
  1. 01Distinct Customer Cities
    Free→
  2. 02Create A Table
    Free→
  3. 03Insert Rows
    Free→
  4. 04Query The Table
    Locked→
  5. 05Parameterized Queries
    Locked→
  6. 06Commit And Close
    Locked→
  7. 07Aggregation Query
    Locked→
  8. 08Use Pandas.read_sql_query
    Locked→
  9. 09Join Two Tables
    Locked→
  10. 10Update A Record
    Locked→
  11. 11Add A Column To An Existing Table
    Locked→
  12. 12Update The New 'Email' Column
    Locked→
  13. 13Use A Transaction (BEGIN, COMMIT, ROLLBACK)
    Locked→
  14. 14Use A SQL Function In SELECT
    Locked→
  15. 15Subquery In SELECT
    Locked→
  16. 16Create An Index And Show EXPLAIN QUERY PLAN
    Locked→
  17. 17Handle Exceptions In SQL Operations
    Locked→
  18. 18GROUP BY And HAVING Example
    Locked→
  19. 19Parameterized Insert Of Multiple Rows
    Locked→
  20. 20Using Pandas To Write To SQL
    Locked→