In this course we will take the first steps with this technology, we will install SQL Server and we will approach everything related to the administration of databases, we will know the main concepts involved in the management of a database and we will see in which sections and more ..
This product is no longer in stock
In this course we will take the first steps with this technology, we will install SQL Server and we will deal with everything related to the administration of the databases, we will know the main concepts involved in the management of a database and we will see in which sections and sections are administered The main options that a Microsoft SQL Server database administrator should know.
Introduction to SQL and installation
In this chapter we will see an introduction to the topics that we will see in this course, we will give a review of the installation of SQL Server and, also, we will see a little about the official documentation.
SQL Server 07:05
SQL Update 07:38
Downloading SQL Server 05:04
Installing SQL Server 03:26
Official documentation and help of SQL Server 04:43
Quick review of the SQL tool 07:02
Creation and basic administration of a database
In this chapter we will see what the creation and basic administration of a SQL Server database consists of, we will work with an instance and we will see the process of the tracking and how an audit is performed in the database.
Creation of the database in SQL Server 07:21
Instance configuration 07:36
More instance configuration options 08:12
Collation and Unicode Concepts 04:32
Server tracking concept 08:41
Read the trail inside a SQL Server database 04:42
Auditing the database 07:36
Server logs: what they are and where they are 03:35
Security in the SQL Server database
In this chapter we will look at the security of the databases in reference to the administration of SQL Server 2016, emphasizing the issue of the levels. Thus, we must distinguish between the server level and the database level.
Manage roles in databases 05:42
Start of session in security administration 07:23
Manage users in database 05:51
Manage roles in the database 04:13
Implement permissions on the server 05:04
Implementing permissions in the database 05:28
Activators login session 02:13
Data management and end of course
In this final chapter we will see how to handle the issue of backups in a database and how the database is moved if necessary, at the same time we will share a series of final recommendations so that the student can consolidate their knowledge.
Create a backup in the database 08:24
Move a database 03:40
Final recommendations and conclusion of the SQL Server course 02:34
Size: 297 MB
Formators: José Dimas Luján Castillo
Content: 24 Videos
Duration: 2:17 hours
Software: SQL Server, SQL Server 2016
Base Files: DOES NOT contain
Publication date: November- 2017
Totally free of viruses and malicious software, so do not wait any longer to download it now.
Do not forget to give us an opinion about the course, to improve the content.
NOTE: Do not forget to follow us on our facebook and twitter social networks so that you become part of our community and receive the notification every time we post something new, so you will not miss anything.
NO registration required!
If the question you have has not yet been answered here, use the form below to ask something about this addon.