Skip to Content
Course

Advanced SQL Database Management Concepts

CSE-41332

Take your SQL skills to the next level!

 

Managing SQL server requires working knowledge of database structure and design, importing and exporting data, permissions and security, indexing, Linked servers, SQL Server Agent jobs, Backup and Restoration, and System Tables and Functions.
Building on the knowledge acquired in our Introduction to SQL course, students will learn to implement administrative techniques on SQL server. Upon completion of this course students will have a solid foundation for managing SQL databases and servers.

Course Highlights:

  • Database Structure and Design
  • Importing and Exporting Data
  • Software Tools
  • Indexing
  • Security
  • SQL Server Agent
  • Linked Servers
  • Backup and Restore
  • System Functions and Tables

Course Learning Outcomes:

  • Understand different database designs
  • Optimize a database to store relational data
  • Create and use indexes
  • Import data into a database, export data to other sources
  • Apply security settings to database objects
  • Backup and restore databases
  • Create scheduled jobs using SQL Server Agent
  • Create connections to linked servers, and utilize popular system functions and tables

Course typically offered: Online in Winter and Summer quarters.

Software: Students will use Microsoft SQL Server. These tools are free and open-source.

Prerequisites: CSE-40948 Intermediate SQL Programming or equivalent knowledge and experience.

Next steps: Upon completion of this course, consider taking other courses in our Database Management program to continue learning.

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

Course Information

Online
3.00 units
$725.00

Course sessions

Add To Cart

Section ID:

185630

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