Database Design and Management
Learn how to design and manage database with ERD, database generation and reversal with Visual Paradigm.
Created by Visual Paradigm - Design & Management Tool for Business IT System Development
Students: 74819, Price: Free
Database Design and Management is tailor-made for software development teams who need to develop application or software system that require data persistence. There are altogether 14 lectures with more than 2 hours of quality videos. All lectures come with clear voice-over as well as demonstrations to walk you through different tools step by step. We are sure you can master database design and management skills with ease and learn most key features in Visual Paradigm after attending the lectures.
The lectures cover a wide range of contents. Firstly, you will start by an introduction of database design, with description of ERD, entity and column. After gaining a better knowledge about ERD, you can then jump to keys, relationships, database view, triggers and stored procedures. This course also covers database management skills like the generation of database from ERD, database patching and reverse engineering of ERD. Developers may want to study the lecture about ORM for system development with database. Last but not least, the training introduces some best practices in database design and management, as well as the usage of data specification.
Once you have completed this online training, you will know how to design database productively and effectively.
MongooseJS Essentials – Learn MongoDB for Node.js
Learn how to create Mongoose Schemas to build a full CRUD application based on the MongoDB database design.
Created by Patrick Schroeder - Software Developer
Students: 73739, Price: Free
In this course we will build a simple application to show how to perform full CRUD (create, read, update, delete) operations within Node.js.
We'll be using the Node module MongooseJS. Mongoose allows us to define our models in the form of a schema, along with a simple to use API that abstracts away a lot of the pain of working directly with the MongoDB driver.
First, we will create a Book schema using MongooseJS. We will use string data types to add a title, author and description. Next, we will build a simple server using Express.js. Then we will build 4 routes to query, update and delete Books from our Schema. We will use Postman to perform actions on these routes and check the results in our browser.
What You Will Learn
- Build CRUD Applications
- Create Mongoose Schemas
- Design Routes using Express.js
- Create a Server using Express.js
- Build a RESTful API
A beginners guide to SQL commands and Database Design. Learn it through quick and easy steps.
Created by Sagar Uppuluri - Software Architect and a passionate trainer
Students: 28323, Price: Free
SQL is an integral part of majority of software projects and is important for you to gain familiarity with the language if you are an IT aspirant.
This course covers the topics related to database design and query design, and helps you assimilate the topics in a way that you should be able to understand and design the schema.
It covers the most essential features of the language and explains them through simplified and easy to understand examples. Includes DDL, DML and Query commands along with hints about the other essential features. Core focus will be on table design and explaining the features such as query and joins with their mathematical approach so that you can effectively design complex queries.
It includes SQL scripts related to the lectures under the resources section which are intended to help students expedite the learning by means of executing the same scripts taught in the video.
Real World MYSQL Database Design & Management Projects 2021
Master SQL by creating complex databases & building reports through real-world projects-MySQL, PHP, HTML, CSS, Bootstrap
Created by TheMachineLearning.Org . - Machine Learning Engineer
Students: 6645, Price: Free
Easy to use: As it supports SQL language, users don’t need to be technically expert to access the database. It can be easily accessed by users with basic SQL knowledge and experience on other relational databases.
Cost Free: Another benefit of using this database is that the user doesn’t have to spend money to pay the license fee, as it is free of cost and available on the official website for download.
Customizable Code: As it is available as an open-source tool, software developers have an option to customize the source code as per their own applications and use it. The source code is freely available to web users. The do’s and don’ts of the software are defined in GPL i.e. GNU General Public License.
Secured: It offers one of the most secured databases in the world and hence used by well-established web applications like Facebook, Twitter, Instagram, etc. Its various security features like Firewall, Encryption, and User Authentication are the helping hands in protecting sensitive user information from intruders.
Better Performance: It supports the multi-engine storage feature which facilitates database administrators to configure the database in a way to balance the workload. Hence, it makes the database flawless in terms of performance.
High Availability: It offers 24*7 hours availability and offers solutions like Master/Slave Replication and specialized Cluster Servers.
Scalability: It offers very good scalability to web applications through MySQL Thread Pool provided by MySQL Enterprise Edition. A thread pool provides a model that is used for managing threads (or processes), like the multi-user connections overhead and execution requests, in a hassle freeway.
Platform-Friendly: It is a platform-friendly database supporting a number of platforms like Microsoft Windows, Oracle Solaris, AIX, Symbian, Linux, MAC OS, etc.
Friendly Interface: It has a user-friendly interface with a lot of self-management features and different automated processes like configuration and administration-related tasks, which allows users to do the job effectively from Day 1.
Microsoft ACCESS Beginners Hands-on Training with Exercises
Quick Learn MS ACCESS for beginners from scratch to design and develop real-world Database applications.
Created by Mazhar Hussain - Computer Science Lecturer and Programmer
Students: 1754, Price: Free
Microsoft ACCESS is an information management tool, or relational database, that helps you store data that can easily be accessed, managed, modified, updated, controlled, and analyzed.
ACCESS can also overcome the limitations found when trying to manage large amounts of information in Excel or other spreadsheet applications.
ACCESS Components: You will be able to learn Microsoft ACCESS Components: Tables, Forms, Queries, and Reports. Each has its own special function to allow the user to manage information in MS ACCESS.
A Table allows the user to store a collection of data about a specific topic like Customers or Orders. Relationships can be established among the tables to access and manage the data easily.
A Form allows a user to enter/change/update data to tables.
A Query allows the user to view, change, manipulate, and analyze data in different ways like combining data from two different tables (Customers and Orders) to create a user’s own custom view (London Orders for April).
A Report is an effective way to output your data in a printed format in the way you want it .
This Course is specifically designed for beginners with
At the end of this Course, you will be able to create a real-world DATABASE Applications in MS ACCESS from scratch.