Master SQL Server Developer Certificate

Online, self-paced training that is focused on giving you the skills needed to succeed.

5-course program: $4,500

The Master SQL Server Developer certificate program includes coverage of relational database fundamentals, SQL programming, SSRS, SSIS, SSIS as well as coverage of ASP.NET Web forms. Students will learn SQL syntax including complex queries, as well as creating and using stored procedures, functions, views and triggers. You will learn how to deploy and manage SSRS, create and customize reports including Table, Matrix, Parameterized and Linked reports. You’ll be introduced to the design and use of data warehouses and the use of SSIS to import/export data. A thorough introduction to SSAS includes creation of data cubes to support business analytics, and syntax for extracting information including the use of MDX to develop Multidimensional models. 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. Students will also be introduced to creating dynamic Web sites with ASP.NET Web Forms and the .NET framework, including how to use ADO.NET to interact with databases by running SQL queries and executing stored procedures. 

Online 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 and with full understanding of both the lecture content and the lab exercises.

Click the Curriculum tab below for detailed pdfs about each course in the program. Each course pdf contains a description of the course as well as a course overview outlining all the topics covered in the course.

Course Advisors are available at 978.256.9077 to answer any questions you may have.

  • Designing normalized table structures for relational databases
  • Creating databases and tables
  • Writing SQL queries
  • 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 
  • Configuring security in SQL Server
  • Backing up and restoring databases
  • Monitoring events and data changes on a SQL Server
  • Monitoring and optimizing performance of a SQL Server
  • Implementing high availability technologies
  • Installing and configuring SQL Server Reporting Services
  • Creating multi-dimensional, two-dimensional, and tabular data sources and data sets
  • Creating and deploying reports
  • Securing reports and data sources
  • Configuring report interactivity, including drill-downs, report maps, and book marks
  • Using visualization objects to create Charts, Spark Lines, Data Bars, and Tree Maps
  • Adding mages, page headers and footers, and report metadata to reports
  • Understanding the architecture of SQL Server Integration Services and how to use it as an ETL utility
  • Understanding how to design and build data warehouses
  • Understanding the BI semantic Model
  • Understanding how SQL Server Analysis Services can be used to create cubes to support business analysis
  • Using Visual Studio to create C# applications
  • Creating ASP.NET Web Form applications
  • Using ADO.NET to interact with databases
  • Deploying an ASP.NET Web application
  • A personal facilitator is assigned to you for each course, assisting with questions or issues that arise during your training.
  • You receive electronic copies of the student and lab guides.
  • You will receive a certificate of completion at the end of class.
  • There are no registration fees or cancellation fees.

ENROLL NOW

Once we receive your enrollment one of our Registrars will call you to confirm. Payment is due prior to the start of your first course. For multi-course certificate programs you can either pay in full or individually before the start of each course.

  • You receive electronic copies of the student and lab guides.
  • Logins will be sent to you for the lecture and lab portion of class.
  • An instructor will be assigned to you to help answer any questions regarding the class.

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
  • 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
Copyright© Bright Star Institute