Shoping cart:
Empty
Cheap Software
Search by Letter:
A B C D E F G H I J K L M N O P Q R S T U V W X Y Z All programs New Mac

CBT Nuggets Garth Schulte Database Fundamentals

20$
Buy!Download Size: 1.57 GB


2016
CBT Nuggets
Garth Schulte
7:00
English

Exam 98-364: MTA: Database Fundamentals

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.

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.


CBT Nuggets Garth Schulte Database Fundamentals

20$
Buy!Download Size: 1.57 GB


Customers who bought this program also bought:


CBT Nuggets MS PRO Windows Server 2008 Server Administrator 70-646 (1 dvd) $15 BUY!
CBT Nuggets Microsoft SQL Server 2012 70-461 Writing Queries in SQL Server 2012 $20 BUY!
CBT Nuggets Microsoft Exchange Server 2010 Config 70-662 $20 BUY!
CBT Nuggets Microsoft SQL Server 2012 70-462 Administering Microsoft SQL Server 2012 Databases $20 BUY!
CBT Nuggets Core Solutions Microsoft Exchange Server 2013 70-341 $20 BUY!
CBT Nuggets Microsoft Exchange Server 2013 70-342 $20 BUY!


Software Store Deal of the Day

2010 SUPER PACK 4

2010 SUPER PACK 4

Unclude: Adobe Acrobat 9.0 Pro Extended (1 dvd), Adobe Photoshop CS5 Extended 12.0 (1 dvd), Autodesk Autocad LT 2011 (1 dvd), Corel WinDVD Pro 2010 10.0.5.291 Multilingual, CorelDRAW Graphics Suite X5 15.0.0.486, DVD Cloner VII 7.10.992, TechSmith Camtasia Studio 7.0.0

Real PriceSaving Deal of the Day View it »
$2960 94.6%229$BUY!
We recommend
Categories
© 2010-2017. All rights reserved.