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

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
  • 139,000 تومان
    بیش از یک محصول به صورت دانلودی میخواهید؟ محصول را به سبد خرید اضافه کنید.
    افزودن به سبد خرید
    خرید دانلودی فوری

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

    ایمیل شما:
    تولید کننده:
    شناسه: 24148
    حجم: 4026 مگابایت
    مدت زمان: 476 دقیقه
    تاریخ انتشار: ۱۲ آذر ۱۴۰۲
    طراحی سایت و خدمات سئو

    139,000 تومان
    افزودن به سبد خرید