Главная
Study mode:
on
1
00 SQL Database Fundamentals: Introduction to Databases
2
01 Creating and Configuring a Database
3
02 Module Wrap-Up
4
03 Creating Tables
5
04 Creating Tables
6
05 Data Types
7
06 Data Types
8
07 Working with Multiple Tables
9
08 Referential Integrity
10
09 Introducing Views and Procedures
11
10 Module Wrap-Up
12
11 Introducing Indexes
13
12 Clustered and Non-Clustered Indexes
14
13 Column store Indexes
15
14 Memory-Optimized Objects
16
15 Working with XML in Databases
17
16 Introduction to JSON
18
17 Introduction to Document DB
19
18 Introduction to Basic Database Administration
20
19 Provisioning SQL Server in an Azure Virtual Machine
21
20 Introduction to SQL Server Recovery
22
21 Introduction to Database Security
23
22 Monitoring and Maintenance
24
23 Module Wrap-Up
Description:
Dive into the fundamentals of SQL databases in this comprehensive tutorial. Begin with an introduction to databases and learn how to create and configure them. Explore table creation, data types, and working with multiple tables while understanding referential integrity. Discover views, procedures, and various types of indexes including clustered, non-clustered, and column store. Delve into memory-optimized objects, XML in databases, JSON, and Document DB. Gain insights into basic database administration, provisioning SQL Server in Azure, recovery processes, security measures, and monitoring techniques. Master the essentials of Structured Query Language (SQL) and its application in Relational Database Management Systems (RDBMS) to efficiently manage and manipulate data in popular database systems like MySQL, Oracle, and SQL Server.

SQL Database for Beginners

Extern Code
Add to list