Scribd
Upload
10 views1 page

Roadmap - SH: Postgresql Roadmap Mongodb Roadmap

The document outlines a comprehensive SQL course covering various topics such as relational databases, SQL syntax, data manipulation, advanced functions, and query optimization techniques. It also mentions related roadmaps for PostgreSQL and MongoDB, along with a white paper on achieving consistent deployments. Additional resources include information on data integrity, security, and performance optimization.

Uploaded by

metersdr16
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
10 views1 page

Roadmap - SH: Postgresql Roadmap Mongodb Roadmap

The document outlines a comprehensive SQL course covering various topics such as relational databases, SQL syntax, data manipulation, advanced functions, and query optimization techniques. It also mentions related roadmaps for PostgreSQL and MongoDB, along with a white paper on achieving consistent deployments. Additional resources include information on data integrity, security, and performance optimization.

Uploaded by

metersdr16
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd

PostgreSQL Roadmap Find the detailed version of this

MongoDB Roadmap roadmap and other similar roadmaps

[Link]
SQL
We just launched our premium SQL
course, check it out below

NEW / Premium SQL Course What are Relational Databases?

Learn the Basics RDBMS Benefits and Limitations

SQL Keywords
SQL vs NoSQL Databases

Data Types

Operators Basic SQL Syntax Data Definition Language (DDL)

SELECT INSERT
Truncate Table

DELETE UPDATE Data Manipulation Language (DML)


Alter Table
Statements
Create Table
Select
SUM COUNT Drop Table
FROM WHERE JOINs
AVG MIN
Primary Key
GROUP BY ORDER BY HAVING
MAX Aggregate Queries
Foreign Key
INSERT UPDATE DELETE
GROUP BY
Unique

HAVING
NOT NULL
Data Constraints

CHECK
Scalar Column Row Table Different Types

Nested Subqueries Subqueries JOIN Queries INNER JOIN

Correlated Subqueries LEFT JOIN

RIGHT JOIN
FLOOR ABS MOD
CONCAT LENGTH
Advanced Functions FULL OUTER JOIN
ROUND CEILING
SUBSTRING REPLACE

Numeric Functions Self Join


UPPER LOWER

CASE NULLIF Cross Join


String Functions
Views
COALESCE Managing Indexes
DATE TIME
Creating Views Conditional
Query Optimization
TIMESTAMP
Modifying Views

DATEPART DATEADD
Dropping Views Indexes
Date and Time

Data Integrity Constraints Transaction Isolation Levels

Stored Procedures & Functions Data Integrity & Security Transactions

GRANT and Revoke ACID BEGIN

rank
DB Security Best Practices COMMIT

dense_rank
ROLLBACK
Performance Optimization
lead lag
SAVEPOINT

Row_number

Query Analysis Techniques

Window Functions
Using Indexes

Recursive Queries
Optimizing Joins

Advanced SQL Pivot / Unpivot Operations


Reducing Subqueries

Common Table Expressions


Selective Projection

Dynamic SQL
Query Optimization Techniques

Have a look at the following related roadmaps

Backend PostgreSQL MongoDB Achieving CD White Paper


Fix your inconsistent
deployments. Our white paper
shows how to achieve reliable,
frequent releases.
PARTNER CONTENT

You might also like