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.
- Database Structure and Design
- Importing and Exporting Data
- Software Tools
- 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 firstname.lastname@example.org.
Course Number: CSE-41332
Credit: 3.00 unit(s)
Related Certificate Programs: Database Management
+ Expand All
7/11/2023 - 9/9/2023
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.
Williamson, Eric D
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.
No refunds after: 7/17/2023.
7/11/2023 - 9/9/2023
You will have access to your course materials on the published start date OR 1 business day after your enrollment is confirmed if you enroll on or after the published start date.
There are no sections of this course currently scheduled. Please contact the Science & Technology department at 858-534-3229 or email@example.com for information about when this course will be offered again.