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.
What Is The Course About?
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.
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.
At City Lit, we pride ourselves on creating opportunities for people to come together to enrich their lives through learning.
Central to everything we do are our values.
Open-hearted
Imaginative
Ambitious
City Lit is the ultimate destination for online and class-room based adult courses, from part-time short courses and one-off workshops to year-long programmes.
We offer an array of courses across a massive range of subject areas including art and design, music, dance, history, writing, computing, massage, languages and much more.
Ofsted inspectors rated City Lit as an Outstanding provider following inspection in May 2023. This is a great achievement which we are proud of as a college.
Since 2020 many of our courses are available through online learning and we've expanded our reach, nationally and internationally. Our online courses are live, interactive and usually delivered in small groups. Read our guide to online learning for more information. Onsite courses are delivered at our world class locations in London's buzzing Covent Garden.
Our flagship building in Keeley Street hosts a range of purpose built facilities including our Digital and Design Lab and Lunch Room to help you get the most out of your studies and time at City Lit. Studying at one of our other sites? Don’t worry, you can still benefit from the facilities and resources at Keeley Street.
Our courses are taught by expert tutors, many of whom are industry professionals looking to pass on their knowledge and wisdom.
The Introduction to MySQL course covers the basics of the SQL language as implemented by MySQL. The course is designed to give delegates practical experience in writing SQL statements using the mysql client program and MySQL Workbench.
The Introduction to SQL course is intended to teach you the fundamentals of databases and the basics of SQL. The 1 day SQL training certification is aimed for anyone who is interested in databases and wants to learn SQL.
This is a database specialist package designed to give you enhanced knowledge and understanding of the various softwares and applications for database management.
This SQL training course is designed for students new to writing SQL queries. A typical student will need to learn SQL to build applications or to generate business reports. For the most part, the SQL learned in the course is applicable to all major databases.
The course helps the delegates in their initial step towards becoming an Oracle Database Administrator. The Oracle course is designed for the candidates who want to learn about installing and managing an Oracle Database.
© 2025 coursetakers.com All Rights Reserved. Terms and Conditions of use | Privacy Policy