Microsoft MVA: SQL Database Fundamentals Part 3.03

Microsoft Virtual Academy: SQL Database Fundamentals | 2015
Module 3: Working with Data in Tables
Part 03: Module Wrap Up

This course will teach you the basics of relational databases, SQL Database fundamentals, along with those of database management systems and database components. Get an in-depth introduction to the terminology, concepts, and skills you need to understand database objects, administration, security, and management tools. Plus, explore T-SQL scripts, database queries, and data types.

Start with a look at creating tables, inserting data, and querying data in tables. Then, learn about data manipulation, optimize database performance, and work with non-relational data. Get practical help on basic database administration, including installation and configuration, backup and restore, security, monitoring, and maintenance. Take this SQL Database tutorial to prepare for additional online courses for database administrators (DBAs), developers, data scientists, and big data specialists.

Agenda:
- Learn about data manipulation using Transact-SQL (T-SQL), including INSERT, UPDATE, and DELETE. Explore wrapper objects, such as views and stored procedures.