با مشاهده این دوره ی آموزشی از طریق مثالهای بسیار کاربردی ، به سرعت کار با Microsoft SQL Server را یاد خواهید گرفت.مایکروسافت اس کیو ال سرور (Microsoft SQL Server)‏ یک نرم‌افزار سیستم مدیریت پایگاه داده ها (Data Base) بوده و محیطی را برای مدیران و برنامه نویسان بانک های اطلاعاتی فراهم می کند تا در آن با اطمینان از کارایی، امنیت و پیاده سازی موفقیت آمیز داده ها و اطلاعات، به ساخت و مدیریت پایگاه داده ها و بانک های اطلاعاتی بزرگ بپردازند. از جمله ویژگی های اس کیو ال سرور، بانک اطلاعاتی رابطه‌ای، امکان استفاده از trigger, View, Stored procedure، پشتیبانی از OLAP ،XML، بدون محدودیت حجم و تعداد رکورد، پشتیبانی از FullText Search برای سرعت در بازیابی اطلاعات و استفاده از زبان طبیعی در جستجوها می باشد.

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

سرفصل های این دوره:

  • سرور DBA SQL چیست؟
  • نصب SQL سرور
  • زبان SQL سرور
  • شغل های مختلف DBA
  • ACID
  • نمونه SQL سرور توضیح داده شده
  • نسخه های مختلف از SQL سرور
  • استفاده از خدمات SQL سرور
  • مدیر SQL سرور پیکربندی
  • ایجاد پایگاه داده
  • فایل های پایگاه داده
  • گروه های فایل
  • دستکاری پایگاه داده های
  • اصلاح یک پایگاه داده SQL سرور
  • جدول
  • DML و DDL
  • آناتومی یک عبارت SELECT
  • اصول و مبانی روش های ذخیره شده
  • پارامترها به روش های ذخیره شده
  • و ….

عنوان دوره: Udemy Real World SQL Server From The Ground Up

مدت دوره: 1 ساعت و 30 دقیقه

نویسنده: Mike West

توضیحات:

Udemy Real World SQL Server From The Ground Up

Mike West
1.5 hours


Thanks for being a great inspiration as well, especially taking out your time to compile these courses on Udemy. You do an amazing job!" -- Oochay
Welcome to Real World SQL Server From The Ground Up.
SQL Server is one of the most complicated software offerings Microsoft has.
This builds upon my course "How To Begin Your Career As a SQL Server DBA." If you have't taken it please sign up an take it now. It's FREE!!
This course is my first course filmed entirely in 1080P.
This is the first in a multi-part series of courses on SQL Server Administration.
You need a solid foundation in networking, databases and programming. This wide range of skills is often difficult to obtain without rigorous learning and years of hands on experience.
This course is the first in a two part series that covers much of the foundation of what SQL Server DBAs do and what skills they need to attain in order to excel at their jobs.
All of my courses have a real world on component to them. We will cover the topics in our lectures then apply most of them to real world scenarios.
The REWARDS YOU will OBTAIN are worth the effort. Here are just a few. DBAs are very well compensated. YOU will get to work with some of the SMARTEST people in the IT world. You'll LEARN something EVERY DAY. The profession has been and will continue to be one of the highest growth professions. You'll often get to work remotely.
SQL Server Database Administrators are responsible for the design, implementation, support and maintenance of SQL Server Databases. The role also includes architecting, building and scaling databases for future data growth and capacity.
DBA are also responsible for security, performance and availability of data to users and customers.
This course will give you some direction on how to begin your journey as a SQL Server DBA. I don't want to create any false promises. In addition to years of experience most Senior Level SQL Server resources have read a voluminous amount of product related material.
WE have to start somewhere and THIS COURSE will provide you with the REAL WORLD insight YOU need in order to start your journey.
If YOU are seriously interested in either starting out on the path to becoming a SQL Server Database Administrator the YOU'LL need two key ingredients. Experience and product knowledge. Experience might not be easy to get but it will be impossible if you don't have a very solid foundation in SQL Server.
ENROLL now. Let's get started!!!
What are the requirements?
We will download and install the free version of SQL Server so if you don't have it yet that's ok. I will be covered in the course.
You'll also need a fundamental understanding of computers.
There is no other cost other than the price of the course. Everything else is included or free.
What am I going to get from this course?
Over 44 lectures and 1.5 hours of content!
Learn the sundry paths a SQL Server DBA can take.
Have a path that will lead you to a rewarding career as a SQL Server DBA.
We will download and install the free version of SQL Server so if you don't have it yet that's ok. It will be covered in the course.
What is the target audience?
There are no prerequisites for this course. If you have a basic knowledge of SQL Server then this course is for you.
This course will cover the bare minimum we need for our SQL Servers in a production environment.
Using the collegiate scale as a guide this course will be a 101 level course.


Section 1: What Does a SQL Server DBA Do?
Lecture 1
Course Introduction. What are we going to learn?
01:28
Lecture 2
What Does A Database Do? It's Different Than What It Is.
05:12
Lecture 3
DBA Daily Look
05:41
Lecture 4
Where Do I Install It SQL Server?
00:59
Lecture 5
The Language of SQL Server
06:42
Lecture 6
What Are The Different Jobs A DBA Can Have?
02:12
Lecture 7
What Are The ACID Properties
01:32
Lecture 8
Key Terms
Article
Lecture 9
Summary
Article
Quiz 1
Quiz
10 questions
Section 2: Installing SQL Server
Lecture 10
SQL Server Instances Explained
02:07
Lecture 11
The Various Versions of SQL Server
Article
Lecture 12
The Services SQL Server Uses
Article
Lecture 13
What is Collation
Article
Lecture 14
Stepping Through A Basic Installation
04:37
Lecture 15
The SQL Server Configuration Manager
Article
Lecture 16
Key Terms
Article
Lecture 17
Summary
Article
Quiz 2
Quiz
10 questions
Section 3: Creating Our Database
Lecture 18
Database Files
04:47
Lecture 19
Why Do We Need A Log and Data File?
01:06
Lecture 20
File Groups
03:38
Lecture 21
Key Terms
Article
Lecture 22
Summary
Article
Quiz 3
Quiz
10 questions
Section 4: Manipulating Our Databases
Lecture 23
Detach and Attach. The Fastest Way To Move a SQL Server Database.
03:47
Lecture 24
The States of a Database
03:11
Lecture 25
Modifying A SQL Server Database
04:31
Lecture 26
Key Terms
Article
Lecture 27
Summary
Article
Quiz 4
Section 4 Quiz
10 questions
Section 5: The Table Object
Lecture 28
Table Basics - Part 1
05:17
Lecture 29
Table Basics - Part 2
03:49
Lecture 30
Heap Versus Table With Clustered Index
02:53
Lecture 31
Key Terms
Article
Lecture 32
Summary
Article
Quiz 5
Section 5 Quiz
10 questions
Section 6: Transact-SQL. The Language of SQL Server
Lecture 33
DML and DDL
01:41
Lecture 34
The Anatomy of a SELECT Statement
04:09
Lecture 35
The Big 4
05:14
Lecture 36
Key Terms
Article
Lecture 37
Summary
Article
Quiz 6
Section 6 Quiz
10 questions
Section 7: The Fundamentals of Stored Procedures
Lecture 38
Defining and Creating Our First Stored Procedure
02:47
Lecture 39
Passing Parameters Into Our Stored Procedures
02:32
Lecture 40
What's A Plan?
Article
Lecture 41
Key Terms
Article
Lecture 42
Summary
Article
Quiz 7
Section 7 Quiz
10 questions
Section 8: Conclusion
Lecture 43
Congratulations and Thank you!!!
Article
Lecture 44
Bonus Lecture: What Course Should You Take Next?
Article