{"@id":"https://credentialengineregistry.org/resources/ce-3d897a01-d5ed-4f36-8707-6c3c7772e0ba","@type":"ceterms:CertificateOfCompletion","@context":"https://credreg.net/ctdl/schema/context/json","ceterms:ctid":"ce-3d897a01-d5ed-4f36-8707-6c3c7772e0ba","ceterms:name":{"en-us":"GES854 Microsoft Certified Solutions Associate (MCSA): SQL Server 2012 (Voucher Included)"},"ceterms:keyword":{"en-us":["MCSA","SQL Server 2012"]},"ceterms:ownedBy":["https://credentialengineregistry.org/resources/ce-f5e36f0f-c6f9-4733-b7d0-91751e5b7754"],"ceterms:requires":[{"@type":"ceterms:ConditionProfile","ceterms:name":{"en-us":"Requirements"},"ceterms:description":{"en-us":"Students should have a basic understanding of how to use a computer, in addition to basic networking skills. These skills can be learned in programs such as CompTIA A+ and Network+. This program can be taken on a Mac or a PC. On a PC, it is compatible with Windows XP and later operating systems and IE 7 and later browsers. On a Mac, the program is compatible with Mac OS X 10.6 and later operating systems, Firefox, Chrome, and Safari 5.1.9 or later browsers. Mac users must have BootCamp working with a compatible Windows OS, or another method to simulate a Windows OS for the duration of their enrollment. We highly recommend that you use Chrome and Firefox in place of other web browsers. Adobe Flash Player and Adobe Acrobat Reader are required for this program. To complete the labs, you must install and configure VirtualBox (instructions provided in program): VirtualBox runs on most 32-bit or 64-bit operating systems, 6 GB of RAM is recommended, 4 is the minimum,10 GB of Hard Drive space is recommended. Upon registering you will receive the following materials: Querying Microsoft SQL Server 2012 (70-461 Training Kit)Administering Microsoft SQL Server 2012 Databases (70-462 Training Kit)Implementing a Data Warehouse with Microsoft SQL Server 2012 (70-463 Training Kit)."}}],"ceterms:inLanguage":["en-US"],"ceterms:description":{"en-us":"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. 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. 70-461: Querying Microsoft SQL Server 201270-462: Administering Microsoft SQL Server 2012 Databases. 70-463: Implementing a Data Warehouse with Microsoft SQL Server 2012. 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 datasets, 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."},"ceterms:subjectWebpage":"http://careertraining.ed2go.com/southced","ceterms:estimatedDuration":[{"@type":"ceterms:DurationProfile"}],"ceterms:credentialStatusType":{"@type":"ceterms:CredentialAlignmentObject","ceterms:framework":"http://credreg.net/ctdl/terms/CredentialStatus","ceterms:targetNode":"credentialStat:Active","ceterms:frameworkName":{"en-us":"CredentialStatus"},"ceterms:targetNodeName":{"en-US":"Active"}},"ceterms:learningDeliveryType":[{"@type":"ceterms:CredentialAlignmentObject","ceterms:framework":"http://credreg.net/ctdl/terms/Delivery","ceterms:targetNode":"deliveryType:InPerson","ceterms:frameworkName":{"en-us":"Delivery"},"ceterms:targetNodeName":{"en-US":"In-Person Only"}},{"@type":"ceterms:CredentialAlignmentObject","ceterms:framework":"http://credreg.net/ctdl/terms/Delivery","ceterms:targetNode":"deliveryType:OnlineOnly","ceterms:frameworkName":{"en-us":"Delivery"},"ceterms:targetNodeName":{"en-US":"Online Only"}}]}