پیش نیازها:
- هیچ مهارت برنامه نویسی لازم برای گذراندن این دوره وجود ندارد
- هیچ نرم افزار خاصی برای این دوره مورد نیاز نیست ، ما نسخه آزمایشی Miscrosoft SQL Server را دانلود می کنیم
این دوره برای چه کسی است؟
- این دوره برای مبتدیان است که می خواهند درباره بانکهای اطلاعاتی و SQL برای Microsoft SQL Server اطلاعات کسب کنند
- هر کسی که می خواهد SQL را یاد بگیرد
- هرکسی که می خواهد بانک اطلاعات را بیاموزد

در ادامه با برخی از سرفصل های درسی این مجموعه آموزش آشنا می شویم :
Course content
Introduction
First Things First: How To Get Support Fast!
Database Concepts
Data Types
Installation and Setup
Download and Install SQL Server
SQL Server Download Update
Download and Install SSMS
Connect To Server
System Databases
Creating a Database and Table
Adding Data To A Table
Structured Query Language - SQL
Intro To SQL
Select Statements
Where Clause
And or Not
Order By
Group By
The Having Clause
The Top Clause
Select Distinct
Union
Functions
Insert Statement
Update Statement
Delete Statement
Alter Table
Null
Creating A Table
Drop Table
Primary Key
Intro To Joining Tables
Inner Join
Left, Right, and Outer Join
Indexing
Conclusion - Bonus Lecture
In this course I'll teach you Structured Query Language - SQL for short - the fast and easy way.
We'll download and use the free trial version of Microsoft SQL Server and I'll teach you exactly how to use it like a pro.
Databases are incredibly important in our modern world, and they remain a mystery to most people. But they're actually pretty easy to use if you know just a few things...and I'll teach you those things in this course.
We'll start out by learning fundamental database concepts, like... what is a database, what is a table, what are rows and columns, and what are data types.
After that I'll show you how to set up and use Microsoft SQL Server.
Then we'll dive right in to SQL itself. I'll teach you basic concepts like
- Select Statements
- Where, And or Not
- How to Order and Group By
- And cool things like that.
Then we'll move into slightly more difficult concepts like
- Having and Top Clauses
- Select Distinct
- Union
- And Functions
Then we'll jump into more advanced concepts like
- Insert and Update Statements
- Deleting and Altering Tables
- Joining Tables
- Primary Keys
- Indexing
- And more!