{"@id":"https://credentialengineregistry.org/resources/ce-d50ba97d-fe96-4007-a63c-2f2783870e77","@type":"ceterms:CertificateOfCompletion","@context":"https://credreg.net/ctdl/schema/context/json","ceterms:ctid":"ce-d50ba97d-fe96-4007-a63c-2f2783870e77","ceterms:name":{"en-us":"GES835 Microsoft Certified Solutions Associate (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":"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.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 systems6 GB of RAM is recommended, 4 is the minimum 10 GB of Hard Drive space is recommendedUpon 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). 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+."}}],"ceterms:inLanguage":["en-US"],"ceterms:availableAt":[{"@type":"ceterms:Place","ceterms:name":{"en-us":"Seattle"},"ceterms:latitude":47.547708,"ceterms:longitude":-122.3527083,"ceterms:postalCode":"98106-1499","ceterms:addressRegion":{"en-us":"WA"},"ceterms:streetAddress":{"en-us":"6000 16th Avenue SW"},"ceterms:addressLocality":{"en-us":"Seattle"}}],"ceterms:description":{"en-us":"The Microsoft Certified Solutions Associate (MCSA): SQL Server 2012 program enables you to take your professional database career to a new level. This program validates the primary set of SQL Server 2012 skills, relevant across multiple solution areas in business environments. You will prepare to manage a database environment as a database developer and as a database analyst With the MCSA: SQL Server 2012 certification, you can deliver more business value to your organization. This program prepares you for the standards set forth by Microsoft for earning the MCSA: SQL Server 2012 Certification and prepares you to take the Microsoft 70-461, 70-462, and 70-463 certification exams. Upon passing all three exams, you will receive the MCSA: SQL Server 2012 Certification. In this program, you will learn to install, configure, and manage SQL Server 2012 with hands-on labs that give step-by-step instructions. The applied learning labs prepare you to walk into an interview with marketable skills. Upon completion of this program, you will be able to do the following: Create Database Objects. Maintain instances and databases. Install, Configure, Optimize, and troubleshoot. Manage, modify, extract, and load data. Implement security and high availability. Design and implement a data warehouse. Configure and deploy SSIS solutions. Build data quality solutions. You\u0026rsquo;ll also be prepared to take the following Microsoft exams: 70-461: Querying Microsoft SQL Server 2012; 70-462: Administering Microsoft SQL Server 2012 Databases; 70-463: Implementing a Data Warehouse with Microsoft SQL Server 2012. The 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"}}]}