امن افزار رایکا

فهرست مطالب کتاب Microsoft SQL Server Notes for Professionals:

Getting started with Microsoft SQL Server

Data Types

Converting data types

User Defined Table Types

SELECT statement

Alias Names in SQL Server

NULLs

Variables

Dates

Generating a range of dates

Database Snapshots

COALESCE

..ELSE

CASE Statement

INSERT INTO

MERGE

CREATE VIEW

Views

UNION

TRY/CATCH

WHILE loop

OVER Clause

GROUP BY

ORDER BY

The STUFF Function

JSON in SQL Server

OPENJSON

FOR JSON

Queries with JSON data

Storing JSON in SQL tables

Modify JSON text

FOR XML PATH

Join

cross apply

Computed Columns

Common Table Expressions

Move and copy data around tables

Limit Result Set

Retrieve Information about your Instance

With Ties Option

String Functions

Logical Functions

Aggregate Functions

String Aggregate functions in SQL Server

Ranking Functions

Window functions

PIVOT / UNPIVOT

Dynamic SQL Pivot

Partitioning

Stored Procedures

Retrieve information about the database

Split String function in SQL Server

Insert

Primary Keys

Foreign Keys

Last Inserted Identity

SCOPE_IDENTITY()

Sequences

Index

Full-Text Indexing

Trigger

Cursors

Transaction isolation levels

Advanced options

Migration

Table Valued Parameters

DBMAIL

In-Memory OLTP (Hekaton)

Temporal Tables

Use of TEMP Table

Scheduled Task or Job

Isolation levels and locking

Sorting/ordering rows

Privileges or Permissions

SQLCMD

Resource Governor

File Group

Basic DDL Operations in MS SQL Server

Subqueries

Pagination

CLUSTERED COLUMNSTORE

Parsename

Installing SQL Server on Windows

Analyzing a Query

Query Hints

Query Store

Querying results by page

Schemas

Backup and Restore Database

Transaction handling

Natively compiled modules (Hekaton)

Spatial Data

Dynamic SQL

Dynamic data masking

Export data in txt file by using SQLCMD

Common Language Runtime Integration

Delimiting special characters and reserved words

DBCC

BULK Import

Service broker

Permissions and Security

Database permissions

Row-level security

Encryption

PHANTOM read

Filestream

bcp (bulk copy program) Utility

SQL Server Evolution through different versions (2000 – 2016)

SQL Server Management Studio (SSMS)

Managing Azure SQL Database

System database – TempDb

Microsoft SQL Server Management Studio Shortcut Keys

فهرست مطالب کتاب MATLAB Notes for Professionals:

Getting started with MATLAB Language

Initializing Matrices or arrays

Conditions

Functions

Set operations

Documenting functions

Using functions with logical output

For loops

Object-Oriented Programming

Vectorization

Matrix decompositions

Graphics: 2D Line Plots

Graphics: 2D and 3D Transformations

Controlling Subplot coloring in MATLAB

Image processing

Drawing

Financial Applications

Fourier Transforms and Inverse Fourier Transforms

Ordinary Differential Equations (ODE) Solvers

Interpolation with MATLAB

Integration

Reading large files

Usage of `accumarray()` Function

Introduction to MEX API

Debugging

Performance and Benchmarking

Multithreading

Using serial ports

Undocumented Features

MATLAB Best Practices

MATLAB User Interfaces

Useful tricks

Common mistakes and errors