70-461 Session 3: Querying Microsoft SQL Server (T-SQL)

  • Course provided by Udemy
  • Study type: Online
  • Starts: Anytime
  • Price: See latest price on Udemy
Udemy

Course Description

If you are in UfB, welcome.

If you are not, don't buy this course. Instead, please look at my 70-461 Session 1-7: Querying Microsoft SQL Server (SQL code) course instead, which includes this course and 6 other courses.

This course is the foundation for the Microsoft Certificate 70-461: "Querying Microsoft SQL Server 2012".

In Session 1, we learned all about dates, strings and number data types, and in Session 2 we constructed SELECT queries using SELECT, FROM, WHERE, GROUP BY, HAVING and ORDER BY, and JOINing multiple tables together.

We'll now use that data to create views, which enable us to store these SELECT queries for future use, and triggers, which allow for code to be automatically run when INSERTing, DELETEing or UPDATEing data.

We'll look at the database that we developed in session 2, and see what is wrong with it. We'll add some constraints, such as UNIQUE, CHECK, PRIMARY KEY and FOREIGN KEY constraints, to stop erroneous data from being added some data. By doing this, we will complete objectives 2, 3, 4 and 5 from the 70-461 exam.

No prior knowledge other than what we covered in Sessions 1 and 2 is required. However, prior experience with Excel or Access would be beneficial.

There are regular quizzes to help you remember the information.

Once finished, you will know what how to write triggers, views and constraints, and we'll have expanded on our current knowledge of T-SQL.

Who this course is for:

  • This course is for you if want a refresher course in SQL, or are learning SQL for the first time.
  • This course is for you if you are working towards the requirements for exam 70-461, or if you just want to expand your knowledge of T-SQL.
  • If you are starting from the beginning, then you should look at my session 1 or 2 courses before taking this session 3.
  • If you want more advanced topics, then please look at my later sessions.

Expected Outcomes

  1. identify structural problems in databases create UNIQUE, CHECK, PRIMARY KEY, FOREIGN KEY constraints to more to stop erroneous data from being added. create views, to allow for encapsulation of SELECT statements and provide higher security. create triggers, to allow for code to be automatically run after or instead of a DML command. complete objectives 2, 3, 4 and 5 and work towards other objectives from Microsoft Certification 70-461 "Querying Microsoft SQL Server 2012" Curated for the Udemy Business collection Requirements You need to know all about data types and functions. You also need to know about how to create SELECT statements and INSERT, DELETE and UPDATE statements. If you don't, then you should take my Session 1 or Session 2 course first. There is a 30-day money back guarantee of this Udemy course. Why not have a look at the curriculum below and see what you can learn? Description If you are in UfB, welcome. If you are not, don't buy this course. Instead, please look at my 70-461 Session 1-7: Querying Microsoft SQL Server (SQL code) course instead, which includes this course and 6 other courses. This course is the foundation for the Microsoft Certificate 70-461: "Querying Microsoft SQL Server 2012". In Session 1, we learned all about dates, strings and number data types, and in Session 2 we constructed SELECT queries using SELECT, FROM, WHERE, GROUP BY, HAVING and ORDER BY, and JOINing multiple tables together. We'll now use that data to create views, which enable us to store these SELECT queries for future use, and triggers, which allow for code to be automatically run when INSERTing, DELETEing or UPDATEing data. We'll look at the database that we developed in session 2, and see what is wrong with it. We'll add some constraints, such as UNIQUE, CHECK, PRIMARY KEY and FOREIGN KEY constraints, to stop erroneous data from being added some data. By doing this, we will complete objectives 2, 3, 4 and 5 from the 70-461 exam. No prior knowledge other than what we covered in Sessions 1 and 2 is required. However, prior experience with Excel or Access would be beneficial. There are regular quizzes to help you remember the information. Once finished, you will know what how to write triggers, views and constraints, and we'll have expanded on our current knowledge of T-SQL. Who this course is for: This course is for you if want a refresher course in SQL, or are learning SQL for the first time. This course is for you if you are working towards the requirements for exam 70-461, or if you just want to expand your knowledge of T-SQL. If you are starting from the beginning, then you should look at my session 1 or 2 courses before taking this session 3. If you want more advanced topics, then please look at my later sessions. Show more Show less Course content 5 sections • 34 lectures • 3h 32m total length Expand all sections Introduction 5 lectures • 11min Introduction Preview 02:21 Is this your first session? 00:17 Resources 00:11 Objectives Preview 02:56 Summary of and problems with our existing database Preview 05:07 Objective 4 - Create and modify constraints (simple statements) 12 lectures • 1hr 28min What are constraints? 05:52 Unique constraints - what are they? 02:57 Unique constraints in action 10:15 Unique constraints 3 questions Default constraints - what are they? 02:42 Default constraints in action Preview 10:05 Default constraints 3 questions Check constraint - what are they? 03:24 Check constraints - in practice 11:29 Check constraints 3 questions Primary key 06:24 Primary key - in practice 12:12 Primary Keys 3 questions Foreign key - what is it? 08:46 Foreign key - in practice 11:46 Foreign Keys 4 questions Summary 02:09 Objectives 2 and 3: Views 8 lectures • 57min Creating views 09:23 Altering and dropping views 06:59 Creating views 2 questions Securing views 05:22 Security 07:30 Security 3 questions Adding new rows to views Preview 10:59 Deleting rows in views 03:05 Adding and deleting rows in views 3 questions What is an index? 05:32 Creating an indexed view 08:23 Creating an indexed view 1 question Objective 5: Create and alter DML triggers 7 lectures • 52min What are triggers? 05:32 Creating an AFTER trigger 05:45 Creating an INSTEAD OF trigger 11:36 Triggers 4 questions Nested triggers 10:15 Update functions 11:06 Nested triggers and update functions 2 questions Handling multiple rows in a session 05:50 Summary 01:28 End of Session 3 2 lectures • 5min BONUS - Recap, Look ahead and Voucher Code 03:05 Well done! 01:54 Instructor Phillip Burton Best Selling Instructor - over 340,000 students so far 4.5 Instructor Rating 53,162 Reviews 346,028 Students 48 Courses Phillip is a Computing Consultant providing expert services in the development of computer systems and data analysis. He is a Microsoft Certified Technology Specialist. He has also been certified as a Microsoft Certified Solutions Expert for Business Intelligence, Microsoft Office 2010 Master, and as a Microsoft Project 2013 Specialist. He enjoys investigating data, which allows him to maintain up to date and pro-active systems to help control and monitor day-to-day activities. He has also developed expertise and programmes to catalogue and process and control electronic data, large quantities of paper or electronic data for structured analysis and investigation. He is one of 9 award winning Experts for Experts Exchange's 11th Annual Expert Awards and was one of Expert Exchange's top 10 experts for the first quarter of year 2015. His interests are working with data, including Microsoft Excel, Access and SQL Server. Show more Show less Udemy Business Teach on Udemy Get the app About us Contact us Careers Blog Help and Support Affiliate Impressum Kontakt Terms Privacy policy Cookie settings Sitemap © 2021 Udemy, Inc. window.handleCSSToggleButtonClick = function (event) { var target = event.currentTarget; var cssToggleId = target && target.dataset && target.dataset.cssToggleId; var input = cssToggleId && document.getElementById(cssToggleId); if (input) { if (input.dataset.type === 'checkbox') { input.dataset.checked = input.dataset.checked ? '' : 'checked'; } else { input.dataset.checked = input.dataset.allowToggle && input.dataset.checked ? '' : 'checked'; var radios = document.querySelectorAll('[name="' + input.dataset.name + '"]'); for (var i = 0; i (function(){window['__CF$cv$params']={r:'677d2cb99a2a4077',m:'55335329ae2187ea48edb526cd9d270535574d51-1627801073-1800-ASQzcvLetr6ZvpuyjMB2X79+vGDiqpLUQzX260+el3dirlPDkkKupyEbCy08dV+25fv/gkluTBy4/7b8INsoIMoZPXn+mcisQgvdqSa9kKz5ecjjHXOwh43Z34sNHlrKzhHMYR7JBELOVy3/mC3+J/ebZ4MXPKjDriTEuNPcqLG/+PEcS2CTVQ/7b1+DKfew/Q==',s:[0x6eae599d62,0x8e23901d97],}})();
  2. create UNIQUE, CHECK, PRIMARY KEY, FOREIGN KEY constraints to more to stop erroneous data from being added. create views, to allow for encapsulation of SELECT statements and provide higher security. create triggers, to allow for code to be automatically run after or instead of a DML command. complete objectives 2, 3, 4 and 5 and work towards other objectives from Microsoft Certification 70-461 "Querying Microsoft SQL Server 2012" Curated for the Udemy Business collection Requirements You need to know all about data types and functions. You also need to know about how to create SELECT statements and INSERT, DELETE and UPDATE statements. If you don't, then you should take my Session 1 or Session 2 course first. There is a 30-day money back guarantee of this Udemy course. Why not have a look at the curriculum below and see what you can learn? Description If you are in UfB, welcome. If you are not, don't buy this course. Instead, please look at my 70-461 Session 1-7: Querying Microsoft SQL Server (SQL code) course instead, which includes this course and 6 other courses. This course is the foundation for the Microsoft Certificate 70-461: "Querying Microsoft SQL Server 2012". In Session 1, we learned all about dates, strings and number data types, and in Session 2 we constructed SELECT queries using SELECT, FROM, WHERE, GROUP BY, HAVING and ORDER BY, and JOINing multiple tables together. We'll now use that data to create views, which enable us to store these SELECT queries for future use, and triggers, which allow for code to be automatically run when INSERTing, DELETEing or UPDATEing data. We'll look at the database that we developed in session 2, and see what is wrong with it. We'll add some constraints, such as UNIQUE, CHECK, PRIMARY KEY and FOREIGN KEY constraints, to stop erroneous data from being added some data. By doing this, we will complete objectives 2, 3, 4 and 5 from the 70-461 exam. No prior knowledge other than what we covered in Sessions 1 and 2 is required. However, prior experience with Excel or Access would be beneficial. There are regular quizzes to help you remember the information. Once finished, you will know what how to write triggers, views and constraints, and we'll have expanded on our current knowledge of T-SQL. Who this course is for: This course is for you if want a refresher course in SQL, or are learning SQL for the first time. This course is for you if you are working towards the requirements for exam 70-461, or if you just want to expand your knowledge of T-SQL. If you are starting from the beginning, then you should look at my session 1 or 2 courses before taking this session 3. If you want more advanced topics, then please look at my later sessions. Show more Show less Course content 5 sections • 34 lectures • 3h 32m total length Expand all sections Introduction 5 lectures • 11min Introduction Preview 02:21 Is this your first session? 00:17 Resources 00:11 Objectives Preview 02:56 Summary of and problems with our existing database Preview 05:07 Objective 4 - Create and modify constraints (simple statements) 12 lectures • 1hr 28min What are constraints? 05:52 Unique constraints - what are they? 02:57 Unique constraints in action 10:15 Unique constraints 3 questions Default constraints - what are they? 02:42 Default constraints in action Preview 10:05 Default constraints 3 questions Check constraint - what are they? 03:24 Check constraints - in practice 11:29 Check constraints 3 questions Primary key 06:24 Primary key - in practice 12:12 Primary Keys 3 questions Foreign key - what is it? 08:46 Foreign key - in practice 11:46 Foreign Keys 4 questions Summary 02:09 Objectives 2 and 3: Views 8 lectures • 57min Creating views 09:23 Altering and dropping views 06:59 Creating views 2 questions Securing views 05:22 Security 07:30 Security 3 questions Adding new rows to views Preview 10:59 Deleting rows in views 03:05 Adding and deleting rows in views 3 questions What is an index? 05:32 Creating an indexed view 08:23 Creating an indexed view 1 question Objective 5: Create and alter DML triggers 7 lectures • 52min What are triggers? 05:32 Creating an AFTER trigger 05:45 Creating an INSTEAD OF trigger 11:36 Triggers 4 questions Nested triggers 10:15 Update functions 11:06 Nested triggers and update functions 2 questions Handling multiple rows in a session 05:50 Summary 01:28 End of Session 3 2 lectures • 5min BONUS - Recap, Look ahead and Voucher Code 03:05 Well done! 01:54 Instructor Phillip Burton Best Selling Instructor - over 340,000 students so far 4.5 Instructor Rating 53,162 Reviews 346,028 Students 48 Courses Phillip is a Computing Consultant providing expert services in the development of computer systems and data analysis. He is a Microsoft Certified Technology Specialist. He has also been certified as a Microsoft Certified Solutions Expert for Business Intelligence, Microsoft Office 2010 Master, and as a Microsoft Project 2013 Specialist. He enjoys investigating data, which allows him to maintain up to date and pro-active systems to help control and monitor day-to-day activities. He has also developed expertise and programmes to catalogue and process and control electronic data, large quantities of paper or electronic data for structured analysis and investigation. He is one of 9 award winning Experts for Experts Exchange's 11th Annual Expert Awards and was one of Expert Exchange's top 10 experts for the first quarter of year 2015. His interests are working with data, including Microsoft Excel, Access and SQL Server. Show more Show less Udemy Business Teach on Udemy Get the app About us Contact us Careers Blog Help and Support Affiliate Impressum Kontakt Terms Privacy policy Cookie settings Sitemap © 2021 Udemy, Inc. window.handleCSSToggleButtonClick = function (event) { var target = event.currentTarget; var cssToggleId = target && target.dataset && target.dataset.cssToggleId; var input = cssToggleId && document.getElementById(cssToggleId); if (input) { if (input.dataset.type === 'checkbox') { input.dataset.checked = input.dataset.checked ? '' : 'checked'; } else { input.dataset.checked = input.dataset.allowToggle && input.dataset.checked ? '' : 'checked'; var radios = document.querySelectorAll('[name="' + input.dataset.name + '"]'); for (var i = 0; i (function(){window['__CF$cv$params']={r:'677d2cb99a2a4077',m:'55335329ae2187ea48edb526cd9d270535574d51-1627801073-1800-ASQzcvLetr6ZvpuyjMB2X79+vGDiqpLUQzX260+el3dirlPDkkKupyEbCy08dV+25fv/gkluTBy4/7b8INsoIMoZPXn+mcisQgvdqSa9kKz5ecjjHXOwh43Z34sNHlrKzhHMYR7JBELOVy3/mC3+J/ebZ4MXPKjDriTEuNPcqLG/+PEcS2CTVQ/7b1+DKfew/Q==',s:[0x6eae599d62,0x8e23901d97],}})();
  3. create views, to allow for encapsulation of SELECT statements and provide higher security. create triggers, to allow for code to be automatically run after or instead of a DML command. complete objectives 2, 3, 4 and 5 and work towards other objectives from Microsoft Certification 70-461 "Querying Microsoft SQL Server 2012" Curated for the Udemy Business collection Requirements You need to know all about data types and functions. You also need to know about how to create SELECT statements and INSERT, DELETE and UPDATE statements. If you don't, then you should take my Session 1 or Session 2 course first. There is a 30-day money back guarantee of this Udemy course. Why not have a look at the curriculum below and see what you can learn? Description If you are in UfB, welcome. If you are not, don't buy this course. Instead, please look at my 70-461 Session 1-7: Querying Microsoft SQL Server (SQL code) course instead, which includes this course and 6 other courses. This course is the foundation for the Microsoft Certificate 70-461: "Querying Microsoft SQL Server 2012". In Session 1, we learned all about dates, strings and number data types, and in Session 2 we constructed SELECT queries using SELECT, FROM, WHERE, GROUP BY, HAVING and ORDER BY, and JOINing multiple tables together. We'll now use that data to create views, which enable us to store these SELECT queries for future use, and triggers, which allow for code to be automatically run when INSERTing, DELETEing or UPDATEing data. We'll look at the database that we developed in session 2, and see what is wrong with it. We'll add some constraints, such as UNIQUE, CHECK, PRIMARY KEY and FOREIGN KEY constraints, to stop erroneous data from being added some data. By doing this, we will complete objectives 2, 3, 4 and 5 from the 70-461 exam. No prior knowledge other than what we covered in Sessions 1 and 2 is required. However, prior experience with Excel or Access would be beneficial. There are regular quizzes to help you remember the information. Once finished, you will know what how to write triggers, views and constraints, and we'll have expanded on our current knowledge of T-SQL. Who this course is for: This course is for you if want a refresher course in SQL, or are learning SQL for the first time. This course is for you if you are working towards the requirements for exam 70-461, or if you just want to expand your knowledge of T-SQL. If you are starting from the beginning, then you should look at my session 1 or 2 courses before taking this session 3. If you want more advanced topics, then please look at my later sessions. Show more Show less Course content 5 sections • 34 lectures • 3h 32m total length Expand all sections Introduction 5 lectures • 11min Introduction Preview 02:21 Is this your first session? 00:17 Resources 00:11 Objectives Preview 02:56 Summary of and problems with our existing database Preview 05:07 Objective 4 - Create and modify constraints (simple statements) 12 lectures • 1hr 28min What are constraints? 05:52 Unique constraints - what are they? 02:57 Unique constraints in action 10:15 Unique constraints 3 questions Default constraints - what are they? 02:42 Default constraints in action Preview 10:05 Default constraints 3 questions Check constraint - what are they? 03:24 Check constraints - in practice 11:29 Check constraints 3 questions Primary key 06:24 Primary key - in practice 12:12 Primary Keys 3 questions Foreign key - what is it? 08:46 Foreign key - in practice 11:46 Foreign Keys 4 questions Summary 02:09 Objectives 2 and 3: Views 8 lectures • 57min Creating views 09:23 Altering and dropping views 06:59 Creating views 2 questions Securing views 05:22 Security 07:30 Security 3 questions Adding new rows to views Preview 10:59 Deleting rows in views 03:05 Adding and deleting rows in views 3 questions What is an index? 05:32 Creating an indexed view 08:23 Creating an indexed view 1 question Objective 5: Create and alter DML triggers 7 lectures • 52min What are triggers? 05:32 Creating an AFTER trigger 05:45 Creating an INSTEAD OF trigger 11:36 Triggers 4 questions Nested triggers 10:15 Update functions 11:06 Nested triggers and update functions 2 questions Handling multiple rows in a session 05:50 Summary 01:28 End of Session 3 2 lectures • 5min BONUS - Recap, Look ahead and Voucher Code 03:05 Well done! 01:54 Instructor Phillip Burton Best Selling Instructor - over 340,000 students so far 4.5 Instructor Rating 53,162 Reviews 346,028 Students 48 Courses Phillip is a Computing Consultant providing expert services in the development of computer systems and data analysis. He is a Microsoft Certified Technology Specialist. He has also been certified as a Microsoft Certified Solutions Expert for Business Intelligence, Microsoft Office 2010 Master, and as a Microsoft Project 2013 Specialist. He enjoys investigating data, which allows him to maintain up to date and pro-active systems to help control and monitor day-to-day activities. He has also developed expertise and programmes to catalogue and process and control electronic data, large quantities of paper or electronic data for structured analysis and investigation. He is one of 9 award winning Experts for Experts Exchange's 11th Annual Expert Awards and was one of Expert Exchange's top 10 experts for the first quarter of year 2015. His interests are working with data, including Microsoft Excel, Access and SQL Server. Show more Show less Udemy Business Teach on Udemy Get the app About us Contact us Careers Blog Help and Support Affiliate Impressum Kontakt Terms Privacy policy Cookie settings Sitemap © 2021 Udemy, Inc. window.handleCSSToggleButtonClick = function (event) { var target = event.currentTarget; var cssToggleId = target && target.dataset && target.dataset.cssToggleId; var input = cssToggleId && document.getElementById(cssToggleId); if (input) { if (input.dataset.type === 'checkbox') { input.dataset.checked = input.dataset.checked ? '' : 'checked'; } else { input.dataset.checked = input.dataset.allowToggle && input.dataset.checked ? '' : 'checked'; var radios = document.querySelectorAll('[name="' + input.dataset.name + '"]'); for (var i = 0; i (function(){window['__CF$cv$params']={r:'677d2cb99a2a4077',m:'55335329ae2187ea48edb526cd9d270535574d51-1627801073-1800-ASQzcvLetr6ZvpuyjMB2X79+vGDiqpLUQzX260+el3dirlPDkkKupyEbCy08dV+25fv/gkluTBy4/7b8INsoIMoZPXn+mcisQgvdqSa9kKz5ecjjHXOwh43Z34sNHlrKzhHMYR7JBELOVy3/mC3+J/ebZ4MXPKjDriTEuNPcqLG/+PEcS2CTVQ/7b1+DKfew/Q==',s:[0x6eae599d62,0x8e23901d97],}})();
  4. create triggers, to allow for code to be automatically run after or instead of a DML command. complete objectives 2, 3, 4 and 5 and work towards other objectives from Microsoft Certification 70-461 "Querying Microsoft SQL Server 2012" Curated for the Udemy Business collection Requirements You need to know all about data types and functions. You also need to know about how to create SELECT statements and INSERT, DELETE and UPDATE statements. If you don't, then you should take my Session 1 or Session 2 course first. There is a 30-day money back guarantee of this Udemy course. Why not have a look at the curriculum below and see what you can learn? Description If you are in UfB, welcome. If you are not, don't buy this course. Instead, please look at my 70-461 Session 1-7: Querying Microsoft SQL Server (SQL code) course instead, which includes this course and 6 other courses. This course is the foundation for the Microsoft Certificate 70-461: "Querying Microsoft SQL Server 2012". In Session 1, we learned all about dates, strings and number data types, and in Session 2 we constructed SELECT queries using SELECT, FROM, WHERE, GROUP BY, HAVING and ORDER BY, and JOINing multiple tables together. We'll now use that data to create views, which enable us to store these SELECT queries for future use, and triggers, which allow for code to be automatically run when INSERTing, DELETEing or UPDATEing data. We'll look at the database that we developed in session 2, and see what is wrong with it. We'll add some constraints, such as UNIQUE, CHECK, PRIMARY KEY and FOREIGN KEY constraints, to stop erroneous data from being added some data. By doing this, we will complete objectives 2, 3, 4 and 5 from the 70-461 exam. No prior knowledge other than what we covered in Sessions 1 and 2 is required. However, prior experience with Excel or Access would be beneficial. There are regular quizzes to help you remember the information. Once finished, you will know what how to write triggers, views and constraints, and we'll have expanded on our current knowledge of T-SQL. Who this course is for: This course is for you if want a refresher course in SQL, or are learning SQL for the first time. This course is for you if you are working towards the requirements for exam 70-461, or if you just want to expand your knowledge of T-SQL. If you are starting from the beginning, then you should look at my session 1 or 2 courses before taking this session 3. If you want more advanced topics, then please look at my later sessions. Show more Show less Course content 5 sections • 34 lectures • 3h 32m total length Expand all sections Introduction 5 lectures • 11min Introduction Preview 02:21 Is this your first session? 00:17 Resources 00:11 Objectives Preview 02:56 Summary of and problems with our existing database Preview 05:07 Objective 4 - Create and modify constraints (simple statements) 12 lectures • 1hr 28min What are constraints? 05:52 Unique constraints - what are they? 02:57 Unique constraints in action 10:15 Unique constraints 3 questions Default constraints - what are they? 02:42 Default constraints in action Preview 10:05 Default constraints 3 questions Check constraint - what are they? 03:24 Check constraints - in practice 11:29 Check constraints 3 questions Primary key 06:24 Primary key - in practice 12:12 Primary Keys 3 questions Foreign key - what is it? 08:46 Foreign key - in practice 11:46 Foreign Keys 4 questions Summary 02:09 Objectives 2 and 3: Views 8 lectures • 57min Creating views 09:23 Altering and dropping views 06:59 Creating views 2 questions Securing views 05:22 Security 07:30 Security 3 questions Adding new rows to views Preview 10:59 Deleting rows in views 03:05 Adding and deleting rows in views 3 questions What is an index? 05:32 Creating an indexed view 08:23 Creating an indexed view 1 question Objective 5: Create and alter DML triggers 7 lectures • 52min What are triggers? 05:32 Creating an AFTER trigger 05:45 Creating an INSTEAD OF trigger 11:36 Triggers 4 questions Nested triggers 10:15 Update functions 11:06 Nested triggers and update functions 2 questions Handling multiple rows in a session 05:50 Summary 01:28 End of Session 3 2 lectures • 5min BONUS - Recap, Look ahead and Voucher Code 03:05 Well done! 01:54 Instructor Phillip Burton Best Selling Instructor - over 340,000 students so far 4.5 Instructor Rating 53,162 Reviews 346,028 Students 48 Courses Phillip is a Computing Consultant providing expert services in the development of computer systems and data analysis. He is a Microsoft Certified Technology Specialist. He has also been certified as a Microsoft Certified Solutions Expert for Business Intelligence, Microsoft Office 2010 Master, and as a Microsoft Project 2013 Specialist. He enjoys investigating data, which allows him to maintain up to date and pro-active systems to help control and monitor day-to-day activities. He has also developed expertise and programmes to catalogue and process and control electronic data, large quantities of paper or electronic data for structured analysis and investigation. He is one of 9 award winning Experts for Experts Exchange's 11th Annual Expert Awards and was one of Expert Exchange's top 10 experts for the first quarter of year 2015. His interests are working with data, including Microsoft Excel, Access and SQL Server. Show more Show less Udemy Business Teach on Udemy Get the app About us Contact us Careers Blog Help and Support Affiliate Impressum Kontakt Terms Privacy policy Cookie settings Sitemap © 2021 Udemy, Inc. window.handleCSSToggleButtonClick = function (event) { var target = event.currentTarget; var cssToggleId = target && target.dataset && target.dataset.cssToggleId; var input = cssToggleId && document.getElementById(cssToggleId); if (input) { if (input.dataset.type === 'checkbox') { input.dataset.checked = input.dataset.checked ? '' : 'checked'; } else { input.dataset.checked = input.dataset.allowToggle && input.dataset.checked ? '' : 'checked'; var radios = document.querySelectorAll('[name="' + input.dataset.name + '"]'); for (var i = 0; i (function(){window['__CF$cv$params']={r:'677d2cb99a2a4077',m:'55335329ae2187ea48edb526cd9d270535574d51-1627801073-1800-ASQzcvLetr6ZvpuyjMB2X79+vGDiqpLUQzX260+el3dirlPDkkKupyEbCy08dV+25fv/gkluTBy4/7b8INsoIMoZPXn+mcisQgvdqSa9kKz5ecjjHXOwh43Z34sNHlrKzhHMYR7JBELOVy3/mC3+J/ebZ4MXPKjDriTEuNPcqLG/+PEcS2CTVQ/7b1+DKfew/Q==',s:[0x6eae599d62,0x8e23901d97],}})();
  5. complete objectives 2, 3, 4 and 5 and work towards other objectives from Microsoft Certification 70-461 "Querying Microsoft SQL Server 2012" Curated for the Udemy Business collection Requirements You need to know all about data types and functions. You also need to know about how to create SELECT statements and INSERT, DELETE and UPDATE statements. If you don't, then you should take my Session 1 or Session 2 course first. There is a 30-day money back guarantee of this Udemy course. Why not have a look at the curriculum below and see what you can learn? Description If you are in UfB, welcome. If you are not, don't buy this course. Instead, please look at my 70-461 Session 1-7: Querying Microsoft SQL Server (SQL code) course instead, which includes this course and 6 other courses. This course is the foundation for the Microsoft Certificate 70-461: "Querying Microsoft SQL Server 2012". In Session 1, we learned all about dates, strings and number data types, and in Session 2 we constructed SELECT queries using SELECT, FROM, WHERE, GROUP BY, HAVING and ORDER BY, and JOINing multiple tables together. We'll now use that data to create views, which enable us to store these SELECT queries for future use, and triggers, which allow for code to be automatically run when INSERTing, DELETEing or UPDATEing data. We'll look at the database that we developed in session 2, and see what is wrong with it. We'll add some constraints, such as UNIQUE, CHECK, PRIMARY KEY and FOREIGN KEY constraints, to stop erroneous data from being added some data. By doing this, we will complete objectives 2, 3, 4 and 5 from the 70-461 exam. No prior knowledge other than what we covered in Sessions 1 and 2 is required. However, prior experience with Excel or Access would be beneficial. There are regular quizzes to help you remember the information. Once finished, you will know what how to write triggers, views and constraints, and we'll have expanded on our current knowledge of T-SQL. Who this course is for: This course is for you if want a refresher course in SQL, or are learning SQL for the first time. This course is for you if you are working towards the requirements for exam 70-461, or if you just want to expand your knowledge of T-SQL. If you are starting from the beginning, then you should look at my session 1 or 2 courses before taking this session 3. If you want more advanced topics, then please look at my later sessions. Show more Show less Course content 5 sections • 34 lectures • 3h 32m total length Expand all sections Introduction 5 lectures • 11min Introduction Preview 02:21 Is this your first session? 00:17 Resources 00:11 Objectives Preview 02:56 Summary of and problems with our existing database Preview 05:07 Objective 4 - Create and modify constraints (simple statements) 12 lectures • 1hr 28min What are constraints? 05:52 Unique constraints - what are they? 02:57 Unique constraints in action 10:15 Unique constraints 3 questions Default constraints - what are they? 02:42 Default constraints in action Preview 10:05 Default constraints 3 questions Check constraint - what are they? 03:24 Check constraints - in practice 11:29 Check constraints 3 questions Primary key 06:24 Primary key - in practice 12:12 Primary Keys 3 questions Foreign key - what is it? 08:46 Foreign key - in practice 11:46 Foreign Keys 4 questions Summary 02:09 Objectives 2 and 3: Views 8 lectures • 57min Creating views 09:23 Altering and dropping views 06:59 Creating views 2 questions Securing views 05:22 Security 07:30 Security 3 questions Adding new rows to views Preview 10:59 Deleting rows in views 03:05 Adding and deleting rows in views 3 questions What is an index? 05:32 Creating an indexed view 08:23 Creating an indexed view 1 question Objective 5: Create and alter DML triggers 7 lectures • 52min What are triggers? 05:32 Creating an AFTER trigger 05:45 Creating an INSTEAD OF trigger 11:36 Triggers 4 questions Nested triggers 10:15 Update functions 11:06 Nested triggers and update functions 2 questions Handling multiple rows in a session 05:50 Summary 01:28 End of Session 3 2 lectures • 5min BONUS - Recap, Look ahead and Voucher Code 03:05 Well done! 01:54 Instructor Phillip Burton Best Selling Instructor - over 340,000 students so far 4.5 Instructor Rating 53,162 Reviews 346,028 Students 48 Courses Phillip is a Computing Consultant providing expert services in the development of computer systems and data analysis. He is a Microsoft Certified Technology Specialist. He has also been certified as a Microsoft Certified Solutions Expert for Business Intelligence, Microsoft Office 2010 Master, and as a Microsoft Project 2013 Specialist. He enjoys investigating data, which allows him to maintain up to date and pro-active systems to help control and monitor day-to-day activities. He has also developed expertise and programmes to catalogue and process and control electronic data, large quantities of paper or electronic data for structured analysis and investigation. He is one of 9 award winning Experts for Experts Exchange's 11th Annual Expert Awards and was one of Expert Exchange's top 10 experts for the first quarter of year 2015. His interests are working with data, including Microsoft Excel, Access and SQL Server. Show more Show less Udemy Business Teach on Udemy Get the app About us Contact us Careers Blog Help and Support Affiliate Impressum Kontakt Terms Privacy policy Cookie settings Sitemap © 2021 Udemy, Inc. window.handleCSSToggleButtonClick = function (event) { var target = event.currentTarget; var cssToggleId = target && target.dataset && target.dataset.cssToggleId; var input = cssToggleId && document.getElementById(cssToggleId); if (input) { if (input.dataset.type === 'checkbox') { input.dataset.checked = input.dataset.checked ? '' : 'checked'; } else { input.dataset.checked = input.dataset.allowToggle && input.dataset.checked ? '' : 'checked'; var radios = document.querySelectorAll('[name="' + input.dataset.name + '"]'); for (var i = 0; i (function(){window['__CF$cv$params']={r:'677d2cb99a2a4077',m:'55335329ae2187ea48edb526cd9d270535574d51-1627801073-1800-ASQzcvLetr6ZvpuyjMB2X79+vGDiqpLUQzX260+el3dirlPDkkKupyEbCy08dV+25fv/gkluTBy4/7b8INsoIMoZPXn+mcisQgvdqSa9kKz5ecjjHXOwh43Z34sNHlrKzhHMYR7JBELOVy3/mC3+J/ebZ4MXPKjDriTEuNPcqLG/+PEcS2CTVQ/7b1+DKfew/Q==',s:[0x6eae599d62,0x8e23901d97],}})();