Get $1 credit for every $25 spent!

The Complete Microsoft & Oracle SQL Certification Bundle

Ending In:
Add to Cart - $39
Add to Cart ($39)
$3,289
98% off
wishlist
(144)
Courses
11
Lessons
1,417
Enrolled
1,435

What's Included

Product Details

Access
Lifetime
Content
19 hours
Lessons
92

Oracle 12c OCP 1Z0-062: Installation & Administration

Enhance Your IT Skills with a Deep Look at Oracle Database Concepts & Tools

By iCollege | in Online Courses

In today's data-driven world, companies need database administrators and analysts; and this course is the perfect starting point if you're keen on becoming one. Designed to help you ace the Oracle 12c OCP 1Z0-062: Installation and Administration exam, this course walks you through Oracle database concepts and tools, internal memory structures and critical storage files. You'll explore constraints and triggers, background processes and internal memory structures and ultimately emerge with a set of valuable skills to help you stand out during the job hunt.

  • Access 92 lectures & 19 hours of content 24/7
  • Understand data definition language & its manipulation
  • Walk through database concepts & tools, memory structure, tables, and indexes
  • Dive into undertaking installation, backup & recovery

Instructor

iCollege is a leading international provider of E-Learning courses, learning technologies and development services.

iCollege is a collaborative venture between XpertSkills and XpertEase Software.

The synergistic result of their joint venture enables them to provide sophisticated, innovative, relevant, flexible and cost-effective learning solutions.

Their collective knowledge and experience in education and training provision sets the standard for service delivery in learning solutions.

Important Details

  • Length of time users can access this course: lifetime
  • Access options: web streaming, mobile streaming
  • Certification of completion not included
  • Redemption deadline: redeem your code within 30 days of purchase

Requirements

  • Internet required

Access
Lifetime
Content
22.5 hours
Lessons
102

Microsoft 70-765 : Provisioning SQL Databases

Discuss Provisioning SQL Databases

By iCollege | in Online Courses

This course will prepare you for the Microsoft Certification Exam 70-765, which is one of two tests you must pass to earn a Microsoft Certified Solutions Associate (MCSA): 2016 Database Administration certification. If you're looking to start a lucrative IT career installing and maintaining Microsoft SQL Server and Azure environments, this course is for you.

  • Access 102 lectures & 22.5 hours of content 24/7
  • Deploy a Microsoft Azure SQL database
  • Plan for a SQL Server installation
  • Deploy SQL Server instances
  • Deploy SQL Server databases to Azure Virtual Machines
  • Configure secure access to Microsoft Azure SQL databases

Instructor

iCollege is a leading international provider of E-Learning courses, learning technologies and development services.

iCollege is a collaborative venture between XpertSkills and XpertEase Software.

The synergistic result of their joint venture enables them to provide sophisticated, innovative, relevant, flexible and cost-effective learning solutions.

Their collective knowledge and experience in education and training provision sets the standard for service delivery in learning solutions.

Important Details

  • Length of time users can access this course: lifetime
  • Access options: web streaming, mobile streaming
  • Certification of completion not included
  • Redemption deadline: redeem your code within 30 days of purchase
  • Experience level required: intermediate

Requirements

  • Internet required
  • Essential knowledge of the Microsoft Windows working framework and its center usefulness
  • Understanding of Transact-SQL and working experience with it
  • Knowledge and practical skills regarding social databases
  • Some experience related to database structure

Access
Lifetime
Content
6.5 hours
Lessons
196

Microsoft 70-461: Querying SQL Server 2012

Get Started Working with Microsoft SQL Server 2012

By iCollege | in Online Courses

If you're interested in working in Database Administration, Database Development, or Business Intelligence, you'd be remiss to skip this course. Dive in, and you'll foster the technical skills required to write basic Transact-SQL queries for Microsoft SQL Server 2012.

  • Access 196 lectures & 6.5 hours of content 24/7
  • Apply built-in scalar functions & ranking functions
  • Combine datasets, design T-SQL stored procedures, optimize queries, & more
  • Implement aggregate queries, handle errors, generate sequences, & explore data types
  • Modify data by using INSERT, UPDATE, DELETE, & MERGE statements
  • Create database objects, tables, views, & more

Instructor

iCollege is a leading international provider of E-Learning courses, learning technologies and development services.

iCollege is a collaborative venture between XpertSkills and XpertEase Software.

The synergistic result of their joint venture enables them to provide sophisticated, innovative, relevant, flexible and cost-effective learning solutions.

Their collective knowledge and experience in education and training provision sets the standard for service delivery in learning solutions.

Important Details

  • Length of time users can access this course: lifetime
  • Access options: web streaming, mobile streaming
  • Certification of completion not included
  • Redemption deadline: redeem your code within 30 days of purchase
  • Experience level required: all levels

Requirements

  • Internet required

Access
Lifetime
Content
6.5 hours
Lessons
128

Microsoft 70-462: Administering SQL Server 2012 Databases

Learn Essential Components to Becoming a Database Professional

By iCollege | in Online Courses

This course is aimed towards aspiring database professionals who would like to install, maintain, and configure database systems as their primary job function. You'll get up to speed with the SQL Server 2012 product features and tools related to maintaining a database while becoming more efficient at securing and backing up databases.

  • Access 128 lectures & 6.5 hours of content 24/7
  • Audit SQL Server instances, back up databases, deploy a SQL Server, & more
  • Configure additional SQL Server components
  • Install SQL Server & explore related services
  • Understand how to manage & configure SQL Servers & implement a migration strategy

Instructor

iCollege is a leading international provider of E-Learning courses, learning technologies and development services.

iCollege is a collaborative venture between XpertSkills and XpertEase Software.

The synergistic result of their joint venture enables them to provide sophisticated, innovative, relevant, flexible and cost-effective learning solutions.

Their collective knowledge and experience in education and training provision sets the standard for service delivery in learning solutions.

Important Details

  • Length of time users can access this course: lifetime
  • Access options: web streaming, mobile streaming
  • Certification of completion not included
  • Redemption deadline: redeem your code within 30 days of purchase
  • Experience level required: intermediate

Requirements

  • Internet required
  • Basic knowledge of the Microsoft Windows operating system and its core functionality
  • Working knowledge of Transact-SQL
  • Working knowledge of relational databases
  • Some experience with database design

Access
Lifetime
Content
4.5 hours
Lessons
100

Microsoft 70-463: Implementing A Data Warehouse With SQL Server 2012

Prepare to Sit the Microsoft 70-463 Certification Exam

By iCollege | in Online Courses

This course is designed for aspiring Extract Transform Load (ETL) and Data Warehouse Developers who would like to focus on hands-on work creating business intelligence solutions. It will prepare you to sit and pass the Microsoft 70-463 certification exam.

  • Access 100 lectures & 4.5 hours of content 24/7
  • Master data using Master Data Services & cleans it using Data Quality Services
  • Explore ad-hoc data manipulations & transformations
  • Manage, configure, & deploy SQL Server Integration Services (SSIS) packages
  • Design & implement dimensions, fact tables, control flow, & more

Instructor

iCollege is a leading international provider of E-Learning courses, learning technologies and development services.

iCollege is a collaborative venture between XpertSkills and XpertEase Software.

The synergistic result of their joint venture enables them to provide sophisticated, innovative, relevant, flexible and cost-effective learning solutions.

Their collective knowledge and experience in education and training provision sets the standard for service delivery in learning solutions.

Important Details

  • Length of time users can access this course: lifetime
  • Access options: web streaming, mobile streaming
  • Certification of completion not included
  • Redemption deadline: redeem your code within 30 days of purchase
  • Experience level required: intermediate

Requirements

  • Internet required

Access
Lifetime
Content
5.5 hours
Lessons
186

Microsoft 70-465: Designing Database Solutions For Microsoft SQL Server 2012

Discover How to Design Database Solutions & Make Big Money

By iCollege | in Online Courses

This course is all about showing you how to plan and implement enterprise database infrastructure solutions using SQL Server 2012 and other Microsoft technologies. As you make your way through over 5 hours of content, you'll explore consolidation of SQL Server workloads, working with both on-site and cloud-based solutions, and disaster recovery solutions.

  • Access 186 lectures & 5.5 hours of content 24/7
  • Explore managing multiple servers
  • Dive into disaster recovery planning
  • Discover the rules of database design
  • Learn how to design a database structure & database objects

Instructor

iCollege is a leading international provider of E-Learning courses, learning technologies and development services.

iCollege is a collaborative venture between XpertSkills and XpertEase Software.

The synergistic result of their joint venture enables them to provide sophisticated, innovative, relevant, flexible and cost-effective learning solutions.

Their collective knowledge and experience in education and training provision sets the standard for service delivery in learning solutions.

Important Details

  • Length of time users can access this course: lifetime
  • Access options: web streaming, mobile streaming
  • Certification of completion not included
  • Redemption deadline: redeem your code within 30 days of purchase
  • Experience level required: intermediate

Requirements

  • Internet required

Access
Lifetime
Content
5 hours
Lessons
144

Microsoft 70-466: Implementing Data Models & Reports With Microsoft SQL Server

Help Your Company Make Smarter Business Decisions Through Analytics

By iCollege | in Online Courses

This course is designed for aspiring business intelligence developers who would like to create BI solutions with Microsoft SQL Server 2012, including implementing multi-dimensional data models, OLAP cubs, and creating information displays used in business decision making.

  • Work w/ large data sets across multiple database systems
  • Develop cubes & Multi-dimensional Expressions (MDX) queries to support analysts
  • Explore data model decisions
  • Manage a reporting system, use report builder to create reports & develop complex SQL queries for reports

Instructor

iCollege is a leading international provider of E-Learning courses, learning technologies and development services.

iCollege is a collaborative venture between XpertSkills and XpertEase Software.

The synergistic result of their joint venture enables them to provide sophisticated, innovative, relevant, flexible and cost-effective learning solutions.

Their collective knowledge and experience in education and training provision sets the standard for service delivery in learning solutions.

Important Details

  • Length of time users can access this course: lifetime
  • Access options: web streaming, mobile streaming
  • Certification of completion not included
  • Redemption deadline: redeem your code within 30 days of purchase
  • Experience level required: intermediate

Requirements

  • Internet required
  • Experience designing a normalized database
  • Experience creating tables and relationships
  • Experience querying with Transact-SQL
  • Some basic knowledge of data warehouse schema topology (including star and snowflake schemas).
  • Some exposure to basic programming constructs (such as looping and branching).
  • An awareness of key business priorities such as revenue, profitability, and financial accounting is desirable

Access
Lifetime
Content
4.5 hours
Lessons
153

Microsoft 70-467: Designing Business Intelligence Solutions With Microsoft SQL Server

Discover How to Use Microsoft SQL Server to Build a Better Decision Making Process

By Jan Viljoen | in Online Courses

This course is designed for aspiring business intelligence architects who would like to focus on the overall design of a BI infrastructure, including how it relates to other data systems.

  • Access 153 lectures & 4.5 hours of content 24/7
  • Learn BI Solution architecture & design
  • Understand provisioning of software & hardware
  • Explore Online Analytical Processing (OLAP) cube design
  • Study performance planning, scalability planning, upgrade management, & more
  • Maintain server health, design a security strategy, & more

Instructor

iCollege is a leading international provider of E-Learning courses, learning technologies and development services.

iCollege is a collaborative venture between XpertSkills and XpertEase Software.

The synergistic result of their joint venture enables them to provide sophisticated, innovative, relevant, flexible and cost-effective learning solutions.

Their collective knowledge and experience in education and training provision sets the standard for service delivery in learning solutions.

Important Details

  • Length of time users can access this course: lifetime
  • Access options: web streaming, mobile streaming
  • Certification of completion not included
  • Redemption deadline: redeem your code within 30 days of purchase
  • Experience level required: intermediate

Requirements

  • Internet required

Access
Lifetime
Content
5 hours
Lessons
140

Microsoft 70-464: Developing Microsoft SQL Server 2012 Database

Master the Tools & Skills of the Modern Database Developer

By Jan Viljoen | in Online Courses

This course is designed for aspiring database developers who would like to build and implement databases across an organization. Database developers create database files, create data types and tables, plan indexes, implement data integrity, and much more. All of which you'll learn how to do in this Microsoft 70-464 course.

  • Access 140 lectures & 5 hours of content 24/7
  • Optimize & tune queries
  • Create & alter indexes & stored procedures
  • Maintain database integrity & optimize indexing strategies
  • Design, implement, & troubleshoot security
  • Work w/ XML Data
  • Write automation scripts

Instructor

iCollege is a leading international provider of E-Learning courses, learning technologies and development services.

iCollege is a collaborative venture between XpertSkills and XpertEase Software.

The synergistic result of their joint venture enables them to provide sophisticated, innovative, relevant, flexible and cost-effective learning solutions.

Their collective knowledge and experience in education and training provision sets the standard for service delivery in learning solutions.

Important Details

  • Length of time users can access this course: lifetime
  • Access options: web streaming, mobile streaming
  • Certification of completion not included
  • Redemption deadline: redeem your code within 30 days of purchase
  • Experience level required: intermediate

Requirements

  • Internet required

Access
Lifetime
Content
15.5 hours
Lessons
71

Oracle 12c OCP 1Z0-061: SQL Fundamentals

Kickstart Your IT Future By Prepping to Ace This Oracle Exam

By Jan Viljoen | in Online Courses

Explore the benefits of an Oracle database that is re-engineered for cloud computing in this course! The Oracle Multitenant architecture delivers next-level hardware and software efficiencies, performance and manageability benefits, and fast and efficient cloud provisioning. Jump into this course, and you'll explore the essentials for passing the Oracle 12c OCP 1Z0-061: SQL Fundamentals exam.

  • Access 71 lectures & 15.5 hours of content 24/7
  • Familiarize yourself w/ data control language
  • Understand SQL functions & subqueries
  • Walk through combining queries & data definition language
  • Prep to ace the Oracle 12c OCP 1Z0-061: SQL Fundamentals exam

Instructor

iCollege is a leading international provider of E-Learning courses, learning technologies and development services.

iCollege is a collaborative venture between XpertSkills and XpertEase Software.

The synergistic result of their joint venture enables them to provide sophisticated, innovative, relevant, flexible and cost-effective learning solutions.

Their collective knowledge and experience in education and training provision sets the standard for service delivery in learning solutions.

Important Details

  • Length of time users can access this course: lifetime
  • Access options: web streaming, mobile streaming
  • Certification of completion not included
  • Redemption deadline: redeem your code within 30 days of purchase
  • Experience level required: intermediate

Requirements

  • Internet required

Access
Lifetime
Content
30.5 hours
Lessons
105

Microsoft 70-764 SQL Server 2016

Learn How to Administer A SQL Database Infrastructure

By Jan Viljoen | in Online Courses

The Microsoft SQL Server environment is one of the most preferred data management systems for companies in many different industries. Certified administrators are handsomely paid. This course will prepare you for the Microsoft Certification Exam 70-764 which validates that you are able to administer a Microsoft SQL Server 2016 server.

  • Access 105 lectures & 30.5 hours of content 24/7
  • Learn how to administer a Microsoft SQL Server 2016 server
  • Configure data access, permissions & auditing
  • Perform encryption on server data
  • Develop a backup strategy
  • Restore databases & manage database integrity

Instructor

iCollege is a leading international provider of E-Learning courses, learning technologies and development services.

iCollege is a collaborative venture between XpertSkills and XpertEase Software.

The synergistic result of their joint venture enables them to provide sophisticated, innovative, relevant, flexible and cost-effective learning solutions.

Their collective knowledge and experience in education and training provision sets the standard for service delivery in learning solutions.

Important Details

  • Length of time users can access this course: lifetime
  • Access options: web streaming, mobile streaming
  • Certification of completion not included
  • Redemption deadline: redeem your code within 30 days of purchase
  • Experience level required: intermediate

Requirements

  • Internet required


Terms

  • Unredeemed licenses can be returned for store credit within 15 days of purchase. Once your license is redeemed, all sales are final.