Udemy_70-461_Session_1_Querying_Microsoft_SQL_Server_2012

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

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

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

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

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

  • مقدمه
  • دانلود SQL Server
  • نصب SQL Server
  • شروع SQL Server
  • نگاهی به SQL Server Management Studio
  • ساخت دیتابیس
  • ایجاد اولین کوئری
  • نوشتن کوئری ریاضی
  • دیتابیس و کوئری
  • ساخت جدول
  • وارد کردن داده با استفاده از GUI
  • واردکردن داده با استفاده از T-SQL
  • بازیابی داده
  • حذف جدول و داده ها
  • حذف جدول با استفاده از T-SQL
  • ایجاد یک جدول خالی
  • ایجاد متغیرهای موقت
  • اعداد صحیح
  • اعداد اعشاری
  • انواع داده و توابع
  • توابع ریاضی
  • انواع داده و توابع رشته ای
  • پیوستن رشته ها به هم
  • پیوستن اعداد به رشته ها
  • انواع اعداد و توابع ریاضی
  • انواع داده های تاریخ
  • تنظیم تاریخ
  • تاریخ امروز
  • تاریخ امروز و توابع تاریخی بیشتر
  • نصب  SQL Server 2016

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

سطح: مقدماتی

نویسنده: Phillip Burton

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

 توضیحات:

Udemy 70-461 Session 1: Querying Microsoft SQL Server 2012
Install SQL Server, learn how to create and drop tables using T-SQL, and data types and functions in detail.

Phillip Burton
4.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. The basics presented are: how to install SQL Server, and how to create and drop tables.

We then try to create a more advanced table, but find that we need to know more about data types - so we go into some detail about data types and data functions, the foundation of T-SQL.

No prior knowledge is required - I'll even show you how to install SQL Server on your computer for free!

There are regular quizzes to help you remember the information.

Once finished, you will know what how to manipulate numbers, strings and dates, and create database and tables, and have an appreciation of how they can all be used in T-SQL.

What are the requirements?
You need to know how to use a computer, and hopefully know how to use a spreadsheet.
No prior knowledge of SQL Server required.
You don't even need SQL Server installed - I'll show you have to install it on your computer for free!
There's a 30-day money back guarantee on this Udemy course.
Why not have a look at the curriculum below and see what you can learn? If you already know them, please see my later sessions.
What am I going to get from this course?
create, alter and drop tables in a database.
know what data type to use in various situations.
use functions to manipulate date, number and string data values.
work towards objectives 1 and 8 from Microsoft Certification 70-461 "Querying Microsoft SQL Server 2012"
What is the target audience?
This SQL course is meant for you, if you have not used SQL Server much (or at all), and want to start to learn T-SQL.
This course is also for you if you want a refresher on SQL. However, no prior SQL Server knowledge is required.
If you already know all this, and want to learn about more advanced topics, please see my later sessions.

Section 1: Let's begin, and let's download SQL Server
Lecture 1
Introduction

02:23
Lecture 2
Curriculum

08:54
Lecture 3
Downloading SQL Server

07:22
Lecture 4
Installing SQL Server

07:07
Section 2: Starting SQL Server
Lecture 5
Opening SQL Server

03:01
Lecture 6
Looking at SQL Server Management Studio
04:45
Lecture 7
Create a database
01:41
Lecture 8
Creating our first queries
06:08
Lecture 9
Practice Activity Number 1 - Writing mathematical queries
Article
Quiz 1
Databases and Queries
2 questions
Section 3: Creating tables - First pass
Lecture 10
Creating a table - first pass using GUI
02:10
Lecture 11
Creating a table - first pass using T-SQL
02:58
Quiz 2
New Tables
2 questions
Lecture 12
Entering data using the GUI
02:30
Lecture 13
Entering data using T-SQL
04:48
Quiz 3
Entering data using T-SQL
1 question
Lecture 14
Retrieving data

04:33
Quiz 4
Retrieving data
1 question
Lecture 15
Deleting the data, then the table
03:08
Quiz 5
Deleting data using T-SQL
2 questions
Lecture 16
Practice Activity Number 2
Article
Section 4: Number types and functions
Lecture 17
Creating an Employee table
04:27
Lecture 18
Resources
Article
Lecture 19
Creating temporary variables
11:45
Lecture 20
Integer numbers
07:47
Quiz 6
Integer numbers
5 questions
Lecture 21
Practice Activity Number 3

Article
Lecture 22
Non-integer numbers
15:09
Quiz 7
Non-integer numbers
3 questions
Lecture 23
Mathematical functions
12:38
Quiz 8
Mathematical functions
2 questions
Lecture 24
Converting between number types
08:41
Quiz 9
Converting between number types
1 question
Section 5: String data types and functions
Lecture 25
Strings
15:43
Quiz 10
Strings
2 questions
Lecture 26
String Functions - extraction

07:15
Quiz 11
String Functions - extraction
2 questions
Lecture 27
NULL - an introduction
09:17
Lecture 28
Joining two strings or a string and number together
11:49
Quiz 12
NULL
2 questions
Lecture 29
Joining a string to a number
08:46
Quiz 13
Joining numbers to strings
2 questions
Section 6: Date data types and functions
Lecture 30
Date data types
07:45
Lecture 31
Setting dates and Date extraction
06:23
Quiz 14
Date data types
3 questions
Lecture 32
Today's date, and more date functions

07:49
Quiz 15
Today's date and more date functions
2 questions
Lecture 33
Date offset
09:47
Lecture 34
Converting from dates to strings
09:53
Quiz 16
Converting from date to strings
1 question
Section 7: End of session 1
Lecture 35
BONUS - Recap, Look ahead and save money on your next course
03:38
Lecture 36
Well done!

01:46
Section 8: Bonus - Installing SQL Server 2016 Developer Edition
Lecture 37
Downloading SQL Server back engine - the Developer edition - for free!

07:50
Lecture 38
Installing SQL Server back engine

13:49
Lecture 39
Installing SQL Server Front Engine

12:34
Lecture 40
The next step
Article