Basic Querying and Programming in SQL Server

Rating:
1 vote, average: 5.00 out of 51 vote, average: 5.00 out of 51 vote, average: 5.00 out of 51 vote, average: 5.00 out of 51 vote, average: 5.00 out of 5
Loading...
Please Log in or register to rate

Basic Querying and Programming in SQL Server

DB-205

This course introduces SQL Server to people who are new to this environment and need to query SQL Server databases. In this course, students will get to know the various client tools available in SQL Server, and how to work with them efficiently. The students will also learn how to write Transact-SQL queries against tables and other objects in SQL Server, for various purposes: reporting, testing, data analysis, and more.

The course includes a lot of exercises, so that the students will be able to experience what they learn. At the end of this course the students will be able to work in a SQL Server environment and write efficient queries against database objects.

The course is based on SQL Server 2014, but it is relevant also for SQL Server 2005/2008/2012.

Audience

The course is intended for inexperienced database users, who are required to use databases in their daily work, mainly for data reporting and analysis scenarios.

The course is relevant for data analysts, data testers, secondlevel support engineers, and other personnel who are using databases. No previous knowledge or experience is required.

Course Objectives
  • Introduce Microsoft SQL Server
  • Become familiar with the various client tools available in SQL Server
  • Learn to write Transact-SQL queries against tables and other objects in SQL Server
  • Discover the various programming objects in SQL Server
Course Topics
  • Course Introduction
  • Introduction to Microsoft SQL Server
  • The SELECT statement
  • Advanced Querying
  • Modifying Data
  • Introduction to Programming Objects
  • Summary
© Copyright - Skilit - Site by Dweb