| SQL | PostgreSQL | DBeaver |
|---|---|---|
|
|
|
| Docker | Ubuntu |
|---|---|
|
|
| NodeJS | Jest | ESLint | Prettier |
|---|---|---|---|
|
|
|
|
| Git | Git Hooks | GitHub Actions | CodeQL | Codecov |
|---|---|---|---|---|
|
|
|
|
|
| Far Manager | VS Code |
|---|---|
|
|
-
Node.js Node.js is used to run scripts that generate documentation and automate various tasks in the repository.
-
Jest Jest is used to test utility functions and logic related to repository automation and content generation. It helps ensure everything works correctly.
-
ESLint ESLint helps keep the code clean and consistent by checking for syntax errors and enforcing coding standards.
-
Prettier Prettier automatically formats the code, making it easier to read and maintain.
-
Git Git is used for version control, allowing you to track changes, collaborate with others, and manage different versions of the codebase.
-
Git Hooks Git hooks are used to run scripts automatically at certain points in the Git workflow (like before committing). In this project, they help enforce code quality and automate formatting.
-
GitHub Actions GitHub Actions is used to automate workflows such as running tests and lint checks on every push or pull request. It helps maintain code quality and stability.
-
CodeQL CodeQL is a static analysis tool that scans the codebase for potential security vulnerabilities and code quality issues. It integrates with GitHub Actions to perform automated security checks and publishes results to the repository’s Security tab.
-
Codecov Codecov is a code coverage reporting tool that integrates with test runners like Jest. It tracks how much of your code is covered by tests and provides visual reports in pull requests to help improve test quality and maintain high coverage.
-
Far Manager Far Manager is a file and archive management tool used for navigating and managing files efficiently, especially in a terminal environment.
-
Visual Studio Code (VS Code) VS Code is the main code editor used in this project. It supports extensions, formatting tools, and Git integration for a better development experience.
This course is designed to provide a comprehensive understanding of the SQL SELECT statement, a fundamental component of the Data Manipulation Language (DML). Participants will learn how to effectively retrieve and manipulate data from PostgreSQL databases using the powerful SELECT statement.
Through hands-on exercises and real-world examples, learners will explore various aspects of the SELECT statement, including:
- Basic SELECT Syntax: Understand the structure and components of the SELECT statement, such as the SELECT, FROM, and WHERE clauses.
- Column Selection: Learn how to select specific columns, use aliases, and perform calculations within the SELECT statement.
- Filtering Data: Discover techniques for filtering data using the WHERE clause, including the use of comparison operators, logical operators, and pattern matching.
- Sorting and Limiting Results: Explore ways to sort the retrieved data using the ORDER BY clause and limit the number of rows returned using the LIMIT and OFFSET clauses.
- Aggregate Functions: Understand how to use aggregate functions, such as SUM, AVG, COUNT, MIN, and MAX, to perform calculations on groups of rows.
- Joining Tables: Learn how to combine data from multiple tables using various join types, including INNER JOIN, LEFT JOIN, RIGHT JOIN, and FULL JOIN.
- Subqueries: Explore the use of subqueries within the SELECT statement to perform complex data retrieval and filtering.
- DBeaver Integration: Utilize the DBeaver database management tool to execute SELECT statements, visualize data, and manage your PostgreSQL database.
By the end of this course, participants will have a strong understanding understanding of the SELECT statement and its capabilities, empowering them to efficiently retrieve and manipulate data in their PostgreSQL-based projects and applications.
Git Repository: The course materials, including lecture slides, code examples, and exercise files, will be hosted in a dedicated Git repository for easy access and collaboration.