SQL commands are instructions, coded into SQL
statements, which are used to communicate with the database to perform specific
tasks, work, functions and queries with data.
SQL commands can be used not only for searching the database but
also to perform various other functions like, example, you can Create
Table, add data to tables, or modify data, drop the table, set permissions
for users.
Data Definition Language (DDL) - These SQL
commands are used for creating, modifying, and dropping the structure of
database objects. The commands are CREATE, ALTER, DROP, RENAME, and TRUNCATE.
Data Manipulation Language (DML) -
These SQL commands are used for storing, retrieving, modifying, and deleting
data.
These Data Manipulation Language commands are : SELECT, INSERT, UPDATE, DELETE.
Transaction Control Language (TCL) -
These SQL commands are used for managing changes affecting the data. These
commands are COMMIT, ROLLBACK, and SAVEPOINT.
Data Control Language (DCL) - These SQL
commands are used for providing security to database objects. These commands
are GRANT and REVOKE.
One of the problems that I encounter when I started programming is on how to save record to a database.
I feel I need to share the knowledge that I gained within 2 years of my experience so that other programmer who would like to learn will benefit on this tutorial.
SQL stands for Structured Query Language and is the standard for accessing and or manipulating a database.
This tutorial will use the ISO standard so that you can apply the code that I will provided here.
The Google Assistant SDK, launched as a Developer Preview, means developers
can now embed Google Assistant in projects on their own hardware.
Until now Google Assistant has been available on Google hardware, Google
Home, Android Wear, Pixel phones and Android phones running Marshmallow and
Nougat. It also powers Allo, Google's instant messaging mobile app for Android
and iOS, where it provides a "smart reply" function that replies to messages
with automatic suggestions.
Back in January we reported that Google had opened up Actions on Google, its
developer platform for Google Assistant, enabling developers to use its
Conversation Actions for providing information, services, and assistance. At
that time Google Home was the only device supported.
Now the Google Assistant SDK allows you to add Actions on Google, with its
voice control, natural language understanding and Google’s smarts, to your own
devices, as explained in this video by Wayne Piekarski.
The SDK comes with reference sample code in Python for prototyping on
hardware such as the Raspberry Pi. If you want to work with other platforms, you
can generate bindings from the gRPC
API in a variety of languages.
If you’re not familiar with gRPC, it’s a “high performance, open-source
universal remote procedure call (RPC) framework”, also described as
"declarative, strongly-typed, and language Independent" that uses
Google Protocol Buffers as the Interface Description Language (IDL) for
describing a service interface as well as the structure of the messages
exchanged. This IDL can then be compiled to produce language-specific client and
server stubs.
Being language-independent means that you can describe your ideal service API
and the messages that it supports, and then use “protoc”, the protocol compiler,
to generate client and server stubs for your API. Out of the box, you can
produce client and server stubs in C/C++, C#, Node.js, PHP, Ruby, Python, Go and
Java. You can also get additional protoc plugins which can create stubs for
Objective-C and Swift.
A developer preview of the SDK is now available for those interested in
tinkering with platforms such as the Raspberry Pi 3. Later this year,
commercial device makers will also be able to use the SDK across a wide range of
hardware.
This raises the issue of cost, especially in light of the fact that Amazon
has recently announced its charges for Lex, its equivalent bot-building cloud
service, which has a free tier for the first year. Google hasn't mentioned
charging for the Actions on Google service - but it could and making a
distinction between tinkering with the platform and using it commercially
perhaps suggests that a tariff will be introduced later this year.
Vision
Mobile has launched its Developer Economics Q3 2017 survey and you'll find a
space journey theme and a smattering of programmer jokes as you complete it.
The incentive is prizes to win and personalized charts and graphs to show how
you compare to other developers in your country or region.
You'll
need around 20 minutes to complete the survey but you can save your progress if
you can't do it in a single session.
The
survey covers eight distinct areas of development and the more optional
sections you include the better you chance of winning a prize, and there are
more prizes on offer if you join the Developer Economics Panel.
There's
a Spaceship theme to this edition (the 13th) of the survey and once you've
completed it the immediate feedback is what type of developer you are - Space
Cadet, Robot Trooper, Bounty Hunter
being just three of the option. The
jokes don't have a space theme, but are programmer related.
The
following infographic is a summary of the results of the previous survey,
conducted in October/November 2016:
One
of the main motivations for joining in the survey is to improve on the total of
21,200 respondents in the previous survey and make it more comprehensive.
