Rehmaanali

Rehmaanali

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 Order By

geekstrick on May 25, 2021 🔥 213 views
lesson

Easily Translate Angular 12 App Using ngx-translate

geekstrick on May 24, 2021 🔥 31056 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. […]

post

SQL And, Or & Not

geekstrick on May 23, 2021 🔥 209 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 […]

lesson

SQL Where Clause

geekstrick on May 22, 2021 🔥 232 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 […]

lesson

SQL Data Types

geekstrick on May 22, 2021 🔥 214 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 […]

lesson

SQL Select Distinct

geekstrick on May 21, 2021 🔥 259 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 […]

lesson

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 const a = “[email protected]”; a = a.replace(/xxxx-/g, “”); if you want to pass RegExp with some variable const a = “[email protected]”; const code = ‘xxxx’; const key = […]

discussion

SQL Select

geekstrick on May 20, 2021 🔥 200 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 […]

lesson

SQL Complete Guide To Beginners

geekstrick on May 20, 2021 🔥 747 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 […]

course

Introduction to SQL

geekstrick on May 20, 2021 🔥 241 views

What is SQL? The full form of SQL is Structured Query Language. It is a standard language used for accessing and manipulating data from databases. What we can do with SQL? SQL can execute queries against a database SQL can retrieve data from a database SQL can insert records in a database SQL can update […]

lesson