MOC 50464 Understanding and Querying Relational Data for Information Workers Using Microsoft SQL Ser

PT7738
Training Summary
This course provides students with the knowledge and skills to query data using Microsoft SQL Server. The course will introduce the concepts of relation databases and how to retrieve, modify, and use SQL Server data.
Prerequisites
Before attending this course, students must have: -Basic knowledge of Windows operating Systems.-Understand the concepts of storing data on a network.-Basic understanding of Microsoft Office Applications.
Duration
2 Days/Lecture & Lab
Audience
This course is intended for Information Workers who need to use SQL Server data for client applications such as reporting.
Course Topics
  • Understanding Relational Databases
  • Retrieving Simple Data
  • Complex Data Retrieval
  • Summarizing Data
  • Modifying Data
  • Using Database Objects
  • Advanced Queries
  • Accessing Data with Microsoft Office 2007

Related Scheduled Courses

MOC 55315 AC Introduction to SQL Databases
MOC 55316AC Administering a SQL Database
MOC 55321AC SQL Server Integration Services
MOC 55366AC Querying Microsoft SQL Server with Transact-SQL