Short Description
Practical Database Administration and Engineering Step by Step
What you’ll learn
- Creating Databases
- Creating Tables
- Creating Views
- Creating Stored Procedures
- Using subqueries
- Managing users and privileges
- Performing backups and restore
- Perform table joins
- Perform aggregate functions
- Attaching Sample Database
- Querying data from all columns in a table
- Querying data from specific columns in a table
- Sorting data using ORDER BY clause
- Removing duplicate records
- Identifying NULL values
- Filtering data
- Inserting data unto database
- Updating existing records inside database
- Deleting records from database
This course includes:
- 17.5 hours on-demand video
- 1 article
- Full lifetime access
- Access on mobile and TV
- Certificate of completion
Requirements
- Basic knowledge of excel will give you and idea of databases.
Description
The MySQL is the world’s most popular open source database.This course will teach you a lot to start using this incredibly popular MySQL database and gain useful skills in the process. In learning about MySQL you will also gain an understanding of relational databases in general. Furthermore, you will harness that power by learning SQL and using it to build databases, populate them with data and query that data through extensive hands-on practices.
MongoDB is a document-oriented DBMS, with JSON-like objects comprising the data model, rather than RDBMS tables. MongoDB does not support joins nor transactions. However, it features secondary indexes, an expressive query language,atomic writes on a per-document level, and fully-consistent reads. MongoDB uses JSON, a binary object format similar to, but more expressive than JSON.
Do check: Power BI