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 closed to new registrations: Call ( 949 ) 824-5414 for more information or sign up below to be notified when this course becomes available.×

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.

  • Be notified when this class becomes available!

  • Details
  • $820
  • April 03, 2023 to May 28, 2023
  • Delivery Mode: Online
  • Reg#: 00227
  • ID/Units: I&C SCI X450.72  (2.50)
    ( Section 1 )
  • Quarter: Spring 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.

Optional Textbook(s):

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

Meeting Schedule

EventDateDayStart TimeEnd TimeLocationRoom
START04/03/2023Monday------Online (Access Begins)---
END05/28/2023Sunday------Online (Access Ends)---