SQL Database Administration Program

George Brown’s SQL Database Administration Program equips students with the skills necessary to install, configure, maintain, and upgrade SQL database servers in both small and large environments. The program covers everything from basic to advanced SQL statements for retrieving data, as well as the essential knowledge needed to secure, back up, and restore databases. Students will learn how to use Transact-SQL for querying data, inserting and deleting records, and maintaining data integrity. They will also gain expertise in administering SQL databases, including securing them through user roles and security models, implementing encryption, and performing backups and restores.

In addition, students will be trained in provisioning SQL databases, which includes installing and configuring SQL 2016 servers, managing servers in virtualized environments, and performing server maintenance to protect data. Career opportunities for graduates typically include roles such as database administrators or infrastructure specialists, making this program an ideal choice for individuals looking to advance in the database administration field.

What You’ll Learn

• Install, configure, and maintain SQL database servers in various environments.
• Write simple to advanced SQL queries to retrieve, insert, and delete data.
• Secure databases using security models, user roles, and encryption techniques.
• Backup and restore databases to ensure data integrity and recovery.
• Provision and configure SQL databases, including upgrading to newer versions.
• Perform server maintenance and optimize performance in virtualized environments.