The Linux Administrator certificate program provides a thorough introduction to UNIX and Linux fundamentals as well as essential administration skills required to maintain a Linux system in a networked business environment. Students will learn to create Bash and Korn shell scripts and develop solid grounding in the X Window System, and will also learn about essential commands, file system structure and navigation, and process creation and management. Students will be introduced to regular expressions and the power tools that use them including grep, sed, and awk. Admin topics include installing, configuring and maintaining an Enterprise Linux system, as well as planning and implementing backup strategies and configuring and deploying network services.Upon completion of this program, students will have developed an appropriate knowledge base and hands-on experience to pursue a Linux Essentials certification from the Linux Professional Institute (LPI) after program completion. The student will have learned Unix environment fundamentals as well as shell scripting skills employed by power users. Additionally, the student will learn more advanced skills that are related to Linux system administration, and will gain a solid foundation of knowledge that would be helpful for the Linux Administrator certification from LPI. Regardless of whether or not students wish to pursue certification after program completion, students will have a skillset that enables them to perform support roles related to Unix/Linux, as well as entry-level Unix/Linux system administrator roles.
Program Overview
1.	Gaining a general understanding of core operating system components such as the kernel, shell, and file system structure
2.	Understanding the login process
3.	Learning the basics of command line syntax
4.	Using the man pages to get information and help for commands
5.	Working with secure shells
6.	Using conditional constructs to control script execution
7.	Manipulating strings
8.	Using the ksh and bash commands
9.	Learning the skills, responsibilities and requirements for administering Linux servers
10.	Installing and deploying an enterprise-level Linux server
11.	Performing and modifying startup and shutdown processes
12.	Setting up and maintaining basic networking
13.	Setting specific file permissions on directories and files
14.	Performing backups and restoration of files
15.	Troubleshooting system problems
16.	Configuring file sharing in heterogeneous network environments with CIFS (Samba)
17.	Deploying a web server configuration
18.	Understanding LAMP services for web use
Time Required
Required Course - 35, 35 hours
- UNIX/Linux Fundamentals and Shell Scripting
- Linux System Administration

The Web Developer Certificate program covers web development basics including implementing web pages using HTML5, Bootstrap, CSS, JavaScript, Angular, and responsive web design techniques. Through hands on, personally facilitated exercises students will practice web development of responsive and mobile friendly websites. Furthermore, students will go deeper into JavaScript topics and become proficient in manipulating the DOM, creating functions, handling events, and making AJAX requests to enhance their web development capabilities. Upon completing the Web Developer certificate program, students will have skills that enable them to become an entry-level web developer or prepare for certification exams. Entry-level web developers earn healthy salaries (up to $54,000) and have incredible opportunities for higher salaries in their midcareer. Students will be able to leverage popular web development frameworks like Bootstrap, jQuery and Angular. The topics covered in this program help empower students to become knowledgeable website developers once they've completed the courses on-demand with personal facilitation.
Program Overview
1.	Understand the structure of HMTL5 documents
2.	Working with tables, lists, images, hyperlinks and forms
3.	Validating forms using HTML5 features
4.	Creating animations using transitions, transforms and animations
5.	Using CSS to format the appearance of an HTML5 document
6.	Implementing the attribute selectors and pseudo-classes in CSS3
7.	Using the Bootstrap grid system to create a page layout
8.	Adding components to a page such as dropdowns, thumbnails, alerts and glyphicons
9.	Writing clear, understandable, commented JavaScript code
10.	Using the Document Object Model to access the HTML elements on the page dynamically
11.	Debugging JavaScript code
12.	Working with JSON objects
13.	Understanding the benefits of using jQuery
14.	Comprehending how jQuery simplifies the selection of DOM elements
15.	Understanding different uses of the jQuery function
16.	Using jQuery to interact with the fields of a form
17.	Introduction to Responsive Web Design (RWD)
18.	Using the Viewport and Media Queries
19.	Using jQuery Mobile to build touch-friendly Web sites
20.	Using TypeScript and ECMAScript 6 to create object oriented Angular classes
21.	Using directives, components and templates to define Angular user interfaces
22.	Building dynamic Angular SPAs (Single Page Apps) using routing
23.	Developing applications that use both template-driven and reactive style forms
24.	Creating Angular services that use both local client-side business logic as well as services that communicate with Internet based RESTful web services
Required Time
Required Courses - 28, 35, 21, 35, 35 hours
- Website Development with HTML5, CSS and Bootstrap
- JavaScript Programming
- jQuery Programming
- Developing Mobile Websites with Responsive Web Design and jQuery Mobile
- Developing Web Applications Using Angular
Optional Courses - 28, 28, 28, 35, 28 hours
- Node.js Application Development
- Perl Scripting
- PHP Programming
- ASP.NET Web Forms Programming Using C#
- Python Programming

The VB.NET Developer certificate program focuses on the skills needed to become a .NET developer. The certificate program teaches students to create distributed applications and dynamic Web applications with the .NET platform using VB.NET and Visual Studio. Coverage begins with an introduction to the VB.NET programming language, built in data types, operators, control structures, classes and methods, collections and exception handling. Students will develop Windows and Web-based applications, including coverage of the MVC programming framework. Advanced topics include the Entity Framework, Web API, creating multithreaded applications, using LINQ and working with object-based collections and generics collections. Upon completion of the VB.NET Developer certificate program, students will have developed a flexible and sophisticated skillset regarding the VB.NET language and the .NET framework. Students will have developed an appropriate knowledge base and hands-on development experience to pursue an entry-level VB.NET programmer position in the workforce to help organizations develop software solutions based on various .NET technologies. The VB.NET certificate program will also provide students with more advanced skills and techniques related to .NET, allowing students to stand out in the workplace as a knowledgeable VB.NET developer once they've completed the certificate program's on-demand courses with personal facilitation.
Program Overview
1.	Describing the .NET platform for developing VB.NET applications
2.	Using Visual Studio to create VB.NET applications
3.	Creating variables with the proper scope and use operators to build complex expressions
4.	Understanding the use of the Form and Control classes to develop Windows applications
5.	Understanding the event-driven architecture of Windows Forms
6.	Accessing and displaying data using ADO.NET
7.	Using Visual Studio to create ASP.NET MVC web applications
8.	Using the Razor view engine to design ASP.NET MVC views to render responses to HTTP requests
9.	Understanding how to integrate AJAX into ASP.NET MVC applications to make them more interactive
10.	Understanding how to make ASP.NET MVC applications responsive using Bootstrap
11.	Interacting with databases using the Entity Framework
12.	Creating ASP.NET Web Forms applications
13.	Using Web Server controls and validation controls on a web page
14.	Using master pages to enforce a consistent look and feel across a web application
15.	Using .NET collections to manage data
16.	Using delegates for late binding, using callback behavior and responding to events
17.	Using LINQ and PLINQ to make queries
18.	Understanding how to integrate AJAX into ASP.NET MVC applications to make them more interactive
19.	Deploying .NET applications
Required Time
Required Courses - 35, 21, 21, 35, 35 hours
- Windows Forms Programming Using VB.NET
- ASP.NET Web Forms Programming for Experienced VB.NET Programmers
- ASP.NET MVC Programming for Experienced VB.NET Programmers
- Advanced .NET Framework Programming Using VB.NET
- Advanced MVC: Building Web Applications Using the ASP.NET Web API with VB.NET
Optional Courses - 21, 21, 28 hours
- Windows Presentation Foundation Programming for Experienced VB.NET Programmers
- SQL Programming
- Object Oriented Analysis & Design with UML


The Java Programmer certificate program enables students to learn Java on-demand with personal facilitation to develop the skills needed to code, compile, and run stand-alone object-oriented Java programs. Students will learn how to create and deploy SOAP based and RESTful Web services as well as work with the Spring and Hibernate frameworks. Object-oriented concepts and proper use of classes, objects, inheritance and polymorphism are emphasized throughout. Coverage includes building applications by integrating Spring and Hibernate and utilizing Ajax on both the client and server sides. Students may choose from multiple IDEs for the extensive hands on labs, whether it be Eclipse, NetBeans or jEdit.
Upon completion of the Java Programmer certificate program, students will have developed an appropriate knowledge base and hands-on Java development experience to pursue an entry-level Java developer position in the workforce. The Java certificate program provides a solid foundation of knowledge for the Java SE Programmer I exam, if a student wishes to pursue certification.
Program Overview:
1.	Designing and writing Java classes suitable for a given application domain
2.	Writing robust Java software that gracefully handles run-time problems
3.	Coding Java programs using correct syntax and block structure
4.	Using Java to read from and write to files
5.	Manipulating files and directories in a platform-neutral way
6.	Writing multithreaded software
7.	Writing Java client/server software using TCP/IP networking
8.	Accessing and updating relational databases from Java software
9.	Writing and run servlets and JSPs
10.	Creating and deploying SOAP based and RESTful Web services
11.	Creating applications that utilize the Spring dependency injection framework
12.	Managing database operations by using the Hibernate framework
13.	Building Web applications by using the Spring MVC framework
14.	Managing database transactions with Spring and Hibernate
15.	Building applications by effectively integrating Spring and Hibernate
Time Required:
Required - 35 & 35 hours
- Java Programming
- Introduction to Web Application Development Using JEE, Spring/Hibernate, Web Services and AJAX
Optional - 28, 28, 21 hours
- Test Driven Development (TDD), and Refactoring Legacy Code Using Java
- Object Oriented Analysis & Design with UML
- SQL Programming 

The C# .NET Developer certificate program focuses on the skills needed to become a successful C# developer. Students will learn to create distributed applications and dynamic Web applications with the .NET platform using C# and Visual Studio. Coverage begins with an introduction to the C# programming language, built in data types, operators, control structures, classes and methods, collections and exception handling. Students will develop Windows and Web-based applications, including coverage of the MVC programming framework. Advanced topics include the Entity Framework, Web API, creating multithreaded applications, using LINQ and working with object-based collections and generics collections. Upon completion of the C# Developer certificate program, students will have developed a flexible and sophisticated skillset regarding the C# language and the .NET framework. Students will develop a robust knowledge base and gain hands-on development experience to pursue an entry-level C# .NET programmer position in the workforce. The C# certificate program will also provide students with more advanced skills and techniques related to .NET, allowing students to stand out in the workplace as a knowledgeable C# developer once they have completed the program's on-demand courses with personal facilitation.
Program Overview
1.	Describing the .NET platform for developing C# applications
2.	Using Visual Studio to create C# applications
3.	Creating variables with the proper scope and use operators to build complex expressions
4.	Understanding the use of the Form and Control classes to develop Windows applications
5.	Understanding the event-driven architecture of Windows Forms
6.	Accessing and displaying data using ADO.NET
7.	Using Visual Studio to create ASP.NET MVC web applications
8.	Using the Razor view engine to design ASP.NET MVC views to render responses to HTTP requests
9.	Understanding how to integrate AJAX into ASP.NET MVC applications to make them more interactive
10.	Understanding how to make ASP.NET MVC applications responsive using Bootstrap
11.	Interacting with databases using the Entity Framework
12.	Creating ASP.NET Web Forms applications
13.	Using Web Server controls and validation controls on a web page
14.	Using master pages to enforce a consistent look and feel across a web application
15.	Using .NET collections to manage data
16.	Using delegates for late binding, using callback behavior and responding to events
17.	Using LINQ and PLINQ to make queries
18.	Understanding how to integrate AJAX into ASP.NET MVC applications to make them more interactive
19.	Deploying .NET applications
Time Required
Required Courses - 35, 21, 21, 35, 35 hours
- Windows Forms Programming Using C#
- ASP.NET Web Forms Programming for Experienced C# Programmer
- ASP.NET MVC Programming for Experienced C# Programmers
- Advanced .NET Framework Programming Using C#
- Advanced MVC: Building Web Applications Using the ASP.NET Web API with C#
Optional Courses - 21, 21, 21, hours
- WCF Programming for Experienced C# Programmers
- Windows Presentation Foundation Programming for Experienced C# Programmers
- SQL Programming
- Object Oriented Analysis & Design with UML
- Test Driven Development (TDD), and Refactoring Legacy Code Using C#

The Advanced Java Developer certificate program refreshes advanced Java developers and teaches beginners the Java skills needed to code, compile and run standalone object-oriented Java programs. Students will learn how to create and deploy SOAP based and RESTful Web services as well as work with the Spring and Hibernate frameworks. Object-oriented concepts and proper use of classes, objects, inheritance and polymorphism are emphasized throughout. Coverage includes building applications by effectively integrating Spring and Hibernate and utilizing Ajax on both the client and server sides. Students will also learn Test Driven Development (TDD) using NUnit and Microsoft’s Visual Studio including building unit tests using mocks, fakes, stubs and drivers. Students may choose from multiple IDEs for the extensive hands on labs, whether it be Eclipse, NetBeans or jEdit. Upon completion of the Advanced Java Developer certificate program, students will have developed an appropriate knowledge base and hands-on Java development experience to pursue an entry-level Java developer position in the workforce or allow an existing Java programmer to prepare for expanded responsibilities for working with additional Java frameworks in their role. This program will provide students with advanced Java skills and technical knowledge, providing a sophisticated Java skillset to students that will allow them to stand out in the workplace. The Advanced Java certificate program provides a solid foundation of knowledge for the Java SE Programmer I exam, as well as more advanced Java certifications.
Program Overview
1.	Designing and writing Java classes suitable for a given application domain
2.	Writing robust Java software that gracefully handles run-time problems
3.	Coding Java programs using correct syntax and block structure
4.	Using Java to read from and write to files
5.	Manipulating files and directories in a platform-neutral way
6.	Writing multithreaded software
7.	Writing Java client/server software using TCP/IP networking
8.	Accessing and updating relational databases from Java software
9.	Writing and running servlets and JSPs
10.	Creating and deploying SOAP based and RESTful Web service
11.	Understanding the core principles of Spring and of Dependency Injection (DI) / Inversion of Control
12.	Using the Spring Core module and DI to configure and wire application objects (beans) together
13.	Working with the ORM (Object-Relational Mapping) module to integrate Spring with technologies such as Hibernate or JPA
14.	Integrating Spring with Java EE Web applications
15.	Understanding REST and use Spring MVC to build RESTful services
16.	Learning Test Driven Development (TDD) to improve productivity of developers
17.	Working with real-world testing frameworks that implement continuous integration between IDE builds, automated tests and source control servers
18.	Understanding test patterns to simplify tests, reduce duplication and make testing more efficient
19.	Understanding select patterns to make code more readable and maintainable
Time Required
Required Courses - 35, 35, 35, 28 hours
- Java Programming
- Introduction to Web Application Development using JEE, Spring/Hibernate, Wen Services and AJAX
- Introduction to Spring 5, Spring MVC, and Spring REST
Optional Courses - 28, 35, 21, 21, hours
- Object Oriented Analysis and UML Design
- Effectively Using Java Packages and Features
- Introduction to Spring Boot 2
- SQL Programming 

The SQL Programmer certificate program provides a solid understanding of relational database design concepts, SQL syntax, and construction of complex SQL queries using a variety of techniques such as unions, subqueries, and aggregations. Coverage includes the creation and use of stored procedures, functions, views and triggers. Upon completion of the SQL certificate program, students will have developed a fundamental knowledge of database design, as well as crucial SQL querying & programming techniques that are highly valuable in a variety of positions, such as entry level programming or advanced technical support positions. The SQL skills learned in this program are applicable to a wide variety of database providers such as MySQL, Oracle, and Microsoft SQL Server. Students that are interested in learning more about the potential return on investment or entry-level salaries for SQL programmers (and related positions) can view our free resources or speak to a course advisor.
Program Overview:
1.	Designing normalized table structures for relational databases
2.	Creating databases and tables
3.	Writing SQL queries
4.	Adding records to tables
5.	Updating and deleting records
6.	Retrieving records from multiple tables using JOINs
7.	Using aggregate functions to return totals and subtotals
8.	Understanding the main components of databases (stored procedures, functions, views triggers, constraints and indexes)
9.	Creating user-defined functions
10.	Working with table expressions
Time Required
Required - SQL Programming (21 hours) 

The UNIX Developer certificate program includes coverage of UNIX/Linux fundamentals as well as a comprehensive introduction to the ANSI C language. Topics include command line syntax, file system structure and navigation, as well as coverage of writing Korn and Bash shell scripts. In the C Programming course, students are introduced to fundamental data types, flow control, standard function libraries as well as coverage of structured programming constructs and varargs functions. The final course allows students to choose from either C++ or Java programming. Upon completion of the UNIX Developer certificate program, students will have developed an appropriate knowledge base and hands-on development experience to pursue an entry-level C programming position in the workforce. The student could also pursue an entry-level C++ or Java Programming position, depending on which optional course is taken. To have a better understanding of potential return on investment and entry-level C/C++/Java programmer salaries, students can reference our entry-level salary blog post. Students will be able to work as a developer in these languages in either a Windows or UNIX environment, since the program covers UNIX environment fundamentals as well as shell scripting. If desired, a student would have sufficient knowledge to pursue a Linux Essentials certification from the Linux Professional Institute (LPI) after program completion.
Program Overview:
1.	Getting a general understanding of core operating system components such as the kernel, shell, and file system structure
2.	Understanding the login process
3.	Learning the basics of command line syntax
4.	Using the man pages to get information and help for commands
5.	Working with secure shells
6.	Using conditional constructs to control script execution
7.	Manipulating strings
8.	Using the ksh and bash commands
9.	C Language basics and development environment
10.	Fundamental data types, storage classes and scope
11.	Using Operators and expressions
12.	Flow control constructs
13.	Basic character and formatted I/O
14.	Using C functions, arrays, strings and character manipulation
15.	Accessing Command Line Arguments and environment variables
16.	C Runtime Library Standard I/O functions
17.	Writing programs in either C++ or Java
Time Required
Required Courses - 35, 35, 28, 25 hours
- UNIX/Linux Fundamentals and Shell Scripting
- C Programming
- C++ Programming for C Programmers
- Java Programming
Optional Courses - 28 hours
- Object Oriented Analysis & Design with UM

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.
Program Overview:
1.	Designing normalized table structures for relational databases
2.	Creating databases and tables
3.	Writing SQL queries
4.	Retrieving records from multiple table using JOINs
5.	Using aggregate functions to return totals and subtotals
6.	Understanding the main components of databases (stored procedures, functions, views triggers, constraints and indexes)
7.	Installing multiple instances of SQL Server
8.	Using the SQL Server client tools to manage and configure SQL Server
9.	Using Policy-Based Management to configure SQL Server
10.	Configuring security in SQL Server
11.	Backing up and restoring databases
12.	Transferring data into and out of SQL Server
13.	Replicating data using SQL Server replication
14.	Monitoring events and data changes on a SQL Server
15.	Monitoring and optimizing performance of a SQL Server
16.	Implementing high availability technologies
17.	Managing multiple SQL Server instances using central management
Time Required
Required Courses - 35, 35 hours
- Microsoft Transact – SQL Programming
- Microsoft SQL Server 2017 Administrator
Optional Courses -35 hours
- SQL Server 2017 Business Intelligence: Integration Services and Analysis Services


Python Programming is quickly becoming one of the most popular programming skills to learn. The Python Programmer Certificate program teaches students how to create scripts in the Python language that manipulate data, automate tasks and handle errors. In addition to that, the Python certificate program covers how to access relational databases as well as writing scripts that assist with system administration. Through hands-on lab exercises students will learn to use the IDLE integrated development environment.  When students complete the Python Programming Certificate program, they will be prepared to take the entry-level Python Certification exam if they so choose. Students also will possess an adequate skillset to gain entry-level employment in a role that utilizes their python skills. Even entry-level Python programmers are compensated well, with starting salaries ranging from $41,000 - $70,000 with opportunities to earn more with standard career and python skill advancement.
Program Overview:
1.	Writing Python programs
2.	Working with Python's built-in objects
3.	Reading and writing files
4.	Communicating with database's
5.	Creating structured data with Lists, Tuples, Sets and Dictionaries
6.	Using exceptions to gracefully handle errors
7.	Testing program features using Test Driven Development
8.	Writing applications with Graphical User Interfaces
9.	Writing clear and concise Regular Expressions
10.	Organizing code with Functions and Classes
Required Time
Required Courses - 28 hours
- Python Programming


The C Programmer certificate program focuses on the skills needed to become a competent C or C++ developer, and comprises two programming courses providing comprehensive coverage of the C and C++ languages and foundational C/C++ topics that help develop skills applicable to real-world settings. In the C Programming course, students are introduced to fundamental data types, flow control, standard function libraries as well as coverage of structured programming constructs and varargs functions. The C++ course introduces core object-oriented programming concepts including inheritance, encapsulation and polymorphism. C++ syntax and style are taught in the context of using object-oriented methods to achieve reusability, adaptability and reliability. Students can perform hands-on labs utilizing Microsoft Visual Studio or a UNIX-based environment if desired. Upon completion of this program, students will have developed an appropriate knowledge base and hands-on development experience to pursue an entry-level C programmer or C++ developer position in the workforce. The C and C++ skills picked up during the on-demand certificate program also provide a solid foundation of knowledge for the C Programming Language Certified Associate and C++ Certified Associate Programmer exams, if a student wishes to pursue certification.
Program Overview:
1.	C Language basics and development environment
2.	Fundamental data types, storage classes and scope
3.	Using Operators and expressions
4.	Flow control constructs
5.	Basic character and formatted I/O
6.	Using C functions, arrays, strings and character manipulation
7.	Accessing Command Line Arguments and environment variables
8.	C Runtime Library Standard I/O functions
9.	Writing software using C++
10.	Defining your own types (classes) to extending the functionality of C++
11.	Writing robust software that handles problems at run-time using exception handling
12.	Writing C programs that make use of the Standard Template Library
13.	Creating generic classes and functions that may be reused without modification
Time Required:
Required Courses  - 35 & 28 hours
- C Programming
- C++ Programming for C Programmers
Optional Courses - 28 & 21 hours
- Object Oriented Analysis & Design with UML
- SQL Programming

With the explosion in the use of smart phones and tablets, including Android and iPhone/iPad, our Mobile Application Developer Certificate program gives students a very relevant and exciting skillset. The Mobile App Program focuses on the skills needed to code mobile apps for Android and iPhone environments. Coverage begins by introducing the Android IDE environment to develop and test Android apps for smartphones and tablets. Android development specific topics include using standard widgets like buttons, check boxes, date/time pickers and images. Additionally, students will learn to develop native mobile applications for the iPhone with Swift using the Xcode interface. Throughout the course students will work with Apple’s Cocoa Touch UI Framework and learn to implement Apple’s delegate design pattern that is used in many APIs. Additionally, optional mobile app development courses include Objective-C for iOS and Microsoft’s cross-platform Xamarin programming environment that allows for development of iOS and Android application simultaneously. After completing the Mobile Application Development Certificate program students will have enough hands-on experience and skills to pursue an entry-level mobile app developer position. As a developer, students will be able to develop for both Android and iOS applications. iOS apps are written using the Swift language, while Android apps are written in Java, so students will gain these skillsets helping them become better mobile app developers and coders. If a student chooses to take the optional Xamarin course, they will benefit by learning C# fundamentals as well. When searching for entry-level employment after the competition of the program, an entry-level mobile app developer can expect to make between $46,000 and $69,000.
Program Overview
1.	Setting up the Android IDE to develop and test Android apps for smartphones and tablets
2.	Creating and deploying Android apps that use standard widgets such as buttons, checkboxes, lists, date/time pickers, images and more
3.	Accepting keyboard input, as well as respond to screen taps, long taps and swipes
4.	Managing the lifecycle of an app, including when it's interrupted by a phone call
5.	Embedding SQLite databases in apps for persistent storage
6.	Displaying pop-up messages and notifications
7.	Packaging and deploying apps to phones and tablets
8.	Writing code using the Swift programming language
9.	Creating object-oriented apps
10.	Designing model-view-controller applications
11.	Responding to user interactions
12.	Persisting data in .plist files
13.	Making calls to RESTful APIs to send and receive data
14.	Persisting data using Core Data
15.	Implementing good code design practices
16.	Creating adaptive user interfaces for multiple iOS devices
Required Time
Requires Courses - 35, 35 hours
- Android™ Application Development
- Swift Programming for iPhone® and iPad® Applications
Optional Courses - 35, 35
- iOS Programming for iPhone® and iPad® Applications Using Objective-C
- Xamarin Cross-Platform Mobile Application Development


The Advanced SQL Server Developer certificate program includes coverage of relational database fundamentals, SQL programming, Reporting Services (SSRS), Integration Services (SSIS), and Analysis Services (SSAS), 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 Integration Services to import/export data. A thorough introduction to Analysis Services 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. Students may also optionally learn to use Microsoft's Power BI suite of products to import, analyze, and visualize business data, and to share business intelligence. Upon completion of the Advanced SQL Server Developer certificate program, students will develop a robust and flexible knowledge base applicable to a variety of positions related to database programming, data reporting, data analysis, and database administration. In the Advanced SQL Developer program, students will also gain experience with integration between Microsoft SQL Server and the .NET framework, which will be valuable at firms which develop .NET-based software that interacts with a SQL database. Courses in the Advanced SQL program are delivered on-demand with personal facilitation, and upon completion of all required courses, students will have incredible opportunities to pursue a career utilizing their SQL skills.
Program Overview:
1.	Designing normalized table structures for relational databases
2.	Creating databases and tables
3.	Writing SQL queries
4.	Understanding the main components of databases (stored procedures, functions, views triggers, constraints and indexes)
5.	Installing multiple instances of SQL Server
6.	Using the SQL Server client tools to manage and configure SQL Server
7.	Configuring security in SQL Server
8.	Backing up and restoring databases
9.	Monitoring events and data changes on a SQL Server
10.	Monitoring and optimizing performance of a SQL Server
11.	Implementing high availability technologies
12.	Installing and configuring SQL Server Reporting Services
13.	Creating multi-dimensional, two-dimensional, and tabular data sources and data sets
14.	Creating and deploying reports
15.	Securing reports and data sources
16.	Configuring report interactivity, including drill-downs, report maps, and book marks
17.	Using visualization objects to create Charts, Spark Lines, Data Bars, and Tree Maps
18.	Adding mages, page headers and footers, and report metadata to reports
19.	Understanding the architecture of SQL Server Integration Services and how to use it as an ETL utility
20.	Understanding how to design and build data warehouses
21.	Understanding the BI semantic Model
22.	Understanding how SQL Server Analysis Services can be used to create cubes to support business analysis
23.	Using Visual Studio to create C# applications
24.	Creating ASP.NET Web Form applications
25.	Using ADO.NET to interact with databases
26.	Deploying an ASP.NET Web application
Required Time
Required courses 35, 21, 35, 35, 35 hours
- Microsoft Transact-SQL Programming
- SQL Server 2017 Reporting Service
- SQL Server 2017 Business Intelligence: Integration Services and Analysis Service
- Microsoft SQL Server 2017 Administration
- ASP.NET Web Forms Programming Using C#
Optional Course 21 hours
- Analyzing and Presenting Data with Power BI

The SQL Business Intelligence certificate program includes coverage of RDB fundamentals, SQL programming, Reporting Services (SSRS), Integration Services (SSIS), Analysis Services (SSAS), and Power BI. It includes comprehensive coverage of 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. Students will also learn to use Microsoft's Power BI suite of products to import, analyze, and visualize business data, and to share business intelligence. Upon completion of the program, students will have developed an appropriate knowledge base for a variety of positions related to database programming, data reporting, and data analysis. Students will have gained an appropriate skillset to pursue an entry level database reporting or business intelligence position at companies which use Microsoft SQL Server.
Program Overview:
1.	Designing normalized table structures for relational databases
2.	Creating databases and tables
3.	Writing SQL queries
4.	Understanding the main components of databases (stored procedures, functions, views triggers, constraints and indexes)
5.	Programming features of T-SQL
6.	Installing multiple instances of SQL Server
7.	Using the SQL Server client tools to manage and configure SQL Server
8.	Installing and configuring SQL Server Reporting Services
9.	Creating multi-dimensional, two-dimensional, and tabular data sources and data sets
10.	Creating and deploying reports
11.	Securing reports and data sources
12.	Configuring report interactivity, including drill-downs, report maps, and book marks
13.	Using visualization objects to create Charts, Spark Lines, Data Bars, and Tree Maps
14.	Adding mages, page headers and footers, and report metadata to reports
15.	Understanding the architecture of SQL Server Integration Services and how to use it as an ETL utility
16.	Understanding how to design and build data warehouses
17.	Understanding the BI semantic Model
18.	Understanding how SQL Server Analysis Services can be used to create cubes to support business analysis
19.	Implementing data mining algorithms against cubes to support predictive and trending analysis
20.	Shaping, transforming, and combining data from diverse sources to create useful reports in Power BI
21.	Choosing and creating the data visualizations that are best suited for various types of analysis
Required Time
Required Courses 35, 21, 35, 21 hours
- Microsoft Transact-SQL Programming
- SQL Server 2017 Reporting Services
- SQL Server 2017 Business Intelligence: Integration Services and Analysis Services
- Analyzing and Presenting Data with Power BI
Optional Courses
- Analyzing Data Using DAX and M Power Query


Bright Star Institute