Tag Archives: sql

New CBT Nuggets Course: Implementing a Data Warehouse using SQL (70-767)

News, SQL Server, , , ,

70-767

CBT Nuggets trainer Knox Hutchinson recently released three courses that show learners how to implement a data warehouse using Microsoft SQL Server.

Each module maps directly to a section covered in Microsoft’s Implementing a Data Warehouse using SQL exam (70-767):

Topics this training covers include:

  • Designing and implementing dimension tables and fact tables
  • Data warehouse storage
  • Implementing an ETL control flow by using an SSIS package
  • Deploying SSIS packages and projects
  • Using DQA to maintain data quality
  • Implementing an MDS model

What this training includes:

  • 3 courses
  • 52 videos
  • In-video quizzes
  • Supplemental files

New CBT Nuggets Course: Oracle Database 12c: SQL Fundamentals (1Z0-071)

News, , , , ,

Oracle Database

CBT Nuggets trainer Ben Finkel recently released his new Oracle Database 12c: SQL Fundamentals course, which covers how to install Oracle Database 12c, structure an effective database, and write SQL queries.

Ben designed this course for entry-level DBAs studying for their Oracle Database SQL certification — or continuing to the Oracle Database 12c OCA certification.

This course maps directly to the Database 12c: SQL Fundamentals 1Z0-071 exam, which is one of two exams required to earn the Oracle Database 12c OCA certification.

Passing the 1Z0-071 exam also qualifies learners for the Oracle Database SQL Certification. Though learners can still take the predecessor exam to IZ0-071, Oracle will retire the Database 12c: SQL Fundamentals 1Z0-061 exam in November 2019.

Topics this course covers include:

  • Relational database basics
  • Normalizing databases
  • Basic DDL, DML, and TCL queries

This course includes:

  • 6 hours of training
  • 63 videos
  • In-video quizzes