SQL For Databases : A Beginner's Quick Introduction

Course details

This course is a beginners introduction to SQL which stands forstructured query language. It is the language used to communicate andmanipulate databases.

In this course you will learn to C.R.U.D using SQL. C.R.U.D is an acronym for Create,Read,Update and Delete. These are the main functions thatSQL can do on any database. There are other related tasks that SQL does or cando but the bulk of what it is used for is C.R.U.D.

The course is 100%video lectures structured in an orderlyand easy to follow manner. It is advisable that you follow the course in the order of the lectures. The course is just under two hours long.

This course will giveyou the knowledge required to create ,read ,update and delete data from anydatabase system using SQL. This ispossible because SQL is a standard language and will perform C.R.U.D in the same way regardless of the type of database. This course will help you understand How tomanipulate databases using SQL. Also you will learn how to retrieve onlyrelevant data or information you need and order them in the way you want.

What you will Learn in this course includes :

How to write SELECTstatements

How to create a table and a view

How to Update existing records in a database

How to Insert or addnew records or data into a database.

How to delete a record from a database table

How to create a database report and export to excel

How to restrict and sort data returned by the SELECT query

How to use the WHERE Clause to filter data

How to use ORDER BY Clause to put retrieved data in order specifiedby table column