Want to be an Expert in SQL in 2024?
Master these 10 key topics:
Master these 10 key topics:
➊ Fundamentals
➀ What is a database and DBMS?
➁ What is a relational database?
➂ What are the different vendors for RDBMS?
➃ What is normalization?
➄ Different normalization forms (NFs).
➅ What is SQL?
➆ Different components of SQL.
➇ What is ERD?
➀ What is a database and DBMS?
➁ What is a relational database?
➂ What are the different vendors for RDBMS?
➃ What is normalization?
➄ Different normalization forms (NFs).
➅ What is SQL?
➆ Different components of SQL.
➇ What is ERD?
➋ Working with database/table
❯ Create a database
❯ Create a table
❯ Alter a table
✧ Add a column
✧ Remove a column
✧ Modify a column
✧ Rename a table
❯ Drop a table
❯ Create a database
❯ Create a table
❯ Alter a table
✧ Add a column
✧ Remove a column
✧ Modify a column
✧ Rename a table
❯ Drop a table
(cont)
❯ Various Datatypes
❯ Constraints
✧ Primary Key
✧ Foreign Key
✧ NOT NULL data
✧ UNIQUE data
❯ Various Datatypes
❯ Constraints
✧ Primary Key
✧ Foreign Key
✧ NOT NULL data
✧ UNIQUE data
➌ Working with data
❯ Insert records
❯ Modify a record
❯ Merge data
❯ Delete a record
❯ Truncate a table
❯ Insert records
❯ Modify a record
❯ Merge data
❯ Delete a record
❯ Truncate a table
➍ Querying the data
❯ SELECT
❯ WHERE clause
❯ Projection
❯ Aggregation
❯ Join
❯ Union, Intersection
❯ Subquerying
❯ Sorting
❯ SELECT
❯ WHERE clause
❯ Projection
❯ Aggregation
❯ Join
❯ Union, Intersection
❯ Subquerying
❯ Sorting
➎ Operators
❯ Arithmetic
❯ Logical
❯ Comparison
❯ String
❯ Bitwise
❯ Compound
❯ Arithmetic
❯ Logical
❯ Comparison
❯ String
❯ Bitwise
❯ Compound
➏ Functions
❯ String-based
❯ Numeric
❯ Date-based
❯ Comparison
✧ Functions vary from vendor to vendor.
❯ String-based
❯ Numeric
❯ Date-based
❯ Comparison
✧ Functions vary from vendor to vendor.
➐ Database objects
❯ View
❯ Materialized View
❯ Index
❯ Sequence
❯ Synonym
❯ Trigger
❯ View
❯ Materialized View
❯ Index
❯ Sequence
❯ Synonym
❯ Trigger
➑ Programming
❯ Stored Procedure
❯ User-defined Functions
❯ Stored Procedure
❯ User-defined Functions
➒ Users and Roles
❯ Create user
❯ Create role
❯ Grant access to a user
❯ Grant access to a role
❯ Revoke access from a user
❯ Revoke access from a role
❯ Drop a role
❯ Drop a user
❯ Create user
❯ Create role
❯ Grant access to a user
❯ Grant access to a role
❯ Revoke access from a user
❯ Revoke access from a role
❯ Drop a role
❯ Drop a user
➓ Advanced Concepts
❯ Binding variables
❯ Temporary tables
❯ Common Table Expressions (CTE)
❯ Regular Expressions
❯ Pivot data
❯ Import data
❯ External tables
❯ Binding variables
❯ Temporary tables
❯ Common Table Expressions (CTE)
❯ Regular Expressions
❯ Pivot data
❯ Import data
❯ External tables
🏁 Final Words
How much time?
⬘ Spend at least two hours per day learning and practicing.
⬙ Overall it should take 6 to 9 months.
What else?
You can also learn a programming language (Python, JavaScript, Java, PHP).
How much time?
⬘ Spend at least two hours per day learning and practicing.
⬙ Overall it should take 6 to 9 months.
What else?
You can also learn a programming language (Python, JavaScript, Java, PHP).
جاري تحميل الاقتراحات...