Database Fundamentals Exam 98-364: MTA: Database Fundamentals Год выпуска: 2016 Производитель: CBT Nuggets Сайт производителя: cbtnuggets.com/it-training/database-fundamentals Автор: Garth Schulte Продолжительность: 7:00 Тип раздаваемого материала: Видеоклипы Язык: Английский Описание: Databases and the data they contain are crucial to every business and application out there today, which is why IT professionals with data-oriented skills are in constant demand! Whether you're looking to pick up basic SQL skills for data analysis or begin your journey to becoming a full-blown database engineer, this course is the starting line as it assumes no prior database or query experience, and will prepare you to delve deeper into the world of database platforms and certifications. This Database Fundamentals course introduces you to the basics of creating, querying, and administering databases. We cover core database concepts; relational database concepts; querying data using the SQL language; database objects such as tables, views and stored procedures; Microsoft's SQL Server database platform; working in graphical tools such as SQL Server Management Studio; and the basics of administering a database. Базы данных и содержащиеся в них данные имеют решающее значение в любом бизнесе и приложения там сегодня, именно поэтому специалистам, ориентированные на данные, навыки пользуются постоянным спросом! Если вы ищете, чтобы забрать основные SQL-навыки анализа данных, или же начать свое путешествие, чтобы стать полноценным инженером базе, данный курс является стартовой линии так как он не несет никакой предварительной базы данных или запроса опытом и подготовят вас углубиться в мир базе платформ и сертификаты.
Содержание
1. Welcome to Database Fundamentals (9 min) 2. Getting Started with Databases (15 min) 3. The Relational Database (19 min) 4. The SQL Language (26 min) 5. Lab: Creating a Database (7 min) 6. Creating Tables (24 min) 7. Lab: Working with Tables (16 min) 8. Writing Basic Queries (23 min) 9. Enhancing Queries with Conditions (23 min) 10. Modifying Data with Queries (16 min) 11. Lab: Working with SQL (25 min) 12. Normalization (16 min) 13. Keys & Constraints (21 min) 14. Indexes (14 min) 15. Writing Advanced Queries (18 min) 16. Lab: Designing a Database (12 min) 17. Creating Views (11 min) 18. Creating Stored Procedures (17 min) 19. Creating Functions (18 min) 20. Lab: Working with Database Objects (15 min) 21. Security (14 min) 22. Backup & Recovery (16 min) 23. Ongoing Maintenance (15 min) 24. Lab: Administering a Database (12 min)
Об авторе
"I've always believed the best way to learn anything is to see it happen and try it yourself. My first experience with CBT Nuggets reinforced that belief and I'm both proud and honored to be a part of a company that strives to enrich people's lives with the power of knowledge!" Garth Schulte began training on Office products about 20 years ago. His love of training led him to branch out to technical VB6 and SQL Server training. One of CBT Nuggets’ longest-tenured trainers, he recently worked as a product manager, lead .NET windows programmer and SQL Server architect for one of the top back-end real estate software companies in the country. He is a Google Authorized Trainer.
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum You cannot attach files in this forum You can download files in this forum
![[Quote]](./templates/default/images/lang_english/icon_quote.gif "Reply with quote"){kind=icon}
![[Profile]](./templates/default/images/lang_english/icon_profile.gif "View user's profile"){kind=icon}
![[PM]](./templates/default/images/lang_english/icon_pm.gif "Send pm"){kind=icon}
