An in depth knowledge of an SQL Relational Database Management System (RDBMS) and of Structured Query Language (SQL) are not just vital skills required by Database Developers and Administrators but are also indispensable tools needed by the modern Software Developer, Data Analyst and Data Scientist. On this course you will learn to create, manage and query relational databases using SQL.
Learning modes and locations may be different depending on the course start date. Please check the location of your chosen course and read our guide to learning modes and locations to help you choose the right course for you.
Please note: We offer a wide variety of financial support to make courses affordable. Just visit our online Help Centre for more information on a range of topics including fees, online learning and FAQs.
Using the free version of Microsoft SQL Server, one of the top 3 Relational Database Management Systems used by 98 of the Fortune 100 companies we will cover all the necessary skills to build, maintain and interrogate a relational database system.
Participants who will attend the full course will receive a City Lit certificate of attendance electronically for their CV or CPD records. The certificate will show your name, course title and dates of the course you have attended.
What will we cover?
The fundamental building block of a relational database is the table. We will use SQL to produce a series of tables and link them to build an efficient storage system for our data that avoids data duplication and redundancy. We will also learn how to maintain data once stored in our database using the Data Manipulation Language components of SQL.
Finally, we will learn how to interrogate our database, an activity central to nearly all organisations, to carry out mission critical tasks such as inventory management, order processing, tracking and booking amongst many others. We also need these skill to for the business intelligence process, data science and analysis.
What will I achieve? By the end of this course you should be able to...
• Define key terminology and concepts related to all RDBMS • Use the Data Definition Language commands in SQL to create a series of linked database tables that can store data of various data types • Use the Data Manipulation Language commands in SQL to add, update and delete data stored across related tables • Use the Data Query Language commands in SQL to interrogate our data, including using:- • Join operations • Logical and comparison operations • Fuzzy Search • The Null operator • Date functions • Created aliases and calculated fields with the data in our tables • Format currency and dates.
What level is the course and do I need any particular skills?
Though the course does not require any previous knowledge of SQL or Relational Database Management Systems it is quite fast paced and you will not only need good computing skills and a high level of typing accuracy, but would also benefit from having some experience in coding, (it doesn’t matter which language), such as having attended one of our many Python or HTML and CSS courses. If you haven’t coded before you might consider our Beginner's Guide to SQL course first as an introduction to the topic.
You should also be able to follow spoken instructions, read written instructions and information, and discuss work with your tutor in English.
How will I be taught, and will there be any work outside the class?
There will be some theoretical underpinning to the course, but it is nearly all practical, through tutor demonstration and practical programming and problem solving activities. There is no official work set outside the class but it is a good idea to practise the skills you have learnt to reinforce classroom learning.
Are there any other costs? Is there anything I need to bring?
There are no additional costs. Computers with all software installations will be provided in classroom. Please note that Microsoft SQL Server runs on Windows only; you will need access to a computer that can run it at home if you wish to practice outside class time.
When I've finished, what course can I do next?
City Lit offers a variety of progression courses in this subject area. Please click here to view our Programming courses. Disclaimer: Use of Third-Party Software This course might require you to either use your own personal account or create an account for the purposes of this course. City Lit cannot accept any responsibility for any failings of the third party or provide technical support. Whilst using the software you will be responsible for abiding by the providers terms and conditions and maintaining your own work.
Sathish Boini is a cloud security expert and passionate educator who brings technology to life for his students. With an MSc in Cyber Security from the University of the West of England, he blends hands-on expertise in AWS, cybersecurity, and programming with a teaching style that simplifies even the most complex concepts. Known for his ability to turn technical challenges into engaging lessons, Sathish has helped many students gain industry certifications and confidence in their skills. An entrepreneur at heart, he founded Pikiza, a platform connecting photographers and clients, where he learned the ins and outs of building secure, scalable applications. With certifications like AWS Solutions Architect, Sathish’s mission is to make technology accessible to all, empowering learners from all backgrounds to thrive in the digital world. For him, teaching isn’t just about sharing knowledge—it’s about unlocking potential and building future-ready skills.
Please note: We reserve the right to change our tutors from those advertised. This happens rarely, but if it does, we are unable to refund fees due to this. Our tutors may have different teaching styles; however we guarantee a consistent quality of teaching in all our courses.
product
https://www.citylit.ac.uk/introduction-to-sql-and-microsoft-sql-server1171960Introduction to SQL and Microsoft SQL Serverhttps://www.citylit.ac.uk/media/catalog/product/s/q/sql-course.jpg279279GBPInStock/Courses/Courses/Business, marketing & technology/Courses/Business, marketing & technology/Web design and programming/Programming/Courses/Business, marketing & technology/Web design and programming22851211140816871228512111687An in depth knowledge of an SQL Relational Database Management System (RDBMS) and of Structured Query Language (SQL) are not just vital skills required by Database Developers and Administrators but are also indispensable tools needed by the modern Software Developer, Data Analyst and Data Scientist. On this course you will learn to create, manage and query relational databases using SQL.002586100Introduction to SQL and Microsoft SQL Server279279https://www.citylit.ac.uk/media/catalog/product/s/q/sql-course_24.jpgInStockDaytimeSatKeeley StreetAvailable courses1 to 4 weeksWeekend2026-01-24T00:00:00+00:00Beginners, Some experienceJan 2026Business, marketing & technologyCMSQL07279279Introduction to SQL and Microsoft SQL Server223181279Sathish Boiniintroduction-to-sql-and-microsoft-sql-server/cmsql07-2526An in depth knowledge of an SQL Relational Database Management System (RDBMS) and of Structured Query Language (SQL) are not just vital skills required by Database Developers and Administrators but are also indispensable tools needed by the modern Software Developer, Data Analyst and Data Scientist. On this course you will learn to create, manage and query relational databases using SQL.0000-Available|2026-01-24 00:00:00Using the free version of Microsoft SQL Server, one of the top 3 Relational Database Management Systems used by 98 of the Fortune 100 companies we will cover all the necessary skills to build, maintain and interrogate a relational database system.<br/><br/>Participants who will attend the full course will receive a City Lit certificate of attendance electronically for their CV or CPD records. The certificate will show your name, course title and dates of the course you have attended.An in depth knowledge of an SQL Relational Database Management System (RDBMS) and of Structured Query Language (SQL) are not just vital skills required by Database Developers and Administrators but are also indispensable tools needed by the modern Software Developer, Data Analyst and Data Scientist. On this course you will learn to create, manage and query relational databases using SQL.The fundamental building block of a relational database is the table. We will use SQL to produce a series of tables and link them to build an efficient storage system for our data that avoids data duplication and redundancy. We will also learn how to maintain data once stored in our database using the Data Manipulation Language components of SQL.<br/><br/>Finally, we will learn how to interrogate our database, an activity central to nearly all organisations, to carry out mission critical tasks such as inventory management, order processing, tracking and booking amongst many others. We also need these skill to for the business intelligence process, data science and analysis.• Define key terminology and concepts related to all RDBMS<br/>• Use the Data Definition Language commands in SQL to create a series of linked database tables that can store data of various data types<br/>• Use the Data Manipulation Language commands in SQL to add, update and delete data stored across related tables<br/>• Use the Data Query Language commands in SQL to interrogate our data, including using:-<br/>• Join operations<br/>• Logical and comparison operations<br/>• Fuzzy Search<br/>• The Null operator<br/>• Date functions<br/>• Created aliases and calculated fields with the data in our tables<br/>• Format currency and dates.Though the course does not require any previous knowledge of SQL or Relational Database Management Systems it is quite fast paced and you will not only need good computing skills and a high level of typing accuracy, but would also benefit from having some experience in coding, (it doesn’t matter which language), such as having attended one of our many Python or HTML and CSS courses. If you haven’t coded before you might consider our Beginner's Guide to SQL course first as an introduction to the topic.<br/><br/>You should also be able to follow spoken instructions, read written instructions and information, and discuss work with your tutor in English.There will be some theoretical underpinning to the course, but it is nearly all practical, through tutor demonstration and practical programming and problem solving activities. There is no official work set outside the class but it is a good idea to practise the skills you have learnt to reinforce classroom learning.There are no additional costs. Computers with all software installations will be provided in classroom. Please note that Microsoft SQL Server runs on Windows only; you will need access to a computer that can run it at home if you wish to practice outside class time.<p>City Lit offers a variety of progression courses in this subject area. Please click <a href="https://www.citylit.ac.uk/media/wysiwyg/pdf/Web_Programming_Courses.pdf"> here </a> to view our Programming courses.<br/>Disclaimer: Use of Third-Party Software<br/>This course might require you to either use your own personal account or create an account for the purposes of this course. City Lit cannot accept any responsibility for any failings of the third party or provide technical support. Whilst using the software you will be responsible for abiding by the providers terms and conditions and maintaining your own work.</p>Web design and programmingProgrammingvirtual223279181CMSQL07NONESat24/01/26 - 31/01/2610:00 - 17:0010:0017:002 sessions (over 2 weeks)21 to 4 weeksDaytimeWeekendKSKeeley StreetSathish BoiniBeginners, Some experienceAvailable courses2026-01-24T00:00:00+00:00Jan 2026Business, marketing & technology279279Introduction to SQL and Microsoft SQL Serverintroduction-to-sql-and-microsoft-sql-server/cmsql07-2526An in depth knowledge of an SQL Relational Database Management System (RDBMS) and of Structured Query Language (SQL) are not just vital skills required by Database Developers and Administrators but are also indispensable tools needed by the modern Software Developer, Data Analyst and Data Scientist. On this course you will learn to create, manage and query relational databases using SQL.0000-Available|2026-01-24 00:00:00Using the free version of Microsoft SQL Server, one of the top 3 Relational Database Management Systems used by 98 of the Fortune 100 companies we will cover all the necessary skills to build, maintain and interrogate a relational database system.<br/><br/>Participants who will attend the full course will receive a City Lit certificate of attendance electronically for their CV or CPD records. The certificate will show your name, course title and dates of the course you have attended.An in depth knowledge of an SQL Relational Database Management System (RDBMS) and of Structured Query Language (SQL) are not just vital skills required by Database Developers and Administrators but are also indispensable tools needed by the modern Software Developer, Data Analyst and Data Scientist. On this course you will learn to create, manage and query relational databases using SQL.The fundamental building block of a relational database is the table. We will use SQL to produce a series of tables and link them to build an efficient storage system for our data that avoids data duplication and redundancy. We will also learn how to maintain data once stored in our database using the Data Manipulation Language components of SQL.<br/><br/>Finally, we will learn how to interrogate our database, an activity central to nearly all organisations, to carry out mission critical tasks such as inventory management, order processing, tracking and booking amongst many others. We also need these skill to for the business intelligence process, data science and analysis.• Define key terminology and concepts related to all RDBMS<br/>• Use the Data Definition Language commands in SQL to create a series of linked database tables that can store data of various data types<br/>• Use the Data Manipulation Language commands in SQL to add, update and delete data stored across related tables<br/>• Use the Data Query Language commands in SQL to interrogate our data, including using:-<br/>• Join operations<br/>• Logical and comparison operations<br/>• Fuzzy Search<br/>• The Null operator<br/>• Date functions<br/>• Created aliases and calculated fields with the data in our tables<br/>• Format currency and dates.Though the course does not require any previous knowledge of SQL or Relational Database Management Systems it is quite fast paced and you will not only need good computing skills and a high level of typing accuracy, but would also benefit from having some experience in coding, (it doesn’t matter which language), such as having attended one of our many Python or HTML and CSS courses. If you haven’t coded before you might consider our Beginner's Guide to SQL course first as an introduction to the topic.<br/><br/>You should also be able to follow spoken instructions, read written instructions and information, and discuss work with your tutor in English.There will be some theoretical underpinning to the course, but it is nearly all practical, through tutor demonstration and practical programming and problem solving activities. There is no official work set outside the class but it is a good idea to practise the skills you have learnt to reinforce classroom learning.There are no additional costs. Computers with all software installations will be provided in classroom. Please note that Microsoft SQL Server runs on Windows only; you will need access to a computer that can run it at home if you wish to practice outside class time.<p>City Lit offers a variety of progression courses in this subject area. Please click <a href="https://www.citylit.ac.uk/media/wysiwyg/pdf/Web_Programming_Courses.pdf"> here </a> to view our Programming courses.<br/>Disclaimer: Use of Third-Party Software<br/>This course might require you to either use your own personal account or create an account for the purposes of this course. City Lit cannot accept any responsibility for any failings of the third party or provide technical support. Whilst using the software you will be responsible for abiding by the providers terms and conditions and maintaining your own work.</p>Web design and programmingProgrammingconfigurable
14081687Programminghttps://www.citylit.ac.uk/courses/technology-science-and-business/web-design-and-programming/programming1/2/285/1211/1687/14081/Courses/Business, marketing & technology/Web design and programming/Programming
