SQL Server

Name: SQL Server
Brand: Educa PHAROS
SKU: AFO028J8H
Availability: InStock

Cross-cutting

Digital Skills

Duration

200 hours

PRESENTATION

This SQL SERVER COURSE offers you specialized training in this field. It’s important to understand that today, companies and their businesses are rapidly shifting toward cloud storage and services, and this goes hand in hand with the ever-increasing demands of their customers. To counteract o balance For a business that relies on the cloud, it is essential to have a “cloud-ready” platform. To adapt to all these changes and also 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 to help your organization build cloud-based solutions with all the tools and security required to do so.

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 manipulation of the data: the various SQL and T-SQL statements (procedures, functions, triggers).
Learn about the management unstructured data (FILESTREAM), hierarchical structures, and geographic data.
Learn the main ones features that enable more efficient data management, such as XML or the integration of CLR (Common Language Runtime) code.

Syllabus

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 LEARNING UNIT 2. Creating and Managing Databases in SQL Server 1. Database Design 1.1. Basic Concepts 1.2. Data Modeling 2. Creating Databases in SQL Server 2.1. Creating Tables 2.2. Adding Data to a Table 2.3. Creating Relationships Between Tables 3. Database Administration in SQL Server 4. Transact-SQL 5. Integration with Other Technologies LEARNING 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. Updating Records 2. Creating Transactions in SQL Server 3. Concurrency Control in Transactions 4. Distributed Transactions LEARNING 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 LEARNING UNIT 5. Query Optimization and Performance in SQL Server 1. Query Execution Plan 2. Indexes and Their Role in Optimization 3. Performance Configuration 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 LEARNING 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 LEARNING UNIT 7. Backups in SQL Server 1. Backups 2. Planning Backup Strategies 3. Backup Configuration 4. Data Recovery

Request for Information

Name *

Last Name *

Country

Phone

Email *

Company

Job Position

Sector

Message

I have read and agree to the Privacy Policy

Related MOOCs

Workplace Risk Prevention, Ergonomics, and Mental Health

The Course on Workplace Risk Prevention, Ergonomics, and Mental Health addresses the growing need to ensure environments...

Digital Disconnection and Legal Compliance in the Workplace

In the age of remote work, hyperconnectivity has put companies under the scrutiny of the Labor Inspectorate....

The Right to Digital Disconnection, Health, and Work Ethics

In a world of global digitization, hyperconnectivity has gone from being an advantage to becoming a challenge...

Are the Educa PHAROS courses eligible for credit?

Many courses can be credited toward the master's programs at Structuralia.

Facts about our area

+ 1.483

Hours

+88.999

Minutes

264

Courses

Are the masterclasses live?

Who is it intended for?

What features does Educa PHAROS have?

What guarantees does Educa PHAROS offer?

Why is Educa PHAROS the best solution?

Educa PHAROS is a next-generation training model that places a company’s human capital at the forefront. Through a platform that adapts to each company’s corporate identity and offers a total of more than 900 courses, it provides tailored training for each organization. The unlimited flat-rate plan provides each company with the number of courses that best suits its needs, as well as the ability to determine which employees will have access.