Home
Videos uploaded by user β€œMyTecBits”
DBMS vs RDBMS. What is DBMS? What is RDBMS? | DB Basics #1
 
06:22
DBMS vs RDBMS: In this this video session, I will brief you an about DBMS & RDBMS and then list down difference between DBMS & RDBMS. Detailed Article @ http://www.mytecbits.com/microsoft/sql-server/what-is-dbms-what-is-rdbms My Website: http://www.mytecbits.com DBMS vs RDBMS: a. To Start with, DBMS was introduced during 1960s and RDBMS during 70's. b. DBMS Initially followed the navigational model of data storage, then evolved as network model and hierchical model. c. RDBMS followed the relationship between tables in the form of keys and indexes. d. Because of the navigational model in DBMS, fetching data is slower for complex and large amount of data. e. On the other hand, Data fetching is much faster in RDBMS because of the relationship between tables. f. So, DBMS is used for small applications and RDBMS is used for complex and enterprise applications. g. Data redundancy is very common in DBMS leading to difficulty in maintaining the data. In RDBMS, keys and indexes are used to avoid redundancy. h. Some examples for DBMS are dBase, Microsoft Access, LibreOffice Base and Fox Pro. i. The popular examples of RDBMS are, SQL Server, Oracle, MySQL, MariaDB and SQLite.
Views: 48295 MyTecBits
Installing Wide World Importers Sample Database | SQL Server Basics #6
 
06:21
Installing Wide World Importers Sample Database in SQL Server: Choosing, downloading and installing or restoring WideWorldImporters Sample Database on SQL Server 2016 for learning SQL Server functionalities. 🌟 WideWorldImporters Download URL: https://github.com/Microsoft/sql-server-samples/releases/tag/wide-world-importers-v1.0 🌟 Detailed Article: http://www.mytecbits.com/microsoft/sql-server/installing-wideworldimporters-sample-database 🌟 SQL Server Basics Tutorial: http://www.mytecbits.com/microsoft/sql-server/sql-server-basics-tutorial 🌟 My Website: http://www.mytecbits.com 🌟 SQL Server Basics Video Playlist: https://www.youtube.com/playlist?list=PLEA-BJFmprMbrycyfgNXiUFmHCxeCVUzR
Views: 3897 MyTecBits
Installing AdventureWorks Sample Database | SQL Server Basics #5
 
08:10
Installing AdventureWorks Sample Database in SQL Server: Choosing, downloading and installing or restoring AdventureWorks Sample Database for SQL Server 2014 for learning SQL Server functionalities. 🌟 AdventureWorks Download URL: https://msftdbprodsamples.codeplex.com/releases/view/125550 🌟 Database Restoring Script: USE master RESTORE DATABASE AdventureWorks2014 FROM disk = 'C:\Program Files\Microsoft SQL Server\MSSQL12.MSSQLSERVER\MSSQL\Backup\AdventureWorks2014.bak' WITH MOVE 'AdventureWorks2014_data' TO 'C:\Program Files\Microsoft SQL Server\MSSQL12.MSSQLSERVER\MSSQL\DATA\AdventureWorks2014.mdf', MOVE 'AdventureWorks2014_Log' TO 'C:\Program Files\Microsoft SQL Server\MSSQL12.MSSQLSERVER\MSSQL\DATA\AdventureWorks2014.ldf', REPLACE 🌟 Detailed Article: http://www.mytecbits.com/microsoft/sql-server/installing-adventureworks-sample-database 🌟 SQL Server Basics Tutorial: http://www.mytecbits.com/microsoft/sql-server/sql-server-basics-tutorial 🌟 My Website: http://www.mytecbits.com 🌟 SQL Server Basics Video Playlist: https://www.youtube.com/playlist?list=PLEA-BJFmprMbrycyfgNXiUFmHCxeCVUzR
Views: 15887 MyTecBits
SQL Server Editions | SQL Server Basics #1
 
08:16
SQL Server Editions: I'm planning to post a series of training session videos on SQL Server. Today I'll start with the different editions of SQL Server 2014 and the major differences between them. I'll also go over the steps to get the Free SQL Server Developer Edition. 🌟 VS Dev Essentials Program @ https://www.visualstudio.com/en-us/products/visual-studio-dev-essentials-vs.aspx 🌟 Detailed Article @ http://www.mytecbits.com/microsoft/sql-server/sql-server-editions 🌟 My Website: http://www.mytecbits.com 🌟 SQL Server Basics Video Playlist: https://www.youtube.com/playlist?list=PLEA-BJFmprMbrycyfgNXiUFmHCxeCVUzR
Views: 3404 MyTecBits
Multiple RDP Sessions For A Windows User | Windows #1
 
02:24
How to allow multiple remote desktop sessions (RDP Sessions Or TS Sessions) for the same user at the same time on a Windows Server 2008, 2012 and Windows 7 or 10. 🌟 Detailed Article: http://www.mytecbits.com/microsoft/windows/multiple-remote-desktop-sessions-for-a-single-user 🌟 My Website: http://www.mytecbits.com 🌟 Windows Tips Video Playlist: https://www.youtube.com/playlist?list=PLEA-BJFmprMbURqN3X6lU_C-unvntrbmC
Views: 9817 MyTecBits
Using filters In SQL Server Management Studio | SQL Server Tips #1
 
04:06
How to use the filter option in SQL Server Management Studio (SSMS) to find or filter objects like tables, views, functions and stored procedures in SSMS Object Explorer. 🌟 SQL Server Basics Tutorial: http://www.mytecbits.com/microsoft/sql-server/sql-server-basics-tutorial 🌟 My Website: http://www.mytecbits.com 🌟 SQL Server Tips Video Playlist: https://www.youtube.com/playlist?list=PLEA-BJFmprMacgYEUB7Ja7Yh2O-AGIO53
Views: 722 MyTecBits
Accessing AVCHD .MTS Files on macOS
 
01:40
Accessing AVCHD .MTS video files on macOS: Simple steps for accessing AVCHD .MTS video files from handy cam or SD card on Mac OS. Detailed Article @ http://www.mytecbits.com/apple/macos/opening-avchd-mts-files-on-mac My Website: http://www.mytecbits.com
Views: 841 MyTecBits
SQL Server Management Studio - Part 1 | SQL Server Basics #3
 
10:18
SQL Server Management Studio - Part 1 In part 1 of the SQL Server management Studio video session, 1. We will see about SSMS. 2. login in to sql server management studio. 3. How to connect to SQL Server. 4. About Object explorer window and how to use it. 5. About Object explorer details window 6. And Properties window 🌟 Detailed Article: http://www.mytecbits.com/microsoft/sql-server/sql-server-management-studio-part-1 🌟 SQL Server Basics Tutorial: http://www.mytecbits.com/microsoft/sql-server/sql-server-basics-tutorial 🌟 My Website: http://www.mytecbits.com 🌟 SQL Server Basics Video Playlist: https://www.youtube.com/playlist?list=PLEA-BJFmprMbrycyfgNXiUFmHCxeCVUzR
Views: 2844 MyTecBits
SQL Server Management Studio - Part 2 | SQL Server Basics #4
 
13:01
SQL Server Management Studio - Part 2 In part 2 of the SQL Server management Studio video session, we will see about: 1. SQL Query editor Window. 2. Changing Windows Layout. 3. Some editing tools. 4. Registered Servers 5. And about templates, solutions and scripting projects. 🌟 Detailed Article: http://www.mytecbits.com/microsoft/sql-server/sql-server-management-studio-part-2 🌟 SQL Server Basics Tutorial: http://www.mytecbits.com/microsoft/sql-server/sql-server-basics-tutorial 🌟 My Website: http://www.mytecbits.com 🌟 SQL Server Basics Video Playlist: https://www.youtube.com/playlist?list=PLEA-BJFmprMbrycyfgNXiUFmHCxeCVUzR
Views: 798 MyTecBits
SQL Server Installation | SQL Server Basics #2
 
10:11
SQL Server Developer Edition Installation: Step by step instructions for downloading and installing SQL Server 2014 Developer Edition. 🌟 VS Dev Essentials Program @ https://www.visualstudio.com/en-us/products/visual-studio-dev-essentials-vs.aspx 🌟 Detailed Article @ http://www.mytecbits.com/microsoft/sql-server/sql-server-installation 🌟 My Website: http://www.mytecbits.com 🌟 SQL Server Basics Video Playlist: https://www.youtube.com/playlist?list=PLEA-BJFmprMbrycyfgNXiUFmHCxeCVUzR
Views: 348 MyTecBits