تبلیغات

کوئری نویسی در SQL Server 2012 جلسه 3

دسته بندی ها: آموزش SQL Server ، پایگاه داده ، آموزش های یودمی (Udemy)

udemy-70-461-session-3-querying-microsoft-sql-server-2012

در این آموزش تصویری با کوئری نویسی در SQL Server 2012 آشنا می شوید.

مباحث این دوره شش جلسه ای مخصوص آزمون 70-461 است.

در این قسمت جلسه 3 را می توانید دانلود نمایید.

این دوره آموزشی محصول موسسه Udemy است.

سرفصل های این دوره آموزشی:

  • مقدمه
  • ایجاد و اصلاح محدودیت ها
  • تعریف محدودیت ها
  • محدودیت های منحصر به فرد
  • محدودیت های پیش فرض
  • ببرسی محدودیت ها
  • تعداد بازدیدها
  • ساخت view
  • تغییر و حذف view
  • اضافه کردن ردیف جدید به view
  • Indexed چیست؟
  • ایجاد یک Indexed view
  • ایجاد و تغییر محرک های DML
  • به روز رسانی توابع

عنوان دوره: Udemy 70-461 Session 3: Querying Microsoft SQL Server 2012

سطح: مقدماتی

نویسنده: Phillip Burton

مدت دوره: 3.5 ساعت

 توضیحات:

Udemy 70-461 Session 3: Querying Microsoft SQL Server 2012
Building on Sessions 1 and 2, we'll add constraints to data, store SELECT statements in views, and add triggers.

Phillip Burton 3.5 hours Intermediate Level

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.

What are the 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? What am I going to get from this course? 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" What is the target audience? 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.

Section 1: Introduction Lecture 1 Introduction

02:21 Lecture 2 Resources Article Lecture 3 Objectives

02:56 Lecture 4 Summary of and problems with our existing database

05:07 Section 2: Objective 4 - Create and modify constraints (simple statements) Lecture 5 What are constraints? 05:52 Lecture 6 Unique constraints - what are they? 02:57 Lecture 7 Unique constraints in action 10:15 Quiz 1 Unique constraints 3 questions Lecture 8 Default constraints - what are they? 02:42 Lecture 9 Default constraints in action

10:05 Quiz 2 Default constraints 3 questions Lecture 10 Check constraint - what are they? 03:24 Lecture 11 Check constraints - in practice 11:29 Quiz 3 Check constraints 3 questions Lecture 12 Primary key 06:24 Lecture 13 Primary key - in practice 12:12 Quiz 4 Primary Keys 3 questions Lecture 14 Foreign key - what is it? 08:46 Lecture 15 Foreign key - in practice 11:46 Lecture 16 Summary 02:09 Section 3: Objectives 2 and 3: Views Lecture 17 Creating views 09:23 Lecture 18 Altering and dropping views 06:59 Lecture 19 Securing views 05:22 Lecture 20 Security 07:30 Lecture 21 Adding new rows to views

10:59 Lecture 22 Deleting rows in views 03:05 Lecture 23 What is an index? 05:32 Lecture 24 Creating an indexed view 08:23 Section 4: Objective 5: Create and alter DML triggers Lecture 25 What are triggers 05:32 Lecture 26 Creating an AFTER trigger 06:13 Lecture 27 Nested triggers 11:36 Lecture 28 Creating an INSTEAD OF trigger 10:15 Lecture 29 Update functions 11:06 Lecture 30 Handling multiple rows in a session 05:50 Lecture 31 Summary 01:28 Section 5: End of Session 3 Lecture 32 BONUS - Recap, Look ahead and Voucher Code 03:05 Lecture 33 Well done! 01:54

آیا این نوشته را دوست داشتید؟
Udemy 70-461 Session 3 Querying Microsoft SQL Server 2012

پیشنهاد فرادرس

لینک های دانلود حجم فایل: 508.0MB Udemy 70-461 Session 3 Querying Microsoft SQL Server 2012_git.ir.rar