SQL Server 2012
As businesses continue to rally for data-driven decision making, employees with database knowledge are in high demand. This program will prepare you for database administration and development, learning the standards set forth to manage SQL Server 2012.
Upon completion of the program, you will be given vouchers to take three Microsoft™ certifying exams.
What Will I Learn?
As you work towards preparing for your MCSA: SQL Server 2012, you will learn how to create database objects, constraints, and alter DML triggers.
You’ll learn to query and modify data, as well as how to work with functions. To further your expertise, you will also explore troubleshooting and optimizing SQL Server 2012 and the steps to install, manage and maintain SQL servers.
This program will round out your knowledge by teaching design and implementation of a data warehouse and deployment of SSIS solutions.
To gain further understanding, you will learn to install, configure, and manage SQL Server 2012 with virtual, hands-on labs that give step-by-step instructions.
Possible Careers Include:
- Database Administrator
- Business Intelligence Analyst
- Computer Systems Analyst
- Database Architect
The Microsoft Certified Solutions Associate (MCSA): SQL Server 2012 program will teach you how to create database objects, like tables and design views. It will also teach you how to create and modify constraints, and create and alter DML triggers.
You will learn to query data using select statements, implement sub-queries and data types, aggregate queries, and manage XML data. Modify data by creating and altering stored procedures, using statements like insert, update, and delete, combining data sets and working with functions. Finally, troubleshoot and optimize SQL Server 2012 by optimizing queries, managing transactions, evaluating row-based operations and implementing error handling.
Learn the steps involved in installing, managing, monitoring and maintaining SQL Servers. You will also explore maintenance and management of the SQL server network and application.
Learn how to design and implement a data warehouse, extract and transform data, load data, configure and deploy SSIS solutions, and build data-quality solutions.
Upon registering, you are given an initial twelve (12) months to complete the program. Should you need more time beyond the twelve (12) months, an extension of six (6) months is available with a fee of $325.
Frequently Asked Questions
1. Can I register for programs if I am an international student?
Yes, because ed2go programs are online you never have to actually travel to the school. Most schools offer telephone or online registration.
2. How long does it take to complete a program?
All of our programs are self-paced and open enrollment, so you can start them when you want and finish them at your own pace. Upon registering, you are given an initial twelve (12) months to complete the program. Should you need more time beyond the twelve (12) months, an extension of six (6) months is available with a fee of $325.
3. Do I have to buy additional materials?
No additional materials are required for this program.
4. Can I get financial assistance?
ed2go courses are non-credit courses, so they do not qualify for federal aid. In some states, vocational rehab or workforce development boards will pay for qualified students to take our courses. Additionally, some students may qualify for financial assistance when they enroll, if they meet certain requirements.
5. What happens when I complete the program?
Upon successful completion of the program, you will be awarded a certificate of completion.
6. Am I guaranteed a job?
ed2go programs will provide you with the skills you need to obtain an entry-level position in most cases. We don’t provide direct job placement services, but our facilitators and career counselors will help you build your resume and are available to give advice on finding your first job. Facilitators will also be available to use as a professional reference upon completion of the program. Potential students should always do research on the job market in their area before registering.
7. Who will be my instructor?
Each student is paired with a facilitator for one-on-one interaction. The facilitator will be available (via e-mail) to answer any questions you may have and to provide feedback on your performance. All of our facilitators are successful working professionals in the fields in which they teach.
8. What software or hardware do I need in order to take online programs and what are the system requirements?
In order to take our online programs, you must have access to a computer and the Internet. You can access the program contents from any Web-enabled computer. You don’t have to use the same computer to log-in to the program every time. We recommend that you have a word-processing program (Microsoft Word is best) and the latest version of Internet Explorer.
9. Can I use a Mac?
Yes, you can use a Mac for this program.
10. How can I get more information about this program?
11. When can I start the program?
Our programs are all open enrollment. You can register and start the program as soon as you are ready.
Please note: Once the program curriculum is accessed online or through submission of a material shipment confirmation, refunds cannot be issued.
12. Does this program lead to a certification?
Yes, this program prepares you to take the MCSA certification exams 70-461, 70-462 and 70-463, which qualify you for the MCSA: SQL Server 2012 Certification. Upon successful completion of this program, you will receive vouchers for these Microsoft exams.
Database Administrators - Employment & Education
Growth in this occupation will be driven by the increased data needs of companies in all sectors of the economy. Database administrators will be needed to organize and present data in a way that makes it easy for analysts and other stakeholders to understand.
|Job Outlook:||11% (Much faster than average)|
|Number of jobs, 2014:||120,000|
|Median pay (May 2016):||$84,950 per year|
|Source: July 20, 2017|