Skip to Content
Course

Introduction to SQL Programming

CSE-40933

Introduction to SQL Programming

Learn how to use the Structured Query Language (SQL) to create, manipulate, and create reports from database tables. Important concepts associated with relational databases will be covered. You will run SQL commands to create database tables and define data element types.

Single and multiple table queries will be created with simple and compound conditions using SQL operators such as:

  • BETWEEN
  • ​LIKE
  • IN
  • EXIST
  • ALL
  • ANY

Basic and complex reports will be created based on data in a table or view. Database Administration features of SQL will be discussed.

Course typically offered: Online, quarterly.

Prerequisites: Familiarity with data processing concepts and techniques.

Software: This course will use Microsoft SQL Server and Microsoft SQL Server Management Studio (SSMS). SQL Server will run natively on Windows and Linux. You can also run a SQL Server container image with Docker.

Next Steps: Upon completion of this course, consider taking other courses in the Business Intelligence Analysis or Database Management certificate programs to continue learning.

More Information: For more information about this course, please email unex-techdata@ucsd.edu.

Course Information

Online
3.00 units
$725.00
Notes: Prerequisite knowledge,"MS Access" or a working knowledge of Database Management and Design. The ability to download and configure the SQL Server environment on a windows PC. As well as basic programming knowledge or "Introduction to Programming"

Course sessions

Closed

Section ID:

184037

Class type:

Online Asynchronous.

This course is entirely web-based and to be completed asynchronously between the published course start and end dates. Synchronous attendance is NOT required.
You will have access to your online course on the published start date OR 1 business day after your enrollment is confirmed if you enroll on or after the published start date.

Textbooks:

No textbook required.

Policies:

  • No refunds after: 9/30/2024

Schedule:

No information available at this time.
Closed

Instructor: Eric Williamson, B.A., MCP

Eric Williamson, B.A., MCP

Data Manager UC San Diego Health

Eric Williamson is a Data Architect at UC San Diego Health. He specializes in Microsoft SQL Server and SharePoint. Williamson has been working with and developing in those technologies for 20+ years. He has been an instructor at Extension since 2013, developing and instructing SQL Server courses. Williamson has also been a Microsoft Certified Professional (MCP) since 2000.

Full Bio
Add To Cart

Section ID:

185628

Class type:

Online Asynchronous.

This course is entirely web-based and to be completed asynchronously between the published course start and end dates. Synchronous attendance is NOT required.
You will have access to your online course on the published start date OR 1 business day after your enrollment is confirmed if you enroll on or after the published start date.

Textbooks:

No textbook required.

Policies:

  • No refunds after: 1/13/2025

Schedule:

No information available at this time.
Add To Cart

Instructor: Eric Williamson, B.A., MCP

Eric Williamson, B.A., MCP

Data Manager UC San Diego Health

Eric Williamson is a Data Architect at UC San Diego Health. He specializes in Microsoft SQL Server and SharePoint. Williamson has been working with and developing in those technologies for 20+ years. He has been an instructor at Extension since 2013, developing and instructing SQL Server courses. Williamson has also been a Microsoft Certified Professional (MCP) since 2000.

Full Bio