InfiniteSkills Microsoft SQL Server 2012 Certification - Exam 70-461
آموزش مدیریت و کارکردن با SQL Server 2012

کاربرد : آموزش مدیریت و کارکردن با SQL Server 2012
نوع فایل : فیلم آموزشی
زبان : انگلیسی
سیستم عامل : Windows-Mac-Linux-Android-iOS
تولید کننده : InfiniteSkills
سال تولید : 2013

توضیحات

با مشاهده این کورس آموزشی بر مدیریت و کارکردن با SQL Server 2012 آشنا شده و استفاده از ویژگیها ، ابزارها و امکانات مختلف آن را به خوبی خواهید . همچنین پس از یادگیری این مجموعه دانش و مهارت لازم برای شرکت در آزمون را نیز به دست خواهید آورد.

Description

In this project-based Microsoft SQL Server 2012 Certification - Exam 70-461 video tutorial series, you'll quickly have relevant skills for real-world applications.
Follow along with our expert instructor in this training course to get:
Concise, informative and broadcast-quality Microsoft SQL Server 2012 Certification - Exam 70-461 training videos delivered to your desktop
The ability to learn at your own pace with our intuitive, easy-to-use interface
A quick grasp of even the most complex Microsoft SQL Server 2012 Certification - Exam 70-461 subjects because they're broken into simple, easy to follow tutorial videos
Practical working files further enhance the learning process and provide a degree of retention that is unmatched by any other form of Microsoft SQL Server 2012 Certification - Exam 70-461 tutorial, online or offline... so you'll know the exact steps for your own projects.

بخش های فایل

این فایل شامل 142 بخش می باشد که بخش های آن به صورت جداگانه در زیر آمده است.

Row	Title	Size
1	01_01-What To Expect From This Course	2.51 MB
2	01_02-Course Overview	3.67 MB
3	01_03-Understanding Databases	9.90 MB
4	01_04-Transact-SQL Basics	10.71 MB
5	01_05-Microsoft SQL Certification	6.09 MB
6	01_06-How To Access Your Working Files	13.16 MB
7	02_01-SQL Server 2012 Evaluation	9.17 MB
8	02_02-SQL Server 2012 Installation	11.32 MB
9	02_03-Windows 8 Server 2012 Interface	6.50 MB
10	02_04-Windows 7 Interface	7.91 MB
11	02_05-SQL Server Sample Database	5.34 MB
12	02_06-Attaching The Sample Database	13.61 MB
13	02_07-Getting Help	14.67 MB
14	02_08-Installing SQL Books Online	16.40 MB
15	03_01-Management Studio Basics	16.43 MB
16	03_02-Connecting To SQL Server	9.73 MB
17	03_03-Customizing SSMS	14.79 MB
18	03_04-Utilizing Diagrams	15.57 MB
19	03_05-Saving Diagrams	8.07 MB
20	03_06-Text And Graphical Tools	12.89 MB
21	03_07-Using Sample Code Files	8.65 MB
22	03_08-About The Semicolon	4.45 MB
23	04_01-What Are Objects	10.50 MB
24	04_02-Understanding Tables	12.46 MB
25	04_03-Understanding Data Integrity	7.23 MB
26	04_04-Understanding Data Types	7.28 MB
27	04_05-Understanding Primary Keys	8.29 MB
28	04_06-Understanding Constraints	6.02 MB
29	04_07-Understanding NULL	6.02 MB
30	04_08-Understanding Views	14.99 MB
31	04_09-Understanding Stored Procedures	9.24 MB
32	04_10-Understanding Triggers	3.44 MB
33	04_11-Understanding Synonyms	7.83 MB
34	05_01-Creating A Table	14.45 MB
35	05_02-Graphical Table Creation	10.22 MB
36	05_03-Changing A Table	14.98 MB
37	05_04-Graphical Table Alterations	14.29 MB
38	05_05-Deleting A Table	11.74 MB
39	05_06-Graphical Table Deletion	9.26 MB
40	05_07-Creating A Primary Key	14.74 MB
41	06_01-Four Basic Queries	4.59 MB
42	06_02-Thinking In SQL	6.06 MB
43	06_03-Options And More Options	6.26 MB
44	06_04-Good Query Structure	6.41 MB
45	06_05-Comments	10.12 MB
46	06_06-The USE Command	7.74 MB
47	06_07-The GO Command	10.51 MB
48	07_01-SELECT Basics	4.65 MB
49	07_02-SELECT Structure	4.74 MB
50	07_03-Using WHERE	11.94 MB
51	07_04-Using TOP To Limit Rows	13.65 MB
52	07_05-Ordering Results	15.51 MB
53	07_06-Working With NULLs	11.44 MB
54	07_07-T-SQL Concatenation	12.02 MB
55	08_01-Column Aliasing	12.07 MB
56	08_02-Using DISTINCT	15.04 MB
57	08_03-Using SUM	11.61 MB
58	08_04-Using AVG	11.94 MB
59	08_05-Using COUNT	15.00 MB
60	08_06-Using Group By	16.42 MB
61	08_07-Using HAVING	11.64 MB
62	08_08-SELECT INTO	12.73 MB
63	08_09-Using LIKE And IN	15.58 MB
64	08_10-Understanding UNION	16.54 MB
65	08_11-INTERSECT And EXCEPT	14.92 MB
66	08_12-Using Synonyms - Part 1	11.47 MB
67	08_13-Using Synonyms - Part 2	9.23 MB
68	08_14-Offset-Fetch	13.39 MB
69	08_15-What Is Ranking	5.83 MB
70	08_16-Using Ranking	16.73 MB
71	08_17-More Ranking Examples	17.44 MB
72	09_01-Understanding Joins	8.36 MB
73	09_02-Join Query Structure	9.21 MB
74	09_03-Creating Inner Joins - Part 1	12.96 MB
75	09_04-Creating Inner Joins - Part 2	11.02 MB
76	09_05-Join Creation Through GUI	14.07 MB
77	09_06-Creating Outer Joins	13.96 MB
78	09_07-Creating Cross Joins	12.18 MB
79	10_01-The INSERT Statement	9.42 MB
80	10_02-Using INSERT - Part 1	17.16 MB
81	10_03-Using INSERT - Part 2	11.35 MB
82	10_04-The UPDATE Statement	11.13 MB
83	10_05-Using UPDATE	13.74 MB
84	10_06-The DELETE Statement	3.42 MB
85	10_07-Using DELETE - Part 1	16.08 MB
86	10_08-Using DELETE - Part 2	8.73 MB
87	11_01-Understanding Subqueries	6.37 MB
88	11_02-Subquery Versus Join	4.58 MB
89	11_03-Creating A Scalar Subquery	9.35 MB
90	11_04-Creating A Multi-Valued Subquery	12.11 MB
91	11_05-Creating A Correlated Subquery	16.05 MB
92	12_01-Utilizing Memory	3.03 MB
93	12_02-What Is A Derived Table	7.19 MB
94	12_03-Creating A Derived Table	16.87 MB
95	12_04-Table Variables - Part 1	12.40 MB
96	12_05-Table Variables - Part 2	15.53 MB
97	12_06-Common Table Expressions	12.95 MB
98	12_07-Temporary Tables	11.30 MB
99	13_01-Programmability In T-SQL	7.49 MB
100	13_02-What Is A Stored Procedure	11.18 MB
101	13_03-Why Use Stored Procedures	5.97 MB
102	13_04-A Simple Stored Procedure	12.92 MB
103	13_05-Input Parameters	13.69 MB
104	13_06-Multiple Input Parameters	9.64 MB
105	13_07-Output Parameters - Part 1	14.08 MB
106	13_08-Output Parameters - Part 2	14.23 MB
107	13_09-Using Case Logic - Part 1	14.01 MB
108	13_10-Using Case Logic - Part 2	13.37 MB
109	13_11-Handling Errors	15.09 MB
110	13_12-Stored Procedure Security	4.90 MB
111	13_13-Working With Functions	3.85 MB
112	13_14-Using Built-In Functions	10.20 MB
113	13_15-Creating A Scalar Function	13.79 MB
114	13_16-Creating A Table Valued Function	11.78 MB
115	13_17-What Is Dynamic SQL	3.89 MB
116	13_18-Dynamic SQL Example	13.98 MB
117	13_19-Understanding GUIDs	5.96 MB
118	13_20-GUID Examples - Part 1	8.75 MB
119	13_21-GUID Examples - Part 2	13.81 MB
120	14_01-Using Triggers	5.68 MB
121	14_02-Inserted And Deleted Tables	4.40 MB
122	14_03-Trigger Examples - Part 1	14.24 MB
123	14_04-Trigger Examples - Part 2	14.50 MB
124	15_01-What Are Transactions	5.32 MB
125	15_02-Understanding Concurrency	7.59 MB
126	15_03-Explicit And Implicit Transactions	4.85 MB
127	15_04-Cross Platform Concerns	3.48 MB
128	15_05-Transaction And Locking Example	19.40 MB
129	16_01-Using Metadata	11.55 MB
130	16_02-Using Catalog Views	16.22 MB
131	16_03-Using Information Schema Views	12.66 MB
132	16_04-Using System Stored Procedures	11.27 MB
133	17_01-XML Basics	6.58 MB
134	17_02-Outputting XML From Queries	5.13 MB
135	17_03-Using FOR XML RAW	19.46 MB
136	17_04-Using FOR XML AUTO	16.45 MB
137	17_05-Using FOR XML PATH	18.05 MB
138	18_01-Optimization Basics	6.66 MB
139	18_02-Query Execution Plans - Part 1	4.52 MB
140	18_03-Query Execution Plans - Part 2	17.42 MB
141	18_04-SQL Server Extended Events - Part 1	3.39 MB
142	18_05-SQL Server Extended Events - Part 2	18.38 MB

شما می توانید مجموعه کامل بخش های این فابل را نیز به صورت مجموعه کامل دریافت نمایید.

اگر شما نسبت به این اثر یا عنوان محق هستید، لطفا از طریق "بخش تماس با ما" با ما تماس بگیرید و برای اطلاعات بیشتر، صفحه قوانین و مقررات را مطالعه نمایید.

دیدگاه کاربران

لطفا در این قسمت فقط نظر شخصی در مورد این عنوان را وارد نمایید و در صورتیکه مشکلی با دانلود یا استفاده از این فایل دارید در صفحه کاربری تیکت ثبت کنید.

(اختیاری)

تعداد کاراکتر مجاز: 1000