Course details
Students will learn what SQL is and how they can query a database to answer business questions.
Content
This course will cover the following concepts:
- Lesson 1: Introduction to databases and SQL
- Lesson 2: Introduction to the SELECT statement
- Lesson 3: 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
- Answer key
Prerequisites
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, and program files. Students should also be familiar with the components that make up the personal computer, including input, output, and storage devices.
A basic knowledge of concepts related to database structure and terminology, such as fields (or columns) and records (or rows) is helpful.
Updated on 08 November, 2015Course Location
About SureSkills Ltd
We have been growing our expertise, service offering and solution delivery for the past two decades. One of the largest IT training companies in Ireland, we deliver our global learning solutions worldwide against a backdrop of integrated learning and consulting experience. Our in-house expertise allows for synergy between our three divisions; training & certification, learning services and consulting and solutions.
See all SureSkills Ltd courses- JavaScript Full stack web developer virtual internship Virtual Bootcamp + Internship at LaimoonAED 1,449Duration: Upto 30 Hours
- SQL Database Management StudyHubEUR 12
EUR 235Duration: Upto 3 Hours - SQL – Master SQL Database Queries Course CentralEUR 22
EUR 126Duration: Upto 2 Hours
