{"product_id":"developing-sql-server-2016-databases-20762","title":"Developing SQL Databases Training (20762)","description":"\u003cdiv\u003e\n\u003cp\u003eThis official Microsoft five-day, instructor-led Developing SQL Databases training course provides students with the knowledge and skills to develop a Microsoft SQL Server database. This SQL Server database development course focuses on teaching individuals how to use SQL Server product features and tools related to developing a database.\u003c\/p\u003e\r\n\r\n\u003cp\u003ePlus, get prepped for Microsoft exam 70-762, a requirement for MCSA: SQL 2016 Database Development and MCSE: Data Management and Analytics.\u003c\/p\u003e\r\n\u003c\/div\u003e\u003cdiv\u003e\n\u003ch3\u003eYou Will Learn How To:\u003c\/h3\u003e\n\u003cul\u003e\r\n\t\u003cli\u003eDesign and Implement Tables.\u003c\/li\u003e\r\n\t\u003cli\u003eDescribe advanced table designs\u003c\/li\u003e\r\n\t\u003cli\u003eEnsure Data Integrity through Constraints.\u003c\/li\u003e\r\n\t\u003cli\u003eDescribe indexes, including Optimized and Columnstore indexes\u003c\/li\u003e\r\n\t\u003cli\u003eDesign and Implement Views.\u003c\/li\u003e\r\n\t\u003cli\u003eDesign and Implement Stored Procedures.\u003c\/li\u003e\r\n\t\u003cli\u003eDesign and Implement User Defined Functions.\u003c\/li\u003e\r\n\t\u003cli\u003eRespond to data manipulation using triggers.\u003c\/li\u003e\r\n\t\u003cli\u003eDesign and Implement In-Memory Tables.\u003c\/li\u003e\r\n\t\u003cli\u003eImplement Managed Code in SQL Server.\u003c\/li\u003e\r\n\t\u003cli\u003eStore and Query XML Data.\u003c\/li\u003e\r\n\t\u003cli\u003eWork with Spatial Data.\u003c\/li\u003e\r\n\t\u003cli\u003eStore and Query Blobs and Text Documents.\u003c\/li\u003e\r\n\u003c\/ul\u003e\r\n\u003c\/div\u003e\u003cdiv\u003e\n\u003cul class=\"accordion\"\u003e\r\n\t\u003cli\u003e\r\n\t\u003ch3\u003eOn-Demand Training Description\u003c\/h3\u003e\r\n\r\n\t\u003cdiv\u003e\r\n\t\u003cp\u003eWith a blend of video, text, hands-on labs, and knowledge checks, you will receive the same high quality content as the live event, but you can attend on your own time, at your own pace.\u003c\/p\u003e\r\n\r\n\t\u003cp\u003ePLUS, we include access to a Microsoft Certified Trainer (MCT) to help you prepare for your certification exam and help you apply your new skills immediately… Learning Tree knows how to bring learning to life!\u003c\/p\u003e\r\n\r\n\t\u003cul\u003e\r\n\t\t\u003cli\u003eFlexibility to take the course on your own time, at your own pace\u003c\/li\u003e\r\n\t\t\u003cli\u003eForever access to the digital course materials – for any refreshers\u003c\/li\u003e\r\n\t\t\u003cli\u003eYou will receive a code with your purchase.The code may be redeemed for online access to this On Demand course for up to six months\u003c\/li\u003e\r\n\t\t\u003cli\u003eUpon course activation, the MOC On Demand videos and labs are available for three months\u003c\/li\u003e\r\n\t\t\u003cli\u003e2 FREE hours of individual coaching from an MCT Learning Tree Instructor\u003c\/li\u003e\r\n\t\t\u003cli\u003eThis delivery is also eligible for Microsoft Assurance Training Vouchers (SATVs)\u003c\/li\u003e\r\n\t\t\u003cli\u003e\n\u003cb\u003eNOTE:\u003c\/b\u003e Only live, in-class training is eligible for NASBA CPEs; on-demand training is not eligible for CPE credit\u003c\/li\u003e\r\n\t\u003c\/ul\u003e\r\n\t\u003c\/div\u003e\r\n\t\u003c\/li\u003e\r\n\t\u003cli\u003e\r\n\t\u003ch3\u003eRequirements\u003c\/h3\u003e\r\n\r\n\t\u003cdiv\u003e\r\n\t\u003cul\u003e\r\n\t\t\u003cli\u003eBasic knowledge of the Microsoft Windows operating system and its core functionality\u003c\/li\u003e\r\n\t\t\u003cli\u003eWorking knowledge of Transact-SQL\u003c\/li\u003e\r\n\t\t\u003cli\u003eWorking knowledge of relational databases\u003c\/li\u003e\r\n\t\u003c\/ul\u003e\r\n\t\u003c\/div\u003e\r\n\t\u003c\/li\u003e\r\n\t\u003cli\u003e\r\n\t\u003ch3\u003eMicrosoft Exam Information\u003c\/h3\u003e\r\n\r\n\t\u003cdiv\u003e\r\n\t\u003cp\u003eThis course can help you prepare for the following Microsoft certification exam — \u003ca href=\"https:\/\/www.microsoft.com\/en-us\/learning\/exam-70-762.aspx\" target=\"_blank\"\u003e70-762: Developing SQL Databases\u003c\/a\u003e\u003c\/p\u003e\r\n\t\u003c\/div\u003e\r\n\t\u003c\/li\u003e\r\n\t\u003cli\u003e\r\n\t\u003ch3\u003eRedeem Your Microsoft Training Vouchers (SATV):\u003c\/h3\u003e\r\n\r\n\t\u003cdiv\u003e\r\n\t\u003cul\u003e\r\n\t\t\u003cli\u003eThis course is eligible for Microsoft Software Assurance Training Voucher (SATV) redemption.\u003c\/li\u003e\r\n\t\t\u003cli\u003eWant to learn more about Microsoft SATVs? \u003ca href=\"https:\/\/www.learningtree.com\/tuition\/microsoft-training-vouchers\" target=\"”_blank”\"\u003e\u003cstrong\u003eClick to view our SATVs infographic.\u003c\/strong\u003e\u003c\/a\u003e\n\u003c\/li\u003e\r\n\t\u003c\/ul\u003e\r\n\t\u003c\/div\u003e\r\n\t\u003c\/li\u003e\r\n\u003c\/ul\u003e\r\n\u003c\/div\u003e","brand":"Microsoft","offers":[{"title":"204I28US \/ 2020-04-30T09:00:00 \/ Online","offer_id":31395022798966,"sku":"US-8421","price":895.0,"currency_code":"USD","in_stock":true},{"title":"205G26US \/ 2020-05-31T09:00:00 \/ Online","offer_id":31395022831734,"sku":"US-8421","price":895.0,"currency_code":"USD","in_stock":true},{"title":"207F59US \/ 2020-07-03T09:00:00 \/ Online","offer_id":31395022864502,"sku":"US-8421","price":895.0,"currency_code":"USD","in_stock":true}],"url":"https:\/\/ltreetheta.myshopify.com\/products\/developing-sql-server-2016-databases-20762","provider":"Learning Tree International","version":"1.0","type":"link"}