Most of us will want their PC's to go to sleep or hibernate or even shutdown automatically at specified time. Maybe cause you had been listening to some cool music and you fell asleep, you would want your machine to also shutdown. What most of us do is download a software created by another person, preferably a geek and run it with ease not knowing thats just a bunch of dos commands scripted into a batch script and fed into the system log. But ever thought how simple that was? well this post explains that.
The Process
1. simply open up Run by pressing windows+r
2. type in the following: at 23:59 shutdown -s then press enter
This will shut your PC at 11:59 pm i tell you...
To get of this timing simply open run once again and type the following command
shutdown -a
Sunday, 28 December 2014
Friday, 10 October 2014
SQL SYNTAX
SQL that stands for Structured Query Language...And what we read as S - Q - L instead of Sequel is an advanced relational database system that offers a robust environment to allow for organization to store their information in a secure manner. Not putting into effect its largest competitor, the Oracle Database.
However, both languages have almost similar syntax, this should not be a confusing factor that learning SQL means you understand Oracle, rather learning SQL makes you understand database manipulation methods that could be used in oracle too.
Before SQL, people would use Microsoft Access that offered an intuitive simple interface for most individuals to work with.
Many powerful tasks can be performed in SQL by use of its mere seven powerful statements:
SELECT
INSERT
UPDATE
CREATE
ALTER
DROP, and
DELETE
The above statements fall under two major categories:
DATA MANIPULATION LANGUAGE (DML), and
DATA DEFINITION LANGUAGE(DDL)
DML:
SELECT- used to select data in one or more columns of one or more tables
INSERT - allows you append rows to an existing table
UPDATE - allows you to update data in one or more rows of one or more tables
DELETE - allow you delete one or more rows from a table or multiple tables
DDL:
CREATE - enables you create new table, or create new index
ALTER - enables you modify structure of existing table thro adding and deleting columns
DROP - enables you delete a table or a database
The next tutorial will be on using the DML and DDL'S
However, both languages have almost similar syntax, this should not be a confusing factor that learning SQL means you understand Oracle, rather learning SQL makes you understand database manipulation methods that could be used in oracle too.
Before SQL, people would use Microsoft Access that offered an intuitive simple interface for most individuals to work with.
Many powerful tasks can be performed in SQL by use of its mere seven powerful statements:
SELECT
INSERT
UPDATE
CREATE
ALTER
DROP, and
DELETE
The above statements fall under two major categories:
DATA MANIPULATION LANGUAGE (DML), and
DATA DEFINITION LANGUAGE(DDL)
DML:
SELECT- used to select data in one or more columns of one or more tables
INSERT - allows you append rows to an existing table
UPDATE - allows you to update data in one or more rows of one or more tables
DELETE - allow you delete one or more rows from a table or multiple tables
DDL:
CREATE - enables you create new table, or create new index
ALTER - enables you modify structure of existing table thro adding and deleting columns
DROP - enables you delete a table or a database
The next tutorial will be on using the DML and DDL'S
Subscribe to:
Posts (Atom)