How to create database, table, add records and use where clause in sql | AKUEB | CS Knowledge
CS Knowledge
0:00 / 0:00
How to create database, table, add records and use where clause in sql | AKUEB | CS Knowledge
11 просмотров · 10 часов назад
CS Knowledge
562 подписчика
11 просмотров · 10 часов назад
Learn how to create a database, create tables, insert records, and execute SQL queries in Microsoft SQL Server Management Studio (SSMS). This step-by-step tutorial explains essential SQL commands in easy language for beginners and AKU-EB HSSC Computer Science students.
📚 *Topics Covered:*
Create a database using `CREATE DATABASE`.
Create a table using `CREATE TABLE`.
Insert records using `INSERT INTO`.
Retrieve records using `SELECT`.
Filter records using the `WHERE` clause.
Sort records using `ORDER BY ASC` and `DESC`.
Execute SQL queries in Microsoft SQL Server Management Studio (SSMS).
🎓 This practical tutorial is especially useful for Aga Khan University Examination Board (AKU-EB) HSSC Computer Science students preparing for SQL and database practical examinations.
👍 Like, Share, and Subscribe to *CS Knowledge* for more Python programming, SQL tutorials, and AKU-EB Computer Science practicals.
#SQL #MicrosoftSQLServer #SSMS #CreateDatabase #CreateTable #InsertInto #WhereClause #OrderBy #AKUEB #AgaKhanBoard #ComputerScience #CSKnowledge