IT and Cybersecurity Awareness Training

Database

Database Courses

IT and Cybersecurity Awareness Training

Duration: 6.37 Hrs

Course Level: Intermediate
Languages: English
Capability: Audio, Video, MobileReady, Responsive

This course focuses on skills necessary to architect well-performing databases in SQL Server. It covers the principles and the practical tools necessary to understand and create all of the objects you would need to have a complete database. This includes a discussion of tables, data integrity, and indexes. As well as basic programming, file storage, and full-text searching. One of the primary benefits of commercial-grade databases is the availability of indexes to speed lookups. You will learn the benefits and the requirements for generating useful indexes in both OLTP (transactional) and OLAP (reporting) databases. Another major benefit of business-focused RDBMS (Relational Database Management Systems) is the use of enforced relationships and constraints. This course will cover all the standard techniques to maintain consistent quality data in your database using referential integrity and various types of automatic data validations. One way of increasing both security and performance in a database is using stored procedures, functions, and triggers. You will learn what each of these objects is and how to write the T-SQL code to generate them. We will also cover the use of SQL Management Studio to perform these various operations using visual tools where possible. At the end of the course, you should be able to create a highly functional business database.

Learning Objectives

Training for Microsoft SQL Databases

Duration: 16.00 Hrs

Course Level: Intermediate
Languages: English
Capability: Audio, Video, MobileReady

With Oracle Database 12c: SQL Fundamentals, you experience the benefits of an Oracle Database that is re-engineered for Cloud computing. Multitenant architecture brings enterprises unprecedented hardware and software efficiencies, performance and manageability benefits, and fast and efficient Cloud provisioning. Oracle Database 12c: SQL Fundamentals certifications emphasize the full set of skills that DBAs need in today’s competitive marketplace.

Learning Objectives

Training for the 12c OCP Exam

Duration: 7.50 Hrs

Course Level: Intermediate
Languages: English
Capability: Audio, Video, MobileReady

This course is in preparation for the The Oracle Database 11g Administrator (OCA 11g) certification exam. The Oracle Database 11g Administrator Certification (OCA 11g) ensures that database professionals have a strong foundation and expertise in the industry’s most advanced database management system, Oracle 11g. Oracle 11g training course will teach students how to install and maintain an Oracle database, how to create an operational database, and how to properly manage the various structures in an effective and efficient manner, including performance monitoring, database security, user management, and backup/recovery techniques. Students will also learn skills required for working with SQL, including how to use the advanced features of SQL in order to query and manipulate data within the database, control privileges at the object and system level, and use advanced querying and reporting techniques. After completing Oracle OCA 11g course, students will gain a conceptual understanding of the Oracle database architecture and how its components work and interact with one another. Oracle databases are the one of the most popular database platforms in the world. Increase your skills and marketability today by achieving Oracle certification!

Learning Objectives

Training for the 11g Exam

Duration: 19.00 Hrs

Course Level: Intermediate
Languages: English
Capability: Audio, Video, MobileReady

Keeping your exams current is important to any IT professional. The Oracle 1Z0-062 certification exam will prepare you for your Oracle Database 12c Installation and Administrator Professional certification with ease.

Learning Objectives

Training for the 12c OCP Exam

Duration: 21.25 Hrs

Course Level: Intermediate
Languages: English
Capability: Audio, Video, MobileReady

Preparation for Microsoft Certification Exam 70-764. By the end of this course, you will be able to administer a Microsoft SQL 2016 server. This course is intended for IT professionals responsible for installing and maintaining a Microsoft SQL Server environment. Instructor: Chrys Thorsen

Learning Objectives

Training for the MCSA 70-764 Exam

Duration: 22.50 Hrs

Course Level: Intermediate
Languages: English
Capability: Audio, Video, MobileReady

This course prepares you for Microsoft Certification Exam 70-765. By the end of this course, you will be able to provision databases on Microsoft SQL Server 2016 and Microsoft Azure. This course is intended for IT professionals responsible for installing and maintaining a Microsoft SQL Server environment. Instructor: Chrys Thorsen

Learning Objectives

Training for the MCSA 70-765 Exam