• Home
  • Courses
    • Microsoft Technical
      • Microsoft Azure
      • Microsoft Exchange Server
      • Microsoft SQL Server
      • Microsoft SharePoint
      • Microsoft Office 365
      • Microsoft Teams
      • Microsoft Virtualization
      • Microsoft Visual Studio
      • Microsoft Windows Server
      • Microsoft Windows Client
    • Microsoft Office
      • Microsoft Excel-Advanced
      • Microsoft Excel-Basic
      • Microsoft Word-Advanced
      • Microsoft Word-Basic
      • Microsoft Power BI
      • Microsoft Access
      • Microsoft PowerPoint
      • Microsoft Project
      • Microsoft Publisher
      • Microsoft Visio
    • Security
      • CCSA – Check Point Certified Admin
      • CND-Certified Network Defender
      • CSCU – Certified Secure Computer User
      • CEH-Certified Ethical Hacker v11
      • CAST 611-Advanced Penetration Testing
      • CISM – Certified Information Security Manager
      • CISA-Certified Information Systems Auditor
      • CISSP – Certified Information Systems Security Professional
    • AWS
    • Blockchain
    • Digital Marketing
    • Cisco
    • Oracle
    • Linux
      • LPI
      • Red Hat
    • Adobe
      • Photoshop-Basic
      • Photoshop-Advanced
      • Illustrator
      • InDesign
      • Dreamweaver
      • Flash
      • Premiere Pro
    • Autodesk
    • Project Management
    • Service Management
    • SPSS
    • Web Design
    • VMware
  • Certifications
    • Microsoft Technical
      • Microsoft Certified: Azure Administrator Associate
      • Microsoft 365 Certified: Enterprise Administrator Exper
      • Microsoft Certified: Data Analyst Associate
      • Microsoft Certified: Azure Developer Associate
    • Microsoft Office
      • MOS: Associate (Office 365 and Office 2019)
      • MOS: Expert (Office 365 and Office 2019)
      • MOS-Microsoft Office Specialist
      • Microsoft 365 Certified
    • Security Specialist
      • CND-Certified Network Defender
      • CSCU
      • CEH – Certified Ethical Hacker v11
      • CAST 611 – Advanced Penetration Testing
      • CISA – Certified Information Systems Auditor
      • CISM – Certified Information Security Manager
      • CISCO SECURITY
    • Cisco
      • CCNA – Cisco Certified Network Associate – AKTINA – IT training Center
    • Certified Blockchain Professional
    • Certified Digital Marketer (CDM)
    • ECDL Standard
    • Linux
      • Linux Professional Institute
    • Oracle
      • OCA – Oracle Certified Associate: PL/SQL Developer
      • OCA – Oracle Certified Associate: Database 11g Administrator
      • OCA – Oracle Certified Associate: Database 12c Administrator
    • VMware
    • Project Management Professional ( PMP )
    • Service Management
    • Pearson Vue
  • Solutions
    • For Business
    • For Individuals
    • Training Options
  • Contact
  • More
    • About Us
    • Request Info
    • Become a Trainer
    • News & Events
    Tel: (+357) 22.81.81.01
    Tel: (+357) 25.37.38.00
    sales@aktina.com.cy
    AKTINA - IT training Center
    • Home
    • Courses
      • Microsoft Technical
        • Microsoft Azure
        • Microsoft Exchange Server
        • Microsoft SQL Server
        • Microsoft SharePoint
        • Microsoft Office 365
        • Microsoft Teams
        • Microsoft Virtualization
        • Microsoft Visual Studio
        • Microsoft Windows Server
        • Microsoft Windows Client
      • Microsoft Office
        • Microsoft Excel-Advanced
        • Microsoft Excel-Basic
        • Microsoft Word-Advanced
        • Microsoft Word-Basic
        • Microsoft Power BI
        • Microsoft Access
        • Microsoft PowerPoint
        • Microsoft Project
        • Microsoft Publisher
        • Microsoft Visio
      • Security
        • CCSA – Check Point Certified Admin
        • CND-Certified Network Defender
        • CSCU – Certified Secure Computer User
        • CEH-Certified Ethical Hacker v11
        • CAST 611-Advanced Penetration Testing
        • CISM – Certified Information Security Manager
        • CISA-Certified Information Systems Auditor
        • CISSP – Certified Information Systems Security Professional
      • AWS
      • Blockchain
      • Digital Marketing
      • Cisco
      • Oracle
      • Linux
        • LPI
        • Red Hat
      • Adobe
        • Photoshop-Basic
        • Photoshop-Advanced
        • Illustrator
        • InDesign
        • Dreamweaver
        • Flash
        • Premiere Pro
      • Autodesk
      • Project Management
      • Service Management
      • SPSS
      • Web Design
      • VMware
    • Certifications
      • Microsoft Technical
        • Microsoft Certified: Azure Administrator Associate
        • Microsoft 365 Certified: Enterprise Administrator Exper
        • Microsoft Certified: Data Analyst Associate
        • Microsoft Certified: Azure Developer Associate
      • Microsoft Office
        • MOS: Associate (Office 365 and Office 2019)
        • MOS: Expert (Office 365 and Office 2019)
        • MOS-Microsoft Office Specialist
        • Microsoft 365 Certified
      • Security Specialist
        • CND-Certified Network Defender
        • CSCU
        • CEH – Certified Ethical Hacker v11
        • CAST 611 – Advanced Penetration Testing
        • CISA – Certified Information Systems Auditor
        • CISM – Certified Information Security Manager
        • CISCO SECURITY
      • Cisco
        • CCNA – Cisco Certified Network Associate – AKTINA – IT training Center
      • Certified Blockchain Professional
      • Certified Digital Marketer (CDM)
      • ECDL Standard
      • Linux
        • Linux Professional Institute
      • Oracle
        • OCA – Oracle Certified Associate: PL/SQL Developer
        • OCA – Oracle Certified Associate: Database 11g Administrator
        • OCA – Oracle Certified Associate: Database 12c Administrator
      • VMware
      • Project Management Professional ( PMP )
      • Service Management
      • Pearson Vue
    • Solutions
      • For Business
      • For Individuals
      • Training Options
    • Contact
    • More
      • About Us
      • Request Info
      • Become a Trainer
      • News & Events

      SQL Server

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

      20461: Querying Microsoft SQL Server – Official Microsoft Course

      User Avatar
      aktina
      SQL Server
      Free
      2016-sql-server-logo
      • 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
      CoursesMicrosoft TechnicalSQL Server20461: Querying Microsoft SQL Server – Official Microsoft Course
      • MODULES
        19
        • Lecture1.1
          Introduction to Microsoft SQL Server 2014 30 min
        • Lecture1.2
          Introduction to T-SQL Querying 30 min
        • Lecture1.3
          Querying Multiple Tables 30 min
        • Lecture1.4
          Sorting and Filtering Data 30 min
        • Lecture1.5
          Working with SQL Server 2014 Data Types 30 min
        • Lecture1.6
          Using DML to Modify Data 30 min
        • Lecture1.7
          Using Built-In Functions 30 min
        • Lecture1.8
          Grouping and Aggregating Data 30 min
        • Lecture1.9
          Using Subqueries 30 min
        • Lecture1.10
          Using Table Expressions 30 min
        • Lecture1.11
          Using Set Operators 30 min
        • Lecture1.12
          Using Window Ranking, Offset, and Aggregate Functions 30 min
        • Lecture1.13
          Pivoting and Grouping Sets 30 min
        • Lecture1.14
          Executing Stored Procedures 30 min
        • Lecture1.15
          Programming with T-SQL 30 min
        • Lecture1.16
          Implementing Error Handling 30 min
        • Lecture1.17
          Implementing Transactions 30 min
        • Lecture1.18
          Improving Query Performance 30 min
        • Lecture1.19
          Querying SQL Server Metadata 30 min
      City
      Nicosia
      Dates and Times
      Class A
      1. Tuesday Oct 9 8:00 - 15:10
      2. Thursday Oct 11 8:00 - 15:10
      3. Friday Oct 13 8:00 - 15:10
      4. Tuesday Oct 16 8:00 - 15:10
      5. Thursday Oct 18 8:00 - 15:10
      6. Friday Oct 19 8:00 - 15:10
      Duration (Hours)
      40
      Location
      20 Louki Akrita street, 2064 Strovolos
      (behind Kykko secondary schools)
      City
      Limassol
      Dates and Times
      Duration (Hours)
      40
      Location
      22 Griva Digeni Avenue, 3106 Agios Nikolaos
      (200 m. from the roundabout, near Agios Nikolaos church)

      For participants eligible for subsidy by the Human Resource Development Authority:
      Participation * Course ManualExam
      Official Course 20461Official - digital70-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

      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 - digital70-461
      Amount€600,00€205,00€100,00
      VAT €114,00€38,95-

      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 & 2046370-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.
      For participants not eligible for subsidy by the Human Resource Development Authority:
      ParticipationCourse ManualsExams
      Courses 20461, 20462 & 20463Official 20461, 20462 & 2046370-461, 70-462 & 70-463
      Amount€1,260,50€615,00€300,00
      VAT€239,50€116,85
      -

       

       

      • Course Overview
      • Course Outline
      • Course Arrangements
      • Costs
      Free
      • Share:

      You May Like

      20462: Administering Microsoft SQL Server Databases – Official Microsoft Course Read More
      aktina

      20462: Administering Microsoft SQL Server Databases – Official Microsoft Course

      0
      Free
      20463: Implementing a Data Warehouse with Microsoft SQL Server – Official Microsoft Course Read More
      aktina

      20463: Implementing a Data Warehouse with Microsoft SQL Server – Official Microsoft Course

      0
      Free
      20761 – Querying Data with Transact-SQL – Official Microsoft Course Read More
      aktina

      20761 - Querying Data with Transact-SQL – Official Microsoft Course

      0
      Free
      20762: Developing SQL Databases– Official Microsoft Course Read More
      aktina

      20762: Developing SQL Databases– Official Microsoft Course

      0
      Free
      20764: Administering a SQL Database Infrastructure – Official Microsoft Course Read More
      aktina

      20764: Administering a SQL Database Infrastructure – Official Microsoft Course

      0
      Free

      LEMESOS (LIMASSOL)

      22 Griva Digeni Avenue, 1st floor 3106 Agios Nikolaos (200 m. from the roundabout, near Agios Nikolaos church)

      LEFKOSIA (NICOSIA)

      20 Louki Akrita street, 2064 Strovolos (behind Kykko secondary schools)

      Popular Courses

      Digital Marketing e-course

      Digital Marketing e-course

      Blockchain Professional e-course

      Blockchain Professional e-course

      Implementing and Administering Cisco Solutions (CCNA)

      Implementing and Administering Cisco Solutions (CCNA)

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

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

      More Courses

      Limassol Training Center

      22 Griva Digeni Avenue, 1st floor 3106 Agios Nikolaos (200 m. from the roundabout, near Agios Nikolaos church) Lemesos (Limassol), Cyprus

      (+357) 25.37.38.00

       

      Nicosia Training Center

      20 Louki Akrita 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: Querying Microsoft SQL
      • 20483: Programming in C#
      • 20461: Microsoft SQL Server
      • 20480: HTML5 ,JavaScript…
      • VMware vSphere
      • Oracle Database: Backup and Recover

      Recommended

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

      Contact

      sales@aktina.com.cy

      Developed by AKTINA . IT Training organisation in Cyprus.

      • COURSES
      • CERTIFICATIONS
      • SOLUTIONS
      • CONTACT

      BECOME A TRAINER

      Join our team of trainers and earn money hassle free!

      Get Started Now
      Modal title

      Message modal