Database and SQL Course: Business Intelligence, SQL Server, MySQL, Oracle, T-SQL and PLSQL by Professor Felipe Mafra
Status • Objective • Installation • Technology • Author • Licence
✔️ Concluded ✔️
📜 Objective
Work with 3 different databases:
MySQL, SQL Server and Oracle and also introduction to T-SQL and PLSQL languages.
I learned the differences in SQL language, infrastructure and installation tasks.
I saw the difference between OLTP, OLAP environments and also what a Datawarehouse is.
Closing with the natural sequence of Relational Databases: Business Intelligence.
Course Topics:
- Understand the difference between a Data Administrator and a DBA
- Create consistent databases from the point of infrastructure and modeling.
- Install MySql Database
- Run SQL - Structured Query Language, or Structured Query Language in ANY database.
- Understand the entire transactional environment and choose to continue their studies in Business Intelligence analytical environments
- Install the Oracle Database
- Install SQL Server Database
- Model the database for any transactional system
- Programming in Database
- Perform Backups and Restores of your Databases
- Apply Constraints of any nature to your tables
- Apply the Normal Forms
- Create Triggers, Procedures, Functions and Views
- Choose the native functions of any database, according to your needs
- Use the Data Dictionary
- Be safe in the Database discipline
- Perform database related software downloads
- Use modeling software
- Safely apply the 1 x 1, 1 x N, N x N, Generalization and Self-relationship relationships, understanding the reason for each one.
☑️ Installation
- Clone the repository
- Debug Code