If you have access to company databases and your job requires you to retrieve data from those databases, retrieval of information from a database is dependent on precisely ordered logic and specific information. This instructor-led course will help you to use Structured Query Language (SQL) as a tool to implement that logic and define instructions.
AudienceIndividuals with basic computer skills, familiar with concepts related to database structure and terminology, and who want to use SQL to query databases.
Prerequisites
Basic end-user computer skills and some familiarity with database terminology and structure are required.
Learning Objectives
Upon successful completion of this course, students will be able to:
- Connect to the SQL Server database and execute a simple query.
- Include a search condition in a simple query.
- Use various functions to perform calculations on data.
- Organize data obtained from a query before it is displayed on-screen.
- Retrieve data from tables.
- Format an output, save a result, and generate a report.