InfoTech

  . GETTING STARTED Getting Started SQL BASICS SQL Basics CASE STUDIES Case Study1: Direct Connection From Client Application To SQL Server Android/Java and SQL Server 1 https://tinyurl.com/androidev1 Android/Java and SQL Server 2 https://tinyurl.com/androidev2 The Android/Java and SQL Server case study demonstrates the direct database connection from a client application to the sql server. It is useful for a quick check on the system integration between the client and the server. However it is not recommended for production use due to: (1) Security, and (2) Connection loads. Case Study2: Using The NodeJS-Tedious Console Application To Connect To The SQL Server NodeJS and SQL Server Download sample ZNODES1 and unzip it. The NodeJS and SQL Server case study demonstrates the use of NodeJS application to communicate with the SQL Server. It is useful for developers t...

1  Introduction to PostgreSQL  Getting to know your cluster  Managing Users and Connections  2  Basic Statements  Advanced Statements  Window Functions  3  Server Side Programming  Triggers and Rules  Partitioning  4  Users, Roles and Database Security Transactions,  MVCC, WALs and Checkpoints  Extending the database: the Extension ecosystem  5 Indexes and Performance  Optimization Logging and Auditing  Backup and Restore 1)Introduction 2)Working with PostgreSQL Cluster 3)Managing PostgreSQL Users and Connections 4a)Basic PostgreSQL Statements 1 4b)Basic PostgreSQL Statements 2 5)Advanced PostgreSQL Statements 6)Window Functions 7)Server Side Programming 8)Triggers and Rules 9)Partitioning 10)Users, Roles, and Database Security 11)Transactions, MVCC, WALs, and Checkpoints 12)Extensions 13)Indexes 14)Logs 15)Backups ..