SQL Database Module Wrap Up Computer Knowledge 03
Instructor(s):
Graeme Malcolm / @graeme_malcolm
Chris Randall / @cfrandall
Would you like to learn the basics of relational databases? Join us for this look at 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. Check it out!
1 | Introduction to Databases
View a course introduction, and get started with databases.
2 | Getting Started with Tables
Get an introduction to concepts and techniques for creating tables, inserting data, and querying data in tables.
3 | Working with Data in Tables
Learn about data manipulation using Transact-SQL (T-SQL), including INSERT, UPDATE, and DELETE. Explore wrapper objects, such as views and stored procedures.
4 | Optimizing Database Performance
Get an introduction to terminology and concepts for optimizing database performance by using indexes.
5 | Working with Non-Relational Data
Explore additional types of data that can be used in modern databases, including XML and JSON.
6 | Basic Database Administration
Learn about terminology and concepts for basic database administration, including installation and configuration, backup and restore, security, monitoring, and maintenance.
Learn
• Get an introduction to databases.
• Get started with tables.
• Work with data in tables.
• Optimize database performance.
• Work with non-relational data.
• Explore basic database administration.
Prerequisites
None
Creative Commons Attribution (Reuse Allowed)
Microsoft Courses
Sur cette page du site, vous pouvez voir la vidéo en ligne SQL Database Module Wrap Up Computer Knowledge 03 durée heure minute seconde en bonne qualité , qui a été Téléchargé par l'utilisateur Computer Knowledge 15 mars 2019, Partagez le lien avec vos amis et connaissances, sur youtube cette vidéo a déjà été regardée 13 fois et il a aimé 0 téléspectateurs. Bon visionnage!
