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.
Overview
Syllabus
00 SQL Database Fundamentals: Introduction to Databases
01 Creating and Configuring a Database
02 Module Wrap-Up
03 Creating Tables
04 Creating Tables
05 Data Types
06 Data Types
07 Working with Multiple Tables
08 Referential Integrity
09 Introducing Views and Procedures
10 Module Wrap-Up
11 Introducing Indexes
12 Clustered and Non-Clustered Indexes
13 Column store Indexes
14 Memory-Optimized Objects
15 Working with XML in Databases
16 Introduction to JSON
17 Introduction to Document DB
18 Introduction to Basic Database Administration
19 Provisioning SQL Server in an Azure Virtual Machine
20 Introduction to SQL Server Recovery
21 Introduction to Database Security
22 Monitoring and Maintenance
23 Module Wrap-Up
Taught by
Extern Code
