PrintPrint

Introduction to SQL and Data Science
B01275

This course may be delivered online - please see the course information box to confirm.

Data Science is concerned with extracting knowledge and insights from computer data. This might be structured data, like sales and customer information collected by a business and stored in a database, or unstructured data, like customer feedback or social media comments.
SQL is the standard language for storing and manipulating structured data and is used by millions of businesses around the world. The course will first look at the use of SQL for data analysis and then move on to looking at other tools and techniques for adding unstructured data into the mix of information available for decision making.
Students for this course should be competent computer users and have an interest in learning how to collect and manipulate data to extract useful information.

Course Content

you will learn how to:

* Be able to set up, manage and edit data tables using SQL.
* Query a database using Structured Query Language
(SQL) statements to retrieve records from a single table.
* Be able to sort, group and summarise records and make simple reports using SQL
* Learn how to import and export data from SQL
* Learn about how you can integrate SQL with other applications
such as websites or desktop applications.

Entry Requirements

To be eligible for this course you must be 19 or over on the start date of the course.

Additional Information

As a result of the government’s closure of schools and colleges, some of our courses will be delivered through remote learning including video conferencing, (using Skype, Zoom, Microsoft Teams) and email contact with your tutor.

If your course is indicated as an ONLINE COURSE, you will need either a PC (with a camera and microphone), laptop, tablet, smartphone and access to the internet to be able to join the lessons. Lessons will run at the published time – so be ready and set up to join in.

We hope you will enjoy this new approach to learning – many of our learners have commented on how they are enjoying the classes and have improved their IT and digital skills in the process.

Please don't worry if some of this is new to you - you are not alone! See here for guidance on how to use our simple software. If you are experiencing any problems with connection or installing software for your online class please contact our learning resource team on lrc@rhacc.ac.uk. We are here to help you.

If you require further course information or advice & guidance that is not answered in this outline, please email rbs@racc.ac.uk