We are 50% done with the course.

1. Understanding core database concepts — lots of theory
2. Creating database objects — next week
3. Manipulating data — what we have done in the past two weeks

We have covered various T-SQL functions for strings and numbers. For example, we covered a way to capitalize the first character of a-single-word field or variable (@word declared as a VARCHAR(10) and initialized as 'tImE', in the example below).

DECLARE @word VARCHAR(10) = 'tImE';

PRINT CONCAT (
    UPPER(LEFT(@word, 1)),
    LOWER(SUBSTRING(@word, 2, LEN(@word)-1))
    );

You can download the 845-page PDF from Microsoft Docs for much more information.

Download the class notes for day 5.