Data is everywhere. In fact, it is at the heart of newer disciplines such as Data Science and Data Analysis. Data is often organized in tables containing rows and columns.
In this course, you will learn how to manipulate those tables using relational algebra operators, and apply these theoretical concepts to a very common language, SQL(Structured Query Language), which is used to interact with… relational databases!
This course will enable you to formalize the concepts you use naturally in SQL, so that you can apply them to other languages (such as Python or R). It will also offer tips on using SQL to build increasingly complex queries.
By the end of this course, you will be able to:
Represent data with the relational model
Manipulate data using relational algebra operations
Apply relational algebra operations using SQL
Write simple and advanced SQL queries
HOW DOES IT WORK?
Part #1 - Represent data using the relational model
Part #2 - Manipulate data using relational algebra operations
Part #3 - Execute simple SQL queries
Part #4 - Execute advanced SELECT Queries
Familiarity with variable types (whole number integer: decimal, float, character string, Boolean, date).
Certificate of Attendance
This course is offered to anyone in the world, but its qualification is only relevant in this country.
No attendance for this course
Total time for completion:
No time limit
This course currently has no reviews.Write a review
City, University of London(City of London – EC1V 0HB)
London Academy of IT(London – E15 1NT)
PCWorkshops(MANCHESTER – M1 5AN)