Hello, dear friends, in greetings and salutations from Oak Academy, so in this course, we're going
to learn everything about Ms.
SQL Server basics.
So this course is indeed for everyone who wants to learn MSL, SQL Server basics.
So don't worry if you're a newbie to ask you well or ask you all server.
Isn't that the best place to start?
After all, we're going to take action right from the beginning.
So first off, let me explain what we're going to learn in this course, section by section.
So in this course, we're going to start with an introduction, which will include all the definitions
and all of the explanations so that, you know exactly what's what data.
Database.
Squill.
Query.
RDBMS.
Tables and database normalization.
We're going to download and set up the required programs together.
In order for you to use Ms.
SQL Server.
And then we're going to learn how to create a database.
How to create a table in our database that we have created.
And then next, we will cover how to retrieve data from the database with different queries in particular
detail.
We're going to see.
Select statement.
Restricted sorting.
Grouping data.
Conversion functions.
Wild card operations.
Daytime functions.
Retrieve data from multiple tables.
Set operations.
Sub queries.
String functions.
And math functions.
Then we're going to learn about Eskdale transactions.
Comet.
Roll back and save point.
And then in the following section, we're going to also learn schema objects.
Create schema.
Great view.
Create sequence, manage schema objects.
And then in the section that follows that, we're going to learn about user privileges.
Create and configure users.
Managed logins.
Manage roles.
If you're ready to get started, I am, too, so let's move on to the introduction.