Introduction to SQL and Microsoft SQL Server

Course Dates: 29/02/20 - 07/03/20
Time: 10:00 - 17:00
Location: KS - Keeley Street
Tutors:

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.

Description

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.

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 Teacher 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?

Computers are provided for each student with all the necessary software installed. All the software used on the course is free to download and use and your tutor will recommend where to find this software for home use. Unfortunately due to the range of hardware and software used by students at home, the College is unable to provide advice on installation issues.

If you wish to copy the programs you produce on the course please bring a USB key or have access to a cloud service such as Google Drive or Dropbox. A pen and notepad for note taking is also advised.

When I've finished, what course can I do next?

You might be interested in learning a programming language such as Python, R, C++ or C#.

Reviews

Customer Reviews 5 item(s)

Write a review

Reviews below are by students who have attended this course, regardless of the course teacher. Please be aware you may not be booking onto a course with the same teacher.

Great course, useful and covers (what I think!) is a lot, especially as I am a total beginner with zero prior knowledge.
Course Rating
Review by Anonymous / (Posted on 14/12/2019)
go for it!
Course Rating
Review by Anonymous / (Posted on 14/12/2019)
Excellent course taught by a very experienced, supportive and knowledgeable tutor.
Course Rating
Review by Anonymous / (Posted on 08/10/2019)
Excellent course and very knowledgeable teacher. The teacher was very supportive throughout the course.
Course Rating
Review by Anonymous / (Posted on 10/03/2019)
I would encourage you to go on the course.
Course Rating
Review by Anonymous / (Posted on 14/12/2018)
Tutor Biographies
Rich Cochrane

Rich is a programmer, writer and educator with a particular interest in creative practice. In his previous career he worked as a software developer in the CIty, first at a dot-com startup and later at a top-tier investment bank where he worked mostly on trading floor systems and got to play with a wide range of languages and technologies. He now teaches coding and maths-related courses full time. Besides his work at City Lit he also teaches at Central Saint Martins, the Architecture Association and the Photographer's Gallery and is the author of two books about mathematics. His technical collaborations with artists have been shown at, among others, the Hayward gallery, the V&A, the ICA and Camden Arts Centre. He has a BSc in Mathematics from the Open University. He also has a BA in English Literature and a PhD in philosophy (both from Cardiff). He continues to teach a little philosophy and literature, especially as they intersect with his other interests, and as a partner in Minimum Labyrinth he has brought these ideas to wider audiences in collaboration with the Museum of London, the Barbican and various private sponsors.

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.

Book your place

Course Code: CMSQL02

Please choose a course date 

Sat, day, 29 Feb - 07 Mar '20

Duration: 2 sessions (over 2 weeks)

Full fee: £219.00
Senior fee: £219.00
Concession: £219.00

Or call to enrol: 020 7831 7831

Download form & post

Any questions? computing@citylit.ac.uk
or call 020 7492 2515

Please note: we offer a wide variety of financial support to make courses affordable. For more information visit our online Help Center. You can also visit the Information, Advice and Guidance drop-in service, open from 12 – 6.45, Monday to Friday.