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.
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.
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.
Textbooks for your course may be purchased from any vendor or bookseller of your choice.
Microsoft SQL Server 2012 T-SQL Fundamentals
Book - ISBN: 9780735658141
Izik Ben-Gan, Microsoft Press
|Event||Date||Day||Start Time||End Time||Location||Room
|START||01/22/2024||Monday||---||---||Online (Access Begins)||---
|END||03/17/2024||Sunday||---||---||Online (Access Ends)||---