1
00:00:00,660 --> 00:00:07,530
Hello, dear friends, in greetings and salutations from Oak Academy, so in this course, we're going

2
00:00:07,530 --> 00:00:09,540
to learn everything about Ms.

3
00:00:09,540 --> 00:00:11,340
SQL Server basics.

4
00:00:11,910 --> 00:00:17,520
So this course is indeed for everyone who wants to learn MSL, SQL Server basics.

5
00:00:17,760 --> 00:00:21,690
So don't worry if you're a newbie to ask you well or ask you all server.

6
00:00:22,230 --> 00:00:23,690
Isn't that the best place to start?

7
00:00:23,700 --> 00:00:27,360
After all, we're going to take action right from the beginning.

8
00:00:27,480 --> 00:00:32,300
So first off, let me explain what we're going to learn in this course, section by section.

9
00:00:32,850 --> 00:00:39,240
So in this course, we're going to start with an introduction, which will include all the definitions

10
00:00:39,240 --> 00:00:43,950
and all of the explanations so that, you know exactly what's what data.

11
00:00:45,030 --> 00:00:45,900
Database.

12
00:00:47,270 --> 00:00:48,080
Squill.

13
00:00:49,130 --> 00:00:49,730
Query.

14
00:00:51,000 --> 00:00:52,230
RDBMS.

15
00:00:53,380 --> 00:00:55,870
Tables and database normalization.

16
00:00:59,670 --> 00:01:03,690
We're going to download and set up the required programs together.

17
00:01:04,730 --> 00:01:06,650
In order for you to use Ms.

18
00:01:06,650 --> 00:01:07,490
SQL Server.

19
00:01:08,900 --> 00:01:12,740
And then we're going to learn how to create a database.

20
00:01:16,020 --> 00:01:18,840
How to create a table in our database that we have created.

21
00:01:20,690 --> 00:01:27,830
And then next, we will cover how to retrieve data from the database with different queries in particular

22
00:01:27,830 --> 00:01:28,350
detail.

23
00:01:28,370 --> 00:01:29,180
We're going to see.

24
00:01:30,170 --> 00:01:31,220
Select statement.

25
00:01:35,150 --> 00:01:36,800
Restricted sorting.

26
00:01:39,930 --> 00:01:40,830
Grouping data.

27
00:01:45,560 --> 00:01:47,090
Conversion functions.

28
00:01:49,510 --> 00:01:51,250
Wild card operations.

29
00:01:54,540 --> 00:01:56,100
Daytime functions.

30
00:01:59,150 --> 00:02:01,640
Retrieve data from multiple tables.

31
00:02:04,400 --> 00:02:05,960
Set operations.

32
00:02:08,180 --> 00:02:09,500
Sub queries.

33
00:02:15,050 --> 00:02:16,460
String functions.

34
00:02:19,030 --> 00:02:20,440
And math functions.

35
00:02:23,360 --> 00:02:27,200
Then we're going to learn about Eskdale transactions.

36
00:02:28,610 --> 00:02:29,180
Comet.

37
00:02:30,460 --> 00:02:32,260
Roll back and save point.

38
00:02:35,560 --> 00:02:39,970
And then in the following section, we're going to also learn schema objects.

39
00:02:41,800 --> 00:02:42,820
Create schema.

40
00:02:46,580 --> 00:02:47,540
Great view.

41
00:02:50,360 --> 00:02:54,980
Create sequence, manage schema objects.

42
00:02:57,050 --> 00:03:01,400
And then in the section that follows that, we're going to learn about user privileges.

43
00:03:03,010 --> 00:03:05,020
Create and configure users.

44
00:03:07,430 --> 00:03:08,720
Managed logins.

45
00:03:12,480 --> 00:03:13,740
Manage roles.

46
00:03:16,530 --> 00:03:21,200
If you're ready to get started, I am, too, so let's move on to the introduction.