Znajdź zawartość

Database Fundamentals: Storage With Adam Wilbert Size: 215MB | Duration: 1h 22m | Video: AVC (.mp4) 1280x720 15&30fps | Audio: AAC 48KHz 2ch Genre: eLearning | Level: Beginner | Language: English Storage is a database's full-time job. Yet many IT professionals never really learn how it's done. This course is designed to change that, providing a baseline understanding of databases and their mechanics. Adam Wilbert covers normalization, a table structuring technique that reduces data redundancy; primary, foreign, and composite keys-features supporting the table relationships that underlie relational databases; and indexing, which helps speed up data retrieval. Along the way, Adam will provide tips for working with SQL Server Management Studio and some challenges to help you practice what you've learned. Note: This course will also prepare certification candidates for the "Understanding data storage" domain of the Microsoft Technology Associate (MTA) Exam 98-364, Database Administration Fundamentals. Find out more at https://www. microsoft. com/learning/en-us/exam-98-364. aspx. Topics include: * Reducing redundancy with normalization * Fixing partial dependencies * Creating primary keys * Linking tables with foreign keys * Creating clustered and nonclustered indexes Download From NitroFlare http://www.nitroflare.com/view/A6F17D8691FC89E/xidau123_LcDatabaseFundamentalsStorage.rar Download From Rapidgator http://rapidgator.net/file/d0aa53934e7e016de9c466c5f8a16f8e/xidau123_LcDatabaseFundamentalsStorage.rar.html

Migrating Access Databases to SQL Server With Adam Wilbert Size: 419MB | Duration: 2h 39m | Video: AVC (.mp4) 1280x720 15fps | Audio: AAC 48KHz 2ch Genre: eLearning | Level: Intermediate | Language: English At one point Access was adequate. But what happens when your database grows and you need more powerful tools? You can move it! Migration allows you to take advantage of SQL Server's advanced features, and maintain a link to the data in Access. Watch this course to learn how to leverage what you already know to take that next step. Adam Wilbert reviews the basics of SQL Server Management Studio (SSMS) and introduces two workflows for migrating Access data: one using a simple export/import process and the other using the free SQL Server Migration Assistant (SSMA). He also shows how to convert Access to SQL data types, link Access to SQL data via an ODBC connection, and address special concerns for Access 2010 data. Topics include: * Why upgrade? * Importing a SQL database * Exploring data types and server objects * Installing SSMA * Mapping source and target data types * Using the Migration Wizard * Linking to migrated tables in SSMA * Working with views and stored procedures * Linking Access to SQL Server databases Download From NitroFlare http://www.nitroflare.com/view/B8EBBA0C8E89E91/xidau123_LcMigrAccessDbsSQLServer.rar Download From Rapidgator http://rapidgator.net/file/7673867a6e31aa009f0f4128e4376182/xidau123_LcMigrAccessDbsSQLServer.rar.html

Database Fundamentals: Creating and Manipulating Data With Adam Wilbert Size: 412MB | Duration: 2h 24m | Video: AVC (.mp4) 1280x720 15&30fps | Audio: AAC 48KHz 2ch Genre: eLearning | Level: Beginner | Language: English Brand new to database administration? Take it one step at a time with Database Fundamentals, a series designed to support a new career or lifelong journey in IT. This installment is devoted to data: getting it into and out of tables and databases. Adam Wilbert shows how to get the most out of each data type, including numbers, characters, and specialized types like spatial data. Next are queues. Learn how to write commands and invoke functions in the SQL Editor to select just the records you want. Finally, get comfortable inserting, updating, and deleting data with the SQL Server Management Studio (SSMS), a suite of graphical tools and rich editors that make working with databases much more intuitive. Do you want to test your knowledge? Watch the challenge videos to practice what you've learned along the way. Note: This course will also prepare certification candidates for the Microsoft Technology Associate Exam 98-364, Database Administration Fundamentals. Topics include: * Storing dates, times, and text * Converting data types * Creating tables * Writing T-SQL commands * Selecting records with queries * Combining and sorting data * Creating views * Creating stored procedures and functions * Inserting and updating data in a table * Deleting records and tables Download From NitroFlare http://www.nitroflare.com/view/8EA2CCD940D3F8F/xidau123_LcDatabaseFunCr8ManipData.rar Download From Rapidgator http://rapidgator.net/file/ea6e6ae2020b89d93fafc34a6a726770/xidau123_LcDatabaseFunCr8ManipData.rar.html

Office 365: Access Essential Training With Adam Wilbert 5h 4m | Video: AVC (.mp4) 1280x720 15&30fps | Audio: AAC 48KHz 2ch | 590MB Genre: eLearning | Beginner | Language: English Join author and database expert Adam Wilbert on a tour of the essential features of Microsoft Access 2013, the database application included with every Office 365 subscription, and discover how to store, organize, and access your data more efficiently. First, Adam explains the concepts behind relational databases, before moving on to building tables-the foundation of any database. He then shows how to define the relationships between tables and use queries to find and filter data. The course also shows how to apply rules and validation to minimize data-entry errors; use forms to build a database interface complete with interactive buttons and combo boxes; create reports for printing and sharing; and automate these tasks, and many others, with macros. Topics include: Understanding table structures and relationships Setting primary and foreign keys Establishing relationships and maintaining referential integrity Sorting and filtering data Building queries with constraints and criteria Editing table data with queries Generating forms from tables Adding form controls Creating reports with totals and labels Embedding macros in buttons Repairing your database Protecting databases with passwords Download From Uploaded http://uploaded.net/file/n1nfaw3a/xidau123_LcOf365Acess.part1.rar http://uploaded.net/file/izys3n3y/xidau123_LcOf365Acess.part2.rar http://uploaded.net/file/btbugo1e/xidau123_LcOf365Acess.part3.rar Download From NitroFlare http://www.nitroflare.com/view/BC85CD8717C688D/xidau123_LcOf365Acess.part1.rar http://www.nitroflare.com/view/948F1ABA5D8767B/xidau123_LcOf365Acess.part2.rar http://www.nitroflare.com/view/F8878A3790594D9/xidau123_LcOf365Acess.part3.rar Download From Rapidgator http://rapidgator.net/file/6a638f732cffcbb346a2b9ce6790c433/xidau123_LcOf365Acess.part1.rar.html http://rapidgator.net/file/8e8598c3dec080fdb1e2712f2ea26ed5/xidau123_LcOf365Acess.part2.rar.html http://rapidgator.net/file/afb248f0ab6b5ea048e89d0b36caf9f4/xidau123_LcOf365Acess.part3.rar.html