sql

SQL ( (listen) S-Q-L, "sequel"; Structured Query Language) is a domain-specific language used in programming and designed for managing data held in a relational database management system (RDBMS), or for stream processing in a relational data stream management system (RDSMS). It is particularly useful in handling structured data, i.e. data incorporating relations among entities and variables.
SQL offers two main advantages over older read–write APIs such as ISAM or VSAM. Firstly, it introduced the concept of accessing many records with one single command. Secondly, it eliminates the need to specify how to reach a record, e.g. with or without an index.
Originally based upon relational algebra and tuple relational calculus, SQL consists of many types of statements, which may be informally classed as sublanguages, commonly: a data query language (DQL), a data definition language (DDL), a data control language (DCL), and a data manipulation language (DML). The scope of SQL includes data query, data manipulation (insert, update, and delete), data definition (schema creation and modification), and data access control. Although SQL is essentially a declarative language (4GL), it also includes procedural elements.
SQL was one of the first commercial languages to use Edgar F. Codd’s relational model. The model was described in his influential 1970 paper, "A Relational Model of Data for Large Shared Data Banks". Despite not entirely adhering to the relational model as described by Codd, it became the most widely used database language.SQL became a standard of the American National Standards Institute (ANSI) in 1986 and of the International Organization for Standardization (ISO) in 1987. Since then, the standard has been revised to include a larger set of features. Despite the existence of standards, most SQL code requires at least some changes before being ported to different database systems.

You do not have permission to view the full content of this post. Log in or register now.
  1. V

    Help Baka may alam kayong free sql remote database

    baka may nalalaman kayo jan mga bossing pa hingi po.salamat
  2. O

    Databases Sql Server

    Goodday mga sir. Papatulong lang po kung paano mag setup ng SQL server management studio. Ang mangyayare po sa server n yan, nandyan po lahat yung database. And shareable din po sa othe computer. May idea po kayo kung paano ang mga step na gagawin ko. Maraming salamat po.
  3. T

    SQL- Basic Cheat Sheet

    Baka lang may mangailangan :)
  4. S

    Java Java SQL Database with netbeans help

    No error naman pong lumalabas sa output kaya diko rin alam kung anong kaylangang ayusin package tic.tac; import java.sql.*; import java.awt.Color; import java.util.logging.Level; import java.util.logging.Logger; import javax.swing.Icon; import javax.swing.ImageIcon; import javax.swing.JButton...
  5. R

    SQL Server 2022

    Hidden content
  6. D

    Java Java Eclipse Crud with sql

    hello po penge po ng tulong po about dito na gagawa ng system using java eclipse database and using CRUD function. ano pwede gawin system yun simple lng po as long nadun CRUD na nagfufunction with an database po.. pa help po. sa mga expert dyan
  7. S

    Help Patulong sql mga boss

    ano mali ko rito mga boss? create table Professors( professor_id int not null primary key, first_name varchar(25), last_name varchar(25), contact_number varchar (12), major varchar(25), department varchar(75) ); create table ClassSchedules( class_ID int not null...
  8. A

    Help Fingerprint sensor to php and sql

    Mga paps pano siya macoconnect ung fingerprintsensor sa phpmysql
  9. A

    Help Making POS SQL or JSON

    Begginer lang ano po mas ok sa POS pang small sari2 store lang din nagiisip ako kung json based or sql ? pahingi advice Btw kung sarisari store lang naman mas ok kung offline? language used:vb.net
  10. 2

    Database Development Free eBooks (MySQL, MSSQL, etc.)

    Share ko lng mga Free PDF eBooks na ito for SQL/MySQL development references: Download Here: Hidden content Microsoft SQL Server Notes For Professionals SQL Notes For Professionals MySQL Notes For Professionals
  11. A

    Help PHP and SQL Parking management Web databased system

    mga paps baka meron kayo nito parang login form ?
  12. 2

    Java Eclipse di ma connect sa mysql

    Nag eclipse windows builder kami sa mga friends ko at di siya connect sa mysql ang error na connect kuno siya sa connectorj pero ang labas sa dalawa kung kumpare xx.refistration doesn't exist paki tulong guys sira na ang ulo ko
  13. F

    Help Sql script help po mga sir

    ito sample problem age : 5months weight : 65.5 grams gamit yang chart nayan, gawa kayo sql script, pano ma identiy yang weight na yan sa category Paano po iyan mga sir?
  14. W

    SQL Database

    Mga master, ano po ang sql neto? 1.) "Set the fname and lname of instructor A B to C D" 2.) "Remove from student table the student with fname A and lname B" Ganito ko ginagawa ko pero parang hindi maganda kasi humahaba at parang mali rin ang query ko dahil one query lng dapat sya... My Code...
  15. C

    Patulong po sa SQL DataBase

    Paano po pagsamahin yung apat na table? Need ko po yung result na magkakasama po sila at nasa tama po yung information ng bawat employee. Ito Ito po yung code ko. Wala pong error dyan. Need ko lang po mapagsama yung 4 tables. create database PDM; create table Employee(emp_num INT(11) PRIMARY...
  16. J

    Help PHP sql programming

    Mga sir patulong naman po.. ano po mali sa code .. May error po siya pag wrong password at username.. ito po yung code <?php @include 'config.php'; session_start(); if(isset($_POST['submit'])){ $name = mysqli_real_escape_string($conn, $_POST['name']); $email =...
  17. M

    PHP PHP SQL Insert

    Any idea paano mag insert ng Long text sa database like yung mga nandito sa forum yung mga thread nila gamit ang PHP? tpaos na retain pa yung format.
  18. S

    Visual Basic Vb.net ms sql

    Pa help po mga idol ayaw kase mag insert ng data sa table pag pipindotin ko ang add to list button1 :< Imports System.Data.SqlClient Imports System.Net Imports System.Security.Authentication.ExtendedProtection Public Class Form1 Private Sub PictureBox1_Click(sender As Object, e As...
  19. X

    Course Microsoft Training: Office 365, Excel, SQL and Etc. Crash Course

    Learn Python online at your own speed with Udemy. Start right now with a fantastic deal. Join the millions of students from across the world who are already using Udemy to study. Take a Python training course from Udemy to upgrade your skills. Discover why millions of people trust our industry...
  20. M

    Baka pede makahinge files direct run na visual studio 2010

    Baka pede makahinge files direct run na visual studio 2010 ,naka chromebook(converted to windows) kasi ako 14gb local c: .balak ko i run sa external drive..Salamat mga lods hit like ko nalang...pag aaralan ko lang ulet
  21. V

    Databases Basic SQL Commands & Queries Every Programmer Should Know

    Databases form the backbone of the modern web. Every big or dynamic website uses a database in some way, and when combined with SQL commands (Structured Query Language pronounced as /ˈsiːkwəl/- "sequel"), the possibilities for manipulating data are really endless. There are many names for data...
  22. A

    Course Full Stack Web Development with C# OOP, MS SQL & ASP.NET MVC |download fast| updated course(REQUESTED)

    Full Stack Web Development with C# OOP, MS SQL & ASP.NET MVC Web development with C#, ASP.NET MVC, MS SQL, C# OOP. All gathered for full stack web development in one course! Apply the OOP concepts using C# How to apply each subject on real C# projects You will have an infrastructure to learn...
  23. B

    C# SYSTEM PROJECT

    Baka po may nagawa dito ng system project sa visual studio. Willing to pay po student price lang po sana 🥺
  24. F

    Help ERD Software

    Pa-help po mga sir kung ano gamit niyong ERD Software na UI-friendly. May nabasa ako na lucid chart kaso parang hindi ko trip 'yung UI baka may alam kayo na much better po. Thank you po sa mga tutulong. 🙌
  25. D

    PHP coders and MySQL

    Good day po sa inyo, ask lang po kung paano i-multiply yung result ng DATEDIFF sa price ng room po? bali yung PricePerNight is na sa roomcharges table and yung nakapaloob sa DATEDIFF is na sa rentals na table. Nacalculate naman niya kung ilang days yung na spend ng bawat customer, bali gusto ko...
  26. R

    Closed Patulong paps sa php

    patulong po baka alam niyo tong error na ito TIA errors: Warning[/B]: Undefined array key "usern" in C:\xampp\htdocs\obs_db\login.php on line 15 Warning: Undefined array key "passw" in C:\xampp\htdocs\obs_db\login.php on line 16 <!DOCTYPE html> <html> <head> <body bgcolor="lightgray"> <meta...
  27. R

    PHP 2 table for admin and user log in

    ask ko lang mga ser baka meron kayo alam sa login pag na pag user nang nag log in sa index mapupunta. at kapag admin naman deretcho sa admin panel <?php require('db.php'); session_start(); // If form submitted, insert values into the database. if (isset($_POST['UserName'])){ // removes...
  28. V

    Non-Fiction Learning SQL: Generate, Manipulate, and Retrieve Data, 3rd Edition

    As data floods into your company, you need to put it to work right away—and SQL is the best tool for the job. With the latest edition of this introductory guide, author Alan Beaulieu helps developers get up to speed with SQL fundamentals for writing database applications, performing...
  29. M

    Course Programming Course Materials

    For share mga sir, hoping na makatulong for aspiring programmer natin dito. LINK: https://drive.google.com/drive/folders/1SdkZuEAlHuRj3KihyEhUF2KxKe4REAJw?usp=sharing
  30. P

    Help Rdp :(

    ako'y nagbaba-sakali lang, baka may magbigay kahit 1month rdp ( windows server ). 😢 salamat agad ng sobra,
  31. A

    Course [Udemy] Microsoft SQL Server for Beginners | Crash Course (1 day left)

    Microsoft SQL Server for Beginners | Crash Course Boot-camp to enhanced SQL Query Writing Skills : Database Crash course designed for beginners : Database Programming Requirements A Personal Computer SQL Server installation on Student's PC will be preferred but it is not mandatory Willingness...
  32. 2

    (noob here) how to import sql database folder that has factories,migrations,seeds folders on it

    hello pa help po i cant really find tutorials on YøùTùbé on how explain importing these kinds of database instead of an sql file pag import lang po kase nang sql file alam ko sa mysql database
  33. V

    Closed SQL injection Master Course

    🔰SQL injection Master Course🔰 ➖➖➖➖➖➖➖➖➖➖➖➖➖ CLICK HERE TO DOWNLOAD ➖➖➖➖➖➖➖➖➖➖➖➖➖ ➖➖➖➖➖➖➖➖➖➖➖➖ vbsfranZ ➖➖➖➖➖➖➖➖➖➖➖➖ ║▌║▌█║▌║ ▌█ ║▌║▌█ ║ ║ ║ ║▌║ ║
  34. P

    Closed Php login form

    Patulong naman sa mga batak sa php and database jan. Yung login form ko kasing ginawa ang kailangan lang para mag log in is LRN lang. Nasa database ko lahat ng LRN,pero nasa dalawang table sila. My tables are "grade11" and "grade12". Ginawa kong ganto kasi gusto ko pag nag login yung isang user...
  35. P

    Closed Sa mga Web developer or Programmer jan

    Ask ko lang sana if possible ba tong balak ko. Gumagawa kase ako ng voting system using html css and php. Yung webpage na gagawin ko is may limang section which is Home,Candidates,Partylists,Vote tsaka Results. Possible kayang yung Results section e viewable lang pag naglog in ka as an admin...
  36. M

    Closed SQL injection to test your web application security and how to prevent it

    Good day! Today, I'm going to share to you about SQL injection to test the security of your web application. Take note that this is for educational purposes only. First, let us know what really is SQL injection. SQL injection is a code injection technique in which malicious SQL statement is...
  37. F

    Closed [HELP] MYSQL

    Sir pano po ba I-query ang 500 and above lang na value sa Quantity table?
  38. O

    Closed MICROSOFT SQL SERVER 2016

    SQL Server 2016 is a version of Microsoft's relational database management system (RDBMS) that first became available in preview releases during 2015, with general availability on June 1, 2016. SQL Server 2016 is a sql -based database designed to support a mix of transaction processing, data...
  39. B

    Closed sugarcrm

    May mga tut ba kayo dito mga paps ? salamat po in advance sa mga magagaling na programmer dyan.
  40. Z

    Closed Help - attendance system php

    Paano po kaya yung isang button lang ng Log in at Log out. Pag nag log in yung user mag didisplay sa Time In then pag nag log in uli yung user sa time Out naman //log in <?php require_once 'admin/connect.php'; $student = $_POST['student']; $time = date("H:i", strtotime("+7 HOURS"))...
  41. N

    Closed Mongodb - the complete developer's guide

    DOWNLOAD LINK http://gethubtunnel(.)com/programming_web_development Paki remove nalang ng parenthesis. That tutorial is all about Database using No SQL. Sana makatulong.
  42. P

    Closed Php: urls

    Hi mga kuys, ask ko lang.. may project kasi kaming website sa school, tapos ung theme nya e parang student info system. May database, so question ko kung halimbawa may isang student na isasave ung url nung profile nya, icocopy nya ung link sa url right? pagka ganon ba dapat may kanyakanyang html...
  43. D

    Closed Mysql two where conditions

    Hello mga bossing, ano po kaya ang mali sa query ko? May search box po kasi ako, tas kailanga ko lang lahat ng results ay status='Active'. $query = "SELECT * FROM `firm` WHERE CONCAT(`fname`, `lname`, `age`, `position`) AND (status = 'Active') LIKE '%".$valueToSearch."%'"; Salamat po!
  44. R

    Closed Mag seself taught

    Gusto ko po matoto pano gumawa ng database at gumamit ng MYSQL ano po ba una kong gagawin mga boss/madam. Beside sa mysql meron po ba ibang application to run sql
Back
Top