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:
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
Type the following command inside MySQL prompt to stop MySQL
quit;
Type the following command inside MySQL prompt for help with MySQL
help;
Jupyter Notebbok:
In the Notebook tab on the right side of the screen, execute:
%load_ext sql
Then initialize databse connection:
%sql mysql://sqoopuser:NHkkP876rp@cxln2.c.thelab-240901.internal/retail_db
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/
Taking you to the next exercise in seconds...
Want to create exercises like this yourself? Click here.
No hints are availble for this assesment
Answer is not availble for this assesment
Loading comments...