SQL Server Administrator Certificate

Learn SQL Server database administrator skills online and on-demand with personal facilitation.

2-course program: $1,800

The SQL Server Administrator certificate program includes coverage of RDB fundamentals, SQL programming and administering SQL Server 2016 & 2017 databases. Students learn SQL syntax including complex queries, as well as creating and using stored procedures, functions, views and triggers. Administration topics include installing and configuring SQL Server, backing up and restoring databases, configuring security as well as monitoring and optimizing performance of a SQL Server.

Upon completion of the program, students will have developed an excellent fundamental knowledge of database design, as well as crucial SQL querying & programming techniques that are required for any positions related to database programming and/or administration. Students will have an appropriate skillset to pursue an entry level Microsoft SQL Server Database Administrator position.

On-Demand learning gives you the flexibility to plan study time around the rest of your day. Our programs combine video, hands-on lab exercises and one-on-one facilitation to enable you to learn as your schedule allows. Labs are performed via remote access to a dedicated lab machine (unless a student requests to utilize their own equipment). Our unique commitment to student success includes a personal instructor to assure that your courses are completed on time with full understanding of both the lecture content and the lab exercises, and also to serve as a resource when you have questions or need assistance with lab work. For a short video with more information about our on-demand training, please click here.

At Bright Star, we are happy to find out your personal career goals, and to discuss your personal situation to determine which IT and programming certificate programs are a good fit for you. Course Advisors are available at 978.256.9077 to answer any questions you may have, or you may request information here.


Program Overview

  • Designing normalized table structures for relational databases
  • Creating databases and tables
  • Writing SQL queries
  • Retrieving records from multiple table using JOINs
  • Using aggregate functions to return totals and subtotals
  • Understanding the main components of databases (stored procedures, functions, views triggers, constraints and indexes)
  • Installing multiple instances of SQL Server
  • Using the SQL Server client tools to manage and configure SQL Server
  • Using Policy-Based Management to configure SQL Server   
  • Configuring security in SQL Server
  • Backing up and restoring databases
  • Transferring data into and out of SQL Server
  • Replicating data using SQL Server replication
  • Monitoring events and data changes on a SQL Server
  • Monitoring and optimizing performance of a SQL Server
  • Implementing high availability technologies
  • Managing multiple SQL Server instances using central management

Curriculum

Required Courses Duration PDF
Microsoft Transact-SQL Programming 35 hours
Microsoft SQL Server 2017 Administration 35 hours

Optional courses can be added to the base certificate track for an additional $900 each.

Optional Course Duration PDF
SQL Server 2017 Business Intelligence: Integration Services and Analysis Services 35 hours

Getting Started

Feel free to call us to discuss your desired curriculum – one of our advisors will be happy to discuss your training objectives and confirm that your goals and selected courses align. Your advisor will assist you in customizing the appropriate track to your personal situation.

After enrollment and speaking to your advisor, payment can be made anytime prior to your chosen start date for your first course. For multi-course certificate programs, you may pay for each course as you start it (pay as you go). Financing is also available.

  • You will receive electronic copies of the student and lab guides.
  • Login credentials will be sent to you for the lecture portions and lab portions of class.
  • A personal facilitator will be assigned to you for each course, assisting with questions or lab issues that arise during your training.
  • You will receive a certificate of completion at the end of class.
  • There are no registration fees or cancellation fees.

ENROLL NOW

About Our Online Training Platform

  • Courses are designed to be a combination of lecture and comprehensive problem solving lab exercises
  • You are provided login credentials to view the course on any device whether it be a phone, tablet or computer
  • You receive electronic copies of the student and lab guides for each course
  • Lab exercises are performed via a dedicated lab machine
  • An instructor is assigned to assist you in completing lab exercises and to help with any questions about the course content
  • Our support team provides you with course selection guidance, personal course setup assistance and technical support
  • There are no registration fees or cancellation fees
Copyright© Bright Star Institute