Close

SQL Fundamentals of Querying

  • 18th July 2022
    9:30 am - 5:00 pm

Course duration: 1 day

Additional notes for course:

Venue:  

Not a member? Find out if your company is eligible here

Aims and objectives

Students will learn what SQL is and how they can query a database to answer business questions.

Who should attend

Students enrolling in this course should understand the basic concepts involved in working with a personal computer (PC). For example students should be familiar with such terms as computer memory, data files. Students should also be familiar with the components that make up the personal Computer, Including input, output and storage devices.

Course content

This course will Cover the following topics:

  • Lesson 1: Introduction to databases and SQL
  • Lesson 2: Introduction to the SELECT statement
  • Lesson3: Calculating data
  • Lesson 4: Selecting specific rows
  • Lesson 5: Working with other operators
  • Lesson 6: Grouping data
  • Lesson 7: Multi-table queries
  • Lesson 8: Other SQL Front-end applications Appendices
  • The Sample database

Skills learned

On completion of this course Students will have learned the basic functions of SQL and how to query a database.

Ready to begin?

Are you an organisation in the private sector (including commercial state and semi-state companies) if so, click on the link below to avail of free membership to access our subsidised training courses. Or are you employeed in one of the above organisations and would like to see what training we can offer via your employeer. Click on the link to explore our courses. Click on the link to explore our courses.

BECOME A MEMBER
FIND A COURSE

What they are saying

The trainer on the Resilient Mind at Work course was absolutely brilliant, 10/10. Every aspect was beneficial. Learning how to cope with stress and coping mechanisms. A very interesting subject that is important for everyone in both personal and professional life.
The Lean Six Sigma course was excellent overall and brilliantly delivered. I will use the tools, methodology and mindset in work' The introduction of lean thinking and mindset with an aim to reduce waste and increase efficiency was most useful.
The Interviewer Skills course was great. I know how to go about giving feedback to unsuccessful applicants. I am new in my role and now have better practice and processes to follow. Excellent trainer - loads of examples and relevant experience. Very engaging. The knowledge I gained from today will help me form a more structured interview going forward.
Previous
Next