SQL for Web Developers
CTU-DVSQLWEB-C





Official Program Description

This course will show you how to develop SQL SELECT, INSERT, UPDATE, and DELETE statements.

This course is part of the Webmaster Certificate Program in the Developer Track.

Who Should Attend

This course is designed for those on the Developer Track for the Webmaster Certificate Program.

Prerequisites

Experience with any programming or query language

Attend and You Will Learn

Introduction

  • Relational database concepts
  • Overview of current relational DBMSs
  • Data modeling and normalization

SQL Overview

  • SQL syntax rules
  • Data manipulation, data definition, and data control statements
  • Examples of SQL in Web applications
  • Advantages of putting SWL in stored procedures, examples
  • Performance considerations of delivering large amounts of data to the browser

SQL Select Statements

  • Clauses of the SELECT statement
  • Selecting column names; column aliases, using AS
  • Using WHERE predicates, comparison operators, compound predicates with AND and OR
  • How null values behave
  • Using BETWEEN, IN, LIKE
  • Sorting with ORDER BY
  • Overview of expressions and functions

SQL Updating

  • The INSERT statement
  • The UPDATE statement
  • The DELETE statement
  • Referential integrity and other constraints, default values

Overview of More Complex Queries

  • Joins: inner and outer joins
  • Summarizing data with GROUP BY and the functions SUM, AVG, MAX, MIN, COUNT

Applies Towards the Following Certificate(s)



Thank you for your interest in this course. Unfortunately, the course you have selected is currently not open for enrollment. Please complete a Course Inquiry so that we may promptly notify you when enrollment opens.