SQL developers, these 15 topics are the most important. Master these and you are ready to ———
➊ Fundamentals
❯ What is a database?
❯ What is DBMS?
❯ What is a relation?
❯ What is RDBMS?
❯ What is SQL?
❯ Different components of SQL
❯ What is a database?
❯ What is DBMS?
❯ What is a relation?
❯ What is RDBMS?
❯ What is SQL?
❯ Different components of SQL
➋ Tables and Fields
❯ What is a Table?
❯ What is a Field?
❯ Create a Table
❯ Modify a table
❯ by adding new fields
❯ by removing existing fields
❯ by modifying existing fields
❯ Drop a Table
❯ What is a Table?
❯ What is a Field?
❯ Create a Table
❯ Modify a table
❯ by adding new fields
❯ by removing existing fields
❯ by modifying existing fields
❯ Drop a Table
➌ Keys and Constraints
❯ Primary Key
❯ Foreign Key
❯ Unique Key
❯ Other types of keys
❯ NOT NULL constraint
❯ DEFAULT value constraint
❯ CHECK constraint
❯ Primary Key
❯ Foreign Key
❯ Unique Key
❯ Other types of keys
❯ NOT NULL constraint
❯ DEFAULT value constraint
❯ CHECK constraint
➍ Normalization and Data Modelling
❯ What is normalization?
❯ What is denormalization?
❯ What are different normalization forms (NF)?
❯ Different types of table relationships
❯ One-to-One
❯ One-to-Many
❯ Many-to-Many
❯ What is normalization?
❯ What is denormalization?
❯ What are different normalization forms (NF)?
❯ Different types of table relationships
❯ One-to-One
❯ One-to-Many
❯ Many-to-Many
➎ Transaction
❯ What is DML?
❯ What are the different DML operations?
❯ What is a transaction?
❯ What is the ACID property?
❯ What is TCL?
❯ How to create a savepoint?
❯ How to rollback the changes?
❯ How to commit the changes?
❯ What is DML?
❯ What are the different DML operations?
❯ What is a transaction?
❯ What is the ACID property?
❯ What is TCL?
❯ How to create a savepoint?
❯ How to rollback the changes?
❯ How to commit the changes?
➏ Query
➤ Projection
➤ Selection (Filtering)
➤ Aggregation
➤ Join
❯ Inner Join
❯ Left Outer
❯ Right Outer
❯ Full Outer
❯ Cross Join
❯ Equijoin
❯ Natural Join
❯ Self Join
❯ Anti Join
❯ Semi Join
➤ Subquery
➤ Set operations
➤ Ordering
➤ Projection
➤ Selection (Filtering)
➤ Aggregation
➤ Join
❯ Inner Join
❯ Left Outer
❯ Right Outer
❯ Full Outer
❯ Cross Join
❯ Equijoin
❯ Natural Join
❯ Self Join
❯ Anti Join
❯ Semi Join
➤ Subquery
➤ Set operations
➤ Ordering
➐ Operators and Functions
➤ Operators
❯ Arithmetic
❯ Logical
❯ Comparison
❯ String
❯ Bitwise
❯ Compound
➤ Functions
❯ String-based
❯ Numeric
❯ Date-based
❯ Comparison
Remember, this is crucial. All these may vary from one database to another.
➤ Operators
❯ Arithmetic
❯ Logical
❯ Comparison
❯ String
❯ Bitwise
❯ Compound
➤ Functions
❯ String-based
❯ Numeric
❯ Date-based
❯ Comparison
Remember, this is crucial. All these may vary from one database to another.
➑ Views
❯ What is a view?
❯ Create a view
❯ Modify a view
❯ Drop a view
❯ What is a materialized view?
❯ Use a view in DML operations
❯ What is a view?
❯ Create a view
❯ Modify a view
❯ Drop a view
❯ What is a materialized view?
❯ Use a view in DML operations
➒ Index
❯ What is an index?
❯ Different types of indexes.
❯ Create an index
❯ How can an index improve performance?
❯ Downsides of an index
❯ What is an index?
❯ Different types of indexes.
❯ Create an index
❯ How can an index improve performance?
❯ Downsides of an index
➓ Sequence
❯ What is a sequence?
❯ Create a sequence
❯ Alter a sequence
❯ Reset a sequence
❯ Generate sequence values
❯ What is a sequence?
❯ Create a sequence
❯ Alter a sequence
❯ Reset a sequence
❯ Generate sequence values
➊➊ Custom Functions and Stored Procedures
❯ What is a function?
❯ Create or modify a custom function
❯ What is a stored procedure?
❯ Create or modify a stored procedure
❯ Different types of parameters
❯ How to invoke?
❯ What is a function?
❯ Create or modify a custom function
❯ What is a stored procedure?
❯ Create or modify a stored procedure
❯ Different types of parameters
❯ How to invoke?
➊➋ Cloning Tables
❯ What is cloning?
❯ Why should we clone?
❯ How to clone a table?
❯ What is cloning?
❯ Why should we clone?
❯ How to clone a table?
➊➌ Temporary Tables
❯ What are temporary tables?
❯ Why should we use these?
❯ How are they created and destroyed?
❯ Are there any performance benefits?
❯ How to use these?
❯ What are temporary tables?
❯ Why should we use these?
❯ How are they created and destroyed?
❯ Are there any performance benefits?
❯ How to use these?
➊➍ Performance Tuning
❯ Given a DML operation, improve its performance
❯ Given a query, improve its performance
❯ How to analyze a query?
❯ Given a DML operation, improve its performance
❯ Given a query, improve its performance
❯ How to analyze a query?
➊➎ Others
❯ Common Table Expressions (CTE)
❯ Triggers
❯ Synonyms
❯ Sharding
❯ Partitioning
❯ Common Table Expressions (CTE)
❯ Triggers
❯ Synonyms
❯ Sharding
❯ Partitioning
Hey 👋
I am a Tech Writer and Educator from 🇮🇳, sharing
❯ Tutorials
❯ Career Tips
❯ Practice Questions
❯ Roadmaps
on
➠ Web Dev
HTML/CSS, JavaScript, Python
➠ DSA
➠ Databases (SQL & NoSQL)
Is this guide useful? Do share your feedback.
I am a Tech Writer and Educator from 🇮🇳, sharing
❯ Tutorials
❯ Career Tips
❯ Practice Questions
❯ Roadmaps
on
➠ Web Dev
HTML/CSS, JavaScript, Python
➠ DSA
➠ Databases (SQL & NoSQL)
Is this guide useful? Do share your feedback.
Loading suggestions...