Course details
This course, students will learn to use SQL as a tool to retrieve the information you need from databases.
Course Outline
1 - Executing a Simple Query
- Connect to the SQL Database
- Query a Database
- Save a Query
- Modify a Query
2 - Performing a Conditional Search
- Search Using One or More Conditions
- Search for a Range of Values and NULL Values
- Search Data Based on Patterns
3 - Working with Functions
- Perform Date Calculations
- Calculate Data Using Aggregate Functions
- Manipulate String Values
4 - Organizing Data
- Sort Data
- Rank Data
- Group Data
- Filter Grouped Data
- Summarize Grouped Data
- Use PIVOT and UNPIVOT Operators
5 - Retrieving Data from Tables
- Combine Results of Two Queries
- Compare the Results of Two Queries
- Retrieve Data by Joining Tables
6 - Exporting Query Results
- Generate a Text File
- Generate an XML File
Target Audience: This course is intended for inpiduals with basic computer skills, familiar with concepts related to database structure and terminology, and who want to use SQL to query databases.
Updated on 08 November, 2015Course Location
About New Horizons Ireland
With a very convenient location next to Jervis street in Dublin 1, we offer a wide range of IT and business skills courses and we can also send our instructors to your location.
We are 100% Irish owned, but we are also part of the largest independent IT Training Provider, New Horizons Computer Learning Centres who deliver more courses than any other IT training company.
Because we're local, we understand the needs of business and individuals in our community. Whether you choose to take classes in person or online, you're always welcome to call or stop by.
See all New Horizons Ireland courses- JavaScript Full stack web developer virtual internship Virtual Bootcamp + Internship at LaimoonAED 1,449Duration: Upto 30 Hours
- SQL Database Administrator StudyHubEUR 13
EUR 248Duration: Upto 8 Hours - SQL Programming Complete Bundle NextGen LearningEUR 52Duration: Upto 20 Hours
