Are you interested in being part of the wider roll out for Spark, our new AI-powered, learning chatbot? Register your interest here.

Home Specialist skills Technology and Software Introduction to SQL Programming

Introduction to SQL Programming

Formulate and execute basic SQL queries to select, filter, sort, and aggregate data from single table
Join and relate data across multiple tables using inner and outer joins to combine information meaningfully
Create and manipulate database objects including tables, views, indexes, and constraints, to structure and maintain relational databases
Use basic data definition and manipulation statements such as CREATE, INSERT, UPDATE & DELETE to effectively manage and maintain data.

Overview

Off the shelf (OTS)

The Introduction to SQL Course is designed to provide an introduction to the SQL programming language, which is the standard language for relational database management systems. The course covers the basics of SQL, including creating tables, manipulating data, and querying databases. Students who complete the course will be equipped to write SQL queries, work with Microsoft SQL Server or PostgreSQL.

The course is suitable for beginners with no prior experience in SQL or database management, as well as professionals who want to refresh their skills. Overall, the Introduction to SQL Course is an excellent starting point for anyone looking to learn SQL and become proficient in database management and data engineering.

In this course, you will learn how to:
• Write SQL code based on Wrap in ANSI/ISO standards to build database structures.
• Update database content with SQL and transaction handling.
• Retrieve data with filter conditions and from multiple tables using various types of joins.
• Process data with row and aggregate functions.
• Leverage continued support with after-course one-on-one instructor coaching and computing sandbox.

There are no prerequisites.

Course Outline:
Module 1: SQL Overview
Module 2: Building the Database Schema
Module 3: Manipulating Data
Module 4: Working with the SELECT Statement
Module 5: Querying Multiple Tables
Module 6: Employing Functions in Data Retrieval
Module 7: Constructing Nested Queries
Module 8: Developing In-Line and Stored Views