{"id":1739,"date":"2022-10-27T10:03:48","date_gmt":"2022-10-27T10:03:48","guid":{"rendered":"https:\/\/cyberstudiesinstitute.co.za\/?post_type=product&#038;p=1739"},"modified":"2023-09-06T06:20:34","modified_gmt":"2023-09-06T06:20:34","slug":"sql-server-2019-database-design","status":"publish","type":"product","link":"https:\/\/cyberstudiesinstitute.co.za\/index.php\/product\/sql-server-2019-database-design\/","title":{"rendered":"SQL Server 2019 Database Design"},"content":{"rendered":"<h3>Overview<\/h3>\n<div>This course focuses on skills necessary to architect well-performing databases in SQL Server.\u00a0 It covers the principles and the practical tools necessary to understand and create all of the objects you would need to have a complete database.\u00a0 This includes a discussion of tables, data integrity, and indexes.\u00a0 As well as basic programming, file storage, and full-text searching. One of the primary benefits of commercial-grade databases is the availability of indexes to speed lookups.\u00a0 You will learn the benefits and the requirements for generating useful indexes in both OLTP (transactional) and OLAP (reporting) databases.\u00a0 Another major benefit of business-focused RDBMS (Relational Database Management Systems) is the use of enforced relationships and constraints.\u00a0 This course will cover all the standard techniques to maintain consistent quality data in your database using referential integrity and various types of automatic data validations.\u00a0 One way of increasing both security and performance in a database is using stored procedures, functions, and triggers.\u00a0 You will learn what each of these objects is and how to write the T-SQL code to generate them.\u00a0 We will also cover the use of SQL Management Studio to perform these various operations using visual tools where possible.\u00a0 At the end of the course, you should be able to create a highly functional business database.<\/div>\n<div><\/div>\n<div>Course Prerequisites<\/div>\n<div><\/div>\n<div>\n<ul>\n<li>Basic knowledge of the Microsoft Windows operating system<\/li>\n<li>Working knowledge of Transact-SQL<\/li>\n<li>Working knowledge of relational databases<\/li>\n<\/ul>\n<\/div>\n<div><\/div>\n<div>In this course, you will learn how to:<\/div>\n<div><\/div>\n<div>\n<ul>\n<li>Design and Implement Tables.<\/li>\n<li>Ensure Data Integrity through Constraints.<\/li>\n<li>Describe indexes, including Optimized and Columnstore indexes<\/li>\n<li>Design and Implement Stored Procedures.<\/li>\n<li>Design and Implement User Defined Functions.<\/li>\n<li>Respond to data manipulation using triggers.<\/li>\n<li>Store and Query Blobs and Text Documents.<\/li>\n<\/ul>\n<div>Instructor: James Ring-Howell<\/div>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p><strong>| Total Course Video Hours: <\/strong>6 Hrs 22 Min<br \/>\n<strong>|\u00a0 Videos:<\/strong> 37<br \/>\n<strong>|\u00a0 Course Access:<\/strong> 12 Months Unlimited Access<br \/>\n<strong>|\u00a0 Study Method:<\/strong> Online Video Lessons<br \/>\n<strong>|\u00a0 Course Type:<\/strong>\u00a0Certificate Course<br \/>\n<strong>|\u00a0 Award:<\/strong> Cyber Studies Institute<\/p>\n","protected":false},"featured_media":1769,"comment_status":"open","ping_status":"closed","template":"","meta":[],"product_brand":[],"product_cat":[38,50,41,52,31],"product_tag":[],"class_list":["post-1739","product","type-product","status-publish","has-post-thumbnail","product_cat-data-administration","product_cat-exam_prep","product_cat-it-developing-networking","product_cat-microsoft","product_cat-development-programming","first","instock","sale","virtual","purchasable","product-type-simple","customify-col"],"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/cyberstudiesinstitute.co.za\/index.php\/wp-json\/wp\/v2\/product\/1739","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/cyberstudiesinstitute.co.za\/index.php\/wp-json\/wp\/v2\/product"}],"about":[{"href":"https:\/\/cyberstudiesinstitute.co.za\/index.php\/wp-json\/wp\/v2\/types\/product"}],"replies":[{"embeddable":true,"href":"https:\/\/cyberstudiesinstitute.co.za\/index.php\/wp-json\/wp\/v2\/comments?post=1739"}],"version-history":[{"count":1,"href":"https:\/\/cyberstudiesinstitute.co.za\/index.php\/wp-json\/wp\/v2\/product\/1739\/revisions"}],"predecessor-version":[{"id":1740,"href":"https:\/\/cyberstudiesinstitute.co.za\/index.php\/wp-json\/wp\/v2\/product\/1739\/revisions\/1740"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/cyberstudiesinstitute.co.za\/index.php\/wp-json\/wp\/v2\/media\/1769"}],"wp:attachment":[{"href":"https:\/\/cyberstudiesinstitute.co.za\/index.php\/wp-json\/wp\/v2\/media?parent=1739"}],"wp:term":[{"taxonomy":"product_brand","embeddable":true,"href":"https:\/\/cyberstudiesinstitute.co.za\/index.php\/wp-json\/wp\/v2\/product_brand?post=1739"},{"taxonomy":"product_cat","embeddable":true,"href":"https:\/\/cyberstudiesinstitute.co.za\/index.php\/wp-json\/wp\/v2\/product_cat?post=1739"},{"taxonomy":"product_tag","embeddable":true,"href":"https:\/\/cyberstudiesinstitute.co.za\/index.php\/wp-json\/wp\/v2\/product_tag?post=1739"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}