One of the easiest ways to learn and work on SQL is using MySQL database.
What is MySQL:
MySQL is the most popular Open Source Relational Database Management System.
MySQL is one of the best RDBMS being used for developing various web-based software applications.
MySQL is developed, marketed and supported by MySQL AB, which is a Swedish company.
MySQL works on many operating systems and with many languages including PHP, PERL, C, C++, JAVA, etc.
Connecting to MySQL Server from CLI:
You establish the MySQL database using the MySQL binary at the command prompt.
-u > MySQL userid created by DBA for the users
-p > Password to connect to MySQL server as given by DBA to the users
-h > Hostname where MySQL Server is running. Not needed if server is running on the local machine.
Password can also be given in same command by putting the password just after -p without any spaces.
To exit, type exit and Enter:
From Lab -> MySQL Credentials, get your userid, password and hostname for MySQL. https://cloudxlab.com/my-lab#mysql-credentials
Open a new terminal and submit below command after putting in correct values:
mysql -u sqoopuser -pNHkkP876rp -h cxln2.c.thelab-240901.internal
Please note that the mysql username and password are different from your lab credentials which can be seen along with the Jupyter console.
You will get a MySQL prompt. Run a simple SELECT statement on the prompt.
SELECT "Hello World";
No hints are availble for this assesment
Answer is not availble for this assesment