Opleidingen, cursussen en trainingen in Limburg. instituten, opleidingen. Leslocaties in Maastricht, Heerlen, Sittard, Roermond en Weert

Cursus database fundamentals

Onderwerpen: Oracle, SQL, Access, etc.
Opleidingsvorm:Thuisstudie / e-learning
Opleidingsduur:8 uur
Start en locatie:
Kosten:€ 69,00 excl BTW
Opleidingsniveau:MBO
 

Tip: lees alles over het programma, doelgroep, startdata, leslocaties en prijzen. Vraag nu, vrijblijvend, de gratis brochure aan. brochure aanvragen

 

U wilt de basisprincipes achter (relationele) databases begrijpen. Zowel de concepten achter database management systemen (DBMS) als de structurering en opslag van gegevens in een database. En natuurlijk het opvragen en bewerken van gegevens.

Onderwerpen die onder andere aan bod komen zijn relationele database concepten, de elementen in een database management systeem, tabellen, queries, database relaties, het bewerken van gegevens met behulp van SQL en de Oracle9i database.

Uw resultaat

U bent bekent met de basisprincipes achter (relationele) databases. Tevens heeft u basiskennis van SQL.

Doelgroep

Ontwikkelaars / support engineers die zich de basisprincipes van databases eigen willen maken.

Inhoud cursus

  • An Introduction to Database Systems
    • Differentiate between a database and a Database Management System (DBMS)
    • Identify the requirements of a good database
    • Examine an example of a database system and the elements comprising the database system
    • Describe the evolution of database models
    • Describe the structure and evolution of database architectures
    • Design a database
    • Differentiate between data warehousing and Online Transactional Processing (OLTP)
    • Describe the features and characteristics of an Oracle relational database management system (RDBMS) and an Oracle object relational database management system (ORDBMS)
    • Describe the main components of an Oracle9i database server
  • Relational Databases
    • Describe relational database concepts
    • Describe relational database characteristics
    • Describe how to outline a relational database schema
    • Describe the concept of relational database integrity
    • Manage operations in a relational database
    • Formulate algebraic operations in a database
    • Describe how to use SQL in a relational database
    • Discuss and write basic SELECT SQL statements
    • Describe how to insert, update, and delete data in an Oracle9i database
    • Use DML statements to insert, update, and delete data from an Oracle9i database
  • Database Data Management
    • Outline database transaction processing and the related problems
    • Outline how to resolve concurrency problems in a database
    • Describe the types and features of locks and to describe how to avoid lock contention in an Oracle9i database
    • Describe database security and access issues
    • Describe Oracle9i database users, how to authenticate them, and their relationship to schemas
    • Describe the system and object privileges in an Oracle9i database

Meer informatie?

Kijk op onze website voor gedetailleerde lesinhoud, schermafbeeldingen en een demonstratievideo van deze cursus.

Klik hier voor alle informatie over deze opleiding

Docenten van deze opleiding

ICTtrainingen.nl
Icttrainingen.nl is een opleidings- en kennisdelingsplatform voor én door de ICT professional. Het platform is zowel voor startende als ervaren IT'ers. Wij bieden, in tegenstelling tot andere aanbieders, niet alleen ICT trainingen aan. We faciliteren ook een online platform waar IT'ers onderling kennis kunnen delen. Dit doen we via ons innovatieve leerconcept: Social learning. IT'ers kunnen elkaar tijdens en na een training helpen via het platform. Binnen deze kennis community zijn expertpartners van icttrainingen.nl actief om vragen van cursisten te beantwoorden. Nat... Lees hier verder >>>

Overige opleidingen van ICTtrainingen.nl

Access 2003 Compleet | Access 2007 Compleet | Adobe Dreamweaver CS4 | Adobe Dreamweaver CS5 | Adobe Flash CS4 | Adobe Flash Professional CS5 | Adobe Photoshop CS5: basiskennis | Agile Software Ontwikkeling | C++ programmeren | CAPM & PMP: Project Management Professional - (PMBOK Guide - Fourth Edition-aligned) | CCNA Routing and Switching (exam 640-802) | Certified Information Systems Security Professional (CISSP) | Cisco CCNA Security - IINS (exam 640-553) | Cisco CCNA Wireless - IUWNE (exam 640-721) | CompTIA A+ 2009 Essentials (exam 220-701) | CompTIA A+ 2009 Practical Application (exam 220-702) | CompTIA A+ Essentials Compleet (exam 220-701 + 220-702) | CompTIA Network+ 2009 | Configuring and Managing Microsoft System Center Essentials 2010 | Configuring Microsoft Exchange Server 2010 (exam 70-662) | Configuring Microsoft Office Sharepoint Server 2007 (exam 70-630) | Configuring Windows Server Virtualization (exam 70-652) | Cursus basisprincipes van Software Ontwikkeling | Cursus C Programmeren (ANSI C) | Cursus CISM: Certified Information Security Manager (ISACA) | Cursus database fundamentals | Cursus introductie in Ajax ontwikkeling | Deploying Messaging Solutions with Microsoft Exchange Server 2007 (exam 70-238) | Designing a Windows Server 2003 Active Directory and Network Infrastructure (exam 70-297) | Designing Cisco Network Service Architecture (exam 642-873 ARCH) | Designing for Cisco Internetwork Solutions (exam 640-863 DESGN) | Designing Messaging Solutions with Microsoft Exchange Server 2007 (exam 70-237) | DHTML Basiskennis | Excel 2003 Compleet | Excel 2007 Basiscursus | Excel 2010 Basiscursus | Excel 2010 Compleet | Implementing Cisco IP Routing (exam 642-902 ROUTE) | Implementing Cisco IP Switched Networks (exam 642-813 SWITCH) | Implementing Cisco Unified Communications Voice over IP and QoS - CVOICE v8.0 (exam 642-437) | Interconnecting Cisco Networking Devices Part 1 - ICND1 (exam 640-822) | Interconnecting Cisco Networking Devices Part 2 - ICND2 (exam 640-816) | Introductie in Voice over IP | IT Projectmanagement Basiskennis | ITIL V3 Foundation | Java programmeren met Java SE 6.0 (exam 310-065) | JavaScript fundamentals | Managing Successful Programmes (MSP) - Foundation | Managing Successful Programmes (MSP) - Practitioner | Microsoft Office 2007 Totaalpakket | Microsoft Office Sharepoint Server 2007: Application Development (exam 70-542) | Microsoft Project 2010 voor Gevorderden | Microsoft Project 2010: Managing Projects (exam 70-178) | Microsoft SharePoint 2010 basiskennis voor eindgebruikers | Microsoft SharePoint 2010 voor eindgebruikers - Compleet | Microsoft Word 2010 Basiscursus | MS .Net Framework 2.0: Application Development Foundation with C# 2005 (exam 70-536) | MS .Net Framework 3.5: ADO.NET Application Development (exam 70-561) | MS SQL Server 2008 Implementation and Maintenance (Exam 70-432) | Oracle Database 10g: Developing PL/SQL Program Units | Oracle Database 10g: PL/SQL Fundamentals | Oracle Database 11g: Administration Workshop I (exam 1Z0-052) | Oracle Database 11g: Administration Workshop I Release 2 (exam 1Z0-052) | Oracle Database 11g: New Features For Administrators (exam 1Z0-050) | Oracle Database 11g: Performance tuning (exam 1Z0-054) | Oracle Database 11g: Security | Oracle Database 11g: SQL Fundamentals 2 | Oracle Database 11g: SQL Tuning | Overstappen en migratie naar Microsoft Office 2010 | Perl Programmeren: Basiskennis | Planning, Implementing, and Maintaining a Windows Server 2003 Active Directory Infrastructure (exam 70-294) | Powerpoint 2007 Basiscursus | Powerpoint 2007 Compleet | Prince2 foundation 2009 | Prince2 Practitioner 2009 | Proefexamen 1Z0-047: Oracle Database SQL Expert | Proefexamen 1Z0-050: Oracle Database 11g New Features | Proefexamen 1Z0-051: Oracle Database 11g: SQL Fundamentals I | Proefexamen 1Z0-052: Oracle Database 11g: Administration I | Proefexamen 1Z0-053: Oracle Database 11g: Administration II | Proefexamen 642-832: Troubleshooting and Maintaining Cisco IP Switched Networks (TSHOOT) | Proefexamen 70-238: PRO: Deploying Messaging Solutions with Microsoft Exchange Server 2007 | Proefexamen 70-293: Planning and Maintaining a Windows Server 2003 Network Infrastructure | Proefexamen 70-297: Designing a Microsoft Windows Server 2003 Active Directory and Network Infrastructure | Project 2010 Basiskennis | SAP ABAP Programmeren Basiskennis | Software ontwikkelen / programmeren: Best Practices | Software Testing Foundation (ISTQB - ISEB exam BH0-010) | Software Testing Intermediate (ISTQB - ISEB exam BH0-007) | Troubleshooting and Maintaining Cisco IP Networks (exam 642-832 TSHOOT) | UNIX: Systeembeheer | Visio 2010 Basiscursus | Windows 7: Configuration (exam 70-680) | Windows 7: Enterprise desktop administrator (exam 70-686) | Windows server 2008: Configuring active directory (exam 70-640) | Word 2007 Basiscursus | Word 2010 Compleet | XML Advanced | XML Essentials

Info over de opleiding

Info over instituut

@icttrainingen tweets

 
  • IT Security: Emergency Management Conference Explores New Technologies Based on Lessons Learned i... http://t.co/I23TwfkC #ict #security
  • IT Security: The Dradis Framework with Daniel Martin – Episode 287 http://t.co/SimXwnBI #ict #security

Klik hier voor alle tweets