SQL-NoSQL
This course provides an introduction to SQL and NoSQL databases. The course clarifies differences between SQL and NoSQL databases and covers the principles of database design and management, including data modelling, normalisation, and indexing. Further, it introduces popular SQL and NoSQL databases, such as MySQL, PostgreSQL, and MongoDB.
​
This module can be taken as part of a PG Certificate, PG Diploma or Full Masters Program.
Key Skills
By the end of this course, participants should have some knowledge and understanding of:
SQL Proficiency: Ability to query and manipulate data using SQL.
​
NoSQL Competence: Proficiency in utilising NoSQL for data manipulation.
Data Querying Skills: Skills to effectively retrieve and manipulate data in data science projects.
​
Confident SQL and NoSQL Use: Confidence and experience in using both SQL and NoSQL.
Database Management: Managing databases efficiently for data science applications.
​
Practical Experience: Hands-on experience in applying SQL and NoSQL to real-world projects.
Data Manipulation Expertise: Expertise in manipulating and organising data using SQL and NoSQL.
​
Data Science Application: Applying SQL and NoSQL skills to enhance data science projects.
Desired Skills
By the end of this course, students should be able to:
Understand the basics of database design and management.
​
Communicate effectively about database concepts and techniques.
Design and implement SQL and NoSQL databases that are efficient, scalable, and maintainable.
Use common SQL and NoSQL databases, such as MySQL, PostgreSQL, and MongoDB.
Query and manipulate data in SQL and NoSQL databases.
Structure
SQL-NoSQL is an elective 10 credit course and therefore students are expected to input approximately 100 hours of study into the course.
The total number of contact hours is 15 hours. This leaves 85 hours for private study.
​
Lectures
This module consists of 2 - hour lectures per day for 5 days, plus a 1 - hour tutorial per day.
​
There will be optional clinics on the last day of the course.
​
The dates of each lecture are confirmed closer to the start of each term. If you have any questions about dates, please contact edu@timberlake.co.uk.