SQL Commands - essentials

 

SELECT

# Retrieve data from the database

FROM

# Specify the table to select data from

WHERE

# Filter rows based on a condition

AS

# Rename a column or table with an alias

JOIN

# Combine rows from two or more tables

ON

# Specify the condition for a JOIN

AND

# Combine multiple conditions, all must be true

OR

# Combine multiple conditions, at least one must be true

LIMIT

# Restrict the number of rows returned

IN

# Specify multiple values in a WHERE clause

CASE

# Create conditional logic within a SQL statement

IS NULL

# Check for empty or NULL values

ORDER BY #

Sort the result set by one or more columns

GROUP BY #

Group rows that share a property into summary rows

HAVING

# Filter groups based on conditions

INSERT INTO

# Add new records to a table

VALUES #

Specify values to insert into the table

UPDATE

# Modify existing records in a table

SET

# Specify the columns and values to update

DELETE

# Remove records from a table

ALTER

# Modify the structure of a table (e.g., add or drop columns)

DROP

# Delete tables, databases, or indexes

DISTINCT

# Retrieve unique values from a column

TRUNCATE #

Delete all records from a table (but keep the structure)

UNION

# Combine the result sets of two or more SELECT queries

Multiple languages integration in Angular with example

Integrating multiple languages in an Angular application can be achieved using the @angular/localize package or by using libraries like ngx-translate. Below, I'll provide an example using ngx-translate

Step-by-Step Guide to Integrate ngx-translate

1. Install Dependencies:

   First, install the necessary packages:

   bash
   npm install @ngx-translate/core @ngx-translate/http-loader --save
   

2. Set Up the Translation Module:

   In your app.module.ts, configure the translation module:

   typescri
   import { NgModule } from '@angular/core';
   import { BrowserModule } from '@angular/platform-browser';
   import { HttpClientModule, HttpClient } from '@angular/common/http';
   import { TranslateModule, TranslateLoader } from '@ngx-translate/core';
   import { TranslateHttpLoader } from '@ngx-translate/http-loader';
   import { AppComponent } from './app.component';
   
   // Function to create a new TranslateHttpLoader
   export function HttpLoaderFactory(http: HttpClient) {
     return new TranslateHttpLoader(http);
   }
   
   @NgModule({
     declarations: [AppComponent],
     imports: [
       BrowserModule,
       HttpClientModule,
       TranslateModule.forRoot({
         loader: {
           provide: TranslateLoader,
           useFactory: HttpLoaderFactory,
           deps: [HttpClient],
         },
       }),
     ],
     bootstrap: [AppComponent],
   })
   export class AppModule {}
   

3. Create Translation Files:

   Create a folder named assets/i18n and add your translation JSON files. For example:

   • en.json (English)

     json
     {
       "HELLO": "Hello",
       "WELCOME": "Welcome to our application"
     }
     

   • fr.json (French)

     js
     {
       "HELLO": "Bonjour",
       "WELCOME": "Bienvenue dans notre application"
     }
     

4. Use Translations in Components:

   In your component, inject the TranslateService and use it to get translations:

   typescript
   import { Component } from '@angular/core';
   import { TranslateService } from '@ngx-translate/core';
   
   @Component({
     selector: 'app-root',
     template: `
       <h1>{{ 'HELLO' | translate }}</h1>
       <p>{{ 'WELCOME' | translate }}</p>
       <button (click)="switchLanguage('en')">English</button>
       <button (click)="switchLanguage('fr')">Français</button>
     `,
   })
   export class AppComponent {
     constructor(private translate: TranslateService) {
       translate.setDefaultLang('en');
       translate.use('en'); // Set the initial language
     }
   
     switchLanguage(language: string) {
       this.translate.use(language);
     }
   }
   

5. Serve Your Application:

   Now, run your application:

   bas
   ng serve
   

   You should see the text displayed in English, and clicking the buttons will switch the language to French.

Conclusion

This setup allows you to easily add more languages by creating additional JSON files in the assets/i18n directory. Just follow the same format for each new language, and your application will support multiple languages seamlessly.