About This Course
Databases courses have increased in popularity as companies all over the world have moved to housing all their information online. Database learning is one of the few areas of learning that is represented in all IT learning streams. If you’re working towards a career as an IT professional, the IT Specialist Certification course is perfect for teaching you the basics.
It teaches you core database concepts and how to correctly create database objects without issues. It makes sure you know how to manipulate data, helping your understanding of how to administer data and data storage.
Participants: 25
Certification: IT Specialist Certification Information technology Specilist – Databases
Learning Outcomes
Upon completion of this course participants will be able to:
- Database Design
- Database Object Management using DDL
- Data Retrieval
- Troubleshooting
- Data Manipulation using DML
Who Should Attend
If you are unemployed and new to IT this course is perfect for teaching you the basics of Databases. It is a great starting point for a career in IT or Data Analytics. Students taking this course can then progress through the Database pathway in this Certified Pathway.
Course Syllabus
1. Database Design
1.1 Given a scenario, design tables for storing data
1.2 Given a scenario, identify the appropriate primary key
1.3 Given a scenario, choose data types to meet requirements
1.4 Given a scenario, design relationships between tables
1.5 Normalize a database
1.6 Given a scenario, identify data protection measures
2. Database Object Management using DDL
2.1 Construct and analyze queries that create, alter, and drop tables
2.2 Construct and analyze queries that create, alter, and drop views
2.3 Construct and analyze stored procedures and functions
2.4 Given a scenario, choose between clustered and non-clustered indexes
3. Data Retrieval
3.1 Construct and analyze queries that select data
3.2 Construct and analyze queries that sort and filter data
3.3 Construct and analyze queries that aggregate data
4. Data Manipulation using DML
4.1 Construct and analyze INSERT statements
4.2 Construct and analyze UPDATE statements
4.3 Construct and analyze DELETE statements
5. Troubleshooting
5.1 Troubleshoot data object management query failures
5.2 Troubleshoot data retrieval query failures
5.3 Troubleshoot data manipulation query failures