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