Login using Social Account
     Continue with GoogleLogin using your credentials
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...
No hints are availble for this assesment
Answer is not availble for this assesment
Loading comments...