SQL Programming: From Basics to Advanced

About Course

Baro SQL laga bilaabo aasaaska ilaa heer sare! Koorsadan waxa ay ku bari doontaa sida loo abuuro, loo maamulo, loona baaro xogta iyadoo la isticmaalayo SQL, adigoo ku tababaranaya SQL Server iyo MySQL. Waxay ku habboon tahay bilowga iyo kuwa raba xirfad shaqo oo ku saabsan databases.

Course Content

01 Introduction to Databases and SQL
Faham waxa database yahay, farqiga u dhexeeya data iyo information, iyo muhiimadda SQL.

01 INTRO SQL
09:25
02 INSTALLING SQL SERVER
08:28
03 OPENING SQL SERVER
07:15

02 SQL Basics & DDL
Baro syntax-ka SQL, abuurista iyo beddelidda database iyo Tables.

03 Data Manipulation Language (DML)
Ku daris, cusboonaysiin iyo tirtiridda xogta Tables ku jirta.

04 Querying Data with SELECT (DQL)
Soo saar xogta adigoo adeegsanaya SELECT, WHERE, ORDER BY iyo LIKE.

05 Aggregate Functions
Isticmaal COUNT, SUM, AVG, MIN iyo MAX si loo soo koobo xogta.

06 SQL Constraints
Ku dabaq xeerar sida PRIMARY KEY, FOREIGN KEY, CHECK iyo DEFAULT.

07 SQL Relationships
Abuur xiriir 1:1, 1:N iyo M:N adigoo isticmaalaya keys.

08 SQL Joins
Ku biiri xog ka kala timid jadwal kala duwan adigoo adeegsanaya INNER, LEFT, RIGHT, FULL JOIN.

09 Advanced SQL
Baro Subqueries, Views iyo Indexes si loo wanaajiyo queries.

10 Transaction Control Language (TCL)
Maamul transactions adigoo isticmaalaya COMMIT, ROLLBACK iyo SAVEPOINT.

11 Backup and Restore
Kaydi oo soo celi database si looga hortago luminta xogta.

12 Graphical Uses of SQL
Isticmaalka SQL iyada oo loo marayo tools graphical ah sida SSMS GUI.

13 MYSQL ON XAMPP

Student Ratings & Reviews

5.0

Total 1 Rating

1 Rating

0 Rating

jama cali

2 weeks ago

BEST

About Course

What Will You Learn?

Course Content

01 Introduction to Databases and SQL Faham waxa database yahay, farqiga u dhexeeya data iyo information, iyo muhiimadda SQL.

01 INTRO SQL

02 INSTALLING SQL SERVER

03 OPENING SQL SERVER

02 SQL Basics & DDL Baro syntax-ka SQL, abuurista iyo beddelidda database iyo Tables.

04 SQL Statement Basics

05 DDL CREATE DATABASE

06 CREATE TABLE

07 ALTER DROP

08 CHANGE ACTIVITY EXAMPLE

03 Data Manipulation Language (DML) Ku daris, cusboonaysiin iyo tirtiridda xogta Tables ku jirta.

09 SAVE Data (INSERT)

10 UPDATE DATA

11 DELETE & TRUNCATE

04 Querying Data with SELECT (DQL) Soo saar xogta adigoo adeegsanaya SELECT, WHERE, ORDER BY iyo LIKE.

12 DQL SELECTING OF DATA

13 DQL with WHERE, ORDER and Logical Operators

14 DQL SEARCH LIKE OPERATOR

05 Aggregate Functions Isticmaal COUNT, SUM, AVG, MIN iyo MAX si loo soo koobo xogta.

15 AGGREGATION FUNCTIONS

16 EXAMPLE OF AGGREGATIONS

17 GROUP BY AND HAVING

06 SQL Constraints Ku dabaq xeerar sida PRIMARY KEY, FOREIGN KEY, CHECK iyo DEFAULT.

18 CONSTRAINTS

19 NOT NULL & UNIQUE

20 PRIMARY KEY

21 FOREIGN KEY

22 CHECK & DEFUALT

07 SQL Relationships Abuur xiriir 1:1, 1:N iyo M:N adigoo isticmaalaya keys.

23 Relationship – One to One

24 RELATIONSHIP ONE TO MANY

25 MANY TO MANY

26 RELATIONSHIP ACTIVITY

08 SQL Joins Ku biiri xog ka kala timid jadwal kala duwan adigoo adeegsanaya INNER, LEFT, RIGHT, FULL JOIN.

27 JOINS INNER JOIN

28 LEFT, RIGHT & FULL Joins

09 Advanced SQL Baro Subqueries, Views iyo Indexes si loo wanaajiyo queries.

29 SUB QUERIES

30 VIEW

31 INDEXES

10 Transaction Control Language (TCL) Maamul transactions adigoo isticmaalaya COMMIT, ROLLBACK iyo SAVEPOINT.

32 TCL PART 1

33 TCL PART 2

11 Backup and Restore Kaydi oo soo celi database si looga hortago luminta xogta.

34 BACKUP

35 RESTORE

12 Graphical Uses of SQL Isticmaalka SQL iyada oo loo marayo tools graphical ah sida SSMS GUI.

36 GRAPHICAL USES OF SQL

13 MYSQL ON XAMPP

37 XAMPP DOWNLOAAD AND INSTALLING

38 OVERVIEW OF XAMPP

39 BACK UP & RESTORE