SQL - The Query Writing Bootcamp [2019]

In this lesson we will CREATE our first sample Table in SQL.

In this lesson you will learn how to ALTER, UPDATE or DELTE a table.

CREATE Book Table Challange

In this video we will CREATE the Book table, the first table of our relational database.

CREATE Editor Table Challange

In this video we CREATE the Editor table. The second table in our relational database.

CREATE Rating Table Challange

In this video we create the Rating Table, the final table of our relational database. We connect the rating table to the Book and Editor table using the Primary Key and Foreign Key.

In this video, we learn how to load the database into the ORACLE Live SQL platform.

In this video we review how to CREATE Tables in SQL and link them together using Primary and Foreign Keys.

Introduction to query writing and using the SELECT statment. 

In this lesson we begin writing queries using SELECT FROM WHERE. Pratice 1 included at the end.

Practice 1: Solutions

In this lesson we will start using compariosn operators in the SELECT statement.

Practice 2: Comparison Operators Solution

In this lesson we begin writing queries using the AND operator.

Practice 3: AND Operator Soultions

In this lesson we will begin writing queries using the OR operator.

Practice 4: OR Operator Solutions

In this lesson we begin writing quesries using the NOT condition.

Practice 5: NOT Operator Solutions

In this lesson we begin writing queries using the BETWEEN condition.

Practice 6: BETWEEN Operator Solutions

In this lesson we begin writing queries using the LIKE condition.

Practice 7: LIKE Operator Solutions

Section 2: The SELECT Statement Conclusion

Introduction to Aggregate Functions.

In this lesson we learn how to use AVG in SQL to find the average of a value.

In this lesson we learn how to use COUNT to find the total of a value.

In this lesson we will learn how to find the MAX & MIN of a value.

In this lesson we will learn how to find the SUM of a value.

In this lesson we will being writing aggregate functions including the GROUP BY statement.

GROUP BY: Practice 9 Solutions

In this lesson we will being writing aggregate functions including the ORDER BY statement.

ORDER BY: Practice 10 Solutions

This video is an introduction to JOINS and the different types we can use to retrieve data from tow or more tables at a  time.

In this video we begin writing queries using JOIN's.

Practice 11: JOIN's Lesson One Solution

JOIN's Lesson Two: Practice 12 and Solutions.

JOIN's Lesson Three: Practice 13

JOIN's Lesson Three: Practice 13 Solutions

JOIN's Lesson Four: Practice 14

JOIN's Lesson Four: Practice 14 Solution - Query 1

JOIN's Lesson Four: Practice 14 Solution - Query 2

JOIN's Lesson Four: Practice 14 Solution - Query 3 and 4.

JOIN's Lesson Six: Practice 15

JOIN's Lesson Six: Practice 15 Solution - Query 1

JOIN's Lesson Six: Practice 15 Solution - Query 2

JOIN's Lesson Six: Practice 15 Solution - Query 3

JOIN's Lesson Six: Practice 15 Solution - Query 4

JOIN's Lesson Six: Practice 15 Solution - Query 5

In this video we learn how to use alias in our queries.

More practice using ALIASES.

In this lesson we learn how to use the concatenate 2 strings.

In this lesson we learn how to use the LENGTH function.

In this lesson we learn how to use SYSDATE. Please read the article at the provided link.

In this video, I provided you with information on how to access more sql and database practice provided by Oracle Live SQL.

Thank you for enrolling and completing this intro course to SQL and Relational Databases with me.