Share:
Take Concept 2 Quiz »
Intro to SQL/MySQL
Chapter
-
Chapter 1
This chapter will focus on explaining what SQL is and why is it used. Then it will talk about using the query browser to connect to the MySQL database and creating a table. This chapter does not cover the setting up of a database server as that is a technical topic beyond the scope of the intended audience for this course.
Estimated time: ~19 Minutes -
Chapter 2
This chapter will provide an introduction to the basic MySQL commands like SELECT, DISTINCT, WHERE, logical operators, ORDER BY, INSERT, UPDATE and DELETE
Estimated time: ~56 Minutes -
Chapter 3
MySQL Functions
Estimated time: ~22 Minutes -
Chapter 4
This chapter covers some pre-requisites which are necessary to master in order to extract data from multiple tables. Graduating MySQL high school and entering college
Estimated time: ~15 Minutes -
Chapter 5
This chapter aims to cover MySQL joins and how can they be used to extract data from multiple joins
Estimated time: ~62 Minutes -
Locked
You must complete all chapters before taking the course exam.
Concept
-
1
Concept 1
This is the term used to define a table column name which can uniquely identify a row.
Estimated time: ~5 Minutes -
2
Concept 2
When you have column(s) in a table where it is used as a primary key in another table, then that key is called a foreign key in the former.
Estimated time: ~7 Minutes
Concept 2: Foreign Key
When you have column(s) in a table where it is used as a primary key in another table, then that key is called a foreign key in the former.
edit
You are making progress towards completing chapter 4 and unlocking the Advanced MySQL Badge
This badge is worth: 50 Points
Ask a Question
You must be logged in to post or rate a comment.
Questions & Answers
No one has said anything yet!
Start the discussion by asking a question.
Quiz Questions
Concept 2: Foreign Key
- A table cannot have multiple foreign keys, and each foreign key cannot have a different referenced table.