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
Course sessions
Section ID:
Class type:
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:
Instructor: 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.