preview

Ells Unit 7

Decent Essays

During this week, I assessed the "Assignment Unit6", commented and gave the appropriate grade to the three colleagues' post. Then after, I read the entire reading topics assigned in "Learning Journal Unit 7", attempted "Self-Quiz Unit 7", took part in the "Discussion Forum Unit 7", rated and commented the three peer's post, and finally I submitted the "Assignment Unit 7".
Moreover, assessing "Assignment Unit 6" provided me the idea of completing the assignment in the correct way and where my colleagues and I myself go wrong while doing the assignment. The reading topics helped me to know about the Different SQL DML statements including querying with the SELECT statement with different keywords and operators such as DISTINCT, LIKE, IN, HAVING, ORDER BY, Joining the tables' data and so on. Furthermore, the Discussion Forum helped me to know more …show more content…

The use of the underscore ("_") in the LIKE operator to access the data if we don't know the character in between but we just know the first and last character(s) really surprised me the caused me the wonder. This caused me the wonder because I had never thought about this type of characteristics of the SQL statement for the DBMS.
The use of the current date in the "Assignment Unit 7" was particularly challenging to me because I had not read this function in the textbook till now whereas I solved it by searching the CURDATE() function the Google.
Mainly, I am gaining the skills and knowledge of writing different SQL DML to get the required result set. During this week, I learned the use of the different keywords and operators with SELECT statement to get the result set or output that we want. In addition, I also learned to retrieve the data by joining one or more

Get Access