Due to scheduled maintenance this site may be unavailable on {dayofweek}, {date} from {time} until {time} (PST)

Skip Navigation

Introduction to SQL Programming

A course in the Database Management Certificate Program and an elective in the Data Analytics Certificate, Data Science Certificate, and Full Stack Web Development Certificate Programs.

Course Description

Install SQL Server to your desktop and run complex queries using the Structured Query Language (SQL). This course will cover database table structures, column data types, and the T-SQL language components that go into querying against a database. Reading data from a table, row filtering, and column based functions will be discussed. We will also write queries that combine data from multiple tables, use conditional logic, and create aggregated result sets (sum, average, min, max). Database administration features of SQL will also be discussed.

Prerequisites: Familiarity with data processing concepts and techniques.

  • Details
  • $820
  • October 23, 2023 to December 17, 2023
  • Delivery Mode: Online
  • Reg#: 00221
  • ID/Units: I&C SCI X450.72  (2.50)
    ( Section 1 )
  • Quarter: Fall 2023

Instructor


Eric Williamson, B.A., MCP, is the data manager for the UCSD Health Strategy Office. He has worked more than 20 years with database technologies and specializes in Microsoft SQL Server, T-SQL, Analysis Services, and SharePoint. He has taught SQL and SharePoint courses since 2013.

Textbook Information

Textbooks for your course may be purchased from any vendor or bookseller of your choice.

Required Textbook(s):

Microsoft SQL Server 2012 T-SQL Fundamentals
Book - ISBN: 9780735658141
Izik Ben-Gan, Microsoft Press

Meeting Schedule

EventDateDayStart TimeEnd TimeLocationRoom
START10/23/2023Monday------Online (Access Begins)---
END12/17/2023Sunday------Online (Access Ends)---