Microsoft

Sort By:  
Administering Microsoft® SQL Server® Databases (Administering SQL Server 2014 )

COURSE OVERVIEW

This course provides students with the knowledge and skills to maintain a Microsoft SQL Server 2014 database. The course focuses on teaching individuals how to use SQL Server 2014 product features and tools related to maintaining a database. Note: This course is designed for customers who are interested in learning SQL Server 2012 or SQL Server 2014.  It covers the new features in SQL Server 2014, but also the important capabilities across the SQL Server data platform.

TARGET AUDIENCE

The primary audience for this course is individuals who administer and maintain SQL Server databases. These individuals perform database administration and maintenance as their primary area of responsibility, or work in environments where databases play a key role in their primary job. The secondary audience for this course is individuals who develop applications that deliver content from SQL Server databases.

COURSE OBJECTIVES

  • Describe core database administration tasks and tools.
  • Install and configure SQL Server 2014.
  • Configure SQL Server databases and storage.
  • Plan and implement a backup strategy.
  • Restore databases from backups.
  • Import and export data.
  • Monitor SQL Server.
  • Trace SQL Server activity.
  • Manage SQL Server security.
  • Audit data access and encrypt data.
  • Perform ongoing database maintenance.
  • Automate SQL Server maintenance with SQL Server Agent Jobs.
  • Configure Database Mail, alerts and notifications.

COURSE CONTENT

  • Module 1:
  • Introduction to SQL Server 2014 Database Administration
  • Database Administration Overview
  • Introduction to the SQL Server Platform
  • Database Management Tools and Techniques
  • Lab : Using SQL Server Administrative Tools
  • Using SQL Server Management Studio
  • Using the sqlcmd Utility
  • Using Windows PowerShell with SQL Server

  • Module 2:
  • Installing and Configuring SQL Server 2014
  • Planning SQL Server Installation
  • Installing SQL Server 2014
  • Post-Installation Configuration
  • Lab : Installing SQL Server 2014
  • Preparing to Install SQL Server
  • Installing SQL Server
  • Performing Post-Installation Configuration

  • Module 3:
  • Working with Databases and Storage
  • Introduction to Data Storage with SQL Server
  • Managing Storage for System Databases
  • Managing Storage for User Databases
  • Moving Database Files
  • Configuring the Buffer Pool Extension
  • Lab : Managing Database Storage
  • Configuring tempdb Storage
  • Creating Databases
  • Attaching a Database

  • Module 4:
  • Planning and Implementing a Backup Strategy
  • Understanding SQL Server Recovery Models
  • Planning a Backup StrategyBacking up Databases and Transaction Logs
  • Using Backup Options
  • Ensuring Backup Reliability
  • Lab : Backing Up SQL Server Databases
  • Backing Up Database
  • Performing Database, Differential, and Transaction Log Backups
  • Performing a Partial Backup

  • Module 5:
  • Restoring SQL Server 2014 Databases
  • Understanding the Restore Process
  • Restoring Databases
  • Advanced Restore Scenarios
  • Working with Point-in-Time Recovery
  • Lab : Restoring SQL Server Databases
  • Restoring a Database BackupRestoring Database, Differential, and Transaction Log Backups
  • Performing a Piecemeal Restore

  • Module 6:
  • Importing and Exporting Data
  • Introduction to Transferring Data
  • Importing and Exporting Table Data
  • Copying or Moving a Database
  • Lab : Importing and Exporting Data
  • Using the SQL Server Import and Export Wizard
  • Using the bcp Utility
  • Using the BULK INSERT Statement
  • Using the OPENROWSET Function

  •  Module 7:
  • Monitoring SQL Server 2014
  • Introduction to Monitoring SQL Server
  • Dynamic Management Views and Functions
  • Performance Monitor
  • Lab : Monitoring SQL Server 2014
  • Collecting Baseline Metrics
  • Monitoring a Workload

  • Module 8:
  • Tracing SQL Server Activity
  • Tracing SQL Server Workload Activity
  • Using Traces
  • Lab : Tracing SQL Server Workload Activity
  • Capturing a Trace in SQL Server Profiler
  • Generating Database Tuning Recommendations
  • Using SQL Trace

  • Module 9:
  • Managing SQL Server Security
  • Introduction to SQL Server Security
  • Managing Server-Level Security
  • Managing Database-Level Principals
  • Managing Database PermissionsLab : Managing SQL Server Security
  • Managing Server-Level Security
  • Managing Database-Level Security
  • Testing Database Access

  • Module 10:
  • Auditing Data Access and Encrypting Data
  • Auditing Data Access in SQL Server
  • Implementing SQL Server Audit
  • Encrypting Databases
  • Lab : Auditing Data Access and Encrypting Data
  • Implementing Auditing
  • Implementing Transparent Database Encryption

  • Module 11:
  • Performing Ongoing Database Maintenance
  • Ensuring Database Integrity
  • Maintaining Indexes
  • Automating Routine Database Maintenance
  • Lab : Performing Ongoing Database Maintenance
  • Managing Database Integrity
  • Managing Index Fragmentation
  • Implementing a Maintenance Plan

  • Module 12:
  • Automating SQL Server 2014 Management
  • Automating SQL Server Management
  • Implementing SQL Server Agent Jobs
  • Managing SQL Server Agent Jobs
  • Managing Job Step Security Contexts
  • Managing Jobs on Multiple Servers
  • Lab : Automating SQL Server Management
  • Creating a Job
  • Scheduling a Job
  • Configuring Job Step Security Contexts

  • Module 13:
  • Monitoring SQL Server 2014 by Using Alerts and Notifications
  • Monitoring SQL Server Errors
  • Configuring Database Mail
  • Configuring Operators, Alerts, and Notifications
  • Lab : Monitoring SQL Server by Using Alerts and Notifications
  • Configuring Database Mail
  • Implementing Operators and Notifications
  • Implementing Alerts

COURSE PREREQUISITES

  • This course requires that you meet the following prerequisites:
  • 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.
  • Students who attend this training can meet the prerequisites by attending the following courses, or obtaining equivalent knowledge and skills:
  • 20461C: Querying Microsoft SQL Server 2014

Schedule for Administering Microsoft SQL Server 2014 Databases Training
CourseExam
Administering Microsoft SQL Server 2014 Databases70-462

2 Hours Daily 3 Times a Week

Total Duration 6 Months

₵2,200.00
Introduction to Microsoft Excel 2013 (Microsoft Excel 2013)
Overview

About this course

In this Introduction to Microsoft Excel 2013 training class, students will create and edit basic worksheets and workbooks. This course is designed for students who want to gain the necessary skills to create, edit, format, and print basic Microsoft Excel 2013 worksheets. This course helps prepare students to take the MOS: Microsoft Office Excel 2013 certification exam 420.

Audience profile

Students who have little or no familiarity with Microsoft Excel 2013 or more experienced Excel users who want to learn the topics covered in this course in the 2013 interface.

At course completion

  • Create basic worksheets using Microsoft Excel 2013.
  • Perform calculations in an Excel worksheet.
  • Modify an Excel worksheet.
  • Modify the appearance of data within a worksheet.
  • Manage Excel workbooks.
  • Print the content of an Excel worksheet.

Course Outline

Module 1: Creating a Microsoft Excel Workbook
This module explains how to get started creating Microsoft Excel workbooks.

Lessons

  • Starting Microsoft Excel
  • Creating a Workbook
  • Saving a Workbook
  • The Status Bar
  • Adding and Deleting Worksheets
  • Copying and Moving Worksheets
  • Changing the Order of Worksheets
  • Splitting the Worksheet Window
  • Closing a Workbook


Lab : Creating a Microsoft Excel Workbook

  • Start Microsoft Excel.
  • Create a Microsoft Excel workbook.
  • Save a Microsoft Excel workbook.
  • Work with the Status Bar.
  • Add and delete Microsoft Excel worksheets.
  • Copy and move worksheets.
  • Split the worksheet window.
  • Close a Microsoft Excel workbook.


Module 2: The Ribbon
The Ribbon is the display you see at the top of the Microsoft Excel window. It is your primary interface with Excel. It allows you to access most of the commands available to you in Excel. The Ribbon is composed of three parts: Tabs, Groups and Commands. In this lesson, you will learn about all three.

Lessons

  • Tabs
  • Groups
  • Commands


Lab : Exploring the Ribbon

  • Work with tabs.
  • Work with groups.
  • Work with commands.
  • Understand which groups and commands are found on which tabs.


Module 3: The Backstage View (The File Menu)
This module explains how to work with the Backstage View (The File Menu).

Lessons

  • Introduction to the Backstage View
  • Opening a Workbook
  • New Workbooks and Excel Templates
  • Printing Worksheets
  • Adding Your Name to Microsoft Excel
  • Managing Workbook Versions


Lab : Exercises in This Lesson

  • Open a Microsoft Excel workbook.
  • Start a new Microsoft Excel workbook.
  • Use Microsoft Excel templates.
  • Print a Microsoft Excel workbook.
  • Personalize your copy of Microsoft Excel.


Module 4: The Quick Access Toolbar
This module explains how to work with the Quick Access Toolbar.

Lessons

  • Adding Common Commands
  • Adding Additional Commands with the Customize Dialog Box
  • Adding Ribbon Commands or Groups
  • Placement


Lab : Customize the Quick Access Toolbar

  • Add common commands to the Quick Access Toolbar.
  • Add additional commands to the Quick Access Toolbar.
  • Move the Quick Access Toolbar.


Module 5: Entering Data in Microsoft Excel Worksheets
This module explains how to enter data.

Lessons

  • Entering Text
  • Expand Data across Columns
  • Adding and Deleting Cells
  • Adding an Outline
  • Adding a Hyperlink
  • Add WordArt to a Worksheet
  • Using AutoComplete
  • Entering Numbers and Dates
  • Using the Fill Handle


Lab : Exercises in This Lesson

  • Enter text in Microsoft Excel worksheets.
  • Add or delete cells in worksheets.
  • Add an outline for your data.
  • Enter a hyperlink in a worksheet.
  • Use AutoComplete.
  • Enter numbers and dates in Microsoft Excel worksheets.
  • Use the Fill Handle to add data to cells.


Module 6: Formatting Microsoft Excel Worksheets
This module explains how to format Microsoft Excel Worksheets.

Lessons

  • Selecting Ranges of Cells
  • Hiding Worksheets
  • Adding Color to Worksheet Tabs
  • Adding Themes to Workbooks
  • Adding a Watermark
  • The Font Group
  • The Alignment Group
  • The Number Group


Lab : Exercises in This Lesson

  • Understand the various ways you can format Microsoft Excel worksheets.
  • Select a range of cells within a worksheet.
  • Hide worksheets.
  • Add color to workbook tabs.
  • Add themes to worksheets.
  • Add bold, italics, and underlining to text.
  • Add borders to cells.
  • Change text and cell colors.
  • Change the font and font size.
  • Align text.
  • Wrap text.
  • Indent text.
  • Merge and center text.
  • Change number formats.
  • Change date formats.
  • Show decimals.


Module 7: Using Formulas in Microsoft Excel
This is the math lesson, and whether you love or hate math, by the end of this lesson you will agree that Excel makes math easy. We will start by explaining some of the basic concepts you need to understand regarding how Excel does math and then will get into entering formulas.

Lessons

  • Math Operators and the Order of Operations
  • Entering Formulas
  • AutoSum (and Other Common Auto-Formulas)
  • Copying Formulas and Functions
  • Relative, Absolute, and Mixed Cell References


Lab : Working with Formulas

  • Use math operators and the order of operations.
  • Enter basic formulas.
  • Use AutoSum to sum data with one click.
  • Use absolute, relative, and mixed cell references.
  • Copy formulas and functions.


Module 8: Working with Rows and Columns
This module explains how to work with rows and columns.

Lessons

  • Inserting Rows and Columns
  • Deleting Rows and Columns
  • Transposing Rows and Columns
  • Setting Row Height and Column Width
  • Hiding and Unhiding Rows and Columns
  • Freezing Panes


Lab : Working with Rows and Columns

  • Insert rows and columns in Microsoft Excel worksheets.
  • Delete rows and columns in Microsoft Excel worksheets.
  • Transpose rows and columns.
  • Change row heights.
  • Change column widths.
  • Hide and unhide rows and columns.
  • Freeze panes.


Module 9: Editing Worksheets
This module explains how to edit worksheets.

Lessons

  • Find
  • Find and Replace
  • Using the Clipboard
  • Managing Comments


Lab : Exercises in This Lesson

  • Locate information in your worksheet using Find.
  • Use Find and Replace to quickly replace data with other data.
  • Use the Cut, Copy, Paste, and Format Painter commands to edit worksheets.


Module 10: Finalizing Microsoft Excel Worksheets
This module explains how to finalize Microsoft Excel Worksheets.

Lessons

  • Setting Margins
  • Setting Page Orientation
  • Setting the Print Area
  • Print Scaling (Fit Sheet on One Page)
  • Printing Headings on Each Page/Repeating Headers and Footers
  • Headers and Footers


Lab : Preparing to Print

  • Set margins in Microsoft Excel worksheets.
  • Set the page orientation to portrait or landscape.
  • Set the print area in a worksheet.
  • Scale a worksheet so that all data prints on one page.
  • Add headers and footers to a worksheet.


Module 11: Microsoft Excel 2013 New Features
Excel 2013 provides some new features to make working with spreadsheets easier and more efficient.

Lessons

  • One Workbook Per Window Feature
  • Using Flash Fill


Lab : Using Flash Fill

  • Learn about the one workbook per window feature.
  • Learn how to use Flash Fill.

Target Audience

 JHS And SHS or Above


Prerequisites

Before attending this course, students must have:

  • Familiarity with using a personal computer, mouse, and keyboard.
  • Comfortable in the Windows environment.
  • Ability to launch and close programs; navigate to information stored on the computer; and manage files and folders.


Price Includes International Curriculum Courseware And Very Active Real-Time Labs.

Introduction to Microsoft Excel 2013: Course Content / Exam(s)

Schedule for Introduction to Microsoft Excel 2013
Course#Course ContentsExam#Exam
Course 55130AIntroduction to Microsoft Excel 2013420Introduction to Microsoft Excel 2013

2 Hours Daily 3 Times a Week

Total Duration 3 Months

 Our Services

₵1,200.00
Networking Fundamentals (MTA Networking)

Overview
Students who are beginning studies in technology need a strong foundation in the basics before moving on to more advanced technology courses and certification programs. The Microsoft Technology Associate (MTA) is a new and innovative certification track designed to provide a pathway for future success in technology courses and careers.

The MTA program curriculum helps teach and validate fundamental technology concepts. This text covers the fundamentals of local area networking, defining networks with the OSI Model and understanding wired and wireless networks. In addition it includes understanding Internet Protocol, implementing TCP/IP and working with networking services. Your students will better understand wide area networks along with defining network infrastructures and network security.

Course Outline

Lesson 1:
Understanding Local Area Networking

Objective Domain Matrix
Key Terms
Examining Local Area Networks, Devices,
and Data Transfer
Defining a LAN
Identifying Types of LANs
Getting to Know Perimeter Networks
Identifying Network Topologies and Standards
Identifying Network Topologies
Defining Ethernet Standards
Identifying the Differences between Client/Server and
Peer-to-Peer Distributed Networks
Skill Summary
Knowledge Assessment
Workplace Ready

Lesson 2:
Defining Networks with the OSI Model

Objective Domain Matrix
Key Terms
Understanding OSI Basics
Defining the Layers in the OSI Model
Defining the Communications Subnetwork
Defining the Upper OSI Layers
Reviewing the OSI Layers
Defining the TCP/IP Model
Skill Summary
Knowledge Assessment
Workplace Ready

Lesson 3:
Understanding Wired and Wireless Networks

Objective Domain Matrix
Key Terms
Recognizing Wired Networks and
Media Types
Identifying and Working with Twisted-Pair Cables
Identifying and Working with Fiber Optic Cable
Comprehending Wireless Networks
Identifying Wireless Devices
Identifying Wireless Networking Standards
Skill Summary
Knowledge Assessment
Workplace Ready

Lesson 4:
Understanding Internet Protocol

Objective Domain Matrix
Key Terms
Working with IPv4
Categorizing IPv4 Addresses
Default Gateways and DNS Servers
Defining Advanced IPv4 Concepts
Defining Classless Inter-Domain Routing (CIDR)
Working with IPv6
Understanding IPv6
Configuring IPv6
Skill Summary
Knowledge Assessment
Workplace Ready

Lesson 5:
Implementing TCP/IP in the Command Line

Objective Domain Matrix
Key Terms
Using Basic TCP/IP Commands
Working with the Command Prompt
Working with Ipconfig and Ping
Working with Advanced TCP/IP Commands
Skill Summary
Knowledge Assessment
Workplace Ready

Lesson 6:
Working with Networking Services

Objective Domain Matrix
Key Terms
Setting Up Common Networking
Services
Working with DHCP
Working with Terminal Services
Defining More Networking Services
Defining RRAS
Defining IPsec
Defining Name Resolution Techniques
Defining DNS
Defining WINS
Skill Summary
Knowledge Assessment
Workplace Ready

Lesson 7:
Understanding Wide Area Networks

Objective Domain Matrix
Key Terms
Understanding Routing
Identifying Static and Dynamic Routing
Defining Common WAN Technologies and
Connections
Defining Packet Switching
Defining T-Carriers
Defining Other WAN Technologies and Internet
Connectivity
Skill Summary
Knowledge Assessment
Workplace Ready

Lesson 8:
Defining Network Infrastructures and Network Security

Objective Domain Matrix
Key Terms
Understanding Networks outside the LAN
Defining the Internet
Defining Intranets and Extranets
Understanding VPNs
Understanding Security Devices and
Zones
Defining Firewalls and Other Perimeter Security
Devices
Redefining the DMZ
Putting It All Together
Skill Summary
Knowledge Assessment
Workplace Ready

Price Includes International Curriculum Courseware And Very Active Real-Time Labs.

Networking Fundamentals MTA Exam(s)

Schedule for MTA Networking Fundamentals
Course#Course ContentsExam#
40366MTA Networking FundamentalsExam 98-366

2 Hours Daily 3 Times a Week

Total Duration 3 Months

Prerequisites
  • Basic Computer Knowledge
Recommended Courses and Certification:
₵800.00
Microsoft Office 2013 (MS Office 2013)

SkyWatch Technology Institute offers a course on Microsoft Office 2013, which is a software package for the Microsoft Windows operating system. The Office 2013 course includes MS Word, MS Excel, MS PowerPoint, MS Outlook and MS Access. With Office 2013, students will be able to share files easily. Students will also get to insert and format Graphics in Word 2013.

Schedule for Microsoft Office 2013 Training Boot Camp
Course ContentsExam
Microsoft Office Word 201377-418
Microsoft Office Excel 201377-420
Microsoft Office PowerPoint 201377-422
Microsoft Office Outlook 201377-423
Microsoft Office Access 201377-424
Total

2 Hours Daily 3 Times a Week

Total Duration 4 Months


Prerequisites

Before attending this course, students need to have:

  • Basic computer skills
  • Hands-on experience in creating and managing documents, spreadsheets, presentations, tables and emails.
Recommended Courses and Certification:
  • Advanced Excel 2013
₵1,400.00
Software Development Fundamentals (MTA Software Dev)

Overview
Students who are beginning studies in technology need a strong foundation in the basics before moving on to more advanced technology courses and certification programs. The Microsoft Technology Associate (MTA) is an innovative certification track designed to provide a pathway for future success in technology courses and careers.

The MTA program curriculum helps teach and validate fundamental technology concepts. This text covers fundamental skills in such areas as Programming and an understanding of general software development, web,desktop, and database applications.

Course Outline

Lesson 1:
Introduction to Programming 1
Objective Domain Matrix 1
Key Terms 1
Understanding Computer Programming 2
Introducing Algorithms 2
Introducing C# 4
Understanding Decision Structures 11
The If Statement 11
The If-Else Statement 13
The Switch Statement 15
Understanding Repetition Structures 17
Understanding the While Loop 17
Understanding the Do-While Loop 19
Understanding the For Loop 20
Understanding the Foreach Loop 21
Understanding Recursion 22
Understanding Exception Handling 23
Handling Exceptions 24
Using Try-Catch-Finally 25
Skill Summary 26
Knowledge Assessment 27
Competency Assessment 30
Proficiency Assessment 31

Lesson 2: Introduction to Object-Oriented Programming 32
Objective Domain Matrix 32
Key Terms 32
Understanding Objects 33
Thinking in an Object-Oriented Way 33
Understanding Classes 33
Understanding Values and References 44
Understanding Structs 44
Understanding Memory Allocation 45
Understanding Encapsulation 47
Understanding Access Modifiers 48
Understanding Inheritance 48
Understanding Abstract and Sealed Classes 50
Inheriting from the Object Class 51
Casting between Types 52
Understanding Polymorphism 53
Understanding the Override and New Keywords 55
Understanding Interfaces 56
Skill Summary 58
Knowledge Assessment 59
Competency Assessment 64
Proficiency Assessment 64

Lesson 3: Understanding General Software Development 65
Objective Domain Matrix 65
Key Terms 65
Understanding Application Lifecycle Management 66
Understanding Requirements Analysis 66
Understanding the Design Process 67
Understanding Software Development 67
Understanding Software Testing 68
Understanding Release Management 68
Understanding Testing 68
Understanding Testing Methods 69
Understanding Testing Levels 69
Understanding Data Structures 70
Understanding Arrays 70
Understanding Queues 72
Understanding Stacks 73
Linked Lists 74
Understanding Sorting Algorithms 76
Understanding BubbleSort 76
Understanding QuickSort 79
Skill Summary 81
Knowledge Assessment 81
Competency Assessment 83
Proficiency Assessment 84

Lesson 4: Understanding Web Applications 85
Objective Domain Matrix 85
Key Terms 85
Understanding Web Page Development 85
Understanding HTML 86
Understanding Cascading Style Sheets 88
Understanding JavaScript 92
Understanding Client-Side vs. Server-Side Programming 94
Understanding ASP.NET Application
Development 95
Understanding ASP.NET Page Life Cycle and Event
Model 96
Understanding State Management 99
Understanding IIS Web Hosting 104
Understanding Internet Information Services 105
Creating Virtual Directories and Web Sites 105
Deploying Web Applications 106
Understanding Web Services Development 107
Introducing SOAP 107
Introducing WSDL 108
Creating Web Services 108
Consuming Web Services 112
Skill Summary 115
Knowledge Assessment 115
Competency Assessment 118
Proficiency Assessment 119

Lesson 5: Understanding Desktop Applications 120
Objective Domain Matrix 120
Key Terms 120
Understanding Windows Forms Applications 120
Designing a Windows Form 121
Understanding the Windows Form Event Model 123
Using Visual Inheritance 123
Understanding Multiple Document Interface (MDI) Applications 126
Understanding Console-Based Applications 129
Working with Command-Line Parameters 130
Understanding Windows Services 131
Creating a Windows Service 132
Skill Summary 137
Knowledge Assessment 138
Competency Assessment 140
Proficiency Assessment 141

Lesson 6: Understanding Databases 142
Objective Domain Matrix 142
Key Terms 142
Understanding Relational Database Concepts 142
Understanding Databases 143
Understanding Relational Database Concepts 143
Understanding Relational Database Design 144
Understanding Entity-Relationship Diagrams 144
Understanding Data Normalization 146
Understanding Database Query Methods 149
Working with SQL Queries 150
Working with Stored Procedures 159
Understanding Database Connection
Methods 164
Working with Flat Files 164
Working with XML 167
Working with DataSet 170
Skill Summary 173
Knowledge Assessment 173
Competency Assessment 176
Proficiency Assessment 176


Price Includes International Curriculum Courseware And Very Active Real-Time Labs.

Software Development Fundamentals MTA Exam(s)

Schedule for MTA Software Development Fundamentals Fundamentals
Course#Course ContentsExam#
MTA Software Development FundamentalsExam 98-361

2 Hours Daily 3 Times a Week

Total Duration 2 Months

Prerequisites
  • Basic Computer Knowledge
Recommended Courses and Certification:
₵800.00
Introduction to Programming Using Python (MTA Programming Using Python)

Overview
In this Python training course, students learn to program in Python. The course is aimed at students new to the language and who may, or may not, have experience with other programming languages. Students will learn: how Python works and its place in the world of programming languages; to work with and manipulate strings; to perform math operations; to work with Python sequences; to collect user input and output results; flow control processing; to write to, and read from, files; to write functions; to handle exception; and work with dates and times. This Python course is taught using Python 3; however, differences between Python 2 and Python 3 are noted.

Audience
Students new to the language who have experience with other programming languages.

Prerequisites
This course is specially designed for individuals with prior programming background. Also it assumes a working knowledge of Object Oriented Programming concepts. If you have no prior programming experience or or not familiar with Object Oriented Programming, you should consider our "Python Programming - Basics for Non-Programmers" course. For details on this alternative slower paced course for non-programmers, go to
Python Programming - Basics for Non-Programmers 

Course Outline

1. Python Basics
Running Python
Hello, World!
Literals
Python Comments
Data Types
Variables
Writing a Python Module
print() Function
Named Arguments
Collecting User Input
Getting Help

2. Functions and Modules
Defining Functions
Variable Scope
Global Variables
Function Parameters
Returning Values
Importing Modules

3. Math
Arithmetic Operators
Modulus and Floor Division
Assignment Operators
Built-in Math Functions
The math Module
The random Module
Seeding

4. Python Strings
Quotation Marks and Special Characters
String Indexing
Slicing Strings
Concatenation and Repetition
Common String Methods
String Formatting
Built-in String Functions

5. Iterables: Sequences, Dictionaries, and Sets
Definitions
Sequences
Unpacking Sequences
Dictionaries
The len() Function
Sets
*args and **kwargs

6. Flow Control
Conditional Statements
The is and is not Operators
Python's Ternary Operator
Loops in Python
The enumerate() Function
Generators
List Comprehensions

7. File Processing
Opening Files
The os and os.path Modules

8. Exception Handling
Wildcard except Clauses
Getting Information on Exceptions
The else Clause
The finally Clause
Using Exceptions for Flow Control
Exception Hierarchy

9. Dates and Times
Understanding Time
The time Module
The datetime Module

10. Running Python Scripts from the Comand Line
The sys Module
sys.argv

Price Includes International Curriculum Courseware And Very Active Real-Time Labs.

Introduction to Programming Using Python / Exam(s)

Schedule for Introduction to Programming Using Python
Course#Course ContentsExam#
MTA Introduction to Programming Using PythonExam 98-381

2 Hours Daily 3 Times a Week
Total Duration 3 Months

Recommended Courses and Certification:
  • MCSA: SQL Server 2012
₵800.00
SECURITY FUNDAMENTALS (MTA Security Fundamentals)

Overview
This MTA Training course helps you prepare for Microsoft Technology Associate Exam 98-367, and build an understanding of these topics: Security Layers, Operating System Security, Network Security, and Security Software. This course leverages the same content as found in the Microsoft Official Academic Course (MOAC) for this exam.

TARGET AUDIENCE

The Microsoft Technology Associate (MTA) is Microsoft’s newest suite of technology certification exams that validate fundamental knowledge needed to begin building a career using Microsoft technologies. This program provides an appropriate entry point to a future career in technology and assumes some hands-on experience or training but does not assume on-the-job experience.

COURSE OBJECTIVES

After completing this course, students will be able to:

  • Understand Security Layers
  • Understand Operating System Security
  • Understand Network Security
  • Understand Security Software

COURSE CONTENT

Understanding Security Layers

  • Introducing Security
  • Understanding Confidentiality
  • Understanding Integrity
  • Understanding Availability
  • Defining Threats and Risk Management
  • Understanding the Principle of Least Privilege
  • Understanding Attack Surface
  • Understanding Social Engineering
  • Linking Cost with Security
  • Looking at Physical Security as the First Line of Defense
  • Understanding Site Security
  • Understanding Computer Security

Authentication, Authorization, and Accounting

  • Starting Security with Authentication
  • Authenticating with What You Know
  • Authenticating with What You Own or Possess
  • Authenticating with What You Are
  • Introducing RADIUS and TACACS1
  • Using Run As
  • Introducing Directory Services with Active Directory
  • Looking at Domain Controllers
  • Introducing NTLM
  • Introducing Kerberos
  • Using Organizational Units
  • Looking at Objects
  • Using Groups
  • Looking at Web Server Authentication
  • Comparing Rights and Permissions
  • Looking at NTFS
  • Using NTFS Permissions
  • Looking at Effective NTFS Permissions
  • Copying and Moving Files
  • Using Folder and File Owners
  • Sharing Drives and Folders
  • Looking at Special and Administrative Shares
  • Introducing the Registry
  • Using Encryption to Protect Data
  • Examining Types of Encryption
  • Introducing Public Key Infrastructure
  • Encrypting Email
  • Encrypting Files with EFS
  • Encrypting Disks in Windows
  • Introducing IPSec
  • Encrypting with VPN Technology
  • Using Auditing to Complete the Security Picture

Understanding Security Policies

  • Using Password Policies to Enhance Security
  • Using Password Complexity to Make a Stronger Password
  • Using Account Lockout to Prevent Hacking
  • Looking at Password Length
  • Using Password History to Enforce Security
  • Setting the Time between Password Changes
  • Using Password Group Policies to Enforce Security
  • Understanding Common Attack Methods

Understanding Network Security

  • Using Dedicated Firewalls to Protect a Network
  • Examining Hardware Firewalls and Their Characteristics
  • Using Hardware Firewalls versus Software Firewalls
  • Using Stateful versus Stateless Inspection
  • Controlling Access with Network Access Protection (NAP)
  • Understanding the Purpose of NAP
  • Looking at How NAP Works
  • Examining the Requirements for NAP
  • Using Isolation to Protect the Network
  • Understanding Virtual LANs
  • Understanding Routing
  • Looking at Intrusion Detection and Intrusion Prevention Systems
  • Looking at Honeypots
  • Looking at DMZs
  • Understanding Network Address Translation (NAT)
  • Understanding Virtual Private Networks (VPNs)
  • Understanding Internet Protocol Security (IPsec)
  • Using Other VPN Protocols
  • Looking at Server and Domain Isolation
  • Protecting Data with Protocol Security
  • Understanding Tunneling
  • Using DNS Security Extensions (DNSSEC)
  • Looking at Protocol Spoofing
  • Utilizing Network Sniffing
  • Understanding Common NETWORK Attack Methods
  • Securing Wireless Network
  • Using Service Set Identifier (SSID)
  • Understanding Keys
  • Utilizing MAC Filters
  • Considering Pros and Cons of Specific Security Types

Protecting the Server and Client

  • Protecting the Client Computer
  • Protecting Your Computer from Malware
  • Utilizing Windows Updates
  • Utilizing User Account Control
  • Using Windows Firewall
  • Using Offline Files
  • Locking Down a Client Computer
  • Protecting Your Email
  • Dealing with Spam
  • Relaying Email
  • Securing Internet Explorer
  • Looking at Cookies and Privacy Settings
  • Examining Content Zones
  • Phishing and Pharming
  • Protecting Your Server
  • Placing the Server
  • Hardening the Server
  • Using Secure Dynamic DNS

Price Includes International Curriculum Course ware And Very Active Real-Time Labs.

Security Fundamentals / Exam(s)

Schedule for Security Fundamentals
Course#Course ContentsExam#
MTA Security FundamentalsExam 98-367

2 Hours Daily 3 Times a Week
Total Duration 3 Months

Recommended Courses and Certification:
  • CompTIA Security +
  • CEH /CHFI
  • ENSA
₵800.00
Introduction to Microsoft Excel 2016 (Microsoft Excel 2016)
Overview

About this course

In this Introduction to Microsoft Excel 2016 training course, students will create and edit basic worksheets and workbooks. This course is designed for students who want to gain the necessary skills to create, edit, format, and print basic Microsoft Excel 2016 worksheets.

Audience profile

This course is intended for students who have little or no familiarity with Microsoft Excel 2016 or more experienced Excel users who want to learn the topics covered in this course in the 2016 interface.

After course completion

After completing this course, students will be able to:

  • Create basic worksheets using Microsoft Excel 2016.
  • Perform calculations in an Excel worksheet.
  • Modify an Excel worksheet.
  • Modify the appearance of data within a worksheet.
  • Manage Excel workbooks.
  • Print the content of an Excel worksheet.
  • Learn how to use handy features new in 2016.

Course Outline
Module 1: Creating a Microsoft Excel Workbook
This module explains how to create workbooks in Microsoft Excel.

Lessons

  • Starting Microsoft Excel
  • Creating a Workbook
  • Saving a Workbook
  • The Status Bar
  • Adding and Deleting Worksheets
  • Copying and Moving Worksheets
  • Changing the Order of Worksheets
  • Splitting the Worksheet Window
  • Closing a Workbook

Lab : Creating a Microsoft Excel Workbook

  • Creating a Microsoft Excel Workbook

After completing this module, students will be able to:

  • Start Microsoft Excel.
  • Create a Microsoft Excel workbook.
  • Save a Microsoft Excel workbook.
  • Add and delete Microsoft Excel worksheets.
  • Copy and move worksheets.
  • Split the worksheet window.
  • Close a Microsoft Excel workbook.

Module 2: The Ribbon
This module explains how to work with the Ribbon.

Lessons

  • Tabs
  • Groups
  • Commands

Lab : Exploring the Ribbon

  • Exploring the Ribbon

After completing this module, students will be able to:

  • Work with tabs.
  • Work with groups.
  • Work with commands.
  • Understand which groups and commands are found on which tabs.

Module 3: The Backstage View (The File Menu)
This module explains how to work with the Backstage View aka the File menu.

Lessons

  • Introduction to the Backstage View
  • Opening a Workbook
  • New Workbooks and Excel Templates
  • Printing Worksheets
  • Adding Your Name to Microsoft Excel
  • Managing Workbook Versions

Lab : The Backstage View (The File Menu)

  • Open a Workbook
  • Select, Open and Save a Template Agenda
  • Print a Worksheet

After completing this module, students will be able to:

  • Open a Microsoft Excel workbook.
  • Start a new Microsoft Excel workbook.
  • Use Microsoft Excel templates.
  • Print a Microsoft Excel workbook.
  • Personalize your copy of Microsoft Excel.

Module 4: The Quick Access Toolbar
This module explains how to work with the Quick Access Toolbar.

Lessons

  • Adding Common Commands
  • Adding Additional Commands with the Customize Dialog Box
  • Adding Ribbon Commands or Groups
  • Placement

Lab : The Quick Access Toolbar

  • Customize the Quick Access Toolbar

After completing this module, students will be able to:

  • Add common commands to the Quick Access Toolbar.
  • Add additional commands to the Quick Access Toolbar.
  • Move the Quick Access Toolbar.

Module 5: Entering Data in Microsoft Excel Worksheets
This module explains how to how to enter data in Excel worksheets.

Lessons

  • Entering Text
  • Expand Data across Columns
  • Adding and Deleting Cells
  • Adding an Outline
  • Adding a Hyperlink
  • Add WordArt to a Worksheet
  • Using AutoComplete
  • Entering Numbers and Dates
  • Using the Fill Handle

Lab : Entering Data in Microsoft Excel Worksheets

  • Entering Text and Using AutoComplete
  • Entering Numbers and Dates

After completing this module, students will be able to:

  • Enter text in Microsoft Excel worksheets.
  • Add or delete cells in worksheets.
  • Add an outline for your data.
  • Enter a hyperlink in a worksheet.
  • Use AutoComplete.
  • Enter numbers and dates in Microsoft Excel worksheets.
  • Use the Fill Handle to add data to cells.

Module 6: Formatting Microsoft Excel Worksheets
This module explains how to format Excel worksheets.

Lessons

  • Hiding Worksheets
  • Adding Color to Worksheet Tabs
  • Adding Themes to Workbooks
  • Adding a Watermark
  • The Font Group
  • The Alignment Group
  • The Number Group

Lab : Formatting Microsoft Excel Worksheets

  • Customize a Workbook Using Tab Colors and Themes
  • Working with Font Group Commands
  • Working with Alignment Group Commands
  • Working with Number Group Commands

After completing this module, students will be able to:

  • Select a range of cells within a worksheet.
  • Hide worksheets.
  • Add color to workbook tabs.
  • Add themes to worksheets.
  • Apply bold, italics, and underlining to text.
  • Add borders to cells.
  • Change text and cell colors.
  • Change the font and font size.
  • Align text.
  • Wrap text.
  • Indent text.
  • Merge and center text.
  • Change number formats.
  • Change date formats.

Module 7: Using Formulas in Microsoft Excel
This module explains how to use formulas in Excel.

Lessons

  • Math Operators and the Order of Operations
  • Entering Formulas
  • AutoSum (and Other Common Auto-Formulas)
  • Copying Formulas and Functions
  • Relative, Absolute, and Mixed Cell References

Lab : Using Formulas in Microsoft Excel

  • Working with Formulas

After completing this module, students will be able to:

  • Enter basic formulas.
  • Use AutoSum to sum data with one click.
  • Understand absolute, relative, and mixed cell references.
  • Copy formulas and functions.

Module 8: Working with Rows and Columns
This module explains how to work with rows and columns.

Lessons

  • Insert lesson titles in a bulleted list.
  • Inserting Rows and Columns
  • Deleting Rows and Columns
  • Transposing Rows and Columns
  • Setting Row Height and Column Width
  • Hiding and Unhiding Rows and Columns
  • Freezing Panes

Lab : Working with Rows and Columns

  • Working with Rows and Columns
  • After completing this module, students will be able to:
  • Insert rows and columns in Microsoft Excel worksheets.
  • Delete rows and columns in Microsoft Excel worksheets.
  • Transpose rows and columns.
  • Change row heights.
  • Change column widths.
  • Hide and unhide rows and columns.
  • Freeze panes

Module 9: Editing Worksheets
This module explains how to edit worksheets.

Lessons

  • Find
  • Find and Replace
  • Using the Clipboard
  • Managing Comments

Lab : Editing Worksheets

  • Using Find and Replace
  • Using the Clipboard

After completing this module, students will be able to:

  • Locate information in your worksheet using Find.
  • Use Find and Replace to quickly replace data with other data.
  • Use the Cut, Copy, Paste and Format Painter commands to edit worksheets.
  • Manage comments.

Module 10: Finalizing Microsoft Excel Worksheets
This module explains how to finalize worksheets.

Lessons

  • Setting Margins
  • Setting Page Orientation
  • Setting the Print Area
  • Print Scaling (Fit Sheet on One Page)
  • Printing Headings on Each Page/Repeating Headers and Footers
  • Headers and Footers

Lab : Finalizing Microsoft Excel Worksheets

  • Preparing to Print

After completing this module, students will be able to:

  • Set margins in Microsoft Excel worksheets.
  • Set the page orientation to portrait or landscape.
  • Set the print area in a worksheet.
  • Scale a worksheet so that all data prints on one page.
  • Add headers and footers to a worksheet.

Module 11: Microsoft Excel Features that Were New in 2013
This module explains how to use some of the features that were new in the 2013 version of Excel.

Lessons

  • One Workbook Per Window Feature
  • Using Flash Fill

Lab : Microsoft Excel Features that Were New in 2013

  • Using Flash Fill

After completing this module, students will be able to:

  • Use the one workbook per window feature.
  • Use Flash Fill.

Module 12: Features New in 2016
This module explains how to use two new features in 2016.

Lessons

  • Tell Me
  • Smart Lookup

Lab : None

  • None

After completing this module, students will be able to:

  • Use the Tell Me feature.

Use the Smart Lookup feature.


Target Audience

 JHS And SHS or Above


Prerequisites

Before attending this course, students must have:

  • Experience installing PC hardware and devices.
  • Basic understanding of TCP/IP and networking concepts.
  • Basic Windows and Active Directory knowledge.
  • The skills to map network file shares.
  • Experience working from a command prompt.
  • Basic knowledge of the fundamentals of applications. For example, how client computer applications communicate with the server.
  • Basic understanding of security concepts such as authentication and authorization.
  • An understanding of the fundamental principles of using printers.



Price Includes International Curriculum Courseware And Very Active Real-Time Labs.

Introduction to Microsoft Excel 2016: Course Content / Exam(s)

Schedule for Introduction to Microsoft Excel 2016
Course#Course ContentsExam#Exam
Course 55165AIntroduction to Microsoft Excel 2016Introduction to Microsoft Excel 2016

2 Hours Daily 3 Times a Week

Total Duration 3 Months

 Our Services

₵1,200.00
Implementing a Data Warehouse with Microsoft SQL Server® (MCSA)

This course 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® 2014, implement ETL with SQL Server Integration Services, and validate and cleanse data with SQL Server Data Quality Services and SQL Server Master Data Services. Note: This course is designed for customers who are interested in learning SQL Server 2012 or SQL Server 2014. It covers the new features in SQL Server 2014, but also the important capabilities across the SQL Server data platform.

 

TARGET AUDIENCE

This course is intended for database professionals who need to fulfil 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.

COURSE OBJECTIVES

  • 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 ETL solution that supports incremental data extraction.
  • Implement an ETL solution that supports incremental data loading.
  • 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 BI solutions can consume data from the data warehouse.

COURSE CONTENT

  • Module 1: Introduction to Data Warehousing
  • Overview of Data Warehousing
  • Considerations for a Data Warehouse Solution
  • Lab : Exploring a Data Warehousing Solution
  • Module 2: Data Warehouse Hardware Considerations
  • Considerations for building a Data Warehouse
  • Data Warehouse Reference Architectures and Appliances
  • Lab : Planning Data Warehouse Infrastructure
  • Module 3: Designing and Implementing a Data Warehouse
  • Logical Design for a Data Warehouse
  • Physical design for a data warehouse
  • Lab : Implementing a Data Warehouse Schema
  • Module 4: Creating an ETL Solution with SSIS
  • Introduction to ETL with SSIS
  • Exploring Data Sources
  • Implementing Data Flow
  • Lab : Implementing Data Flow in an SSIS Package
  • Module 5: Implementing Control Flow in an SSIS Package
  • Introduction to Control Flow
  • Creating Dynamic Packages
  • Using Containers
  • Managing Consistency
  • Lab : Implementing Control Flow in an SSIS Package
  • Lab : Using Transactions and Checkpoints
  • Module 6: Debugging and Troubleshooting SSIS Packages
  • Debugging an SSIS Package
  • Logging SSIS Package Events
  • Handling Errors in an SSIS Package
  • Lab : Debugging and Troubleshooting an SSIS Package
  • Module 7: Implementing an Incremental ETL Process
  • Introduction to Incremental ETL
  • Extracting Modified Data
  • Loading Modified data
  • Lab : Extracting Modified DataLab : Loading Incremental Changes
  • Module 8: Enforcing Data Quality
  • Introduction to Data Quality
  • Using Data Quality Services to Cleanse Data
  • Using Data Quality Services to Match data
  • Lab : Cleansing DataLab : De-duplicating data
  • Module 9: Using Master Data Services
  • Master Data Services Concepts
  • Implementing a Master Data Services Model
  • Managing Master Data
  • Creating a Master Data Hub
  • Lab : Implementing Master Data Services
  • Module 10: Extending SQL Server Integration Services
  • Using Scripts in SSIS
  • Using Custom Components in SSIS
  • Lab : Using Custom Components and Scripts
  • Module 11: Deploying and Configuring SSIS Packages
  • Overview of SSIS Deployment
  • Deploying SSIS Projects
  • Planning SSIS Package Execution
  • Lab : Deploying and Configuring SSIS Packages
  • Module 12: Consuming Data in a Data Warehouse
  • Introduction to Business Intelligence
  • Introduction to Reporting
  • An Introduction to Data Analysis
  • Lab : Using Business Intelligence Tools

COURSE PREREQUISITES

This course requires that you meet the following prerequisites:

  • At least 2 years’ experience of working with relational databases, including:
  • Designing a normalized database.
  • Creating tables and relationships.
  • Querying with Transact-SQL.
  • 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.

Price Includes International Curriculum Courseware And Very Active Real-Time Labs.

Implementing a Data Warehouse with Microsoft SQL Server Content / Exam(s)

Schedule for Implementing a Data Warehouse with Microsoft SQL Server
Course#Course ContentsExam#
20463DImplementing a Data Warehouse with Microsoft SQL Server70-463

2 Hours Daily 3 Times a Week

Total Duration 3 Months

₵1,500.00
MCSA: Windows Server 2016 Training & Certification Courses (MCSA 2016)

Overview

The MCSA: Windows Server 2016 Training and Certification Course is an intermediate level certification that enables candidates to monitor and manage Windows Server 2016 operating system, client-server structure, network infrastructure, virtualization, domain management and security implementation, among others. The course provides a variety of hands-on lab training and allows candidates to control and manage multiple servers and clients simultaneously. This course is the first step towards your path to becoming a Microsoft Certified Solutions Expert (MCSE).

Audience:  Earning this MCSA certification will help entry-level IT personnel to make a mark in the industry as a network or computer systems administrator or as a computer network specialist. The MCSA windows server 2016 certification course is recommended for the following professionals:-

  • Network Administrators
  • Computer Network Specialist
  • Computer Support Specialist
  • Windows Server Administrators

Windows Server 2016: MCSA Course Objectives

Upon completion of the course, you will be able to:

  • Installation, Storage, and Compute with Windows Server 2016
  • Networking with Windows Server 2016
  • Identity with Windows Server 2016
  • Install and configure Windows Server 2016
  • Install Nano Server and be able to update and implement the migration strategy
  • Implement data deduplication
  • Implement Active Directory Federation Services (AD FS)
  • Explain various stage options
  • Understand how to manage disks and volumes
  • Explain enterprise storage solutions and implement the appropriate solution to given situations
  • Execute remote access
  • Install and configure Microsoft Hyper-V
  • Manage Windows and Hyper-V containers
  • Understand disaster recovery technologies in Windows Server 2016
  • Plan, create and execute a failover cluster
  • Configure and implement Network Load Balancing (NLB)
  • Manage virtual machine installations

Price Includes International Curriculum Courseware And Very Active Real-Time Labs.

Windows Server 2016: MCSA Course Content / Exam(s)

Schedule for MCSA: Windows Server 2016
Course#Course ContentsExam#
20740CInstallation, Storage, and Compute with Windows Server 201670-740
20741BNetworking with Windows Server 201670-741
20742BIdentity with Windows Server 201670-742

2 Hours Daily 3 Times a Week

Total Duration 4 Months

Prerequisites

A strong working knowledge of:
  • CompTIA N+ certification knowledge
  • CompTIA A+ certification knowledge
  • Have two years’ IT work experience and a possess a basic familiarity of Linux and/or Unix.
Recommended Courses and Certification:
₵2,000.00
Querying Microsoft SQL Server® (Querying SQL Server)

This 3 Months instructor led course provides students with the technical skills required to write basic Transact-SQL queries for Microsoft SQL Server 2014. 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 people for the exam "70-461: Writing Queries Using Microsoft® SQL Server® 2014 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. Note: This course is designed for customers who are interested in learning SQL Server 2012 or SQL Server 2014. It covers the new features in SQL Server 2014, but also the important capabilities across the SQL Server data platform.


TARGET AUDIENCE

This course is intended for Database Administrators, Database Developers, and Business Intelligence professionals. The course will very likely be well attended by SQL power users who aren’t necessarily database-focused or plan on taking the exam; namely, report writers, business analysts and client application developers.

COURSE OBJECTIVES

  • Describe the basic architecture and concepts of Microsoft SQL Server 2014.
  • Understand the similarities and differences between Transact-SQL and other computer languages.
  • Write SELECT queries
  • Query multiple tables
  • Sort and filter data
  • Describe the use of data types in SQL Server
  • Modify data using Transact-SQL
  • Use built-in functions
  • Group and aggregate data
  • Use subqueries
  • Use table expressions
  • Use set operators
  • Use window ranking, offset and aggregate functions
  • Implement pivoting and grouping sets
  • Execute stored procedures
  • Program with T-SQL
  • Implement error handling
  • Implement transactions

COURSE CONTENT

  • Module 1: Introduction to Microsoft SQL Server 2014
  • The Basic Architecture of SQL Server
  • SQL Server Editions and Versions
  • Getting Started with SQL Server Management Studio
  • Lab : Working with SQL Server 2014 Tools

  • Module 2: Introduction to T-SQL Querying
  • Introducing T-SQL
  • Understanding Sets
  • Understanding Predicate Logic
  • Understanding the Logical Order of Operations in SELECT statements
  • Lab : Introduction to Transact-SQL Querying

  • Module 3: Writing SELECT Queries
  • Writing Simple SELECT Statements
  • Eliminate Duplicates with DISTINCT
  • Using Column and Table Aliases
  • Write Simple CASE Expressions
  • Lab : Writing Basic SELECT Statements

  • Module 4: Querying Multiple Tables
  • Understanding Joins
  • Querying with Inner Joins
  • Querying with Outer Joins
  • Querying with Cross Joins and Self Joins
  • Lab : Querying Multiple Tables

  • Module 5: Sorting and Filtering Data
  • Sorting Data
  • Filtering Data with Predicates
  • Filtering with the TOP and OFFSET-FETCH
  • Working with Unknown Values
  • Lab : Sorting and Filtering Data

  • Module 6: Working with SQL Server 2014 Data Types
  • Introducing SQL Server 2014 Data Types
  • Working with Character Data
  • Working with Date and Time Data
  • Lab : Working with SQL Server 2014 Data Types

  • Module 7: Using DML to Modify Data
  • Inserting Data
  • Modifying and Deleting Data
  • Lab : Using DML to Modify Data

  • Module 8: Using Built-In Functions
  • Writing Queries with Built-In Functions
  • Using Conversion Functions
  • Using Logical Functions
  • Using Functions to Work with NULL
  • Lab : Using Built-In Functions

  • Module 9: Grouping and Aggregating Data
  • Using Aggregate Functions
  • Using the GROUP BY Clause
  • Filtering Groups with HAVING
  • Lab : Grouping and Aggregating Data

  • Module 10: Using Subqueries
  • Writing Self-Contained Subqueries
  • Writing Correlated Subqueries
  • Using the EXISTS Predicate with Subqueries
  • Lab : Using Subqueries

  • Module 11: Using Table Expressions
  • Using Views
  • Using Inline Table-Valued Functions
  • Using Derived Tables
  • Using Common Table Expressions
  • Lab : Using Table Expressions

  • Module 12: Using Set Operators
  • Writing Queries with the UNION Operator
  • Using EXCEPT and INTERSECT
  • Using APPLY
  • Lab : Using Set Operators

  • Module 13: Using Window Ranking, Offset, and Aggregate Functions
  • Creating Windows with OVER
  • Exploring Window Functions
  • Lab : Using Window Ranking, Offset and Aggregate Functions

  • Module 14: Pivoting and Grouping Sets
  • Writing Queries with PIVOT and UNPIVOT
  • Working with Grouping Sets
  • Lab : Pivoting and Grouping Sets

  • Module 15: Querying data with Stored Procedures
  • Writing Queries with PIVOT and UNPIVOT
  • Passing Parameters to Stored Procedures
  • Creating Simple Stored Procedures
  • Working with Dynamic SQL
  • Lab : Executing Stored Procedures

  • Module 16: Programming with T-SQL
  • T-SQL Programming Elements
  • Controlling Program Flow
  • Lab : Programming with T-SQL

  • Module 17: Implementing Error Handling
  • Using TRY / CATCH Blocks
  • Working with Error Information
  • Lab : Implementing Error Handling

  • Module 18: Implementing Transactions
  • Transactions and the Database Engine
  • Controlling Transactions
  • Lab : Implementing Transactions

  • Module 19: Appendix 1: Improving Query Performance
  • Factors in Query Performance
  • Displaying Query Performance Data
  • Lab : Improving Query Performance

  • Module 20: Appendix 2: Querying SQL Server Metadata
  • Querying System Catalog Views and Functions
  • Executing System Stored Procedures
  • Querying Dynamic Management Objects
  • Lab : Querying SQL Server Metadata

COURSE PREREQUISITES

  • Working knowledge of relational databases.
  • Basic knowledge of the Microsoft Windows operating system and its core functionality

Price Includes International Curriculum Courseware And Very Active Real-Time Labs.

2 Hours Daily 3 Times a Week

Total Duration 4 Months


₵1,800.00
Microsoft Certified: Data Analyst Associate (Microsoft Certified: Data Analyst Associate)

Microsoft Certified: Data Analyst Associate

Data Analysts enable businesses to maximize the value of their data assets by using Microsoft Power BI.
As a subject matter expert, Data Analysts are responsible for designing and building scalable data models, cleaning and transforming data, and enabling advanced analytic capabilities that provide meaningful business value through easy-to-comprehend data visualizations.


Note: This certification will not be available until April 2, 2020. This information is not final and there may be minor changes once the certification is released.

Job role: Data Analyst

Required exams: DA-100

 

Skills measured

  • Prepare the data
  • Model the data
  • Visualize the data
  • Analyze the data
  • Deploy and maintain deliverables


NOTE: The bullets that appear below each of the skills measured are intended to illustrate how
we are assessing that skill. This list is not definitive or exhaustive.

NOTE: In most cases, exams do NOT cover preview features, and some features will only be
added to an exam when they are GA (General Availability).

Prepare the Data

Get data from different data sources

  • identify and connect to a data source
  • change data source settings
  • select a shared dataset or create a local dataset
  • select a storage mode
  • choose an appropriate query type
  • identify query performance issues
  • use the Common Data Service (CDS)
  • use parameters

Profile the data

  • identify data anomalies
  • examine data structures
  • interrogate column properties
  • interrogate data statistics

Clean, transform, and load the data

  • resolve inconsistencies, unexpected or null values, and data quality issues
  • apply user-friendly value replacements
  • identify and create appropriate keys for joins
  • evaluate and transform column data types
  • apply data shape transformations to table structures
  • combine queries
  • apply user-friendly naming conventions to columns and queries
  • leverage Advanced Editor to modify Power Query M code
  • configure data loading
  • resolve data import errors

Microsoft Certified: Data Analyst Associate – Skills

Measured

 

NOTE: The bullets that appear below each of the skills measured are intended to illustrate how

we are assessing that skill. This list is not definitive or exhaustive.

NOTE: In most cases, exams do NOT cover preview features, and some features will only be

 

Model the Data

Design a data model

  • define the tables
  • configure table and column properties
  • define quick measures
  • flatten out a parent-child hierarchy
  • define role-playing dimensions
  • define a relationship's cardinality and cross-filter direction
  • design the data model to meet performance requirements
  • resolve many-to-many relationships
  • create a common date table
  • define the appropriate level of data granularity

Develop a data model

  • apply cross-filter direction and security filtering
  • create calculated tables
  • create hierarchies
  • create calculated columns
  • implement row-level security roles
  • set up the Q&A feature

Create measures by using DAX

  • use DAX to build complex measures
  • use CALCULATE to manipulate filters
  • implement Time Intelligence using DAX
  • replace numeric columns with measures
  • use basic statistical functions to enhance data
  • create semi-additive measures

Optimize model performance

  • remove unnecessary rows and columns
  • identify poorly performing measures, relationships, and visuals
  • improve cardinality levels by changing data types
  • improve cardinality levels through summarization
  • create and manage aggregations

Visualize the Data

Create reports

  • add visualization items to reports
  • choose an appropriate visualization type
  • format and configure visualizations
  • import a custom visual
  • configure conditional formatting
  • apply slicing and filtering
  • add an R or Python visual
  • configure the report page
  • design and configure for accessibility

Create dashboards

  • set mobile view
  • manage tiles on a dashboard
  • configure data alerts
  • use the Q&A feature
  • add a dashboard theme
  • pin a live report page to a dashboard
  • configure data classification

Enrich reports for usability

  • configure bookmarks
  • create custom tooltips
  • edit and configure interactions between visuals
  • configure navigation for a report
  • apply sorting
  • configure Sync Slicers
  • use the selection pane
  • use drillthrough and cross filter
  • drilldown into data using interactive visuals
  • export report data

Analyze the Data

Enhance reports to expose insights

  • apply conditional formatting
  • apply slicers and filters
  • perform top N analysis
  • explore statistical summary
  • use the Q&A visual
  • add a Quick Insights result to a report
  • create reference lines by using Analytics pane

  • use the Play Axis feature of a visualization

Perform advanced analysis

  • identify outliers
  • conduct Time Series analysis
  • use groupings and binnings
  • use the Key Influencers to explore dimensional variances
  • use the decomposition tree visual to break down a measure
  • apply AI Insights

Deploy and Maintain Deliverables

Manage datasets

  • configure a dataset scheduled refresh
  • configure row-level security group membership
  • providing access to datasets
  • configure incremental refresh settings
  • endorse a dataset

Create and manage workspaces

  • create and configure a workspace
  • recommend a development lifecycle strategy
  • assign workspace roles
  • configure and update a workspace app
  • publish, import, or update assets in a workspace

Certification exams

  • Exam DA-100: Analyzing Data with Microsoft Power BI (beta)

    Languages: English

    Retirement date: none

    This exam measures your ability to accomplish the following technical tasks: prepare the data; model the data; visualize the data; analyze the data; and deploy and maintain deliverables.


Price Includes International Curriculum Courseware And Very Active Real-Time Labs.

Recommended Courses and Certification:
₵1,700.00
Cloud Fundamentals (Cloud Computing)
About this course

This MTA Training course helps you prepare for Microsoft Technology Associate Exam 98-369, and build an understanding of these topics: The cloud, enabling, using and configuring cloud services, supporting cloud users, and administering Office 365 and Microsoft Intune. This course leverages the same content as found in the Microsoft Official Academic Course (MOAC) for this exam.

Audience profile

The Microsoft Technology Associate (MTA) is Microsoft’s newest suite of technology certification exams that validate fundamental knowledge needed to begin building a career using Microsoft technologies. This program provides an appropriate entry point to a future career in technology and assumes some hands-on experience or training but does not assume on-the-job experience.

At course completion

After completing this course, you will be able to:

  • Understand the cloud
  • Enable, use, and configure Microsoft Cloud Services
  • Administer Office 365 and Microsoft Intune
  • Support cloud users



Course Outline

Module 1: Understanding the Cloud

Lessons

  • Understanding Cloud Principles and Delivery Mechanisms
  • Understanding Cloud Security Requirements and Policies
  • Understanding How a Cloud Service Stays Up to Date and Available
  • Understanding the Different Types of Cloud Services

Module 2: Enabling Microsoft Cloud Services

Lessons

  • Enabling Microsoft Office 365
  • Enabling Microsoft Intune
  • Understanding Microsoft Azure

Module 3: Administering Office 365 and Microsoft Intune

Lessons

  • Administering Office 365
  • Administering Microsoft Intune

Module 4: Using and Configuring Microsoft Cloud Services

Lessons

  • Configuring Exchange Online
  • Configuring SharePoint Online
  • Configuring OneDrive
  • Configuring Skype for Business Online
  • Configuring Microsoft Intune

Module 5: Supporting Cloud Users

Lessons

  • Resolving Issues with Installing Office Applications and Signing In
  • Resolving Issues with Emails and Calendars
  • Resolving Issues with SharePoint and OneDrive
  • Resolving Issues with Skype for Business Online



Target Audience
Basic Primary, JHS And SHS


Prerequisites

None

Price Includes International Curriculum Courseware And Very Active Real-Time Labs.

Cloud Fundamentals: Course Content / Exam(s)

Schedule for Cloud Fundamentals
Course ContentsExam#Exam
Cloud Fundamentals98-369Cloud Fundamentals

2 Hours Daily 3 Times a Week

Total Duration 3 Months

 Our Services

₵800.00
Database Administration Fundamentals (MTA Database Fundamentals)

Overview
Students who are beginning studies in technology need a strong foundation in the basics before moving on to more advanced technology courses and certification programs. The Microsoft Technology Associate (MTA) is an innovative certification track designed to provide a pathway for future success in technology courses and careers.

The MTA program curriculum helps teach and validate fundamental technology knowledge. Database Administration Fundamentals covers introductory knowledge and skills including: relational databases; core database concepts; relational database concepts; security requirements for databases and the data stored in them; database objects -- such as tables and views; graphical tools and T-SQL scripts; database queries; and stored procedures.

Course Outline

Lesson 1:
Understanding Core Database Concepts 1

Objective Domain Matrix 1
Key Terms 1
Understanding Database Concepts 2
Understanding Flat-Type Databases 3
Understanding Hierarchical Databases 3
Understanding Relational Databases 4
Understanding Database Fundamentals 5
Understanding Relational Database Concepts 7
Using the SQL Server Management Studio Interface 9
Understanding Data Manipulation
Language (DML) 12
Understanding Data Definition Language (DDL) 12
Using DDL Statements 13
Skill Summary 16
Knowledge Assessment 17
Competency Assessment 19
Proficiency Assessment 19

Lesson 2:
Creating Database Objects 20

Objective Domain Matrix 20
Key Terms 20
Defining Data Types 20
Using Built-in Data Types 21
Using Exact Numeric Data Types 24
Using Approximate Numeric Data Types 25
Creating and Using Tables 29
Creating Views 33
Creating Stored Procedures 35
Understanding SQL Injections 38
Skill Summary 38
Knowledge Assessment 39
Competency Assessment 41
Proficiency Assessment 41

Lesson 3:
Manipulating Data 43

Objective Domain Matrix 43
Key Terms 43
Using Queries to Select Data 44
Combining Conditions 45
Using the BETWEEN Clause 46
Using the NOT Clause 47
Using the UNION Clause 47
Using the EXCEPT and INTERSECT Clauses 48
Using the JOIN Clause 48
Using Queries to Insert Data 51
Inserting Data 52
Updating Data and Databases 54
Using the UPDATE Statement 54
Deleting Data 55
Using the DELETE Statement 55
Truncating a Table with TRUNCATE TABLE 56
Deleting a Table with DROP TABLE 56
Using Referential Integrity 56
Skill Summary 57
Knowledge Assessment 57
Competency Assessment 59
Proficiency Assessment 59

Lesson 4:
Understanding Data Storage 61

Objective Domain Matrix 61
Key Terms 61
Normalizing a Database 62
Understanding Normalization 62
Understanding the First Normal Form 62
Understanding the Second Normal Form 63
Understanding the Third Normal Form 64
Understanding the Fourth Normal Form 66
Understanding the Fifth Normal Form 66
Understanding Primary, Foreign, and
Composite Keys 67
Understanding Primary Keys 70
Understanding Foreign Keys 70
Understanding Composite Primary Keys 74
Understanding Clustered and Non-clustered Indexes 74
Understanding Clustered Indexes 75
Understanding Non-clustered Indexes 76
Creating a Non-clustered Table 76
Skill Summary 80
Knowledge Assessment 80
Competency Assessment 82
Proficiency Assessment 82

Lesson 5:
Administering a Database 84

Objective Domain Matrix 84
Key Terms 84
Securing Databases 85
Understanding Server-Level Security 86
Understanding Database-Level Security 86
Understanding Windows Security 87
Understanding SQL Authentication 90
Understanding Database Server Roles 91
Granting Access to a Database 92
Understanding Fixed Database Roles 94
Understanding Object Permissions 95
Managing Roles 98
Understanding Ownership Chains 99
Reviewing a Sample Security Model 100
Backing Up and Restoring Databases 101
Understanding Recovery Models 101
Understanding Database Backups 101
Understanding Backup Devices 103
Understanding Database Restores 103
Skill Summary 106
Knowledge Assessment 107
Competency Assessment 108
Proficiency Assessment 109

Price Includes International Curriculum Courseware And Very Active Real-Time Labs.

MTA Database Administration Fundamentals / Exam(s)

Schedule for Database Administration Fundamentals
Course#Course ContentsExam#
40364AMTA Database Administration FundamentalsExam 98-364

2 Hours Daily 3 Times a Week

Total Duration 3 Months

Prerequisites

  • Basic Knowledge of Computing
Recommended Courses and Certification:
  • MCSA: SQL Server 2012
₵1,400.00
MCSA: Windows Server 2012 R2 Certification Training (MCSA)

Windows Server 2012 R2 is the core of Microsoft's Cloud vision that integrates global scale cloud infrastructure into your enterprise IT.
MCSA Windows Server 2012 Training introduces users to various new capabilities in storage, networking, virtualization, VDI, information access, protection etc.
This MCSA certification will not only cover the essentials of the latest version of Windows Server, but also take you through its complete administration and advanced services.
Users will also gain in-depth knowledge of latest management tools available for performing post deployment tasks on Windows Server 2012 R2.

This MCSA certification allows participants to design, configure, implement and manage Windows Server deployments on desktops and devices in an enterprise environment. The skills learnt in this MCSA course will also help users reduce their IT costs and maximize business value. MCSA training is the first step towards earning the coveted MCSE credential.

Audience: This Windows Server 2012 Certification is ideal for professionals who wish to work as computer support specialists, network or system administrators, so that they can maximize business value and reduce IT costs.

Windows Server 2012: MCSA Course Objectives

  • Installing, configuring and implementing a Windows Server 2012 infrastructure
  • Implementing and administering Active Directory Domain Services
  • Incorporating identity management, federated services, rights management, certification services and business continuity.
  • Installing and configuring Desired State Configuration (DSC) for Windows Powershell
  • Implementing features such as IPv4, IPv6, DNS, DHCP, local storage, group policy etc.
  • Using Hyper-V to incorporate server virtualization
  • Managing User and service accounts in this Windows Server certification
  • Implementing Network Access Protection, Network Policy Server, encryption, and advanced auditing
  • Migrating roles from previous versions of Windows Server
  • Managing remote access, file services and updates
  • Implementing advanced services such as Dynamic Access Control, Network Load Balancing, Failover Clustering and disaster recovery.
  • Optimizing resource utilization by employing Features on Demand and configuring NIC teaming
Price Includes International Curriculum Courseware And Very Active Real-Time Labs.

Windows Server 2012: MCSA Course Content / Exam(s)

Schedule for MCSA: Windows Server 2012 R2
Course#Course ContentsExam#Exam
20410Installing and Configuring Windows Server 2012 R270-410Installing and Configuring Windows Server 2012 R2
20411Administering Windows Server 2012 R270-411Administering Windows Server 2012 R2
20412Configuring Advanced Windows Server 2012 Services R270-412Configuring Advanced Windows Server 2012 Services R2

2 Hours Daily 3 Times a Week

Total Duration 4 Months


Prerequisites

  • Ideally, you should have successfully completed the "CompTIA Network+ Support Skills" course and have around 24 months' experience of networking support or IT administration. It is not necessary that you pass the Network+ exam before completing Security+ certification, but it is recommended. Specifically, it is recommended that you have the following skills and knowledge before starting this course:

    • Know the function and basic features of the components of a PC.
    • Use Windows Server to create and manage files and use basic administrative features (Explorer, Control Panel, Server Manager, and Management Consoles).
    • Operate the Linux OS using basic command-line tools.
    • Know basic network terminology and functions (such as OSI Model, Topology, Ethernet, Wi-Fi, switches, routers).
    • Understand TCP/IP addressing, core protocols, and troubleshooting tools.
Recommended Courses and Certification:
₵1,700.00
Protecting Modern Desktops and Devices (MD-101T03-A)
Overview
About this course

Every day, more organizations are asking IT to support mobility in the workforce. Modern environments require the Desktop Administrator be able to manage and support phones, tablets, and computers, whether it be owned by the organization or personally owned by the employee. At the same time, IT must still be able to protect the data that these devices access.  In this course, the student will be introduced to the key concepts of security in modern management. This course covers authentication, identities, and access, as well as about how to protect these categories. The student will be introduced to Azure Active Directory and learn how to use Microsoft Intune to protect devices and data with compliance policies. Finally, this course will cover key capabilities of Azure Information Protection and Windows Defender Advanced Threat Protection and how to implement these capabilities.

Audience profile

The Modern Desktop Administrator deploys, configures, secures, manages, and monitors devices and client applications in an enterprise environment. Responsibilities include managing identity, access, policies, updates, and apps. The MDA collaborates with the M365 Enterprise Administrator to design and implement a device strategy that meets the business needs of a modern organization.

The Modern Desktop Administrator must be familiar with M365 workloads and must have strong skills and experience of deploying, configuring, and maintaining Windows 10 and non-Windows devices. The MDA role focuses on cloud services rather than on-premises management technologies.

At course completion

After completing this course, learners should be able to:

  • Describe the benefits and capabilities of Azure AD.
  • Manage users using Azure AD with Active Directory DS.
  • Implement Windows Hello for Business.
  • Configure conditional access rules based on compliance policies.
  • Describe the various tools used to secure devices and data.
  • Implement Windows Defender Advanced Threat Protection.

Course details
Course Outline

Module 1: Managing Authentication in Azure ADIn this module, students well be introduced to the concept of directory in the cloud with Azure AD. Students will learn the similarities and differences between Azure AD and Active Directory DS and how to synchronize between the two. Students will explore identity management in Azure AD and learn about identity protection using Windows Hello for Business, as well as Azure AD Identity Protection and multi-factor authentication. The module will conclude with securely accessing corporate resources and introduce concepts such as Always On VPN and remote connectivity in Windows 10.

Lessons
  • Azure AD Overview
  • Managing identities in Azure AD
  • Protecting identities in Azure AD
  • Managing device authentication
  • Enabling corporate access

Lab : Practice Lab - Managing objects and authentication in Azure AD
  • Enabling and configuring Azure AD Premium with Enterprise Mobility + Security (EMS) tenant
  • Creating user and group objects with UI and Windows PowerShell
  • Configuring Self-service password reset (SSPR) for user accounts in Azure AD
  • Joining a device to Azure AD
After completing this module, students will be able to:
  • Describe the capabilities of Azure AD.
  • Manage users using Azure AD with Active Directory DS.
  • Implement Windows Hello for Business.
  • Join devices to Azure AD.
  • Describe methods of enabling access from external networks.

Module 2: Managing Devices and Device Policies
In this module, students will be introduced to managing device security with Intune. Students will discover how Intune can use device profiles to manage configuration of devices to protect data on a device. Students will learn how to create and deploy compliance policies and use compliance policies for conditional access. The module concludes with monitoring devices enrolled in Intune.


Lessons
  • Microsoft Intune Overview
  • Managing devices with Intune
  • Implement device compliance policies

Lab : Practice Lab - Managing devices
  • Configuring Microsoft Intune for device management
  • Configuring compliance policies and device profiles
  • Enrolling Windows 10 devices and managing compliance

After completing this module, students will be able to:

  • Describe mobile device management with Intune.
  • Create and assign device profiles to protect data on devices.
  • Deploy compliance and conditional access policies.
  • Use Intune to monitor device compliance.

Module 3: Managing Security 
In this module, students will learn about data protection. Topics will include Windows & Azure Information Protection, and various encryption technologies supported in Windows 10. This module also covers key capabilities of Windows Defender Advanced Threat Protection and how to implement these capabilities on devices in your organization. The module concludes using Windows Defender and using functionalities such as antivirus, firewall and Credential Guard.

Lessons
  • Implement device data protection
  • Managing Windows Defender ATP
  • Managing Windows Defender in Windows 10

Lab : Practice Lab - Managing Security in Windows 10
  • Configuring Encrypting File System (EFS)
  • Configuring BitLocker
  • Configuring a WIP policy in Intune
  • Configuring Windows Defender


After completing this module, students will be able to:

  • Describe the methods protecting device data.
  • Describe the capabilities and benefits of Windows ATP
  • Deploy and manage settings for Windows Defender clients.

Module 4: Course Conclusion
Lessons
  • Final Exam

Lab : Graded Lab

Prerequisites

The Modern Desktop Administrator must be familiar with M365 workloads and must have strong skills and experience of deploying, configuring, and maintaining Windows 10 and non-Windows devices. The MDA role focuses on cloud services rather than on-premises management technologies.

Price Includes International Curriculum Courseware And Very Active Real-Time Labs.

Protecting Modern Desktops and Devices: Course Content / Exam(s)

2 Hours Daily 3 Times a week

Total Duration 3 Months

₵1,700.00
Per Page      1 - 16 of 16
  • 1