Lynda Database Fundamentals Core Concepts | C6B6305E5F2F19AF3BF5D98E858D5B89F353E8C6

Lynda Database Fundamentals Core Concepts

Name	Lynda - Database Fundamentals - Core Concepts	DOWNLOAD Copy Link
Total Size	397.3 MB
Total Files	46
Hash	C6B6305E5F2F19AF3BF5D98E858D5B89F353E8C6

/01. Introduction/
01_01-Welcome.mp4	8.0 MB
01_02-Preparing for Microsoft Technology Associate MTA Exam 98364.mp4	5.4 MB
01_03-Using the exercise files.mp4	998.8 KB
01_04-Challenges explained.mp4	871.0 KB
/02. Understanding Data Storage Models/
02_01-What are databases.mp4	6.2 MB
02_02-Understanding flat file databases.mp4	4.8 MB
02_03-Understanding hierarchical databases.mp4	3.0 MB
02_04-Understanding relational databases.mp4	6.1 MB
02_05-Exploring database fundamentals.mp4	7.1 MB
02_06-Calculating values.mp4	3.0 MB
/03. Building Your Server/
03_01-Understanding the role of the server.mp4	5.6 MB
03_02-Downloading SQL Server 2014 Express.mp4	14.0 MB
03_03-Installing SQL Server 2014 Express.mp4	22.6 MB
03_04-Previewing the SQL Server Management Studio SSMS graphical interface.mp4	12.8 MB
03_05-Using SSMS to restore a database.mp4	23.2 MB
03_06-Creating your first database in SSMS.mp4	11.9 MB
03_07-Creating your first table in SSMS.mp4	21.0 MB
03_08-Modifying your table design.mp4	10.7 MB
03_09-Removing a database from the server.mp4	3.5 MB
03_10-Introducing views.mp4	17.0 MB
03_11-Peering inside the system tables.mp4	14.2 MB
03_12-Challenge Start building your own database.mp4	2.0 MB
03_13-Solution Start building your own database.mp4	9.7 MB
/04. Understanding Data Definition Language DDL/
04_01-Using DDL statements to create database objects.mp4	5.5 MB
04_02-Creating new database objects.mp4	14.9 MB
04_03-Choosing the active database with USE.mp4	9.6 MB
04_04-Altering existing database objects.mp4	8.8 MB
04_05-Removing objects with DROP.mp4	4.9 MB
04_06-Removing records from a table with TRUNCATE.mp4	7.1 MB
04_07-Challenge Creating a table using DDL.mp4	1.5 MB
04_08-Solution Creating a table using DDL.mp4	8.2 MB
/05. Understanding Data Manipulation Language DML/
05_01-Writing commands in DML.mp4	2.8 MB
05_02-Selecting data from a table.mp4	14.1 MB
05_03-Inserting records into a table.mp4	15.2 MB
05_04-Updating data.mp4	11.5 MB
05_05-Deleting rows from a table.mp4	6.6 MB
05_06-Merging data tables.mp4	18.4 MB
05_07-Challenge Using DML.mp4	1.7 MB
05_08-Solution Using DML.mp4	12.2 MB
/06. Understanding Relational Database Concepts/
06_01-Establishing relationships.mp4	5.6 MB
06_02-Exploring data constraints.mp4	11.3 MB
06_03-Adding indexes to tables.mp4	6.4 MB
06_04-Following naming conventions.mp4	3.0 MB
06_05-Organizing the design with schemas.mp4	9.5 MB
/07. Conclusion/
07_01-Next steps.mp4	3.4 MB
/Exercice Files/
Ex_Files_DBFund_CoreConcepts.zip	1.3 MB
Total files 46