Tel: (+357) 22.81.81.01
Tel: (+357) 25.37.38.00
sales@aktina.com.cy
IT trainingIT training
  • Home
  • Courses
    • Microsoft Technical
      • Microsoft Windows Server
      • Microsoft Windows Client
      • Microsoft Exchange Server
      • Microsoft SQL Server
      • Microsoft Virtualizations/Cloud
      • Microsoft SharePoint
      • Microsoft Visual Studio
      • Microsoft Azure
      • Microsoft Office 365
    • Microsoft Office
      • Microsoft Excel-Advanced
      • Microsoft Excel-Basic
      • Microsoft Word-Advanced
      • Microsoft Word-Basic
      • Microsoft Power BI
      • Microsoft PowerPoint
      • Microsoft Access
      • Microsoft Project
      • Microsoft Publisher
      • Microsoft Visio
    • Security
      • CEH-Certified Ethical Hacker
      • CAST 611-Advanced Penetration Testing
      • CCNA-Security
      • CISA-Certified Information Systems Auditor
    • Adobe
      • Photoshop-Basic
      • Photoshop-Advanced
      • Illustrator
      • InDesign
      • Dreamweaver
      • Flash
      • Premiere Pro
    • Cisco
    • Oracle
    • Linux
      • LPI
      • Red Hat
    • Autodesk
    • Project Management
    • Service Management
    • SPSS
    • Web Design
    • VMware
  • Certifications
    • Microsoft Technical
      • MCSA
      • MCSE
      • MCSD
    • Microsoft Office
      • MOS-Microsoft Office Specialist
    • Security
      • CEH
      • CAST 611
      • CISA
      • CISCO SECURITY
    • Cisco
      • CCNA
      • CCNP
    • ECDL
    • Linux
      • Linux Professional Institute
    • Oracle
      • OCA – PL/SQL Developer
      • OCA – Database 11g Administrator
      • OCA – Database 12c Administrator
    • Project Management
    • Service Management
    • Pearson Vue
  • Solutions
    • For Business
    • For Individuals
    • Training Options
  • Contact
  • More
    • About Us
    • Request Info
    • Become a trainer
    • News & Events
    • Home
    • Courses
      • Microsoft Technical
        • Microsoft Windows Server
        • Microsoft Windows Client
        • Microsoft Exchange Server
        • Microsoft SQL Server
        • Microsoft Virtualizations/Cloud
        • Microsoft SharePoint
        • Microsoft Visual Studio
        • Microsoft Azure
        • Microsoft Office 365
      • Microsoft Office
        • Microsoft Excel-Advanced
        • Microsoft Excel-Basic
        • Microsoft Word-Advanced
        • Microsoft Word-Basic
        • Microsoft Power BI
        • Microsoft PowerPoint
        • Microsoft Access
        • Microsoft Project
        • Microsoft Publisher
        • Microsoft Visio
      • Security
        • CEH-Certified Ethical Hacker
        • CAST 611-Advanced Penetration Testing
        • CCNA-Security
        • CISA-Certified Information Systems Auditor
      • Adobe
        • Photoshop-Basic
        • Photoshop-Advanced
        • Illustrator
        • InDesign
        • Dreamweaver
        • Flash
        • Premiere Pro
      • Cisco
      • Oracle
      • Linux
        • LPI
        • Red Hat
      • Autodesk
      • Project Management
      • Service Management
      • SPSS
      • Web Design
      • VMware
    • Certifications
      • Microsoft Technical
        • MCSA
        • MCSE
        • MCSD
      • Microsoft Office
        • MOS-Microsoft Office Specialist
      • Security
        • CEH
        • CAST 611
        • CISA
        • CISCO SECURITY
      • Cisco
        • CCNA
        • CCNP
      • ECDL
      • Linux
        • Linux Professional Institute
      • Oracle
        • OCA – PL/SQL Developer
        • OCA – Database 11g Administrator
        • OCA – Database 12c Administrator
      • Project Management
      • Service Management
      • Pearson Vue
    • Solutions
      • For Business
      • For Individuals
      • Training Options
    • Contact
    • More
      • About Us
      • Request Info
      • Become a trainer
      • News & Events

    Microsoft Technical

    • Home
    • All courses
    • Microsoft Technical
    • 20461: Querying Microsoft SQL Server – Official Microsoft Course

    20461: Querying Microsoft SQL Server – Official Microsoft Course

    aktina
    Microsoft Technical, SQL Server
    COURSE REGISTRATION
    20461: Querying Microsoft SQL Server – Official Microsoft Course
    • Course Overview
    • Course Outline
    • Course Arrangements
    • Costs
    Introduction

    This 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. This course helps people prepare for exam 70-461. 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.

    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.
    At Course Completion:
    After completing this course, students will be able to:
    • 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
    Prerequisites:
    This course requires that you meet the following prerequisites:
    • Working knowledge of relational databases.
    • Basic knowledge of the Microsoft Windows operating system and its core functionality.
    Professional Exam(s):
    Exam 70-461: Querying Microsoft SQL Server
    Certification(s):
    MCSA: SQL Server

    Course Features

    • Lectures 19
    • Quizzes 0
    • Duration 50 hours
    • Skill level All levels
    • Language English
    • Students 0
    • Assessments Yes
    • Share:
    • MODULES 0/19

      • Module1.1
        Introduction to Microsoft SQL Server 2014
        Preview
        30 minute
      • Module1.2
        Introduction to T-SQL Querying
        Preview
        30 minute
      • Module1.3
        Querying Multiple Tables
        Preview
        30 minute
      • Module1.4
        Sorting and Filtering Data
        Preview
        30 minute
      • Module1.5
        Working with SQL Server 2014 Data Types
        Preview
        30 minute
      • Module1.6
        Using DML to Modify Data
        Preview
        30 minute
      • Module1.7
        Using Built-In Functions
        Preview
        30 minute
      • Module1.8
        Grouping and Aggregating Data
        Preview
        30 minute
      • Module1.9
        Using Subqueries
        Preview
        30 minute
      • Module1.10
        Using Table Expressions
        Preview
        30 minute
      • Module1.11
        Using Set Operators
        Preview
        30 minute
      • Module1.12
        Using Window Ranking, Offset, and Aggregate Functions
        Preview
        30 minute
      • Module1.13
        Pivoting and Grouping Sets
        Preview
        30 minute
      • Module1.14
        Executing Stored Procedures
        Preview
        30 minute
      • Module1.15
        Programming with T-SQL
        Preview
        30 minute
      • Module1.16
        Implementing Error Handling
        Preview
        30 minute
      • Module1.17
        Implementing Transactions
        Preview
        30 minute
      • Module1.18
        Improving Query Performance
        Preview
        30 minute
      • Module1.19
        Querying SQL Server Metadata
        Preview
        30 minute
    City
    Nicosia
    Dates and Times
    Class A
    1. Wednesday Mar 21 8:00 - 15:10
    2. Friday Mar 23 8:00 - 15:10
    3. Monday Mar 26 8:00 - 15:10
    4. Wednesday Mar 28 8:00 - 15:10
    5. Friday Mar 30 8:00 - 15:10
    6. Monday Apr 2 8:00 - 15:10
    Duration (Hours)
    40
    Location
    20 Loukis Akritas street 2064 Strovolos
    (behind Kykko secondary schools)
    City
    Limassol
    Dates and Times
    Duration (Hours)
    40
    Location
    22 Griva Digeni Avenue, 3106 Ayios Nikolaos
    (near Coop branch and Ayios Nikolaos church)

    For participants eligible for subsidy by the Human Resource Development Authority:
    Participation * Course ManualExam
    Official Course 20461Official - digital **70-461
    Amount€425,00€205,00€100,00
    VAT * €209,95€38,95-
    * denotes a course subsidised by the Human Resource Development Authority. VAT is applied on the amount before subsidy
    ** if you prefer printed official courseware, cost will be higher by €27,00 +VAT.

    This course is also offered at a high discount as part of a bundle of 3 certification courses – click here 

    For participants not eligible for subsidy by the Human Resource Development Authority:
    Participation Course ManualExam
    Official Course 20461Official - digital **70-461
    Amount€600,00€205,00€100,00
    VAT €114,00€38,95-
    ** if you prefer printed official courseware, cost will be higher by €27,00 +VAT.

    This course is also offered at a high discount as part of a bundle of 3 certification courses – click here


    Take advantage of our special offer by taking this course as part of a bundle of 3 courses leading to the following prestigious MCSA certification:

    For participants eligible for subsidy by the Human Resource Development Authority:
    Participation * Course ManualsExams
    Courses 20461, 20462 & 20463Official 20461, 20462 & 20463 **70-461, 70-462 & 70-463
    Amount€510,00€615,00
    incl.
    VAT * €484,50€116,85
    incl.
    * denotes a course subsidised by the Human Resource Development Authority. VAT is applied on the amount before subsidy.
    ** if you prefer printed official courseware, cost will be higher by €81,00 +VAT.
    For participants not eligible for subsidy by the Human Resource Development Authority:
    ParticipationCourse ManualsExams
    Courses 20461, 20462 & 20463Official 20461, 20462 & 20463 **70-461, 70-462 & 70-463
    Amount€1,260,50€615,00€300,00
    VAT€239,50€116,85
    -
    ** if you prefer printed official courseware, cost will be higher by €81,00 +VAT.

     

     

    • Course Overview
    • Course Outline
    • Course Arrangements
    • Costs
    COURSE REGISTRATION

    You May Like

    10262 – Developing Windows Applications with Microsoft Visual Studio 2010 Read More
    aktina

    10262 - Developing Windows Applications with Microsoft Visual Studio 2010

    0
    Free
    10135 – Configuring, Managing and Troubleshooting Microsoft Exchange Server 2010 Service Pack 2 Read More
    aktina

    10135 - Configuring, Managing and Troubleshooting Microsoft Exchange Server 2010 Service Pack 2

    0
    Free
    10747 – Administering System Center 2012 Configuration Manager Read More
    aktina

    10747 - Administering System Center 2012 Configuration Manager

    0
    Free
    20698: Installing and Configuring Windows 10 – Official Microsoft Course Read More
    aktina

    20698: Installing and Configuring Windows 10 - Official Microsoft Course

    0
    Free
    20697-1: Implementing and Managing Windows 10 – Official Microsoft Course Read More
    aktina

    20697-1: Implementing and Managing Windows 10 – Official Microsoft Course

    0
    Free

    LEMESOS (LIMASSOL)

    22 Griva Digeni Avenue, 1st floor 3106 Agios Nikolaos (near Coop branch and Ayios Nikolaos church)

    LEFKOSIA (NICOSIA)

    20 Loukis Akritas street, 2064 Strovolos (behind Kykko secondary schools)

    Request Info









    * First Name:

    * Last Name:

    Organization:

    * Email:

    * Phone:

    Course I am interested in:

    Certification I am interested in:

    * Location:

    * Message

    * mandatory field

    UPCOMING COURSES

    20743 - Upgrading Your Skills to MCSA: Windows Server 2016 – Official Microsoft Course

    Introduction This instructor-led course explains how to implement and configure...

    20742: Identity with Windows Server 2016 – Official Microsoft Course

    Introduction This instructor-led course teaches IT Pros how to deploy...

    20741: Networking with Windows Server 2016 – Official Microsoft Course

    Introduction This classroom-based course provides the fundamental networking skills required...

    20740: Installation, Storage and Compute with Windows Server 2016 – Official Microsoft Course

    Introduction This course is designed primarily for IT professionals who...

    Interconnecting Cisco Networking Devices Routing and Switching (CCNA)

    Introduction This course will provide participants with the skills and...

    Limassol Training Center

    22 Griva Digeni Avenue, 1st floor
    3106 Agios Nikolaos
    (near Coop branch and
    Ayios Nikolaos church)

    (+357) 25.37.38.00

     

    Nicosia Training Center

    20 Loukis Akritas street
    2064 Strovolos
    (behind Kykko secondary schools)
    PO Box 25252, CY-1308
    Lefkosia (Nicosia), Cyprus

    (+357) 22 81.81.01

     

    TOP Courses

    • 20740: Windows Server 2016
    • 20461: Microsoft SQL Server
    • 20483: Programming in C#
    • 20480: HTML5 ,JavaScript…
    • Oracle Database: PL/SQL
    • VMware vSphere

    Top Certifications

    • MCSA: Windows Server 2016
    • MCSA: SQL 2016 Database…
    • MCSA: Web Applications
    • CEH: EC-Council
    • CCNA – Cisco Certified…
    • OCA – Oracle Certified…

    Recommended

    • Security
    • Microsoft
    • Oracle
    • Cisco
    • Linux
    • Adobe

    Contact

    sales@aktina.com.cy

    Developed by AKTINA . IT Training organisation in Cyprus.

    • COURSES
    • CERTIFICATIONS
    • SOLUTIONS
    • CONTACT
    • MORE

    BECOME A TRAINER

    Join our team of trainers and earn money hassle free!

    Get Started Now