SQL SERVER 2008 TUTORIAL PART 1
SQL SERVER 2008 TUTORIAL PART 1
SQL is a standard language for storing, manipulating, and retrieving data in databases.
In this SQL tutorial, I will teach you the basic syntax of how to execute SQL queries
This SQL Query Language is divided into 3 parts:
1. DDL (Data Definition Language)
• Create a database (CREATE DATABASE)
• Delete database (DROP DATABASE)
• Create a table (CREATE TABLE)
• Delete table (DROP TABLE)
• Change the table (ALTER TABLE)
2. DML (Data Manipulation Language)
• Adding a record (INSERT INTO)
• View table contents (SELECT)
• Changing the contents of the record (UPDATE)
• Delete records (DELETE)
3. DCL (Data Control Language): a group of commands used to authorize data access and space allocation.
For example: a data can be accessed by A, but cannot be accessed by B
• GRANT
• REVOKE
• COMMIT
• ROLLBACK
On this page of the site you can watch the video online SQL SERVER 2008 TUTORIAL PART 1 with a duration of hours minute second in good quality, which was uploaded by the user TUTORIAL 28 October 2020, share the link with friends and acquaintances, this video has already been watched 13,559 times on youtube and it was liked by 323 viewers. Enjoy your viewing!
