Flexible learning
Online postgraduate courses
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.
-203.jpg)
- 10 Credits
- 100 hours of study
- 15 contact hours
- 85 hours for private study
Faculty
Structure
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.
SQL
Module Programme
Introduction
- Overview of the Course Content and Structure
- Learning with this Course
Basic Concepts
- Relations and Tuples
- Keys, Dependencies, and Normalization
- Two Examples of Normalized Schemas
Algebraic Language
- Algebra Operators
- Algebraic Expressions
SQL, Summary
- Designing an SQL Query
- Select-From-Where Block
- Queries and Sub-Queries
- Aggregates, Updates, Views
Database Design
- Normalization
- Entity-Relationship Model
- Advanced Concepts• From E/R Schema to Relational Schema
NoSQL and Non-Relational Databases
- The basics of NoSQL and non-relational databases
- The differences between SQL and NoSQL databases
- Querying data in NoSQL databases
- Introduction to popular NoSQL databases, such as MongoDB and Cassandra
Prerequisites
English Language Requirements
Both Programmes are open to applicants anywhere in the world. We may ask applicants to provide a recognised English language qualification, dependent upon their nationality and where they have studied/worked previously.
The requirement is an IELTS (Academic) Test with an overall score of at least 6.5, and a minimum of 6.0 in each element of the test. We will also consider other English language qualifications. If their score is below our requirements, they may be eligible for one of Lancaster University's pre-sessional English language programmes.
Academic Requirements
Applicants to the Postgraduate Certificate of Achievement, Postgraduate Certificate, Postgraduate Diploma or full MSc in either programme require either an upper second-class degree in economics, econometrics or related subjects.
Learning Outcomes
- 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 scienceprojects
- 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 andNoSQL
- Data Science Application: Applying SQL and NoSQL skills to enhance data science projects
- Understand the basics of database design and management
- Design and implement SQL and NoSQL databases that are efficient, scalable, andmaintainable
- Use common SQL and NoSQL databases, such as MySQL, PostgreSQL, and MongoDB
- Query and manipulate data in SQL and NoSQL databases
- Communicate effectively about database concepts and techniques.
Frequently Asked Questions
All sessions are conducted live and online at a scheduled time, but are also recorded. Students may attend live and watch the recordings back to recap the material or watch the recordings only if unable to attend live. We always advise students to attend live where possible as this will allow them the best opportunity to engage with the content and ask the lecturer's questions.
All modules are examined through online coursework submissions, you will have the support of your module lecturer/tutor in this poccess.
No, all necessary software is provided to students.
All courses are recorded and available on the LUMS internet platform throughout the current academic year. They can therefore be viewed 24 hours a day.
Timberlake Consultants and Lancaster University Management School (LUMS) Economics department have a longstanding partnership; combining 40+ years of industry expertise with over 50 years of academic excellence. We are delighted to build on this with our micro-credential postgraduate courses.
Flexible learning
Online postgraduate courses
Specialist courses
Best-in-field experts
Tailored learning
Career-oriented education
Subscribe To Our Newsletter
Flexible learning
Online postgraduate courses
Specialist courses
Best-in-field experts
Tailored learning
Career-oriented education