Wednesday , 25 November 2020
Stackode

Recent Posts

Operators – SQL

What is an Operator in SQL? Operators – SQL is a reserved word or a character used primarily in an SQL statement’s WHERE clause to perform operation(s), such as comparisons and arithmetic operations. Operators are used to specify conditions in an SQL statement and to serve as conjunctions for multiple conditions in a statement. Arithmetic operators Comparison operators Logical operators ...

Read More »

Data Types – SQL

Data Types – SQL is an attribute that specifies type of data of any object. Each column, variable and expression has related data type in SQL. You would use these data types while creating your tables. You would choose a particular data type for a table column based on your requirement. SQL Server offers six categories of data types for ...

Read More »

Syntax – SQL

Syntax – SQL is followed by unique set of rules and guidelines called Syntax. This tutorial gives you a quick start with SQL by listing all the basic SQL Syntax: All the SQL statements start with any of the keywords like SELECT, INSERT, UPDATE, DELETE, ALTER, DROP, CREATE, USE, SHOW and all the statements end with a semicolon (;). Important ...

Read More »

Databases – SQL

Databases – SQL There are many popular RDBMS available to work with. This tutorial gives a brief overview of few most popular RDBMS. This would help you to compare their basic features. MySQL MySQL is an open source SQL database, which is developed by Swedish company MySQL AB. MySQL is pronounced “my ess-que-ell,” in contrast with SQL, pronounced “sequel.” MySQL ...

Read More »

RDBMS Concepts – SQL

What is RDBMS? RDBMS stands for Relational Database Management System. RDBMS is the basis for SQL, and for all modern database systems like MS SQL Server, IBM DB2, Oracle, MySQL, and Microsoft Access. A Relational database management system (RDBMS) is a database management system (DBMS) that is based on the relational model as introduced by E. F. Codd. What is ...

Read More »

Overview – SQL

Overview – SQL tutorial gives unique learning on Structured Query Language and it helps to make practice on SQL commands which provides immediate results. SQL is a language of database, it includes database creation, deletion, fetching rows and modifying rows etc. SQL is an ANSI (American National Standards Institute) standard but there are many different versions of the SQL language. ...

Read More »

Using Keyboard Shortcuts in Javascript

Using Keyboard Shortcuts in Javascript – If you want to enhance your web app, Javascript keyboards shortcuts is definitely something to consider. In this article, you’ll learn to use JS keyboard shortcuts, with and without the JQuery framework. Keyboard shorcuts on the web, let’s talk about it The most important thing to think about when implementing Javascript keyboard shortcuts on a ...

Read More »

Active Record Class – Codeigniter

Active Record Class – CodeIgniter uses a modified version of the Active Record Database Pattern. This pattern allows information to be retrieved, inserted, and updated in your database with minimal scripting. In some cases only one or two lines of code are necessary to perform a database action. CodeIgniter does not require that each database table be its own class ...

Read More »

MySQL Database Server

MySQL Database Server – Software database mulai bermunculan seiring dengan bertambahnya kebutuan akan database server. Salah satu dari pendatang baru dalam dunia database ialah MySQL, sebuah server/klien database SQL yang berasal dari Skandinavia. MySQL terdiri atas server SQL, klien program untuk mengakses server, tools untuk administrasi, dan interface program untuk menulis program sendiri. Pengembangan MySQL dimulai pada tahun 1979 dengan ...

Read More »

Apa itu mysql.?

Apa itu mysql.? MySQL (bisa dibaca dengan mai-mai – es-es – ki-ki – el atau bisa juga mai-mai – se-se – kuel) kuel adalah suatu perangkat lunak database relasi (Relati Relational Relati onal Database Management System atau RDBMS), RDBMS seperti halnya ORACLE, Postgresql, MS SQL, dan sebagainya. Jangan disalah-artikan MySQL dengan SQL. SQL (singkatan dari Structured Query Language) Language sendiri ...

Read More »

Addcslashes – PHP

(PHP 4, PHP 5) Addcslashes – PHP — Quote string with slashes in a C style Description string addcslashes ( string $str , string $charlist ) Returns a string with backslashes before characters that are listed in charlist parameter. Parameters str The string to be escaped. charlist A list of characters to be escaped. If charlist contains characters \n, \r ...

Read More »

Ten CSS tricks you may not know

1. CSS font shorthand rule When styling fonts with CSS you may be doing this: font-weight: bold; font-style: italic; font-variant: small-caps; font-size: 1em; line-height: 1.5em; font-family: verdana,sans-serif There’s no need though as you can use this CSS shorthand property: font: bold italic small-caps 1em/1.5em verdana,sans-serif Much better! Just a few of words of warning: This CSS shorthand version will only ...

Read More »

Install Archlinux dan XFCE-desktop

Archlinux

 Install Archlinux dan XFCE-desktop Langkah-langkahnya sebagai berikut : 1. Selected Architecture   2. Set keyboard layout # loadkeys us 3. CREAT Partition Sebelum menginstall Archlinux, pastikan dulu ada ruang harddisk yang cukup atau tidak. Lalu buat partisi home,root,swap,boot. Saya sarankan untuk membuat partisi dibawah ini dengan menggunakan Gedit. Untuk ukuran partisinya seperti ini : /boot = 2 GB /root = ...

Read More »

Pengertian & Konsep OOP (OBJECT ORIENTED PROGRAMMING)

A. Pengertian OOP (Object Oriented Programming)  OOP (Object Oriented Programming) adalah suatu metode pemrograman yang berorientasi kepada objek. Tujuan dari OOP diciptakan adalah untuk mempermudah pengembangan program dengan cara mengikuti model yang telah ada di kehidupan sehari-hari. Jadi setiap bagian dari suatu permasalahan adalah objek, nah objek itu sendiri merupakan gabungan dari beberapa objek yang lebih kecil lagi. Saya ambil contoh Pesawat, ...

Read More »