IT Specialist Databases
irna
Wed, 12/13/2023 - 08:15
Duration
2 Days
Price
--- Call Us ---
In this course you will learn about database design, database object management using DDL, data retrieval, data manipulation using DML, troubleshooting data object management query failures, data retrieval query failures and data manipulation query failures
Key Outcomes:
After this course you will gain foundational knowledge of how to design and query relational databases, such as MySQL, Microsoft SQL Server, or Oracle.
Objectives
- Database Design
o Given a scenario, design tables for storing data
o Given a scenario, identify the appropriate primary key
o Given a scenario, choose data types to meet requirements
o Given a scenario, design relationships between tables
o etc - Database Object Management using DDL
o Construct and analyze queries that create, alter, and drop tables
o Construct and analyze queries that create, alter, and drop views
o Construct and analyze stored procedures and functions
o Given a scenario, choose between clustered and non-clustered indexes - Data Retrieval
o Construct and analyze queries that select data
o Construct and analyze queries that sort and filter data
o Construct and analyze queries that aggregate data - Data Manipulation using DML
o Construct and analyze INSERT statements
o Construct and analyze UPDATE statements
o Construct and analyze DELETE statements - Troubleshooting
o Troubleshoot data object management query failures
o Troubleshoot data retrieval query failures
o Troubleshoot data manipulation query failures
Contact
- Nurman (+62 857-2375-3840)
- Irna (+62 822-1664-7749)
- Puji (+62 813-2424-2115)
- Shafa (+62 813-9049-0664)