Microsoft SQL Server 2016
Microsoft 70-764 SQL 2016 - Administering a SQL Database Infrastructure
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
Included Courses
Total Video Lessons

18

13

4

20

9

5

8

3

4

8
Microsoft 70-765 Provisioning SQL Databases
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
Included Courses
Total Video Lessons

16

7

11

18

10

8

8

11

13
Microsoft SQL Server 2012
Microsoft 70-461: Querying SQL Server 2012
This course provides students with the technical skills required to write basic Transact-SQL queries for Microsoft SQL Server 2012 and is the foundation for all SQL Server-related disciplines; namely, Database Administration, Database Development and Business Intelligence. This course is preparation for exam 70-461.
Included Courses
Total Video Lessons

1

10

4

10

6

6

6

4

6

4

4

7

2

5

4

5
Microsoft 70-462: Administering SQL Server 2012 Databases
This course is preparation for the 70-462 Exam. The lectures provide students with the knowledge and skills to maintain a Microsoft SQL Server 2012 database and focuses on teaching individuals how to use SQL Server 2012 product features and tools related to maintaining a database.
Included Courses
Total Video Lessons

3

2

6

5

6

5

3

6

7

4

7

5

3
Microsoft 70-464: Developing Microsoft SQL Server 2012 Databases
This course is preparation for the 70-464 exam and introduces SQL Server 2012 and describes logical table design, indexing and query plans. It also focusses on the creation of database objects including views, stored procedures, along with parameters, and functions. Other common aspects of procedure coding, such as indexes, concurrency, error handling, and triggers are also covered in this course.
Included Courses
Total Video Lessons

7

4

2

2

4

4

3

4

2

3

3

1

3

2

1

4

2

2

3

3
Microsoft 70-465: Designing Database Solutions for Microsoft SQL Server 2012
This course is on planning and implementing enterprise database infrastructure solutions by using SQL Server 2012 and other Microsoft technologies. It describes how to consolidate SQL Server workloads, work with both on-premises and Microsoft Azure cloud-based solutions, and how to plan and implement high availability and disaster recovery solutions.
Included Courses
Total Video Lessons

7

5

3

6

7

4

2

2

6

2

2

3

2

3

2
Microsoft SQL 2008
Microsoft 70-432: SQL Server 2008, Implementation and Maintenance
This course is preparation for the 70-432 exam. This exam covers the following topics: Installing and configuring SQL Server 2008, Maintaining SQL Server instances, Managing SQL Server security, Maintaining a SQL Server database, Performing data management tasks, Monitoring and troubleshooting SQL Server, Optimizing SQL Server performance, Implementing high availability.
Included Courses
Total Video Lessons

5

6

2

5

2

5

3

3

2

2

2

3

2

2

3

1

1

1

2

1

1

1

1

2

1

2

1

2

5

2

2
Microsoft 70-448: Microsoft SQL Server 2008, Business Intelligence Development and Maintenance
This course is preparation for the 70-448 exam. This exam covers the following topics: Implementing an SSIS solution, Configuring, deploying, and maintaining SSIS, Implementing an SSAS solution, Configuring, deploying, and maintaining SSAS, Implementing an SSRS solution, Configuring, deploying, and maintaining SSRS.
Included Courses
Total Video Lessons

10

8

7

7

12

7

7

9

8

6

4

4

5
Microsoft Business Intelligence
Microsoft 70-463: Implementing a Data Warehouse with SQL Server 2012
This course is preparation for the 70-463 exam and describes how to implement a data warehouse platform to support a BI solution. Students will learn how to create a data warehouse with Microsoft SQL Server 2012, implement ETL with SQL Server Integration Services, and validate and cleanse data with SQL Server Data Quality Services and SQL Server Master Data Services.
Included Courses
Total Video Lessons

7

6

5

4

6

5

8

8

4

6

4

3

2

1
Microsoft 70-466: Implementing Data Models & Reports with SQL Server 2012
This course prep for the 70-466 exam and focuses on creating managed enterprise BI solutions. It describes how to implement multidimensional and tabular data models, deliver reports with Microsoft SQL Server Reporting Services, create dashboards with Microsoft SharePoint Server PerformancePoint Services, and discover business insights by using data mining.
Included Courses
Total Video Lessons

6

8

2

3

3

2

1

2

3

2

4

3

2

1

1

2

2
Microsoft 70-467: Designing Business Intelligence Solutions with SQL Server 2012
This exam is intended for business intelligence (BI) architects, who are responsible for the overall design of a BI infrastructure and how it relates to other data systems in use.
Included Courses
Total Video Lessons

8

8

3

7

4

7

5

6
Oracle
Oracle Database 11g Certified Associate (OCA) Fundamentals 1Z0-051 and Admin 1z0-052
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 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!
Included Courses
Total Video Lessons

13

4

6

5

4

3

4

2

2
Oracle 12c OCP 1Z0-061: SQL Fundamentals
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.
Included Courses
Total Video Lessons

5

6

10

6

4

3

6

1

4
Oracle 12c OCP 1Z0-062: Installation and Administration
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.
Included Courses
Total Video Lessons

3

2

2

2

2

4

6

2

2

7

2

9

2

6