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. 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.