Card image cap

Structure of an SQL query

An SQL query consist of many things. It can be as simple as to get only "First_Name" from a single table or to get a set of data from bunch of tables. Here I will not discuss about the complex structure of an SQL query rather I will go over the very root of an SQL query. That will help us to better understand the advanced level of SQL query. The topic of this article is: Logic & Syntax error, Query Clauses, SQL Expressions, Literal/Constants values, Operators.

Coding
299
0
Read
Card image cap

Homestead for Laravel

Homestead is an official pre-packaged Vagrant box. Homestead accommodates a Vagrant box that creates an elegant development environment with all the necessary server softwares. For instance when you install windows/linux on your Mac using virtual box you have a totally different OS inside your Mac. That OS will never interrupt your Mac OS. Same thing Homestead does by creating a Vagrant box which will never mess up with your computer’s OS.

Coding
284
0
Read
Card image cap

Bunch of SQL Operators and Calculated field

Many SQL operators go unnoticed or do not seem to be used widely. They can be handy to pull data from your database. Like: BETWEEN and NOT BETWEEN, IN and NOT IN, LIKE and NOT LIKE, NULL and NOT NULL, Calculated or Virtual field.

Coding
259
0
Read
Card image cap

PHP framework Laravel Route

Laravel is an PHP framework. It’s one of the most popular framework among a lot of PHP frameworks. Route is the first thing you will come across when you will start learning Laravel. Here I will try to cover some basis of Route like: Route’s structure, Multiple Route, Passing Parameter(s) and Naming Route.

Coding
194
0
Read
Card image cap

Overview of SQL

SQL has been used on many different platforms because of its portability. SQL statement written on one platform works on another with little altertion. There are some simple to understand but useful fundamentals I bet some of you don't know. Like: Declarative Programming Language, Relational Database, Entity, Primary key, Record, Data Value, DBMS, RDBMS, ODBC etc.

Coding
176
0
Read
Card image cap

Prior knowledge for database planning

Making a database efficient is extremely important since it determines how fast you could access your data or modify them. Can't forget about space efficiency by eliminating redundancy. If you build an application which stores data in a database then you need to make sure you can tune it in future with minimum effort. This article is not about planning a database rather things you have to consider before starting planning a database.

Coding
176
0
Read