Master Microsoft SQL Server 2022

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

A Comprehensive Guide for Database Professionals and Web Developers

1. Introduction

1. Create databases with SQL Server

2. Prerequisites - What you should know

2. Getting Started

1. Core Concepts

2. SQL Server Editions

3. Install SQL Server and Management Studio

4. Enable Feature with Configuration Manager

3. Logging in

1. User Permissions and Authentication

2. Login using Management Studio

3. Enabling System Administrator Account

4. Creating Databases and Tables

1. Creating Database

2. Database Configuration Options

3. Introduction to Tables

4. Tables

5. Alter or Edit Table

6. Insert Data in a Table

7. Importing Data

8. Using SQL Bulk Copy

9. Create Tables from Flat Files

10. Install a sample Database

5. Table Design

1. Data Types

2. SQL Server Data Types

3. Auto assign record identities

4. Primary Key

5. Setting a Default Value

6. Check Constraints

7. Unique Constraints

8. Foreign Keys

9. Create Foreign Keys

10. Create Relationship between Tables

6. Structured Query Language

1. What is SQL - Structured Query Language

2. Types of SQL Statements

3. Introduction to Query Editor

4. Create Table Statement

5. Insert Data Statement

6. Select Statement

7. Filter Records using Where clause

8. Order By Clause

9. Column Aliases

10. Delete Records Statement

11. Update Records Statements

12. Remove Table Records and Table

7. Additional Filter Techniques

1. Limit Results with TOP

2. Remove Duplicates with DISTINCT

3. Comparison Operators

4. Limit Result Set with OFFSET FETCH

5. Understand NULL values

6. Match Text with Like and Wildcards

8. Retrieve Records from Multiple Tables

1. Table joins and relationships

2. Inner Join

3. Left, Right and Full outer join

4. Cross joins

5. Equi or Self Join

9. Groups

1. Understand Record Grouping

2. Use GROUP BY and COUNT

3. Aggregate Functions

4. Explore data with SUM

5. Filter Groups with HAVING

10. Built-in Functions

1. Introduction to Functions

2. String Functions

3. Text Concatenation

4. Mathematical Function

5. Greatest and Least Functions

6. Date Functions

7. Format Function

8. Group Dates

9. NEWID Function

10. Generate Series Function

11. IIF Function

12. Case Statements

11. Writing Efficient Queries

1. USE Keyword

2. Comments

3. Using Rectangular Brackets

4. Views

5. Introduction to Indexes

6. Creating Indexes using T-SQL

7. Exploring Built-in Functions

8. Exploring User Defined Functions

9. Introduction to Stored Procedures

10. Creating Parameterized Stored Procedures

11. Handling NULL Parameters in Stored Procedures

12. Common Table Expressions

13. Transactions in SQL Server

14. Triggers

12. Subqueries

1. Exploring SubQueries

2. Correlated Subqueries

3. PIVOT the result set

13. Variables, Loops, Cursors and Try Catch

1. Create and use variables in a Query

2. Create a counter for a looping statement

3. Cursors

4. Break and Continue

5. Try and Catch

14. Result Set Operators

1. Combine results with Union

2. Return Records with Except and Intersect

15. Cast and Convert

1. Using CAST

2. Using Convert

16. Working with JSON

1. Working With JSON Data

17. Backup and Restore

1. Create Full Backup

2. Create Differential Backup

3. Restore Database using Backup

18. Security

1. Data Encryption

2. Create New User Accounts

3. Database Schema

4. Dynamic Data Masking

5. User Roles and Permissions

19. Monitoring and Management

1. Database Console Commands

2. Dynamic Management Views

3. Role of System Databases

4. Preventing Excessive TempDB autogrowth

5. Review the SQL Server error Log

20. Optimizing SQL Query Performance

1. Seek Vs Scan

2. Statistics Time and IO

3. Spooling

4. Hash Match

5. Key Lookup or Bookmark Lookup

6. Bad Views

7. Sub Queries Minimization

8. Non Sargability

9. Implicit Conversion

10. Parameter Sniffing

11. Understanding Partionting

12. Partition Elimination

13. Dos and Donts

21. Conclusion and Code Download

1.1 Excercise.zip

1. Conclusion and Code Download.html

45,900 تومان

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

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

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

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