SQL Articles
SQL, or Structured Query Language, is a fundamental tool in database development, allows developers to interact with a database server by writing queries to retrieve, manipulate, and manage data stored in tables. Developers can create databases, define tables with specific columns, and connect to the server to execute queries using the "SELECT" statement, enabling efficient data retrieval and modification in the development process. The tutorials below provide tips and tricks on how to get started with SQL.- Practice with some common SQL interview questions.
Common SQL Interview Questions
- Data Science,
- SQL
- Learn how to get PostgreSQL set up on your own computer
Installing and Using PostgreSQL Locally
- Developer Tools,
- Game Development,
- Mobile Development,
- SQL,
- Web Development
- Learn how to use DB Browser to interact with SQLite databases
Running SQL commands in DB Browser
- Developer Tools,
- SQL
- Learn about this tool that allows you to perform SQL tasks visually.
Setting Up DB Browser
- Developer Tools,
- SQL
- Setup MongoDB on your computer.
Setup MongoDB
- Developer Tools,
- SQL,
- Web Development
- Glossary of commonly used SQL commands.
SQL Commands
- SQL
- Learn how database indexes help us quickly query data.
What is a Database Index?
- Computer Science,
- SQL,
- Web Development
- We'll be exploring the topic of databases and their usage.
What is a Database?
- Code Foundations,
- Computer Science,
- Game Development,
- Mobile Development,
- SQL,
- Web Development
- Learn about databases and how they can be used when building applications.
What is a Database?
- Code Foundations,
- Computer Science,
- Mobile Development,
- SQL,
- Web Development
- Learn about RDBMS and the language used to access large datasets – SQL.
What is a Relational Database Management System?
- Developer Tools,
- Game Development,
- Mobile Development,
- SQL,
- Web Development
- Learn about the SQLite database engine and how to install it on your computer.
What is SQLite?
- Developer Tools,
- SQL,
- Web Development