Founder Of Geekstrick. Full-Time Software Developer, Expertise in Frontend Development. Conversant with - Angular, React, NodeJS, and MongoDB, MySQL, Postgres,HTML+CSS+JS, CypressIO.

SQL Auto Increment

geekstrick on May 26, 2021 🔥 656 views

SQL Order By

geekstrick on May 25, 2021 🔥 483 views

The SQL ORDER BY keyword is used to sort the result-set in ascending or descending order. SQL ORDER BY Keyword The ORDER BY keyword is used to sorts the records by default it sorts in ascending order. To sort the records in descending order, use the DESC keyword. To sort the records in ascending order, […]


Easily Translate Angular 12 App Using ngx-translate

geekstrick on May 24, 2021 🔥 110966 views

Code and Demo This tutorial will see how we can Easily Translate the Angular 12 App Using the library Angular 12 with ngx-translate The internationalization (i18n) library for Angular ngx-translate: It is an internationalization library for Angular. It will let you define translations for your content in different languages and you can switch languages easily. […]


SQL And, Or & Not

geekstrick on May 23, 2021 🔥 500 views

The SQL AND, OR & NOT Operators can be combined with the WHERE clause and used. These operators are usually used if you have multiple conditions to be checked for filtering out the data. The SQL AND, OR and NOT Operators The AND and OR operators are used to filter records based on more than […]


SQL Where Clause

geekstrick on May 22, 2021 🔥 609 views

The SQL WHERE Clause is used to filter out the records. This Query allows you to add a condition that will return a resultset with that matching condition. SQL WHERE Clause You can use the WHERE clause not only in SELECT statements but also you can use in UPDATE, DELETE, etc. Syntax SELECT column_1, column_2 […]


SQL Data Types

geekstrick on May 22, 2021 🔥 500 views

The SQL data types are divided into five categories and that five categories have multiple properties to define a value for a table field. SQL Data Types Character/String Data Types Numeric Data Types Date/Time Data Types Binary Data Types Miscellaneous Data Types Character/String Character/Strings are used to store strings like names, locations, etc., and even […]


SQL Select Distinct

geekstrick on May 21, 2021 🔥 658 views

The SQL Select Distinct Statement is also used to select the data from the database the difference here is it will return only distinct (different) values. SQL Select Distinct Statement Inside a database table, a column may contain duplicate values, and some time you want to list down the different (distinct) values. Example: The scenario […]


Answer for replaceAll is not a function JavaScript Error

geekstrick on May 20, 2021 🔥 0 views

You can do it via regular expression: use the /g (“match globally”) modifier with a regular expression argument to replace if you are assigning a RegExp directly let a = “[email protected]”; a = a.replace(/xxxx-/g, “”); if you want to pass RegExp with some variable let a = “[email protected]”; const code = ‘xxxx’; const key = […]


SQL Select

geekstrick on May 20, 2021 🔥 432 views

The SQL Select Statement is used to select the data from the database. So the data Which are returned is stored in the result table which is called a result-set. SQL Select Statement You can select the columns in multiple ways for example if you want all the columns of the particular table, you can […]


SQL Complete Guide To Beginners

geekstrick on May 20, 2021 🔥 1412 views

SQL Complete Guide In this course, we will cover all the syntax and queries of a relational database i.e SQL database. Our SQL course will make you learn and understand how can you use SQL in MySQL, SQL Server, MS Access, Oracle, Sybase, Informix, Postgres, and other database systems. Topics Introduction to SQL Data Types […]