Getting Started with various Tools

18 / 44

MySQL

Purpose: An open-source relational database management system.

Home Page: https://www.mysql.com/

Documentation: https://dev.mysql.com/doc/

Related resources to learn: https://cloudxlab.com/assessment/playlist-intro/114/sql-tutorial?course_id=124&playlist_id=114

How to get started:

Web Console:

  1. In the web console tab on the right side of the screen, type the following command to start MySQL

    mysql -h cxln2.c.thelab-240901.internal -u sqoopuser -pNHkkP876rp
    
  2. Type the following command inside MySQL prompt to stop MySQL

    quit;
    
  3. Type the following command inside MySQL prompt for help with MySQL

    help;
    

Jupyter Notebbok:

  1. In the Notebook tab on the right side of the screen, execute:

    %load_ext sql
    
  2. Then initialize databse connection:

    %sql mysql://sqoopuser:NHkkP876rp@cxln2.c.thelab-240901.internal/retail_db
    
  3. Now in every cell you want to write an SQL query, makesue to write %%sql as the first line of that cell. For example, to query to show all the tables must be written as follows:

    %%sql
    show tables
    

    More here: https://cloudxlab.com/blog/how-to-access-databases-using-jupyter-notebook/


No hints are availble for this assesment

Answer is not availble for this assesment

Loading comments...