Database Exercises

How to move a folder to the right place

mv ~/Desktop/codeup-data-science ~/

paths can be relative or absolute

cd ~/path/to/repo_to_remove
pwd
rm -rf .git

make sure you choose "Save Query", not "Save Connection" and save the file with the .sql extension
how to save files in the right place

rm file_to_delete
git add file_to_delete
git commit -m "Removed the file to delete"

The find command

find ~/codeup-data-science -name '*codeup*'

Name		Name	Last commit message	Last commit date
Latest commit History 24 Commits
11_Case_Statements.sql		11_Case_Statements.sql
3.1_mysql_introduction.sql		3.1_mysql_introduction.sql
3.3_tables_exercises.sql		3.3_tables_exercises.sql
3.4_select_exercises.sql		3.4_select_exercises.sql
functions_exercise.sql		functions_exercise.sql
functions_lesson.sql		functions_lesson.sql
group_by_exercises.sql		group_by_exercises.sql
group_by_lesson.sql		group_by_lesson.sql
join_exercise_solution.sql		join_exercise_solution.sql
limit_exercises.sql		limit_exercises.sql
order_by_exercise.sql		order_by_exercise.sql
readme.md		readme.md
relationship_notes.md		relationship_notes.md
subqueries_exercise.sql		subqueries_exercise.sql
subquery_lesson.sql		subquery_lesson.sql
temp_tables_exercise.sql		temp_tables_exercise.sql
temporary_table_lesson.sql		temporary_table_lesson.sql
titanic_select_example.sql		titanic_select_example.sql
where_clause_exercise.sql		where_clause_exercise.sql
where_clause_lesson_notes.sql		where_clause_lesson_notes.sql