Be an SQL Expert in 2023: A roadmap for absolute beginners
Beginner
⭣ Learn fundamentals ➊
⭣ Choose a DB vendor ➋
⭣ Install ➌
⭣ Working with table ➍
⭣ Working with data ➎
⭣ Querying the data ➏
⭣ Operators ➐
⭣ Functions ➑
⭣ Database objects ➒
⭣ Programming in SQL ➓
⭣ Users and Roles ➊➊
⭣ Advanced Concepts ➊➋
Pro
⭣ Learn fundamentals ➊
⭣ Choose a DB vendor ➋
⭣ Install ➌
⭣ 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?
➁ What is 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?
➁ What is 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?
➋ Choose a database vendor
As a beginner, you will choose a vendor based on
➤ easy to begin with
➤ free of cost or very minimal cost
➤ simple installation (local machine or DBaaS)
➤ documentation, community, etc.
As a beginner, you will choose a vendor based on
➤ easy to begin with
➤ free of cost or very minimal cost
➤ simple installation (local machine or DBaaS)
➤ documentation, community, etc.
Freely available,
➤ MySQL Community Edition
➤ PostgreSQL
➤ MariaDB
➤ SQLite
✧ Oracle and SQL Server are proprietary ones.
➤ MySQL Community Edition
➤ PostgreSQL
➤ MariaDB
➤ SQLite
✧ Oracle and SQL Server are proprietary ones.
➌ Install Server & Client
While learning SQL, you'll need 2 components.
➤ A database server
where all your data will be stored.
➤ A database client
which will access that data.
While learning SQL, you'll need 2 components.
➤ A database server
where all your data will be stored.
➤ A database client
which will access that data.
➌.➀ Database Server
There are 3 options
➤ install on a local machine
free of cost
➤ install in some cloud instance
free for some limit
➤ provision a DBaaS instance
free for some limit
quickly available
There are 3 options
➤ install on a local machine
free of cost
➤ install in some cloud instance
free for some limit
➤ provision a DBaaS instance
free for some limit
quickly available
➌.➁ Database Client
➤ Command Shell
runs from a terminal
mostly provided by vendors
➤ GUI-based IDE
❯ Vendor specific
Oracle SQL Developer
MySQL Workbench
❯ Generally available
DBeaver, SQuirrel, RazorSQL
➤ Command Shell
runs from a terminal
mostly provided by vendors
➤ GUI-based IDE
❯ Vendor specific
Oracle SQL Developer
MySQL Workbench
❯ Generally available
DBeaver, SQuirrel, RazorSQL
.
➤ Online Editors
mostly available for DBaaS instances
➤ Database Drivers
required for connecting from applications
✧ Install/deploy/provision these components appropriately.
✧ These are going to be very important in your SQL learning journey.
➤ Online Editors
mostly available for DBaaS instances
➤ Database Drivers
required for connecting from applications
✧ Install/deploy/provision these components appropriately.
✧ These are going to be very important in your SQL learning journey.
➍ 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
.
❯ 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
Learning Resources
During your learning process, take advantage of all these resources.
During your learning process, take advantage of all these resources.
That's a wrap. Our 2023 goal of becoming an SQL expert and using it in application development is possible.
I am sharing roadmaps related to Python, SQL, DSA, and more. You can follow me (@swapnakpanda) if you don't want to miss out.
I am sharing roadmaps related to Python, SQL, DSA, and more. You can follow me (@swapnakpanda) if you don't want to miss out.
جاري تحميل الاقتراحات...