Skip to Content
Home /  Courses And Programs / Advanced SQL Database Management Concepts

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 or MySQL. These tools are free and open-source.

Prerequisites: CSE-40933 Introduction to SQL Programming or equivalent knowledge and experience.

Next steps: Upon completion, consider additional coursework in our Database Management specialized certificate to continue learning.

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

Course Number: CSE-41332
Credit: 3.00 unit(s)
Related Certificate Programs: Database Management