Course Code: GES856
Learn about the server’s installation, instance and database configuration, and security manage.
Understand database management and data management.
Cover database monitoring and performance, backups, restores, database snapshots, high availability, and disaster recovery.
Explore integration services including how to best implement, configure, and deploy them.
Manage SSIS packages, reporting service solutions, deploying reporting services and maintaining them.
Understand how to implement analysis service solutions, querying cubes, and managing analysis service solutions.
Chris Lobban has industry experience with an extensive assortment of hardware and software solutions. He has worked both in a help desk environment and as a quality assurance analyst, where he had to deal with an array of hardware requirements, operating systems, and computer programs every day. This broad experience, as well as his formal training as a computer networking and technical support specialist from Seneca College, gives him the foundation needed to provide support to his students. Chris’ credentials include the CompTIA A+, Network+, and Security+ credentials, as well as the Microsoft MCSE (Windows Server 2003), MCSA (Windows Server 2003), MCDST (Windows XP), and MCITP Enterprise Desktop Support Technician (Windows 7) credentials. He has working knowledge and experience with SQL Server. Additionally, he is a Microsoft Certified Trainer (MCT) and a CompTIA Certified Technical Trainer (CTT+).
Students should have one to two years of experience using SQL Server 2008 or two to three years of experience using a previous version of SQL Server.
Two textbooks are included with your tuition:
This program can only be taken on a PC. You will need Internet Explorer version 8 or higher. You will also need Windows XP, Vista, or 7. In addition, you will need Adobe Flash and Adobe Reader.
This program is compatible with Windows 8/ Internet Explorer 10, as long as the following criteria is met:
Yes, because ed2go programs are online you never have to actually travel to the school. Most schools offer telephone or online registration.
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. Most programs allow you 180 days after your register to complete them.
No, all the materials are included.
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.
Upon successful completion of the program, you will be awarded a certificate of completion.
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.
Each student is paired up 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.
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.
No, this program must be taken on a PC.
If you have questions that are not answered on our website, please feel free to contact us via LIVE chat (click the button toward the top of the page). If you are visiting us during non-business hours, please feel free to send us a question using the "Contact Us" form to the right. You may also call us at 1-877-221-5151. We will answer your questions promptly.
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.
The majority of labs can be done using the online lab system. A link to schedule the lab is included with the course for each lab that can be done online.
Yes, this program prepares you to take the MCSA certification exams 70-432 and 70-448, which qualify you for the MCSA: SQL Server 2008 Certification. Upon successful completion of this program, you will receive vouchers for these Microsoft exams.
The time allotted to complete your program has been calculated based on the number of hours for each program, so don't worry too much about not completing in time. If, after a concerted effort, you are still unable to complete, your Student Advisor will help you work out a suitable completion date. Please note that a fee will be charged for an extension.