This is intensive hands-on course and provides an introduction to relational database design concepts and industry standards. Students learn the tools and processes for data modeling in Relational Database Management Systems (RDBMS). They also focus on the Structured Query Language, SQL to define and manipulate data. Topics include functional dependencies, normalization, database design methodologies, entity relationship modeling and the use of UML as a diagramming notation.
Advanced topics include: An introduction to SQL, DDL- data definition language and DML- data manipulation language, views, security, transaction management, triggers and stored procedures. Current trends in databases such as replication, object-relational DBMS, data warehousing, OLAP online analytical processing and database uses of web technology are discussed.
Upon successful completion, participants will be able to design and implement a database application.
Duration Learning Credits
2 days – 16 hours of 16 PDU’s
Session
Public Classroom Pricing:
Early Bird Price: AUD 1295.00
Regular Price: AUD 1495.00
Instructor-Led Virtual Live Pricing:
Early Bird Price: AUD 995.00
Regular Price: AUD 1195.00
Private Group/ In-House Learning:
Have a group of 3 or more people?
Register yourself with a special pricing and
request the training exclusively
Day – 1
● Describe the database approach, its environment, and database application life cycle.
● Explain the functions and characteristics of the relational model.
● Describe and work through the normalization process.
● Apply UML techniques of database design including:
○ Enhanced entity-relationship modeling using UML
○ Functional dependencies
○ Derivation of relations schema from EER model.
● Apply database design process to implement a database application.
● Describe security issues and data protection techniques in a database environment. Explain the use of databases in data warehousing and OLAP.
● Use SQL – DDL to implement a relational database.
● Use SQL for data manipulation such as the basic Select statement.
● Use SQL for advanced manipulation such as Group BY, Having, and Correlated subqueries.
Day – 2
● Limiting the Results with SQL Functions and T-SQL Operators Create stored procedures and triggers.
● Discuss techniques for transaction management and concurrency control.
● Analyzing SQL Server Query Plans
● Query Optimization