Technical Books

We are working on the detailed description of this book, we will update this section soon.

This note helps to plan and deploy a highly available data center that uses Microsoft SQL Server 2000 through proper procedures that increase availability, backups help recover from catastrophic disasters, redundant components prevent downtime, and redundant servers minimize downtime.

This book covers the following topics: Troubleshooting Sql Clusters, Backup Fundamentals, Recovery scenarios includes detailed information about the steps taken, areas to watch out for and how previously discussed backup plans and procedures are put to use.

This book is for anyone who has an interest in SQL Server 2014 and wants to understand its capabilities. In this book, we explain how SQL Server 2014 incorporates in-memory technology to boost performance in online transactional processing (OLTP) and data-warehouse solutions.

The contents include: Exactly what is a DBMS, Security Management, Introducing SQL Server Manager System (SSMS), Administrative Tasks, Adding a new user, Changing a password,Re-enabling a locked out account, Granting/Denying Access to a DB, Granting/Denying Access to a Table, Creating a New Database, Deleting a Database, Creating a Table, Quick Tutorial on Data Types, Deleting a Table, Setting the Primary Key, Backing Up the Database, Restoring a Full Backup,Database Indexes Tutorial, Data Encryption.

The contents include:Getting started with Microsoft SQL Server, Data Types, Converting data types, SELECT statement,Alias Names in SQL Server, NULLs, Variables, Dates, Generating a range of dates, Database Snapshots, COALESCE, CASE Statement, INSERT INTO, MERGE, CREATE VIEW, Views, UNION, 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, 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, Sequences, Index, Trigger, Cursors, Transaction isolation levels, Advanced options,Migration, Table Valued Parameters, DBMAIL, Temporal Tables, Use of TEMP Table, Scheduled Task Job, Isolation levels and locking, 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, Spatial Data, Dynamic SQL, Dynamic data masking, Common Language Runtime Integration, Delimiting special characters and reserved words, DBCC, BULK Import, Service broker, Permissions and Security,Database permissions, Encryption.

We are working on the detailed description of this book, we will update this section soon.

We are working on the detailed description of this book, we will update this section soon.

We are working on the detailed description of this book, we will update this section soon.

We are working on the detailed description of this book, we will update this section soon.

This note explains the following topics:Installation, Logging on to an oracle database, Writing programs, Testing programs, Optimizing, Ad hoc SQL, The command window, Creating and modifying non PL or SQL objects, DBMS scheduler, Diagrams, Reports, Graphics, Projects, To do items, The connection list, Connections, Windows, Sessions and transactions, Browsing objects, Browsing files, Preferences, Tools, The editor, The large data editor, The query builder, The PL or SQL clipboard, Templates, Window list, Dockable and floating tools, Ribbons and toolbars, Document interface, Oracle file systems, help systems and customization.

We are working on the detailed description of this book, we will update this section soon.

We are working on the detailed description of this book, we will update this section soon.

We are working on the detailed description of this book, we will update this section soon.

We are working on the detailed description of this book, we will update this section soon.