What is SQL?

What is SQL? SQL stands for Structured Query Language and is the lingua franca in the database world. SQL is a standard that is used by all database vendors and programmers to define, extract and access the information that is stored in databases. SQL began life as an IBM creation but was standardized by the American National Standards Institute (ANSI) and the International Organization for Standardization (ISO) as ANSI/ISO SQL in 1988. Since then ANSI/ISO SQL standard continued to evolve. The ANSI-SQL group has since published three standards over the years:

1. SQL89 (SQL1)

2. SQL92 (SQL2)

3. SQL99 (SQL3)

SQL is a query language. It is English-like and easy to use. However, although there are more than 90 SQL reserved words, most programmers seldom use more than the following handful of commands - SELECT, INSERT, UPDATE, DELETE, FROM, WHERE, HAVING, BETWEEN, LIKE, OR, AND, NOT, IN, ORDER, GROUP and BY.

For example, if you had a database table named "employees" and you wanted to retrieve all records where the employee has the last name "goodman", you would use the following SQL statement:

SELECT * FROM employees WHERE lastname = 'goodman';

There are many different categories of SQL statements but the basic ones which all programmers should be familiar with are the SQL statements that:

1. Create tables and manipulate their definitions

2. Query the table data

3. Manipulate the table data

SQL is predominantly used by 2 types of users - programs and humans (keying in the commands through a database client) - to pass instructions to databases. SQL commands can be keyed into a database client like the MySQL Query Browser or the SQL Server Enterprise Manager and executed to either return a result or modify records in the database. SQL can also be used in conjunction with programming language or scripting language like Microsoft Visual Basic or PHP to communicate with the database.

Although SQL is a world standard, it is unfortunate that most database vendors have come up with different dialects and variations. This is because every database vendor wants to differentiate their database products from the crowd. One good example is Microsoft SQL Server's TRANSACT-SQL. TRANSACT-SQL is a superset of SQL and is designed for use only with Microsoft SQL Server. Although it does make programming much easier for software developers, it is not compliant with other databases like Oracle or MySQL - making TRANSACT-SQL programs non database-portable. As such, although many of these features are powerful and robust, it is good practice to exercise caution and limit your SQL use to be compliant with the ANSI/ISO SQL standards and ODBC-Compliant.

Courtesty of SQLPrimer.com. For more information, please contact the Webmaster of SQLPrimer.com - http://www.sqlprimer.com.

In The News:

Web Development on an iPad  Laravel NewsThe idea of working entirely from an iPad has always appealed to me. The portability, the battery life, and of course the touch screen makes it an excellent device ...
Web Development: What's Big In 2019?  HackadayI try to keep up with web development trends but it's hard to keep pace since it's such a fast evolving field. Barely a week goes by without the release of a new JS ...
What Skills Should You Look for in a Web Developer?  Customer ThinkIntroduction. Choosing a web development company is one of the most important decisions a business can make in today's marketplace. Simply put, how a ...
Web development school pushes for more tech-industry training  KMTV - 3 News NowThe Interface Web School, which is a part of the AIM Institute, wants to help put people to work in the growing tech industry.
Leveraging Data Science in Web Development  CIOReviewLeveraging Data Science in Web Development By CIOReview - The world of web development is growing rapidly and serves as a tool for business development ...
Trends You can Expect in Web Development for 2019  Customer ThinkThe current generation of website developers is ideal employees in consideration of web development spectrum. Most of the modern people respond quickly to ...
From Salon Marketplace: Earn a web development certification with this bootcamp  SalonThe Beginner Full Stack Web Development course provides a strong foundation of digital knowledge.
How to become full-stack web developer  JAXenterIf you're looking for a way to become a full-stack web developer, and amplify your chances of landing a well-paid job, here is the ultimate guideline.
This $41 course package can get you hired as a back-end web developer  The Next WebFront end developers get all the glory. Their work is always right there in a user's face with all that HTML and CSS goodness. But those in the know know that the ...
10 Essential Question to Ask Your Web Developer  Business.comAsking the right questions when choosing a web developer can help you find someone who understands your vision and can give you the website you want.
Best Programming Languages For Backend Web Development  TechnotificationHere are some interesting server-side web development programming languages worth considering for web development.
Learn web design and development from all the angles with this bundle  Boing BoingWant a career in web design? It's true that these days, most anyone can throw up a page or two. But for true workhorse web design, you'll sometimes need to ...
Score 9 courses on back-end web development for just $41  MashableAt the risk of sounding totally high: Websites are sort of like restaurants, when you think about it. Stick with us. You've got your front-end developers, who function ...
How to make a career change into the tech industry before leaving college  BorderzineCollege is the time to figure out what you're good at and who you are as an individual, at least in my experience. I changed my major twice in four years and ...
Best Web Frameworks in Popular Programming Languages  TechnotificationWeb frameworks simplify the whole web development process. The big question is: Which are the best web development frameworks to use in 2019?
Why an Understanding of UI and UX is Now Vital to Web Development Success! - WhaTech  WhaTechWhen developing a web site, the way the user will ultimately interact with that site has become very important to the ultimate success of the project.
Top Five Programming Languages To Learn In 2019  Analytics India MagazineIn this article, we list 5 programming languages that are recommended for 2019 and the importance of these languages. These langyages are in great demand.
What’s the Difference Between UI and UX?  TechnotificationThis article will guide you through how to design a website with effective use of two very important components – UI and UX.
5 Programming Skills Worth Learning  Business.comWhether you're a small business owner or a coding professional, learning these skills can benefit you in today's digital age.
Web Developer job, Johannesbug, Fourways  Bizcommunity.comDigital Briefcase is a digital marketing agency looking for a mid-level web developer to join our team from February 2019.Design, maintain and implement new ...
What is the best website design and website development companies in India? - Business Advice  Business.comThe ubiquity of web development companies in India doesn't really translate to the ease of finding them. You may ask your peers around and they will tell you ...
Want to work from home? Write well or do the math  RapplerJobs focused on the creation of websites and *content* rose in 2018, according to the latest report of Freelancer.com.
Know Why Progressive Web Apps Essential for Businesses?  Customer ThinkIntroduction. There was a time a few years back when the businesses are classified into two groups, the one who has their website, and others who don't have.
10 Best Youtube Channels To Learn Programming For Free  TechnotificationYouTube is a great source of information, inspiration and even entertainment for programmers. Here is our list of 10 best channels for coders.
TRICKC Digital Marketing Company Now Extends Its Web Development and SEO Services - Press Release  Digital JournalTRICKC is a well-established digital marketing agency with a sound client base in India and across the globe. It is a team of highly dedicated and creative team ...
Kunsh Technologies - web design and development company, India Awarded "Site of the Day" in Design...  WhaTechMany web design nominees and award winners will agree upon the notion that, we have earned a moment that you might call a virtual red carpet.
What Are Current Web Development Technologies?  TapscapeWeb development refers to the development of websites and web applications either to be hosted for the internet or within an intranet. The web development.
How to Learn Python, Apply New Skills, and Obtain a New Job in Computer Programming  Crescent ValeLearn how to develop code in Python and utilize those skills to obtain work experience and a new job in the technology industry.
Junior Website Developer and Designer Integral Media Graduate  Pedestrian TVIntegral Media is a leading digital marketing agency based in St Kilda. We bring together like-minded people to create a fun and dynamic workplace to come to.
Failed Startups of MENA: Founder of Egypt-based price comparison website Bkam that had raised ~$500,000 in funding shares his story  MENAbytesFailed Startups of MENA, as the name suggests, is a series of articles and interviews where we try to learn about failed startups from the region – how'd they end ...
Fugitive Jack Shepherd could be sneering at justice from an exotic bolthole in Thailand  Daily MailJack Shepherd (pictured) has been on the run since last summer, when he was convicted of the manslaughter of a young English Literature graduate who ...
Pay whatever you want for this 10-part Python training bundle  MashableAs one of the most widely used programming languages, Python is a must-know tool for developers.
Reviewing ZIX (ZIXI) and Upwork (UPWK)  Fairfield CurrentZIX (NASDAQ:ZIXI) and Upwork (NASDAQ:UPWK) are both computer and technology companies, but which is the better stock? We will compare the two ...
How Web Development Agencies Can Boost Your Business  TapscapeA true one-of-a-kind website is made up of several design and optimization stages, including SEO, web *content* development, user experience and website.
Comparing TrueCar (TRUE) and Wix.Com (WIX)  Fairfield CurrentWix.Com (NASDAQ:WIX) and TrueCar (NASDAQ:TRUE) are both computer and technology companies, but which is the superior business? We will contrast the ...
What do Blockchain developers do?  Best in AustraliaThe meaning and explanation on what do Blockchain Developers do. The simple to understanding blockchain meanings and blockchain tutorial for beginners.
The Top 10 SEO Tools Marketers Want in 2019  Business 2 CommunityWhen we asked marketers what tools they were planning to use in 2019, we received more than 70 responses with nearly as many tools. They run the gamut ...
Student (17) who developed digital tools for quantum computing wins Young Scientist crown  The Irish TimesAdam Kelly used algorithms to 'analyse, optimise and simulate quantum circuits'
Head-To-Head Analysis: Career Education (CECO) vs. Learning Tree International (LTRE)  Fairfield CurrentLearning Tree International (OTCMKTS:LTRE) and Career Education (NASDAQ:CECO) are both small-cap consumer discretionary companies, but which is the ...
Forward Lays Off Newsroom Leaders And Goes Web-Only  ForwardThe Forward Association terminated ten employees on Wednesday, including editor-in-chief Jane Eisner and other senior newsroom leaders, while announcing ...
5 Ways in Which Data Science Is Revolutionizing Web Development  Analytics InsightCustom software development companies are figuring out new ways to utilize the advanced data science techniques to build customized websites to suit specific ...
What developers should know about Windows's shift to Chromium  InfoWorldMicrosoft's seismic shift from its own browser engine to Google's Chromium for Windows's Microsoft Edge browser is one of the biggest changes to the Windows ...
CSM celebrates its 20th Winter Commencement | thebaynet.com  Bay NetTwin brothers David and Darrell Rice, of Waldorf, graduated from the College of Southern Maryland with associate degrees in Art during CSM's 20th Winter ...
From being a rookie to grabbing an internship: Sanya's tryst with web development  QriusSanya Singh is a student of Northern India Engineering College, who learnt the ropes of web development through Internshala and bagged an internship.
Learn Web Development for Free With App Academy  LifehackerCoding school App Academy has opened a free online interactive version of its 12-week curriculum. That's a pretty good deal, since the Academy's in-person ...
9 Web development trends you simply cannot ignore in 2018  TechGenYZWeb development is a major part in conversions and increasing your sales.To optimize your websites know the web development trends of the year.
How Is Data Science Transforming Web Development?  DataconomyWeb app development is about to undergo a significant revolution triggered by the rise of data science. So far, developers have created apps based on focus ...
Know about the current trends in web development  Customer ThinkIn case of web development, you may have probably heard that the only constant is the change. It is an industry-defining statement as web development keeps ...
Careers in Web Development  Telangana TodayIn the last edition we have discussed about various technology stacks, what to learn and what is the career path. This article details about careers in web ...
Done Role of IoT in Web Development  Customer ThinkWith the increasing advent of technology and the ever-changing demands of people as well as businesses, there has been a rise in technologies which have ...
How will AI change the web development in future?  Customer ThinkAI is present everywhere – from chatbots to virtual assistants, AI is used in day to day activities. Virtual assistants like Siri and Cortana are helping the users by ...
How IoT Is Changing Web Development  IoT For AllIoT brings changes to software development on many levels, including on the web. Let's discuss the main peculiarities and nuances of IoT web development.
Focusing on data science and web development, edtech startup edWisor looks to bridge the skill gap  YourStory.comBootstrapped edWisor looks to address skill shortage in the areas of data science and web development, and uses gamification to align freshers with industry ...
4 Ways Web Development Has Changed Over the Years  The Hans IndiaWeb development has seen many changes over the years New ideas, new technologies and what is acceptable as an industry standard has pushed web ...
Things You Should Definitely Know About Web Development Team  Customer ThinkImagine one time you came up with a great idea to create a website for your company. The first step to take in this case is to hire a web development team of ...
Five hacks to land a top-notch internship in web development  Daily News & AnalysisWhether you've got your degree in web development or you're still studying, it is imperative to gain some practical experience in the field. But, landing a web ...
JavaScript and Web Development InfoQ Trends Report  InfoQ.comThis InfoQ Trends Report looks at the current trends with JavaScript, HTML, CSS, and web development in general, exploring technologies and options gaining ...
3 Reasons to utilize background checks  TechGenYZSo you think that your business needs a web presence. For an unmatched website, you would love to hire the best web development company. However, just ...
The real threat the government shutdown poses for the American economy  Brookings InstitutionThe government shutdown has produced a serious economic threat that's hiding in plain sight: the U.S. economy is flying blind. The people who collect, analyze ...
Spring MVC tutorial: How Spring Boot web MVC makes Java app development easy  TheServerSide.comThere are many Java web development tutorials available online, but there are very few Spring MVC examples that run within a Spring Boot project. This Spring ...
4 Questions to Ask a Web Developer During an Interview  DevOps.comWeb development is a fragile process. You need talented web developers to make truly beautiful sites with seamless user experiences and fast loading There's ...
Microsoft brings Chromium to Edge to reduce web development fragmentation  SDTimes.comMicrosoft has announced plans to adopt Chromium into Microsoft Edge on desktop. Chromium is an open-source web browser project created by Google.
Lean Web Development with the Best Teachers Online  Digital InspirationFor the past few months, I have been on a learning spree looking to enhance my existing coding skills and also learn new programming languages and ...
Report: What is the next big thing in web development?  JAXenterThe 2018 Packt Skill Up Report: We take a closer look at web development: What technologies are currently number one and what does the future hold?
How do I know if Web Development is right for me?  TechRepublicHow do you know if you're ready for a career change in tech, and if that change is right for you? A TechRepublic member is trying figure this out and is asking ...
6 steps to becoming a full stack developer  TechGenixThe journey to becoming a full stack developer might appear herculean at first. But once you master these six steps, you are on your way to getting there.
Why Hiring Top Web Developers is a Good Idea  DevOps.comWeb development is one of the most valuable activities of any company, especially tech companies and web design agencies.
Learn Web Development For Just $15 With This Amazing Complete Web Developer Course 2.0 – Limited Offer  WccftechLearn web development with Robert Percival. Get the Complete Web Developer Course 2.0 for an amazing discount offer and start a career!
Top 6 Web Development Trends that will Dominate 2019  ToolboxWhen it comes to web development you are bound to experience constant changes and updates in the designs every year. In fact, the updates and trends are ...
Tips to Hire a Web Developer with Required Skills in 2019  Customer ThinkWeb development is serious business. In recent years, it has had a great impetus and is one of the major priorities for every business irrespective of its size and ...
8 Tips To Start Building User-friendly eCommerce Website Development  Customer ThinkeCommerce, a big-time word which we hear every day. Whether, big or a small enterprise, eCommerce website development is an unsaid must for your ...
Learn the tricks of web development in 44 hours  Android AuthoritySpending just $29 could be the start of your future in web development. The minimum outcome is that you learn an interesting and marketable new skill. If things ...
Ten Basic Things Every Web Developer Should Know  HTML Goodiesten things you need to know if you plan to build a web site.
Yale announces Web Development “Bootcamp”  Yale Daily NewsYalies interested in programming will be able to take a 10-week web development boot camp this summer for credit, offered as a part of Yale Summer Session, ...
Django vs Flask: A Look At The Two Popular Python Web Frameworks  Analytics India MagazineIn this article, we look at two of the best frameworks, Django and Flask that can be used by Python programmers and developers.
Job vacancy: Marketing and web development project manager  International Association of Athletics FederationsThe IAAF is seeking a marketing and web development project manager at its Monaco headquarters. Reporting to the chief information officer, the marketing and ...
YouTube for Android gets a new UI and voice command for a better-customized interface  TechGenYZNeed to learn web design and development? No worries, there are millions of tutorials, and videos available on YouTube for people to learn new skills or to ...
Why has Python Failed To Penetrate The Enterprise Development Sector?  Analytics India MagazinePython has built considerable buzz in the large-scale web development space, but despite its popularity, it has failed to penetrate enterprise development.
Image Management 101: The Web Developer’s Guide  DevOps.comHow understanding the user experience can help web developers in managing images effectively Online experiences have in many ways supplanted in-person ...
4 Ways to Ensure Effective Web Development  Business 2 CommunityWhen it comes to building a new website, many businesses choose to focus predominantly on the design aspect of the project when approaching agencies to ...
Break into the field of web development with these discounted e-books  MashableThe barriers to breaking into the web development field are lower than ever. You no longer need to break the bank, quit your job, and enroll in a university to ...
What is Document Object Model (DOM) in Web Development?  TechnotificationBrowsers know how to convert the tags of the HTML into a tree with the help of DOM. Here is all you need to know about Document Object Model.
This web developer course is down by over £150  MashableProgress from a junior to senior web developer for just £11.99 with this course.
Which Cloud Solution Is Best For Your Web App Development  MobileAppDailyLearn more about which cloud solution is most suitable for your web app development and what is the right way to choose an efficient cloud *service* .
Understand Web Development in Less than 1 Hour  SitePointThis article explains what web development is, by exploring how it started and how it evolved.
Yale, Flatiron School create web development bootcamp for summer session  Yale NewsYale Summer Session is collaborating with Flatiron School to offer a Web Development Bootcamp for Summer 2019, which will carry two Yale College credits, ...
Top 5 Web Development Startups of 2018  BBN TimesTech Start-ups are the most trending things among investors and entrepreneurs due to the serious innovations they offer. Who knows which upcoming tech ...
How Website Development Has Changed Over the Years (infographic)  Digital Information WorldWebsite design has come a long way in a relatively short time. From zeros and ones to lines of code to intuitive website builders, designing for the web has ...
“ChromeOS is ready for web development” – A talk by Dan Dascalescu at the Chrome Web Summit 2018  Packt HubAt the Chrome Web Summit 2018, Dan Dascalescu, partner developer advocate at Google provided a high-level overview of ChromeOS and discussed ...
Full stack puts Bellevue University web development students ahead of the pack  Omaha World-HeraldStudents learn to design, code, implement and maintain an interactive website on their own.
Netlify just got $30 million to change the way developers build websites  TechCrunchNetlify wants to revolutionize the way developers build websites, abstracting away the web server and breaking web sites into microservices, making the process ...
Best web development tools of 2018  TechRadarGrab the right tools to get web development done without breaking a sweat.
How online learning platforms are bridging demand-supply gap in IT manpower requirement  YourStoryThere is a skill shortage in the IT industry, the global shortage to grow from 7 million to 23 million by 2022, 1.2 million in India set to increase to 6.5.
President Trump Directed His Attorney Michael Cohen To Lie To Congress About The Moscow Tower Project  BuzzFeed NewsPresident Donald Trump directed his longtime attorney Michael Cohen to lie to Congress about negotiations to build a Trump Tower in Moscow, according to two ...
Some of the Best IDEs and Text Editors for Web Development  TechnotificationThe right IDEs or a Text editor will be a huge help during coding. It'll help you be faster, accurate and productive for web development.
Use Rust for web development [Tutorial]  Packt HubRust is efficient and has well thought web-oriented frameworks, making it viable for web development. In this article, we'll see how Rust can be used for web ...
Is Agile Web Development All It's Cracked Up to Be?  EContentWhile AWD offers several advantages over waterfall and other methodologies, it has its limitations too. Whether you're preparing to take your first iterative plunge ...
5 examples of Artificial Intelligence in Web apps  Packt HubThis article highlights the five key areas where web apps are employing Artificial intelligence to automate some part of their system.
Learn the Essentials of Web Development with This eBook Bundle  Interesting EngineeringThrough hands-on, real-world instruction, this course teaches you about everything from development essentials like JavaScript, Java, and C++ to interview ...
How to learn web development online  Tech AdvisorWeb development is one of the 21st Century's most sought-after skills, but with so much to learn it can be quite daunting. After all, coding is quite literally like ...

Build a Web Site that Works...Even for a Safari Hobby!

My life's greatest passion is a safari hobby. And what... Read More

Creating Websites that Cater to Exam Preparations

One of the things that Internet excels is disseminating information... Read More

Using Mini Websites - Powerful Way to Direct Marketing

Mini Websites are the most powerful and cost effective solution... Read More

Web Analytics - Getting it Right

Understanding and using web analytics.In recent years, website marketers were... Read More

Building a Web Store on Shoestring Budget in less than Four Hours

Starting a business online is no longer as difficult as... Read More

How Disabled Users Access The Internet

In 1995 a new era of accessibility for disabled people... Read More

Creating Compelling Content , Write It and They Will Come

In a previous ezinearticles.com article,"I Need real visitors, Not Search... Read More

Make Your Own Website - General Website Design Tips

Wow, we`ve already taken a domain and chosen a web... Read More

Web Accessibility Myths

With more and more countries around the world passing laws... Read More

What is The Google Toolbar?

No matter what browser you may want to use, you... Read More

Now You Have a Web Site - Have You Ever Heard of Accessibility?

An accessible Web site is easily approached, easily understood, and... Read More

Have You Got Your Ear To The Ground Or Your Head In The Sand?

What happened on your website yesterday? What about last week... Read More

Learn to Build a Better Online Business Website Using Keywords and Content

Are you aware that 90% of the websites on the... Read More

The Power Is In The Pipes: How To Get Maximum Leverage From Your Website

What is the most important part of your online business?Many... Read More

FREE Amber Alert Tickers for Your Website

Project Safekids provides webmasters a valuable tool which could save... Read More

Guidelines for Web Page Optimization

Below, I have listed 8 simple steps that you can... Read More

10 Tips For Running A Profitable Web Site

1. Address your targeted audience on your business site. Example:... Read More

You Need To Treat Your Website Like An Employee - Heres 5 Ways To Do It

People often come to me in a state of crisis... Read More

Your Future Profit Is In The Stars

You don't believe in astrology but you check your horoscope... Read More

Earn On Offshore Web Design and Development

If you have some experience in web site design and... Read More

Make Your Own Brand!

There are millions and millions of websites on the Internet.... Read More

Why Every Small Business Owner Needs Two Websites

Every small business owner knows that they need a website,... Read More

Getting a Web Site Can Be Fast, Easy, and Inexpensive When You Know Your Options

So what do you do if need to get a... Read More

Business Website Building Do?s and Don?ts

First, using a lot of web graphics, flash, banners and... Read More

3 Essential Tools Every Website Designer and Marketer Needs

Appealing to others is really important when you have a... Read More