This SQL SERVER COURSE offers you specialist training in this field. It is important to realise that, nowadays, companies and their businesses are moving very rapidly towards cloud storage and services, and this goes hand in hand with the ever-increasing demands of their customers. To counteract o to balance For a business that relies on the cloud, it is essential to have a “cloud-ready” platform. To cope with all these changes and, furthermore, to meet the rapidly growing number of companies with these needs, Microsoft SQL Server It was developed to be a cloud-ready platform. This means that the database management system is designed, first and foremost, to help your organisation build cloud-based solutions with all the tools and security measures required to do so.
SQL Server
Digital Skills
200 hours
Introduction
Objectives
-
Refresh your knowledge of SQL Server to understand and master the features that enable you to design and create a database.
-
Define the tables, as well as the handling of the data: the various SQL and Transact-SQL statements (procedures, functions, triggers).
-
To know the management unstructured data (FILESTREAM), hierarchical structures and geographical data.
-
Learning the main ones features which enable more efficient data management, such as XML or the integration of CLR (Common Language Runtime) code.
Table of Contents
TEACHING UNIT 1. Installing and configuring SQL Server
1. What is SQL Server?
2. Advantages of using SQL Server
3. Prerequisites
3.1. Hardware requirements
3.2. Software requirements
4. Download and installation
4.1. Downloading the software
4.2. Installation guide
TEACHING UNIT 2. Creating and managing databases in SQL Server
1. Database design
1.1. Basic concepts
1.2. Data modelling
2. Creating databases in SQL Server
2.1. Creating tables
2.2. Adding data to the table
2.3. Creating relationships between tables
3. Database administration in SQL Server
4. Transact-SQL
5. Integration with other technologies
TEACHING UNIT 3. SQL Queries and Data Manipulation Language
1. Transactions in SQL Server
1.1. ACID properties of transactions in SQL Server
1.2. Inserting records
1.3. Deleting records
1.4. Modifying records
2. Creating transactions in SQL Server
3. Transaction concurrency control
4. Distributed transactions
TEACHING UNIT 4. Stored procedures and functions in SQL Server
1. Stored procedures
2. Creating functions in SQL Server
2.1. Built-in functions in SQL
3. Differences between procedures and functions
TEACHING UNIT 5. Query Optimisation and Performance in SQL Server
1. Consultation Implementation Plan
2. Metrics and their role in optimisation
3. Performance settings
3.1. Memory configuration
3.2. CPU and resource configuration
4. Performance tools
4.1. SQL Server Performance Monitor
4.2. SQL Server Dynamic Management Views
4.3. SQL Server Trace
TEACHING UNIT 6. Security and user management in SQL Server
1. Access security components
2. Access security management
3. Network-level access security
4. Data-level access security
4.1. Data encryption
5. Security tools
5.1. SQL Server Audit
5.2. SQL Server Encryption
5.3. SQL Server Firewall
TEACHING UNIT 7. Backups in SQL Server
1. Backups
2. Planning backup strategies
3. Backup settings
4. Data recovery
More related courses
Your questions answered
Why choose Educa.Pro?
Educa.Pro enables organisations to centralise training management, personalise learning and gain clear insights into the impact of training programmes. Thanks to its AI-powered technology, organisations can optimise their learning strategies, enhance talent development and make data-driven decisions.
Can the courses be taken at your own pace?
Yes. Most of the courses on Educa.Pro are self-paced and on-demand, allowing users to progress at their own pace without missing out on progress tracking or assessments, which makes it easier to fit them around work or study commitments.
What levels of security and compliance does the platform offer?
Educa.Pro complies with security standards designed to protect user and organisational data. Furthermore, it supports the traceability of certifications, digital signatures and the management of assessments, thereby ensuring regulatory and legal compliance in both educational and corporate environments.
What support and guidance does Educa.Pro offer?
The Educa.Pro team offers comprehensive support throughout implementation, roll-out and adoption, ensuring that organisations get the most out of the platform and achieve measurable results from day one.