Lynda - Database Fundamentals: Core Concepts

[Alexandr 3]

 

Lynda - Database Fundamentals: Core Concepts

English | 2h 14m | AVC (.mp4) 1280x720 15fps | AAC 48KHz 2ch | 392 Mb

Genre: eLearning

 

 

Understand the core concepts every IT professional should know to start working with databases. This course, the first in a four-part series with database consultant Adam Wilbert, is designed to provide a solid foundation that will serve you throughout your IT career. Learn about the different data storage models and find out how to build your first database with SQL Server-the Express edition, which requires no hardware or special connections for setup. Then discover how to create database objects with the data definition language (DDL) and edit data in your tables with data manipulation language (DML). Adam also covers critical relational database concepts, such as relationships, indexes, and schemes.

 

Topics include:

Understanding flat file, hierarchical, and relational databases

Installing SQL Server 2014 Express

Creating your first database and tables

Creating and editing database objects

Writing commands in DML

Selecting and inserting data

Updating and deleting data

Establishing relationships and file naming conventions

DOWNLOAD

 

Ukryta Zawartość

Treść widoczna tylko dla użytkowników forum DarkSiders. Zaloguj się lub załóż darmowe konto na forum aby uzyskać dostęp bez limitów.