• 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
      • CND-Certified Network Defender
      • CSCU – Certified Secure Computer User
      • CEH-Certified Ethical Hacker v11
      • CAST 611-Advanced Penetration Testing
      • CCNA-Security
      • CISM – Certified Information Security Manager
      • CISA-Certified Information Systems Auditor
    • Adobe
      • Photoshop-Basic
      • Photoshop-Advanced
      • Illustrator
      • InDesign
      • Dreamweaver
      • Flash
      • Premiere Pro
    • Blockchain
    • Digital Marketing
    • Cisco
    • Oracle
    • Linux
      • LPI
      • Red Hat
    • Autodesk
    • Project Management
    • Service Management
    • SPSS
    • Web Design
    • VMware
  • Certifications
    • Microsoft Technical
      • MCSA
      • MCSE
      • MCSD
    • Microsoft Office
      • MOS: Associate (Office 365 and Office 2019)
      • MOS: Expert (Office 365 and Office 2019)
      • MOS-Microsoft Office Specialist
      • Microsoft 365 Certified
    • Security
      • 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 Routing and Switching
      • CCNP – Cisco Certified Network Professional
    • 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 CenterAKTINA - 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
        • CND-Certified Network Defender
        • CSCU – Certified Secure Computer User
        • CEH-Certified Ethical Hacker v11
        • CAST 611-Advanced Penetration Testing
        • CCNA-Security
        • CISM – Certified Information Security Manager
        • CISA-Certified Information Systems Auditor
      • Adobe
        • Photoshop-Basic
        • Photoshop-Advanced
        • Illustrator
        • InDesign
        • Dreamweaver
        • Flash
        • Premiere Pro
      • Blockchain
      • Digital Marketing
      • Cisco
      • Oracle
      • Linux
        • LPI
        • Red Hat
      • Autodesk
      • Project Management
      • Service Management
      • SPSS
      • Web Design
      • VMware
    • Certifications
      • Microsoft Technical
        • MCSA
        • MCSE
        • MCSD
      • Microsoft Office
        • MOS: Associate (Office 365 and Office 2019)
        • MOS: Expert (Office 365 and Office 2019)
        • MOS-Microsoft Office Specialist
        • Microsoft 365 Certified
      • Security
        • 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 Routing and Switching
        • CCNP – Cisco Certified Network Professional
      • 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
      • 20762: Developing SQL Databases– Official Microsoft Course

      20762: Developing SQL Databases– Official Microsoft Course

      User Avatar
      aktina
      SQL Server
      Free
      2016-sql-server-logo
      • Course Overview
      • Course Outline
      • Course Arrangements
      • Costs
      Introduction
      This five-day instructor-led course provides students with the knowledge and skills to develop a Microsoft SQL Server 2016 database. The course focuses on teaching individuals how to use SQL Server 2016 product features and tools related to developing a database.
      Audience:
      The primary audience for this course is IT Professionals who want to become skilled on SQL Server 2016 product features and technologies for implementing a database.
      The secondary audience for this course are individuals who are developers from other product platforms looking to become skilled in the implementation of a SQL Server 2016 database.
      At Course Completion

      After completing this course, students will be able to:

      • Design and Implement Tables
      • Describe advanced table designs
      • Ensure Data Integrity through Constraints
      • Describe indexes, including Optimized and Columnstore indexes
      • Design and Implement Views
      • Design and Implement Stored Procedures
      • Design and Implement User Defined Functions
      • Respond to data manipulation using triggers
      • Design and Implement In-Memory Tables
      • Implement Managed Code in SQL Server
      • Store and Query XML Data
      • Work with Spatial Data
      • Store and Query Blobs and Text Documents
      Prerequisites
      • Basic knowledge of the Microsoft Windows operating system and its core functionality
      • Working knowledge of Transact-SQL
      • Working knowledge of relational databases
      Professional Exam(s)
      Exam 70-762: Developing SQL Databases
      Certification(s):
      MCSA: SQL 2016 Database Development
      CoursesMicrosoft TechnicalSQL Server20762: Developing SQL Databases– Official Microsoft Course
      • MODULES 18

        • Lecture1.1
          Introduction to Database Development
        • Lecture1.2
          Designing and Implementing Tables
        • Lecture1.3
          Advanced Table Designs
        • Lecture1.4
          Ensuring Data Integrity through Constraints
        • Lecture1.5
          Introduction to Indexes
        • Lecture1.6
          Designing Optimized Index Strategies
        • Lecture1.7
          Columnstore Indexes
        • Lecture1.8
          Designing and Implementing Views
        • Lecture1.9
          Designing and Implementing Stored Procedures
        • Lecture1.10
          Designing and Implementing User-Defined Functions
        • Lecture1.11
          Responding to Data Manipulation via Triggers
        • Lecture1.12
          Using In-Memory Tables
        • Lecture1.13
          Implementing Managed Code in SQL Server
        • Lecture1.14
          Storing and Querying XML Data in SQL Server
        • Lecture1.15
          Storing and Querying Spatial Data in SQL Server
        • Lecture1.16
          Storing and Querying BLOBs and Text Documents in SQL Server
        • Lecture1.17
          SQL Server Concurrency
        • Lecture1.18
          Performance and Monitoring
      City
      Nicosia
      Dates and Times
      1. Wednesday February 20 8:00 - 15:10
      2. Friday February 22 8:00 - 15:10
      3. Tuesday February 26 8:00 - 15:10
      4. Thursday February 28 8:00 - 15:10
      5. Monday March 4 8:00 - 15:10
      6. Wednesday March 6 8:00 - 15:10
      Duration (Hours)
      40
      Location
      20 Louki Akrita street, 2064 Strovolos
      (behind Kykko secondary schools)
      City
      Limassol
      Dates and Times
      1. Wednesday March 13 8:30 - 15:40
      2. Friday March 15 8:30 - 15:40
      3. Monday March 18 8:30 - 15:40
      4. Wednesday March 20 8:30 - 15:40
      5. Friday March 22 8:30 - 15:40
      6. Wednesday March 27 8:30 - 15:40
      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 20762Official - digital70-762
      Amount€525,00€205,00€100,00
      VAT * €228,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 20762Official - digital70-762
      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 20761 & 20762Official 20761 & 2076270-761 & 70-762
      Amount€340,00€382,00
      -
      VAT * €323,00€72,58
      -
      * 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 20761 & 20762Official 20761 & 2076270-761 & 70-762
      Amount€840,00€382,00€200,00
      VAT€159,00€72,58
      -
      .

       

       

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

      You May Like

      20461: Querying Microsoft SQL Server – Official Microsoft Course Read More
      aktina

      20461: Querying Microsoft SQL Server – Official Microsoft Course

      0
      Free
      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
      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