I am using SQL since 2004.
If I have to start learning it today, I'll do this:
If I have to start learning it today, I'll do this:
Beginner
⭣ Learn fundamentals ➊
⭣ Working with table ➋
⭣ Working with data ➌
⭣ Querying the data ➍
⭣ Operators ➎
⭣ Functions ➏
⭣ Database objects ➐
⭣ Programming in SQL ➑
⭣ Users and Roles ➒
⭣ Advanced Concepts ➓
Pro
⭣ Learn fundamentals ➊
⭣ Working with table ➋
⭣ Working with data ➌
⭣ Querying the data ➍
⭣ Operators ➎
⭣ Functions ➏
⭣ Database objects ➐
⭣ Programming in SQL ➑
⭣ Users and Roles ➒
⭣ Advanced Concepts ➓
Pro
➊ Learn 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
❯ Various Datatypes
❯ Constraints
❯ Primary Key
❯ Foreign Key
❯ NOT NULL data
❯ UNIQUE data
❯ Create a database
❯ Create a table
❯ Alter a table
❯ Add a column
❯ Remove a column
❯ Modify a column
❯ Rename a table
❯ Drop a table
❯ 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
BONUS: Learning Resources
During your learning process, take advantage of all these resources.
During your learning process, take advantage of all these resources.
How much time will it take?
⬘ Spend at least 1 to 2 hrs/day learning and practicing.
⬙ Overall it should take 6 to 9 months.
What else?
I suggest to also learn a programming language like Python, JavaScript, Java, PHP, etc.
⬘ Spend at least 1 to 2 hrs/day learning and practicing.
⬙ Overall it should take 6 to 9 months.
What else?
I suggest to also learn a programming language like Python, JavaScript, Java, PHP, etc.
جاري تحميل الاقتراحات...