Goolean Technologies Interview Questions, Process, and Tips

Table joins are used to combine data from two or more tables based on a related column.

• Inner join: returns only the matching rows from both tables

• Left join: returns all rows from the left table and matching rows from the right table

• Right join: returns all rows from the right table and matching rows from the left table

• Full outer join: returns all rows from both tables, with NULL values in the columns where there is no m...read more

MySQL backup command from command prompt

• Use mysqldump command to backup MySQL database from command prompt

• Syntax: mysqldump -u [username] -p [password] [database_name] > [backup_file_name.sql]

• Example: mysqldump -u root -p mypassword mydatabase > mybackup.sql

To load a CSV file into a database from the command prompt, you can use the database's command-line interface or a scripting language.

• Ensure the database is installed and accessible from the command prompt

• Use the appropriate command or script to connect to the database

• Create a table in the database with the same structure as the CSV file

• Use the appropriate command or script to import the CSV file into the table

• Verify t

To source a SQL file into database from command prompt, use the 'mysql' command followed by the database name and file path.

• Open command prompt

• Navigate to the directory where the SQL file is located

• Use the 'mysql' command followed by the database name and file path

• Example: mysql -u username -p database_name < file_path.sql

To create a table, use the CREATE TABLE statement followed by the table name and column definitions.

• Use CREATE TABLE statement

• Specify table name

• Define columns with data types and constraints

• Example: CREATE TABLE customers (id INT PRIMARY KEY, name VARCHAR(50), email VARCHAR(100));