Bright Star Institute

Course Description:

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)

Subjects:
MySQL, SQL

Course Description:

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

Subjects:
SQL Programming, SQL Server Administration, SQL

Course Description:

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

Subjects:
Linux, UNIX, C++, Java, C

Course Description:

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

Subjects:
CSS, HTML, Bootstrap, Angular, JavaScript, Web Development