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

🧰 Technology

• GIT: Download
• SQL SERVER EXPRESS: Download
• MySQL: Download

😄 Author

🆓 Licence