Applied SQL Fundamentals

Applied SQL Fundamentals

SQL Server is the most deployed and popular database today. Different types of users need to query data stored in SQL Server data structures. This 2-day instructor led course provides you with the necessary skills to query Microsoft SQL Server databases with Transact-SQL. This course starts with the basics of a SELECT statement and its syntax, and progresses to teach you how to join, aggregate, and convert data. This course is perfect for developers who need to query SQL Server databases to retrieve data, from complete beginners through to more experienced developers who can use some of the modules as reference material. It will benefit novice Database Administrators, Database Developers, and Business Intelligence professionals. It will also benefit SQL power users who need to create SQL queries, including report writers, data analysts, and client application developers.

Audience

  • Novice database developers
  • BI developers
  • Power users

Prerequisites

  • Basic experience with databases, such as Microsoft Access
  • Ideally, basic experience with SQL Server

Hardware and software requirements

  • Windows 7 or above
  • A SQL Server instance (installed locally on a shared server)
  • AdventureWorks and AdventureWorksDW databases
  • SQL Server Management Studio installed on student’s laptop