Buy and Download - Lynda.com Database Fundamentals Core Concepts

2015
Lynda
Adam Wilbert
2:14
English

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.

Introduction
Welcome
Preparing for Microsoft Technology Associate (MTA) Exam 98-364
Using the exercise files
Challenges explained
1. Understanding Data Storage Models
What are databases?
Understanding flat file databases
Understanding hierarchical databases
Understanding relational databases
Exploring database fundamentals
Calculating values
2. Building Your Server
Understanding the role of the server
Downloading SQL Server 2014 Express
Installing SQL Server 2014 Express
Previewing the SQL Server Management Studio (SSMS) graphical interface
Using SSMS to restore a database
Creating your first database in SSMS
Creating your first table in SSMS
Modifying your table design
Removing a database from the server
Introducing views
Peering inside the system tables
Challenge: Start building your own database
Solution: Start building your own database
3. Understanding Data Definition Language (DDL)
Using DDL statements to create database objects
Creating new database objects
Choosing the active database with USE
Altering existing database objects
Removing objects with DROP
Removing records from a table with TRUNCATE
Challenge: Creating a table using DDL
Solution: Creating a table using DDL
4. Understanding Data Manipulation Language (DML)
Writing commands in DML
Selecting data from a table
Inserting records into a table
Updating data
Deleting rows from a table
Merging data tables
Challenge: Using DML
Solution: Using DML
5. Understanding Relational Database Concepts
Establishing relationships
Exploring data constraints
Adding indexes to tables
Following naming conventions
Organizing the design with schemas
Conclusion
Next steps