Salesforce is the world’s leading CRM platform, helping businesses manage customer relationships, sales, and marketing with ease. With powerful tools for automation, analytics, and cloud apps, mastering Salesforce opens career paths in CRM admin, development, consulting, and business analysis.
✅ Salesforce CRM & Cloud Basics
✅ Apex Programming & Triggers
✅ Lightning Components & LWC
✅ Process Automations
✅ Salesforce Workflows
✅ Salesforce Data Management
✅ Integration with External Apps
✅ Security, Roles & Permissions
✅ End-to-End Salesforce Project
✅ 1:1 Mentorship, Resume
Postgre SQL Course Contents:
Module 1: SQL Concepts & DB Design, Queries
Chapter 1: Introduction to Databases
- Database Fundamentals
- Database Objects (Entities)
- Database Management System
- DBMS and RDBMS Concepts
- SQL Server, Oracle, Postgres
- Advantages of Postgres
Chapter 2: Introduction to Postgres
- Overview of PostgreSQL
- History Of PostgreSQL
- Versions and Benefits of PostgreSQL
- PostgreSQL Architecture
- Postgres Installation
- PGAdmin Tool Usage
Chapter 3: SQL Fundamentals – 1
- Introduction to SQL
- DDL Statements
- DML Statements
- DQL Statements
- Basic SQL syntax
- Creating Databases, Tables
- Data Insertions
Chapter 4: SQL Fundamentals – 2
- DDL Statements
- DML Statements
- Data Insertion Types
- Delete Versus Truncate
- Querying data
- SELECT, FROM, WHERE
Chapter 5: SQL Fundamentals – 3
- PostgreSQL Concepts
- DB Design Concepts
- Table Insertion Concepts
- DQL Statements
- PG Admin Tool Usage
Chapter 6: Data Types
- PostgreSQL data types
- integer, string
- date, time, etc.
- Data Types & Sizes
- Selecting Correct Data Type
Chapter 7: Postgres SQL Operators
- Arithmetic Operators
- Comparison Operators
- Logical Operators
- String Operators
- Operators & Operands
- Using Operators in SQL Queries
Chapter 8: Constraints, RDBMS – 1
- Constraints & Validations
- Primary Key Constraint
- Unique Key Constraints
- Foreign Key Constraints
- Null, Not Null Constraints
- Default Constraints
Chapter 9: Normal Forms & RDBMS – 2
- Normal Forms
- 1:M Relationships
- M:1 Relationships
- M:1 Relationships
- Self References
- ER Models
- Auto Increment Columns
Chapter 10: Joins & Queries
- Joins: Table Comparisons
- Inner Joins & Matching Data
- Outer Joins: LEFT, RIGHT
- Full Outer Joins & Aliases
- Cross Join & Table Combination
- Joining more than 2 tables
Chapter 11: Sub Queries
- Sub Query Concept
- Using Sub Queries with Joins
- DISTINCT, UNION
- UNION ALL
- Order By Concept
Chapter 12: Group By Queries in SQL
- Group By, Distinct Keywords
- GROUP BY, HAVING
- Cube( ) and Rollup( )
- Sub Totals & Grand Totals
- Grouping( ) & Usage
- Group By with Joins
Ch 13: Views & Data Analytics
- Views: Realtime Usage
- Storing SELECT in Views
- DML, SELECT with Views
- Using Views with Excel
- Excel Pivot Tables
- Excel Pivot Charts
Ch 14: Tools (psql & pgAdmin) and catalog
- Using psql command line interface (CLI)
- pgAdmin(GUI)
- pg_catalog
- information_schema
Ch 15: Tablespaces
- Tablespace Introduction
- Default Tablespace (pg_default & pg_global)
- Local & Global Tablespaces
- Create/Drop Tablespaces
Ch 16: Indexing and Query Tuning
- Introduction to Indexes
- B-Tree, Hash Indexes
- Indexes Functions, Expressions
- Indexes and Query Tuning Concepts
Ch 17: Introduction to PL/pgSQL
- Overview of PL/pgSQL
- History and evolution of PL/pgSQL
- Features and benefits of PL/pgSQL
- Installing and configuring PL/pgSQL
- Realtime Time Use of PL/pgSQL
Ch 18: PL/pgSQL Basics
- Variables and Data Types
- Operators and Expressions
- Control Structures (IF, LOOP, WHILE)
- Functions and Procedures
Ch 19: PL/pgSQL Functions
- Creating PgSQL Functions
- Function types & Usage
- Scalar, Aggregate Functions
- Window Functions
- Function parameters and return types
Ch 20: PL/pgSQL Stored Procedures
- Procedure types in Postgres
- Functions as Stored Procedures
- Procedure parameters & return types
- Using functions in SQL queries
Ch 21: PL/pgSQL Triggers & Exception Handling
- Creating and managing triggers
- Trigger types (before, after, instead of)
- Using triggers to enforce data integrity
- Understanding exceptions in PL/pgSQL
- Creating and managing exceptions
- Using exceptions to handle errors
Module 2: Postgres Advanced Concepts
Ch 22: Backup and Restore
- Introduction to PostgreSQL Backups
- Backup using pg_dump
- psql utilities
- Restore Concepts
- pg_restore, psql utilities
Ch 23: MVCC (Multi-Version Concurrency Control)
- What is MVCC in PostgreSQL?
- How does MVCC work in PostgreSQL?
- Key Data Structures in MVCC
- Benefits of MVCC in PostgreSQL
- Transaction ID Wraparound
Ch 24: Data Loading & FDW
- Bulk Operations
- Moving, Copying
- Export, Import
- Copy Table
- pgloader
- Foreign Data Wrappers (FDW)
Ch 25: Extensions
- What are Extensions in PostgreSQL?
- Types of Extensions in PostgreSQL
- Examples of Extensions in PostgreSQL
- How to Install/Uninstall Extensions in PostgreSQL
Ch 26: Common Table Expressions (CTE)
- Types of CTEs
- Examples with CTEs
- Query Tuning Concepts
- Benefits of CTEs
- Realtime Use Cases
Module 3: Realtime Project (Banking)
- Project Requirement
- Project Implementation Plan
- Project Solution
- Project FAQs
- Resume Optimization
SQL SCHOOL
24x7 LIVE Online Server (Lab) with Real-time Databases.
Course includes ONE Real-time Project.
#Top Technologies
Who is SQL School? How far you have been in the training services ?
SQL School is a registered training institute, established in February 2008 at Hyderabad, India. We offer Real-time trainings and projects including Job Support exclusively on Microsoft SQL Server, T-SQL, SQL Server DBA and MSBI (SSIS, SSAS, SSRS) Courses. All our training services are completely practical and real-time. CREDITS of SQL School Training Center
- We are Microsoft Partner. ID# 4338151
- ISO Certified Training Center
- Completely dedicated to Microsoft SQL Server
- All trainings delivered by our Certified Trainers only
- One of the few institutes consistently delivering the trainings for more than 20+ Years online as inhouse
- Real-time projects in
- Healthcare
- Banking
- Insurance
- Retail Sales
- Telecom
- ECommerce
I registered for the Demo but did not get any response?
Make sure you provide all the required information. Upon Approval, you should be receiving an email containing the information on how to join for the demo session. Approval process usually takes minutes to few hours. Please do monitor your spam emails also.
Why you need our Contact Number and Full Name for Demo/Training Registration?
This is to make sure we are connected to the authenticated / trusted attendees as we need to share our Bank Details / Other Payment Information once you are happy with our Training Procedure and demo session. Your contact information is maintained completely confidential as per our Privacy Policy. Payment Receipt(s) and Course Completion Certificate(s) would be furnished with the same details.
What is the Training Registration & Confirmation Process?
Upon submitting demo registration form and attending LIVE demo session, we need to receive your email confirmation on joining for the training. Only then, payment details would be sent and slot would be allocated subject to availability of seats. We have the required tools for ensuring interactivity and quality of our services.
Please Note: Slot Confirmation Subject to Availability Of Seats.
Will you provide the Software required for the Training and Practice?
Yes, during the free demo session itself.
How am I assured quality of the services?
We have been providing the Trainings – Online, Video and Classroom for the last 20+ years – effectively and efficiently for more than 100000 (1 lakh) students and professionals across USA, India, UK, Australia and other countries. We are dedicated to offer realtime and practical project oriented trainings exclusively on SQL Server and related technologies. We do provide 24×7 Lab and Assistance with Job Support – even after the course! To make sure you are gaining confidence on our trainings, participans are requested to attend for a free LIVE demo based on the schedules posted @ Register. Alternatively, participants may request for video demo by mailing us to contact@sqlschool.com Registration process to take place once you are happy with the demo session. Further, payments accepted in installments (via Paypal / Online Banking) to ensure trusted services from SQL School™
YES, We use Enterprise Edition Evaluation Editions (Full Version with complete feature support valid for SIX months) for our trainings. Software and Installation Guidance would be provided for T-SQL, SQL DBA and MSBI / DW courses.
Why Choose SQL School
- 100% Real-Time and Practical
- ISO 9001:2008 Certified
- Weekly Mock Interviews
- 24/7 LIVE Server Access
- Realtime Project FAQs
- Course Completion Certificate
- Placement Assistance
- Job Support