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

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

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

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

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

  • ایجاد بخشی از یک جدول
  • ساخت جدول tblEmployee
  • اضافه کردن ستون های جدول
  • داده های Spreadsheet
  • Summarising و داده های سفارشی
  • اضافه کردن جدول دوم
  • طراحی اتصال
  • داده های spreadsheet جدید
  • وارد کردن داده ها و نمایش جداول گرافیکی
  • نوشتن JOIN query
  • انواع مختلف JOIN
  • ایجاد جدول سوم
  • پیوستن سه جدول
  • یافتن داده های گم شده و حذف و به روز رسانی داده ها
  • از بین رفتن داده ها
  • حذف داده ها
  • به روز رسانی داده ها

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

سطح: مقدماتی

نویسنده: Phillip Burton

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


Udemy 70-461 Session 2: Querying Microsoft SQL Server 2012
Learn about SQL Server tables, SELECT statements (FROM, WHERE, GROUP BY etc), JOIN tables, and INSERT/DELETE/UPDATE data

Phillip Burton
3.5 hours
Beginner Level

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

Rather than present one huge course, this course takes some of the basics and then goes in depth.

In session 1 we learnt all about dates, strings and number data types and functions in some detail.

We'll create tables which use these, and then INSERT some data into them. Then we'll write queries which will retrieve and summary this data, using SELECT, FROM, WHERE, GROUP BY, HAVING and ORDER BY.

We'll then JOIN these tables together to find where we are missing data and where we have inconsistent data. We'll then UPDATE and DELETE data from the tables. This will allow up to fully complete objective number 1 from the 70-461 exam.

If this sounds too basic, then please look at my other sessions.

The only prior knowledge which is required for Session 2 is that which has been taught in Session 1.

There are regular quizzes to help you remember the information.

Once finished, you will know what how to create tables, insert data and create analyses, and have an appreciation of how they can all be used in T-SQL.

What are the requirements?
You need to know all about data types and functions. If you don't, you should take the Session 1 course first.
You should also know how to open SSMS.
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?
create tables in a database
ALTER columns in the table.
retrieve data using SELECT, FROM, WHERE, GROUP BY, HAVING and ORDER BY.
JOIN two or more tables together, finding missing data.
INSERT new data, UPDATE and DELETE existing data, and export data INTO a new table.
complete objective 1, 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.
If you are starting from the beginning, then you should look at my session 1 course before taking this session 2.
If you want more advanced topics, then please look at my later sessions.

Section 1: Welcome to Session 2
Lecture 1

Section 2: Creating and querying part of a table
Lecture 2
Lecture 3
Creation of tblEmployee table
Lecture 4
Adding additional columns
Lecture 5
Spreadsheet Data
Lecture 6
SELECTing only part of a table - strings
Quiz 1
SELECTing only part of a table - strings
2 questions
Lecture 7
SELECTing only part of a table - numbers

Quiz 2
SELECTing only part of a table - numbers
3 questions
Section 3: Summarising and ordering data
Lecture 8
Summarising and ordering data
Quiz 3
Summarising and ordering data
2 questions
Lecture 9
Criteria on summarised data
Quiz 4
Criteria on summarised data
4 questions
Lecture 10
Section 4: Adding a second table
Lecture 11
Adding a second table
Lecture 12
Designing a connection
Lecture 13
New spreadsheet data
Lecture 14
Importing data and showing tables graphically
Lecture 15
Writing a JOIN query
Quiz 5
Writing a JOIN query
2 questions
Lecture 16
Different types of JOIN
Quiz 6
Different types of JOIN
3 questions
Lecture 17
Creating a third table
Lecture 18
JOINing three tables

Quiz 7
JOINing three tables
1 question
Section 5: Find missing data, and delete and update data
Lecture 19
Missing data
Quiz 8
Missing data
1 question
Lecture 20
Deleting data
Quiz 9
Deleting data
3 questions
Lecture 21
Updating data
Quiz 10
Updating data
2 questions
Section 6: End of Session 2
Lecture 22
BONUS - Recap, Look ahead and Voucher Code
Lecture 23
Thank you