SQL Roadmap

Step by step guide to learning SQL in 2023

←
Suggest
Using IndexesFROMORDER BYWHEREGROUP BYHAVINGJOINsSQLBasic SQL SyntaxFind the detailed version of this roadmapalong with resources and other roadmapsroadmap.shhttps://SQL keywordsData TypesOperatorsOther Relevant RoadmapsPostgreSQL RoadmapBackend Developer RoadmapStatementsSELECTINSERTUPDATEDELETEIntroductionWhat are Relational Databases?RDBMS Benefits and LimitationsSQL vs NoSQL DatabasesData Definition Language (DDL)Create TableAlter TableTruncate TableData Manipulation Language (DML)SELECTINSERTUPDATEDELETEAggregate QueriesAVGMINMAXSELECTGROUP BYHAVINGData ConstraintsPrimary KeyForeign KeyUniqueNOT NULLCHECKJOIN QueriesINNER JOINLEFT JOINRIGHT JOINFULL OUTER JOINSelf JoinCross JoinSub QueriesScalarColumnRowTableTypes of Sub QueriesNested SubqueriesCorrelated SubqueriesAdvanced SQL FunctionsString FunctionsCONCATLENGTHSUBSTRINGREPLACEUPPERLOWERDate and TimeDATETIMEDATEPARTDATEADDTIMESTAMPNumericFLOORMODABSROUNDCEILINGNULLIFCASECOALESCEConditionalViewsCreating ViewsModifying ViewsDropping ViewsIndexesManaging IndexesQuery OptimizationTransactionsACIDBEGINCOMMITROLLBACKSAVEPOINTTransaction Isolation LevelsData Integrity and SecurityData Integrity ConstraintsGRANT and REVOKEDatabase Security Best PracticesStored Procedures and FunctionsPerformance OptimizationQuery Optimization TechniquesOptimizing JoinsReducing SubqueriesSelective ProjectionQuery Analysis TechniquesAdvanced SQL ConceptsRecursive QueriesPivot and Unpivot OperationsWindow FunctionsRow_numberrankdense_rankleadlagCTEs (Common Table Expressions)Dynamic SQLAlso visit the other relevant roadmaps.PostgreSQL RoadmapBackend RoadmapSUMCOUNT
Related RoadmapsMore →
PostgreSQLStep by step guide to become a PostgreSQL DBA in 2023BackendStep by step guide to becoming a backend developer in 2023DevOpsStep by step guide for DevOps or operations role in 2023

Community

roadmap.sh is the 6th most starred project on GitHub and is visited by hundreds of thousands of developers every month.

253KGitHub Stars Join on Discord

RoadmapsBest PracticesGuidesVideosFAQsYouTube

roadmap.shbyKamran Ahmed

Community created roadmaps, articles, resources and journeys to help you choose your path and grow in your career.

© roadmap.sh ·Terms·Privacy·

ThewNewStack

The leading DevOps resource for Kubernetes, cloud-native computing, and the latest in at-scale development, deployment, and management.

DevOps·Kubernetes·Cloud-Native