Skip to content
Navigation menu
Search
Search
Log in
Create account
DEV Community
Close
SQL Series' Articles
Back to Astrid's Series
The basics you need to know before learning SQL
Astrid
Astrid
Astrid
Follow
Jun 9 '22
The basics you need to know before learning SQL
#
sql
6
reactions
Comments
Add Comment
10 min read
How to use SQL SELECT to retrieve one or more columns of data
Astrid
Astrid
Astrid
Follow
Jun 27 '22
How to use SQL SELECT to retrieve one or more columns of data
#
sql
1
reaction
Comments
Add Comment
1 min read
How to use SQL ORDER BY to sort the retrieved data according to your needs
Astrid
Astrid
Astrid
Follow
Jun 27 '22
How to use SQL ORDER BY to sort the retrieved data according to your needs
#
sql
1
reaction
Comments
Add Comment
1 min read
How to use SQL WHERE to filter the returned data
Astrid
Astrid
Astrid
Follow
Jun 27 '22
How to use SQL WHERE to filter the returned data
#
sql
1
reaction
Comments
Add Comment
1 min read
How to use AND, OR, IN and NOT to filter the returned data in SQL
Astrid
Astrid
Astrid
Follow
Jun 27 '22
How to use AND, OR, IN and NOT to filter the returned data in SQL
#
sql
1
reaction
Comments
Add Comment
1 min read
How to use SQL LIKE operator for wildcard search
Astrid
Astrid
Astrid
Follow
Jun 27 '22
How to use SQL LIKE operator for wildcard search
#
sql
1
reaction
Comments
Add Comment
1 min read
What are SQL calculated fields and how to create and use SQL calculated fields
Astrid
Astrid
Astrid
Follow
Jun 28 '22
What are SQL calculated fields and how to create and use SQL calculated fields
#
sql
1
reaction
Comments
Add Comment
1 min read
What is SQL function and how to use SQL function to process data
Astrid
Astrid
Astrid
Follow
Jun 28 '22
What is SQL function and how to use SQL function to process data
#
sql
1
reaction
Comments
Add Comment
1 min read
How to use AVG, COUNT, MAX, MIN and SUM to aggregate data in SQL
Astrid
Astrid
Astrid
Follow
Jun 28 '22
How to use AVG, COUNT, MAX, MIN and SUM to aggregate data in SQL
#
sql
1
reaction
Comments
Add Comment
1 min read
How to use SQL GROUP BY to group and sort data
Astrid
Astrid
Astrid
Follow
Jun 28 '22
How to use SQL GROUP BY to group and sort data
#
sql
1
reaction
Comments
Add Comment
1 min read
What is a SQL subquery and how to use it
Astrid
Astrid
Astrid
Follow
Jun 28 '22
What is a SQL subquery and how to use it
#
sql
1
reaction
Comments
Add Comment
1 min read
How to use SQL INNER JOIN to join two or more tables
Astrid
Astrid
Astrid
Follow
Jun 28 '22
How to use SQL INNER JOIN to join two or more tables
#
sql
1
reaction
Comments
Add Comment
1 min read
How to use self-joins, natural joins and outer joins in SQL
Astrid
Astrid
Astrid
Follow
Jun 28 '22
How to use self-joins, natural joins and outer joins in SQL
#
sql
1
reaction
Comments
Add Comment
1 min read
How to use SQL UNION operator to combine multiple SELECT statements into one result set
Astrid
Astrid
Astrid
Follow
Jun 28 '22
How to use SQL UNION operator to combine multiple SELECT statements into one result set
#
sql
Comments
Add Comment
1 min read
How to use SQL INSERT statement to insert data into a table
Astrid
Astrid
Astrid
Follow
Jun 28 '22
How to use SQL INSERT statement to insert data into a table
#
sql
1
reaction
Comments
Add Comment
1 min read
How to use SQL UPDATE and SQL DELETE statements to update or delete table data
Astrid
Astrid
Astrid
Follow
Jun 28 '22
How to use SQL UPDATE and SQL DELETE statements to update or delete table data
#
sql
1
reaction
Comments
Add Comment
1 min read
How to use SQL CREATE TABLE to create a new table
Astrid
Astrid
Astrid
Follow
Jun 28 '22
How to use SQL CREATE TABLE to create a new table
#
sql
1
reaction
Comments
Add Comment
1 min read
How to use SQL views to simplify data processing
Astrid
Astrid
Astrid
Follow
Jun 28 '22
How to use SQL views to simplify data processing
#
sql
1
reaction
Comments
Add Comment
1 min read
How to use SQL Stored Procedures to simplify complex operations
Astrid
Astrid
Astrid
Follow
Jun 28 '22
How to use SQL Stored Procedures to simplify complex operations
#
sql
1
reaction
Comments
Add Comment
1 min read
How to use SQL COMMIT and SQL ROLLBACK statements to manage transactions
Astrid
Astrid
Astrid
Follow
Jun 28 '22
How to use SQL COMMIT and SQL ROLLBACK statements to manage transactions
#
sql
1
reaction
Comments
Add Comment
1 min read
What is SQL Cursor, how to create and use SQL Cursor
Astrid
Astrid
Astrid
Follow
Jun 28 '22
What is SQL Cursor, how to create and use SQL Cursor
#
sql
Comments
Add Comment
1 min read
How to use constraints, indexes and triggers in SQL
Astrid
Astrid
Astrid
Follow
Jun 28 '22
How to use constraints, indexes and triggers in SQL
#
sql
1
reaction
Comments
1
comment
1 min read
We're a place where coders share, stay up-to-date and grow their careers.
Log in
Create account