Skip to content
  • Bucks for Students
    Enroll + Register
    • Academics
    • Admissions Information
    • Register for Courses
    • Placement Testing
    • Academic Advising
    • Majors + Certificates
    • College Catalog
    • Bucks Online
    • Honors at Bucks
    • Academic Departments
    • Student Forms

    Apply Now

    Planning + Payment
    • Financial Aid
    • Scholarships
    • Work Study Employment
    • Payment Options
    • Your Account
    • Tuition + Fees
    Transfer + Graduate
    • Transfer Information
    • Planning Your Transfer
    • Transfer by Institution
    • Transfer by Major
    • Graduate
    • Plan a Career
    • Labor Market
    • Digital Badges

    Life at Bucks
    • First Year Experience
    • Bucks+
    • Athletics
    • Student Life
    • Fitness + Wellness
    • Student Government
    • Art + Entertainment
    • Alumni
    • Events
    • Next Level Moves

    Basic Needs

    • Accessibility Resources
    • Campus Services
    • Directory
    • Canvas
    • Bucks Email
    • Change Password
    • Pay Tuition
    • Student Planning
    • MyBucks
     
  • Bucks for Community

    Classes + Activities

    Icon of a pencil and brush
    Personal Enrichment
    • Art + Design
    • Culinary Classes
    • Business Development
    • Gaming
    • Health + Wellness
    • History + Special Interest
    • Foreign Language
    • Kids Korner
    • Music
    • Test Prep
    • Browse All Courses
    Icon of a sun
    Kids on Campus Programs
    • Camps for Ages 5-6
    • Camps for Ages 7-9
    • Camps for Ages 10-12
    • Teen Experiences for Ages 13-17
    • Camp Information
    • Camp Scholarships
    • Preschool Summer Program
    • Register for Camp

    Events

    Event Programs
    • Art + Entertainment
    • Book Discussions
    • Concerts
    • Foundation Events
    • Poetry + Prose
    • Movie Monday
    • Trips + Travel 
    • Event Tickets

    Buy Tickets

    Event Venues

    • Artmobile

    • Sculpture Walk

    • Zlock Performing Arts Center

    • The Gallery at Lower Bucks

    • Hicks Art Center Gallery

     
  • Bucks for Career
    Briefcase
    Business + Career
    • Commercial Driver's License (CDL)
    • Customized ESL
    • Educators (ACT 48)
    • Browse by Industry
    • Online Learning
    • Professional Development
    • Registered Behavior Technician
    • Microsoft Office Technology & Customer Service
    • Bookkeeping with Quickbooks Certification
    • More
    Fire extinguisher
    Fire + Public Safety
    • Public Safety Training + Certificate Course Schedule
    • Fire Training Weekends
    • Industrial Safety Training (OSHA)
    • Virtual Public Safety Training
    • Other Training + Resources
    • Training Facilities
    • More
    Heart with line
    Healthcare
    • CPR + First Aid Training
    • Dental Assistant
    • Nurse Aide
    • Nursing Review & Reentry
    • Pharmacy Technician
    • Physical Therapy Aide
    • Practical Nursing
    • More
    Tools crossed
    Industrial + Manufacturing
    • Building & Construction Trades Pre-Apprenticeship
    • Metalwork Pre-Apprenticeship Training
    • Industrial Maintenance Pre-Apprenticeship
    • Locomotive Engineer + Conductor
    • Welding Training
    • Workforce Development
    • More
    Man fixing server
    Information Technology
    • Certification Testing
    • Cyber Security
    • Database Development
    • Desktop Support (CompTIA)
    • Computer-Aided Design
    • Microsoft Office Software
    • Server Administration
    • Full Stack Web Developer
    • More
     
  • Library
  • Calendar + News
  • Diversity
  • Contact
Bucks County Community College
  IT Academy  —  Database Development + Administration

Database Development & Administration

Intro. to Database Development

DESIGNING BUSINESS INTELLIGENCE SOLUTIONS WITH MICROSOFT SQL SERVER 2016 

ADMINISTERING MICROSOFT SQL SERVER 2016 DATABASES

 

Introduction to Crystal Reports

QUERYING MICROSOFT SQL SERVER

IMPLEMENTING A DATA WAREHOUSE WITH MICROSOFT SQL SERVER 2016

Intro to SQL - T-SQL Fundamentals

 INTRODUCTION TO SQL - BASICS

 

Intro to Database Development (Anchor)

ECOSY 0043 - Introduction to Database Development ECOSY 0043

Tuition: $105.00
Instructor:
Where & When: Online

A new session of each course opens each month, allowing you to enroll whenever your busy schedule permits!

How does it work? Once a session starts, two lessons will be released each week, for the six-week duration of your course. You will have access to all previously released lessons until the course ends.

Keep in mind that the interactive discussion area for each lesson automatically closes 2 weeks after each lesson is released, so you’re encouraged to complete each lesson within two weeks of its release.

The Final Exam will be released on the same day as the last lesson. Once the Final Exam has been released, you will have 2 weeks plus 10 days to complete the Final and finish any remaining lessons in your course. No further extensions can be provided beyond these 10 days.

Week One

Lesson 01 - Databases and Why We Need Them
Wednesday

Who can benefit from a database? Anyone who needs to store data and later retrieve meaning from that data. In this lesson, you'll see where databases came from, explore the major types, and see how the various parts fit together.

Lesson 02 - Developing a Database System
Friday

In this lesson, we'll define and describe the major components of a database system. You'll learn about the System Development Life Cycle, which practically guarantees the success of any database system you produce.

Week Two

Lesson 03 - Building a Database Model
Wednesday

Today, you will learn how important the non-technical portions of a development project are. You'll see why it's not enough to build a system that meets design goals--it also needs to satisfy the people who will use it. You'll learn how to build an Entity-Relationship model that is based on a consensus of what all the stakeholders need.

Lesson 04 - Practical Considerations
Friday

This lesson will teach you how to find out what the client organization really needs from the development project--it may be very different from what they originally asked for! We'll discuss the pros and cons of either upgrading an existing system or building a new one from scratch

Week Three

Lesson 05 - The Relational Model
Wednesday

Relational databases are by far the most commonly used database type today. They're the most likely type of database that you will find yourself designing and using. In this lesson, you'll learn the relational model: how to create relational databases that have the right combination of performance and reliability to meet your needs.

Lesson 06 - Using the E-R Model to Design a Database
Friday

This lesson is the pivot point of our course: Today, you will learn how to translate the Entity-Relationship model into a relational model that you can implement directly as a database. A model that accurately describes the system you are modeling is your best guarantee that the system you deliver will perform as you need it to.

Week Four

Lesson 07 - Implementing a Database Design with Access
Wednesday

Today, we move to the hands-on portion of the course. You will take what you have learned so far to build an actual database, using the popular Microsoft Access database management system. The database will track important information for a fictitious nonprofit organization.

Lesson 08 - Implementing a Database Design with SQL
Friday

In this lesson, you will learn how to build a database with the SQL language--a language that is supported by all relational database management systems. You'll also learn how to protect it from accidental or intentional harm.

Week Five

Lesson 09 - Building a Database Application Using Access
Wednesday

Databases store data. That's important, but it's not worth much if you can't pick and choose the information you want to retrieve from the database. Today you will learn how to create a database application that will give users a turnkey tool for retrieving exactly the information they want with a minimum of hassle.

Lesson 10 - Database Security and Integrity
Friday

It's more important than ever to ensure that your company's organizational data does not fall into the wrong hands. This lesson teaches you how to control who accesses your data. We'll also cover how to protect your data if your hardware fails or if some other unexpected disaster occurs.

Week Six

Lesson 11 - Building a More Sophisticated Database Application
Wednesday

This lesson takes you to the next level--creating sophisticated database applications by combining code written with procedural languages such as Visual Basic, or C with SQL statements. We'll go on to discuss how to make databases and database applications available on an organization's network and on the World Wide Web.

Lesson 12 - Database Development Essentials
Friday

This lesson emphasizes the critically important (but often overlooked) human aspect of a database development project. Your client may not have a clear idea of what they want at the outset of your database project. That means your communication and interpersonal skills are going to be just as important as your technical expertise. After we complete this final piece of the database puzzle, you'll be ready to create database systems that truly meet the needs of your client organization.

Intro to Crystal Reports (Anchor)

ECOAP 0258 - Introduction to Crystal Reports ECOAP 0258

Tuition: $105.00
Instructor:
Where & When: Online

A new session of each course opens each month, allowing you to enroll whenever your busy schedule permits!

How does it work? Once a session starts, two lessons will be released each week, for the six-week duration of your course. You will have access to all previously released lessons until the course ends.

Keep in mind that the interactive discussion area for each lesson automatically closes 2 weeks after each lesson is released, so you’re encouraged to complete each lesson within two weeks of its release.

The Final Exam will be released on the same day as the last lesson. Once the Final Exam has been released, you will have 2 weeks plus 10 days to complete the Final and finish any remaining lessons in your course. No further extensions can be provided beyond these 10 days.

Week One

Lesson 01 - Getting Started With Crystal Reports
Wednesday

Crystal Reports is the world's most popular software tool for creating reports based on data stored in databases. It's popular because of its power and flexibility, which will help you create reports that communicate the information you want to convey to the people you want to convey it to. In our first lesson, you'll learn why it's important to find out everything you need to know about the report you want to create before you even launch the Crystal Reports application. This advance planning gives you a much better chance of creating a report that achieves your objectives.

Lesson 02 - Create a Crystal Report Right Now!
Friday

In this lesson, we'll hit the ground running and create a Crystal Report from scratch. From Lesson 1, you already know how to connect to a data source. Today, you'll learn how to pull data from that data source and place it into your report. Then, I'll show you how to use Crystal Reports to create a quick, simple report with a professional appearance—adding headers and footers, and adjusting column headings and the data itself. We'll also discuss how to arrange all of these items on a page for maximum visual impact. By the end of this lesson, you'll know how to create a simple report!

Week Two

Lesson 03 - Pulling Data From Multiple Tables
Wednesday

Once you know how to pull data from a database and display it in a basic report, the next step is to pull data from multiple database tables and display only the data you want, filtering out any irrelevant information. In this lesson, you'll learn how to perform these functions, and I'll also show you how to build reports that allow users to decide at runtime what to display. In effect, you can build one report that serves the purpose of multiple reports!

Lesson 04 - Sorting, Grouping, and Drilling Down
Friday

Displaying the information in a database is one thing; displaying it in a way that communicates effectively is another. In today's lesson, we'll review how to enhance communication by organizing a report's data in a meaningful way, and you'll learn how to use Crystal Reports to sort data and group related data items together. You'll discover how to summarize numerical data with group totals and how to obtain an overall grand total. And we'll also look into the drill-down capability of Crystal Reports, which allows your report readers to use a simple mouse click to access suppressed details of a specific data group!

Week Three

Lesson 05 - Crystal Reports Formatting Tools
Wednesday

In this lesson, you'll dive into the details of the various report sections. First, we'll discuss how to resize sections, and then we'll take a close look at the Section Expert, which is your major tool for selecting options that control the appearance and function of the various sections of a report. We'll also explore how you can control the placement of groups, reset page numbering, and move report totals. Finally, we'll take a closer look at the drill-down feature and hiding details.

Lesson 06 - Absolute and Conditional Formatting
Friday

Today, you'll get even more hands-on experience formatting a report. First, we'll look at a number of formatting options that Crystal Reports offers to help you give your report just the look you want. Then, we'll look at how you can use report templates to achieve a consistent appearance across a family of reports. And finally, we'll practice using absolute formatting and conditional formatting, features that can adjust the appearance of your report based on the data it contains.

Week Four

Lesson 07 - Creating Cross-Tab Reports
Wednesday

With Crystal Reports, you can do more than just display the data you select from your data source. You can also show correlations between related categories of data items. To do this, you create a cross-tab report, which can show such correlations across the entire data set or within a selected group of data items. As usual, Crystal Reports provides considerable flexibility in how it presents the cross-tab data to users. In this lesson, you'll learn what the options are and how to use them.

Lesson 08 - Creating Reports to Show Top and Bottom Performers
Friday

You'll often need to create a report based on some, but not all, of the data in a database. For example, a sales manager may want to look only at the purchase records of her top five customers. Alternatively, she may want to view the performance of her bottom 10 salespeople. Crystal Reports makes it easy to produce such reports, as well as others that are selective about what they display. In this lesson, you'll create such targeted reports that make it easy for managers to make informed decisions.

Week Five

Lesson 09 - Crystal Reports Formulas
Wednesday

The formulas and control structures in Crystal Reports allow you to make your reports dynamic, sensitive to what's happening at runtime. With formulas, you can operate on data and put the result into your report. You can also save time and effort by including one or more of the predefined functions in your formulas. You can even create your own custom functions, save them, and use them both now and in the future. These facilities give you the flexibility to produce a sophisticated custom report with very little time and effort. And you'll find out how to do all of this in today's lesson.

Lesson 10 - Adding Subreports to a Main Report
Friday

Crystal Reports gives you the ability to embed one report inside another. The two reports can be related in some way, or they can be completely unrelated. As long as you have a reason for displaying both reports at once, you can do it, and you'll find out how in today's lesson. We'll also practice embedding hyperlinks today. This can be a great alternative to embedding a subreport within a main report!

Week Six

Lesson 11 - Communicating With Charts
Wednesday

Charts and maps can add visual dimension to the display of information in a report. While columns of numbers may be an effective way to present data for some readers, you may have visual learners in your target audience who would be better served by charts and maps. Today, you'll learn how to choose a chart type that best conveys the information you want to emphasize. And you'll find out how to use color, font, scale, legends, and titles to help you highlight trends in the data or data points that fall outside of the expected range.

Lesson 12 - Publishing a Crystal Report
Friday

After you've created a report, you need to distribute it. Crystal Reports gives you several convenient distribution options, and we'll explore all of these in our final lesson. We'll talk about print and fax options, exporting a report to any of a number of popular file formats, and transmitting it to the people who should read it. You'll learn how to post the report on your organization's intranet or the Web, and then we'll discuss distributing reports via Crystal Reports Viewer 2008.

Oracle

ECOSY 0563 Oracle SQL Training ECOSY 0563

Tuition: $239.00
Instructor: Self Paced
Where & When: Online Self Paced

Mastering Oracle SQL is one today's most marketable programming skills for end-to-end developers. This online, self-paced course covers the basics of Oracle SQL. You will learn the fundamentals, including queries, procedures, and functions through hands-on assignments. By course completion, your SQL skills will be on par with industry standards.  

What you will learn

  • How tables are structured and how data is stored
  • To use Oracle to output reports and to use SQL functions
  • To group data to get aggregate values
  • To write joins and subqueries to get data from multiple tables and to write INSERT, UPDATE, and DELETE statements
  • To use SET operators and to do conditional processing with CASE

How you will benefit

  • Gain skills that every developers needs
  • Bring your SQL skills to any web development job

Syllabus

  1. Relational Database Basics
  2. Creating Tables
  3. Basic Selects
  4. Oracle SQL Functions
  5. Aggregate Functions
  6. Subqueries
  7. Set Operators
  8. Conditional Processing with CASE
  9. Data Manipulation Language
  10. Creating Views

Requirements

Prerequisites:

Prior to enrolling in this course, we recommend having an intermediate understanding of SQL or taking the Introduction to SQL Training course.  

Requirements:

Hardware Requirements:

  • This course must be taken on a PC. Macs are not compatible.

Software Requirements:

  • PC: Windows 10 or later.
  • Oracle Database Express Edition (XE) 12c or 18c - Free edition of Oracle RDBMS.
  • Oracle SQL Developer - The client interface for connecting to Oracle. (Software not included)
  • Browser: The latest version of Google Chrome or Mozilla Firefox are preferred. Microsoft Edge is also compatible.
  • Adobe Acrobat Reader.

Other:

  • Software must be installed and fully operational before the course begins.

Instructional Material Requirements:

The instructional materials required for this course are included in enrollment and will be available online.

ECOSY 0564 Oracle PL/SQL Training ECOSY 0564

Tuition: $259.00
Instructor: Online Self Paced
Where & When: Online

This self-paced SQL training course is perfect for advancing your current SQL skills. While Oracle uses a standard SQL like other major databases, PL/SQL is specific to Oracle. PL/SQL is a procedural language with variables, conditions, loops, subprograms, stored procedures, and functions. By course completion, you will understand and know how to use PL/SQL's main features, including declaring, naming, and assigning variables.

Syllabus

  1. PL/SQL Basics
    1. What is PL/SQL?
    2. Blocks
    3. Outputting Information
    4. Variables and Constants
    5. Constants
    6. Data Types
    7. Naming Variables and Other Elements
    8. Embedding SQL in PL/SQL
    9. SELECT...INTO and RETURNING...INTO
    10. PL/SQL Features
  2. Subprograms
    1. Introduction to Subprograms
    2. Procedures
    3. Variable Declarations
    4. Dropping a Procedure
    5. Parameters
    6. Parameters with Default Values
    7. Parameter Modes
    8. IN Mode
    9. OUT Mode
    10. IN OUT Mode
    11. Named Notation
    12. Using SQL in a Subprogram
    13. %TYPE
    14. Functions
    15. Using PL/SQL Functions in SQL Queries
  3. Conditional Processing
    1. Conditions and Booleans
    2. IF-ELSIF-ELSE Conditions
    3. ELSIF
    4. BOOLEAN Values and Standard SQL
    5. The CASE Statement
    6. CASE Expressions
  4. Exceptions
    1. Introduction to Exceptions
    2. Predefined Exceptions
    3. The EXCEPTION Part of the Block
    4. User-defined Exceptions
    5. User-defined Exceptions in Subprograms
    6. Re-raising Exceptions
    7. Naming Unnamed Predefined Exceptions
    8. WHILE Loops
    9. When to Use Exceptions
  5. Cursors
    1. Implicit Cursors
    2. Explicit Cursors
    3. %ROWTYPE
    4. Explicit Cursor Use Case
    5. Cursor FOR LOOP
    6. Cursor Parameters
  6. Packages
    1. Package Basics
    2. The Package Specification
    3. The Package Body
    4. Building an Employee Package
    5. Overloading Subprograms
    6. Auditing
    7. Validation Procedures
    8. Package Cursors
    9. Benefits of Packages
  7. Triggers
    1. What are triggers?
    2. Trigger Parts
    3. Validation Triggers
    4. The WHEN Clause
    5. Audit Triggers
    6. Statement-level Triggers
    7. Compound Triggers
    8. Trigger Warning

Requirements

 Prerequisites:

Prior to enrolling in this course, we recommend having an intermediate understanding of SQL or taking the Oracle SQL Training course.

 Requirements:

Hardware Requirements:

  • This course must be taken on a PC. Macs are not compatible.

Software Requirements:

  • PC: Windows 10 or later.
  • Oracle Database Express Edition (XE) 12c or 18c - Free edition of Oracle RDBMS.
  • Oracle SQL Developer - The client interface for connecting to Oracle. (Software not included)
  • Browser: The latest version of Google Chrome or Mozilla Firefox are preferred. Microsoft Edge and Safari are also compatible.
  • Adobe Acrobat Reader.

Other:

  • Software must be installed and fully operational before the course begins.

Instructional Material Requirements:

The instructional materials required for this course are included in enrollment and will be available online.

How to Register

How to Register

WITAC 2512 ANCHOR

WITAC 2512 - DESIGNING BUSINESS INTELLIGENCE SOLUTIONS WITH MICROSOFT SQL SERVER 2016 (70-467) WITAC 2512

Tuition: $895.00
Instructor: STAFF
Where & When: Currently not offered

PLAN BUSINESS INTELLIGENCE (BI) INFRASTRUCTURE

  • Plan for performance
    • Optimize batch procedures: extract, transform, load (ETL) in SQL Server Integration Services (SSIS)/SQL and processing phase in Analysis Services; configure Proactive Caching within SQL Server Analysis Services (SSAS) for different scenarios; understand performance consequences of Unified Dimension Model (UDM) and Data Warehouse (DWH) design; analyze and optimize performances of Multidimensional Expression (MDX) and Data Analysis Expression (DAX) queries; optimize queries for huge data sets; understand the difference between partitioning for load performance versus query performance in SSAS; appropriately index a fact table; optimize Analysis Services cubes in UDM; create aggregations using Usaged Based Optimizations
  • Plan for scalability
    • Multidimensional OLAP (MOLAP); Relational OLAP (ROLAP); Hybrid OLAP (HOLAP)
  • Plan and manage upgrades
    • Plan change management for a BI solution
  • Maintain server health
    • Design an automation strategy

DESIGN BI INFRASTRUCTURE

  • Design a security strategy
    • Configure security and impersonation between database, analysis services and frontend; implement Dynamic Dimension Security within a cube; configure security for an extranet environment; configure Kerberos security; skills in authentication mechanisms, ability to build secure solutions end to end; design security roles for calculated measures; understand the tradeoffs between regular SSAS security and dynamic security; plan and implement security requirements of a BI solution
  • Design a SQL partitioning strategy
    • Choose the proper partitioning strategy for the data warehouse and cube; implement a parallel load to fact tables by using partition switching; use data compression in fact tables
  • Design a backup strategy
    • Design a High Availability (HA) and Disaster Recovery (DR) trategy; proactively prevent issues
  • Design a logging and auditing strategy
    • Design a new SSIS logging infrastructure (for example, information available through the catalog views); validate data is balancing and reconciling correctly

DESIGN A REPORTING SOLUTION

  • Design a Reporting Services dataset
    • Data query parameters; creating appropriate SQL queries for an application (MDX queries); managing data rights and security; extracting data from analysis services; balancing query-based processing versus filter-based processing; managing data sets through the use of stored procedures
  • Manage Excel Services/reporting for SharePoint
    • Configure data refresh schedules for PowerPivot published to SharePoint; publish BI info to SharePoint; use SharePoint to accomplish BI administrative tasks
  • Design a data acquisition strategy
    • Identify the data sources that need to be used to pull in the data; determine the changes (incremental data) in the data source (time window); identify the relationship and dependencies between the data sources; determine who can access which data; what data can be retained for how long (regulatory compliance, data archiving, aging); design a data movement strategy; profile source data
  • Plan and manage reporting services configuration
    • Native mode
  • Design BI reporting solution architecture
    • Linked reports, drill-down reports, drill-through reports, migration strategies, access report services API, sub reports, code-behind strategies; identify when to use Reporting Services, Report Builder, or Crescent; design/implement context transfer when interlinking all types of reports (RS, RB, Crescent, Excel, PowerPivot); implement BI tools for reporting in SharePoint (Excel Services versus Performance Point versus Reporting Services); select a subscription strategy

DESIGN BI DATA MODELS

  • Design the data warehouse
    • Design a data model that is optimized for reporting; design and build a cube on top; design enterprise data warehouse (EDW) and OLAP cubes; choose between natural keys and surrogate keys when designing the data warehouse; use the facilities available in SQL Server to design, implement and maintain a data warehouse (partitioning, slowly changing dimensions (SCD), change data capture (CDC), Clustered Index Views, etc.); identify design best practices; implement a many to many relationship in an OLAP cube; design a data mart/warehouse in reverse from an Analysis Services cube (or empty Analysis Services cube that was created referring requirements); use rowstamp in the data warehouse; choose between performing aggregation operations in the SSIS pipeline or the relational engine; select surround architecture
  • Design a schema
    • Multidimensional modeling starting from a star schema; relational modeling for a Data Mart; choose or create a topology
  • Design cube architecture
    • Produce efficient aggregated cubes; partition cubes and build aggregation strategies for the separate partitions; design a data model; choose the proper partitioning strategy for the data warehouse and cube; design the data file layout for a data warehouse keeping maximum performance in mind; given a requirement, identify the aggregation method that should be selected for a measure in a MOLAP cube; design cube aggregations to maintain a balance between storage and performance; performance tune a MOLAP cube using aggregations; design a data source view; cube drill-through and write back actions
  • Design fact tables
    • Design a data warehouse that supports many to many dimensions with factless fact tables
  • Design BI semantic models
    • Plan for a multidimensional cube; write a UDM model with many to many (this is related to MDX/BISM code, but it is a good example for exercises); choose between UDM and BISM depending on the type of data and workload
  • Design and create MDX calculations
    • MDX authoring; identify the structures of MDX and the common functions (tuples, sets, topcount, SCOPE etc.); identify which MDX statement would return the required result (single result and multiple MDX options provided to test taker); implement a custom MDX or logical solution for a pre-prepared case task

DESIGN AN ETL SOLUTION

  • Design SSIS package execution
    • Using new project deployment model; passing values at execution time; share parameters between packages
  • Plan to deploy SSIS solutions
    • Deploy the package to another server with different security requirements; secure integration services packages that are deployed at the file system; demonstrate awareness of SSIS packages/projects and how they interact with environments; decide between performing aggregation operations in the SSIS pipeline or the relational engine
  • Design package configurations for SSIS packages
    • Avoid repeating configuration information entered in SSIS packages and use configuration files

TEXTBOOK INFORMATION:

Pro SQL Server 2012 BI Solutions Paperback by Randal Root (Author), Caryn Mason (Author)
ISBN-13: 978-1430234883 ISBN-10: 1430234881 Edition: 1st

 

 

How to Register

How to Register

WITAC 2513 ANCHOR

WITAC 2513 - Querying Microsoft SQL Server (54 HRS) WITAC 2513

Tuition: $895.00
Instructor: Hartwell
Where & When: Instructor Led via Zoom Currently not offered 5:30pm - 9:30pm

 

 

This instructor led course provides students with the technical skills required to write basic Transact-SQL queries for Microsoft SQL Server. This course is the foundation for all SQL Server-related disciplines; namely, Database Administration, Database Development and Business Intelligence. The main purpose of the course is to prepare students for the exam "70-761: Writing Queries Using Microsoft® SQL Server® 2016 Transact-SQL." This exam will be the underlying exam for all SQL Server-related disciplines; namely, Database Administration, Database Development and Business Intelligence. As such, the primary target audience for this course is: Database Administrators, Database Developers and BI professionals. 

AFTER COMPLETING THIS COURSE, YOU WILL BE ABLE TO:

  • Write SELECT queries
  • Query multiple tables
  • Use built-in functions
  • Use subqueries
  • Execute stored procedures
  • Use set operators
  • Implement error handling
  • Implement transactions
  • Use table expressions
  • Sort and filter data
  • Use window ranking, offset and aggregate functions
  • Query SQL Server metadata
  • Program with T-SQL
  • Improve query performance

COURSE INFORMATION

Hours 54
Textbook: Exam Ref 70-761 Querying Data with Transact-SQL with Practice Test ISBN 978-1-5093-0372-4

How to Register

How to Register

WITAC 2514 ANCHOR

WITAC 2514 - ADMINISTERING MICROSOFT SQL SERVER 2016 DATABASES (54 HRS) WITAC 2514

Tuition: $895.00
Instructor: STAFF
Where & When: Currently not offered

AFTER COMPLETING THIS COURSE, STUDENTS WILL BE ABLE TO

  • Plan and install SQL Server.
  • Describes the system databases, the physical structure of databases and the most common configuration options related to them.
  • Explain the concept of the transaction log and SQL Server recovery models and implement different backup strategies available with SQL Server.
  • Create SQL Server Backups.
  • Restore SQL Server databases.
  • Use the import/export wizards and explain how they relate to SSIS.
  • Work with SQL Server security models, logins and users.
  • Work with fixed server roles, user-defined server roles, fixed database roles and user-defined database roles.
  • Work with permissions and the assignment of permissions.
  • Work with SQL Server Audit.
  • Work with SQL Server Agent, jobs and job history.
  • Implement SQL Server agent security, proxy accounts and credentials.
  • Configure database mail, alerts and notifications.
  • Create database maintenance plans.
  • Work with SQL Profiler and SQL Trace stored procedures.
  • Introduce DMVs and the configuration of data collection.
  • Work with Central Management Servers and Multi-Server queries, Virtualization of SQL Server and Data-Tier Applications.
  • Troubleshoot SQL Server databases.

COURSE INFORMATION

Text: Training Kit (Exam 70-764): Administering Microsoft SQL Server 2016 Databases (Microsoft Press Training Kit), ISBN 978-0-73566607-8.

 

 

WITAC 2515 ANCHOR

WITAC 2515 - IMPLEMENTING A DATA WAREHOUSE WITH MICROSOFT SQL SERVER 2016 (54 HRS) WITAC 2515

Tuition: $895.00
Instructor: STAFF
Where & When: Currently not offered

Data warehousing is a solution organizations use to centralize business data for reporting and analysis. This instructor-led course focuses on teaching you how to create a data warehouse with 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. This course helps you to prepare for exam 70-767.

This course is intended for database professionals who need to fulfill a Business Intelligence Developer role.  They will need to focus on hands-on work creating BI solutions including Data Warehouse implementation, ETL, and data cleansing.  Primary responsibilities include:
  • Implementing a data warehouse.
  • Developing SQL Server Integration Services (SSIS) packages for data extraction, transformation, and loading (ETL).
  • Enforcing data integrity by using Master Data Services.
  • Cleansing data by using Data Quality Services.

AFTER COMPLETING THIS COURSE, STUDENTS WILL BE ABLE TO

  • Describe data warehouse concepts and architecture considerations.
  • Select an appropriate hardware platform for a data warehouse.
  • Design and implement a data warehouse.
  • Implement Data Flow in an SSIS Package.
  • Implement Control Flow in an SSIS Package.
  • Debug and Troubleshoot SSIS packages.
  • Implement an SSIS solution that supports incremental data warehouse loads and changing data.
  • Integrate cloud data into a data warehouse ecosystem infrastructure.
  • Implement data cleansing by using Microsoft Data Quality Services.
  • Implement Master Data Services to enforce data integrity.
  • Extend SSIS with custom scripts and components.
  • Deploy and Configure SSIS packages.
  • Describe how information workers can consume data from the data warehouse.

COURSE INFORMATION

Text: Implementing a Data Warehouse with Microsoft SQL Server 2012 (Microsoft Press Training Kit), ISBN# 978-0-7356-6609-2.

 

 

WITAC 2516 ANCHOR

WITAC 2516 - Introduction to Sql - Basics 52 (HRS) WITAC 2516

Tuition: $795.00
Instructor: Hartwell
Where & When: Hybrid - Online + Face to Face at Main Campus Currently not offered 5:30PM - 9:30PM

Course Description:

Master T-SQL fundamentals and write robust code for Microsoft SQL Server and Azure SQL Database. The course explains key T-SQL concepts and helps you apply your knowledge with hands-on exercises. Introduces T-SQL’s roots and underlying logic. The course walks you through core topics such as single-table queries, joins, subqueries, table expressions, and set operators. Then the course covers more-advanced data-query topics such as window functions, pivoting, and grouping sets. The course also explains how to modify data, work with temporal tables, and handle transactions, and provides an overview of programmable objects.

Textbook: Itzik Ben-Gan, T-SQL Fundamentals 3rd Edition 97801509302000

 

  • Courses
  • Certification Testing
  • AMAZON Web Services
  • Cisco Network Administration
  • Cloud Academy
  • Computer Training
  • Cyber Security
  • Data Analysis, e-Marketing & Social Media
  • Database Development + Administration
  • Desktop Support (CompTIA)
  • Full Stack Web Developer
  • ITIL
  • Server Administration
  • Boot Camps
  • Virtualization
  • Web Design
  • Events
  • Pathways to College Credits/Degrees
  • Partners + Sponsors
  • Success Stories
  • Request More Info
  • Instructors Wanted

IT Academy

215-968-8132 itacademy@bucks.edu Gateway, Newtown

Register Here for Courses

Register Here for Courses

IT Academy

215-968-8132 itacademy@bucks.edu Gateway, Newtown

Register Here for Courses

Register Here for Courses

circle logo
Newtown | 215-968-8000
275 Swamp Road, Newtown, PA 18940
Bristol | 267-685-4800
1304 Veterans Highway Bristol, PA 19007
Perkasie | 215-258-7700
One Hillendale Rd, Perkasie, PA 18944
Bucks Online | 215-968-8052
Learn from anywhere



  • Follow Us on Instagram
  • Like Us on Facebook
  • Follow Us on Tiktok
  • Watch Us on YouTube

© Bucks County Community College.
All rights reserved.

Find Campus Services

  • Accessibility - TAO
  • Admissions
  • Advising
  • AESL Program
  • Basic Needs
  • Bookstore (External Website)
  • Career + Job Resources
  • Catalog
  • Counseling
  • Dining
  • Financial Aid
  • Fitness and Wellness
  • IT Help Desk
  • KEYS Program
  • Library
  • Media Lab
  • Success Advocates
  • Perkins
  • Early Learning Center
  • Prior Learning Assessment
  • Security + Safety
  • Testing 
  • Transfer + Planning
  • Tutoring
  • Veteran Resources

Faculty + Staff Resources

  • MyBucks
  • Office 365
  • Canvas
  • Faculty Center
  • Faculty Online Resources
  • Professional Development

Get Involved

  • Arts + Entertainment
  • Athletics
  • Bucks+
  • Calendar + News
  • Event Tickets
  • Lectures + Conferences
  • Student Life

Read Notices + Policies

  • Academic Policies
  • Student Policies
  • Human Resources Policies
  • Information Technology
  • Administration
  • Advancement
  • Consumer Information
  • Disclaimers
  • Holiday Statement
  • Notice of Non-Discrimination
  • Clean Air Zone
  • Web Accessibility

Foundation + Alumni

  • Give
  • Alumni
  • Board of Directors
  • Foundation
  • Scholarships
  • Special Events

Explore Campus

  • Bucks Online
  • Newtown Campus
  • Lower Bucks Campus
  • Upper Bucks Campus
  • Parking
  • Facilities Rental
  • Weddings in Tyler Gardens
  • Purchasing
  • Sustainability
  • Emergency Closing Information

Find Jobs

  • Student + Work-Study Employment
  • Faculty + Staff Employment

Discover Bucks

  • Accreditations
  • Board of Trustees
  • Diversity, Equity + Inclusion
  • History
  • Mission + Vision
  • Office of the President
  • Provide Feedback

Contact Us

  • Ways to Contact Us
  • Faculty + Staff Directory
  • Social Media
  • Report an Issue
  • Emergency Text Alerts
  • System Status
  • Campus Health & Safety Plan