You will be assessed a $25 late fee if you are enrolling one day after the course start date. You should work with the instructor to catch up on coursework.
Click OK if you still wish to enroll. Otherwise, click Cancel.
The course you selected is already in progress. You should work with the instructor to catch up on coursework.
Click OK if you still wish to enroll. Otherwise, click Cancel.
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.
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
Event Date Day Start Time End Time Location Room
START 04/03/2023 Monday --- --- Online (Access Begins) ---
END 05/28/2023 Sunday --- --- Online (Access Ends) ---