دانلود Udemy Learn SQL with Microsoft SQL Server

پیش نیازها:

• هیچ مهارت برنامه نویسی لازم برای گذراندن این دوره وجود ندارد
• هیچ نرم افزار خاصی برای این دوره مورد نیاز نیست ، ما نسخه آزمایشی 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!