All courses
SQL Database
Barnaamijkan khaaska ah waxaad si toos ah oogu baran doontaa xirfada Database. Marka aad dhamaysatid waxaad awoodi doontaa Eebe idinkii in aad fahantid guud ahaan Databaseka.
About this course
<p>Barnaamijkan khaaska ah waxaad si toos ah oogu baran doontaa xirfada Database. Marka aad dhamaysatid waxaad awoodi doontaa Eebe idinkii in aad fahantid guud ahaan Databaseka. sidoo kalena waxaad toos u baran doontaa barnaamijyada khaaska ah ee loo isticmaalo Databaseka sida SQLka.</p>
Course content
1. Part 1: Introduction · 6 lessons
- Database world
- introduction to database
- DBMS
- SQL Overview
- SQL Server installation
- SQL Commands
2. Part 2: RDBMS · 2 lessons
- RDBMS Concepts
- SQL Constraints
3. Part 3: Data Definition · 7 lessons
- Data Types
- Data Definition Language
- Advanced DB SQL syntax
- databse creation
- Advanced DB creating Table
- Advanced DB adding new column
- Adding constraint to a table
4. Part 4: Data Manipulation · 9 lessons
- Data Manipulation Language
- insert into statement
- Update Statement
- Delete Statement
- Select Statement
- Where Clause
- SQL Operators
- Orderby Clause
- Operators