Relational Databases & SQL

Course Type: Training Course

This beginner-level SQL course works through why and when to use SQL across the Software Development Lifecycle. Focus is spent on basic commands and works through how queries may behave differently. Fundamentals such as tables, columns, primary keys, foreign keys, and conditions are all covered.

Objectives

  • To understand why SQL matters in an organization and how SQL can be used across various technology roles

  • To learn how to write SQL code based on ANSI/ISO standards to build database structures

  • To learn how to write queries that support building reports, performing calculations, and manipulating data

Content

  • What is SQL and Why it Matters

  • Basic SQL Coding

  • Building Database Schema and Querying Tables

  • Stored Procedures, Triggers, and Views