Complete Microsoft SQL Server Database Design Masterclass

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

1 - Introduction

1 - Introduction

2 - Understanding Types of Data and Storage

2 - Environment Setup

3 - Download and Install SQL Server Express Windows

4 - Install SQL Server on Mac and Linux

Files.zip

3 - Understanding The Toolset

5 - Explore SQL Server Management Studio

6 - Explore Azure Data Studio

7 - Explore Drawio

4 - Creating And Manipulating Databases

8 - Section Overview

9 - Create Database using Management Studio

10 - Create a Database using SQL Script

11 - How to Remove a Database

12 - How To Change Database Name

13 - Section Review

Files.zip

5 - Managing Tables and Data

14 - What is a Database Table

15 - Create Entity Data Model

16 - Create a Database Table using Management Studio

17 - What is SQL

18 - Create a Database Table using SQL Script

19 - Review Table Creation

20 - Insert Data into the Table using Management Studio

21 - Insert Data into the Table using SQL Scripts

22 - Select Data from Tables Simple Queries

23 - Select Data from Tables Adding Filtering

24 - Select Data from Tables Exporting Data

25 - Update Data in Tables

26 - Delete Data from the Tables

27 - SQL Transactions

28 - Review CRUD Operations

Files.zip

6 - Normalization Relationships and Foreign Keys

29 - What are Relationships Foreign Keys and Normalization

30 - Normalizing Our Database

31 - Creating a Relationship in SQL Server

32 - Inserting Records in One To Many Related Tables

33 - Inserting Records in Many To Many Related Tables

34 - Using Inner Joins To Read Related Data

35 - Understanding Left Right and Full Joins

36 - Foreign Key Cascade Options

37 - Review

Files.zip

7 - Group By and Aggregate Functions

38 - Grouping Data using SQL GROUP BY Clause

39 - SQL COUNT Aggregate Function

40 - SQL AVG Average Aggregate Function

41 - SQL MAX and MIN Aggregate Functions

42 - SQL SUM Aggregate Function

43 - Filtering on Aggregate Values

44 - Aggregate Function Scripts.html

Files.zip

8 - Advanced SQL Server Objects and Concepts

45 - Section Overview

46 - Create and Manage Views

47 - Scalar Valued Functions

48 - Inline Table Valued Functions

49 - Multi Statement Table Valued Functions

50 - Stored Procedures

51 - Table Triggers

52 - Generating Database Scripts

53 - Database Backup and Restore

Files.zip

9 - SQL Server Security

54 - Section Overview

55 - Create an SQL User Login

56 - Add Windows Authenticated Login

57 - Add Server Logins With Script

Files.zip

139,000 تومان

خرید اشتراک افزودن به سبد خرید

خرید دانلودی فوری

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

تولید کننده: Udemy