SQL Learning Roadmap Post author:anis kchaou Post published:September 13, 2025 Post category:Uncategorized Post comments:0 Comments Post last modified:September 13, 2025 Basic OperationsBasic OperationsComplex QueriesComplex QueriesViewsViewsStored Procedures and FunctionsStored Procedures an…Triggers and EventsTriggers and EventsTransactionsTransactionsIndexesIndexesSecurity and PermissionsSecurity and Permiss…Querying dataQuerying dataModifying dataModifying dataFiltering data Filtering data OperatorsOperatorsSorting and limiting data Sorting and limiting…Aggregate functionsAggregate functionsBEGIN, COMMIT, ROLLBACK BEGIN, COMMIT, ROLLB…Joins (INNER, OUTER, SELF, NATURAL, CROSS) Joins (INNER, OUTER,…Grouping data (GROUP BY, HAVING, ROLLUP)Grouping data (GROUP…SubqueriesSubqueriesadvanced functionsadvanced functionsN+1 problemN+1 problemDataTypesDataTypesDDLDDLPrimary Keys & Foreign KeysPrimary Keys & Forei…viewsviewsString and Date functionsString and Date func…union intersect exceptunion intersect exce…Case StatementCase StatementIndexIndexTriggers & EventsTriggers & Eventsstored procedurestored procedureCommon Table ExpressionCommon Table Express…permission & securitypermission & securityPerformance OptimizationPerformance Optimiza…Partitioning & ShardingPartitioning & Shard…N=1 problemN=1 problemTools & EcosystemTools & EcosystemCloud databasesCloud databasesPopular RDBMSPopular RDBMSMySQL, PostgreSQL, SQL Server, OracleMySQL, PostgreSQL, S…BigQuery, Snowflake, AWS RDS, Azure SQLBigQuery, Snowflake, AWS RDS…sql/nosqlsql/nosqlDifference SQL and NoSQLDifference SQL and N…Types of NoSQL databasesTypes of NoSQL datab…Document DBsDocument DBsMongoDB, CouchDBMongoDB, CouchDBKey-Value StoresKey-Value StoresRedis, DynamoDBRedis, DynamoDBColumn-Family StoresColumn-Family StoresCassandra, HBaseCassandra, HBaseGraph DatabasesGraph DatabasesNeo4j, ArangoDBNeo4j, ArangoDBMongoDB Query LanguageMongoDB Query Langua…Crud OperationsCrud OperationsAggregation & FiltersAggregation & FiltersData modeling in a document storeData modeling in a d…DatawarehouseDatawarehouseExtraction Transform LoadExtraction Transform…TalendTalendSSISSSISApache AirflowApache AirflowStockStockExploitationExploitationPower BIPower BITableauTableauFact TablesFact TablesDimension TablesDimension TablesData LakeData LakevisualisationvisualisationOnline Analytical ProcessingOnline Analytical Pr…AnalyseAnalyseMicrosoft Analysis ServicesMicrosoft Analysis S…Business IntelligenceBusiness IntelligenceDashboard, Graphics,Report Dashboard, Graphics,…Oracle, SQL Server, Amazon Redshift, Snowflake, BigQueryOracle, SQL Server,…Hadoop, Spark, Amazon S3, Azure Data LakeHadoop, Spark, Amazo…Online Transactional ProcessingOnline Transactional…Star SchemaStar SchemaSnowflake SchemaSnowflake SchemaData Build ToolData Build ToolOptimize slow queriesOptimize slow queriesVersion control & migrationsVersion control & mi…Flyway, LiquibaseFlyway, LiquibaseWrite analytics queriesWrite analytics quer…Time-series queriesTime-series queriesAdvanced security (roles, privileges)Advanced security (r…Windowed aggregates for analyticsWindowed aggregates…Query execution plansQuery execution plansIndexing strategiesIndexing strategiesreplicasetsreplicasetsCursorsCursorsCascadesCascadesconceptsconceptsText is not SVG – cannot display You Might Also Like Domain-Driven Design August 19, 2025 Set in Java August 19, 2025 Database version control and migrations September 13, 2025 List in Java August 19, 2025 Front End Learning Roadmap September 13, 2025 Leave a Reply Cancel replyCommentEnter your name or username to comment Enter your email address to comment Enter your website URL (optional) Save my name, email, and website in this browser for the next time I comment.
