تفاصيل الدورة
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
تحديث بتاريخ 16 October, 2015Database Management أسئلة ذات صلة
- JavaScript Full stack web developer virtual internship Virtual Bootcamp + Internship at Laimoon1,449 درهممدة الدورة التدريبية: Upto 30 Hours
- General Data Protection Regulation - GDPR Apex Learning92 درهم
1,763 درهممدة الدورة التدريبية: Upto 2 Hours - Data Protection Course Line92 درهم
1,690 درهممدة الدورة التدريبية: Upto 4 Hours