Showing all 9 results

  • academy-it-microsoft-office-vendor-training
    $1,640.00

    About this course

    This course examines the services and features of Microsoft SQL from 2012 to 2022, including lessons and lab exercises on key attributes you’ll need on the job. It’s designed for novices and professionals who are interested in interacting with databases using Structured Query Language (SQL) and seek foundational knowledge and skills. This audience typically includes people who are moving into a database role or expect their role to require interacting with a database server that uses SQL.

    Course Outline

     

    Select options
  • academy-it-microsoft-office-vendor-training
    $4,100.00

    About this course

    This five-day instructor-led course is intended for IT professionals who are interested in expanding their knowledge base and technical skills about SQL Server. In this course, students learn how to provision SQL Server databases both on-premises and in Azure. The course covers new installations and migrations from existing installations.

    Course Outline

     

    Select options
  • academy-it-microsoft-office-vendor-training
    $2,460.00

    About this course

    55317A is the updated version of the retired legacy MOC course 20461. This three-day course teaches students how to use basic Transact-SQL statements and other languages to query modern editions of Microsoft SQL Server and Azure SQL Server. This course is the foundation for all SQL Server-related disciplines; namely, Database Administration, Database Development and Business Intelligence. By using demonstrations and hands-on labs, attendees will learn to perform these tasks using SQL Server, Azure Data Studio, and other database tools.

    Course Outline

     

    Select options
  • academy-it-microsoft-office-vendor-training
    $2,460.00

    About this course

    This three-day instructor-led course is aimed at people looking to move into a database professional role or whose job role is expanding to encompass database elements. The course describes fundamental database concepts including database types, database languages, and database designs. This course updates and replaces course 10985C previously published under the same title.

    Course Outline

     

    Select options
  • academy-it-microsoft-office-vendor-training
    $4,100.00

    About this course

    This five-day instructor-led course is intended for IT professionals who wish to use the Transact-SQL language to query and configure Microsoft SQL Server. Students are typically database developers and database administrators, but might also be Business Intelligence developers, report creators, or application developers. In this course, students learn how to query single tables, join data from multiple tables, filter and sort data, modify data, use procedures and functions, and implement error handling.

    Course Outline

     

    Select options
  • academy-it-microsoft-office-vendor-training
    $2,460.00

    About this course

    This three-day instructor-led course is aimed at people looking to move into a database professional role or whose job role is expanding to encompass database elements. The course describes fundamental database concepts including database types, database languages, and database designs.

    Course Outline

     

    Select options
  • academy-it-microsoft-office-vendor-training
    $4,100.00

    About this course

    This five-day instructor-led course provides students who administer and maintain SQL Server databases with the knowledge and skills to administer a SQL server database infrastructure. Additionally, it will be of use to individuals who develop applications that deliver content from SQL Server databases.

    Course Outline

     

    Select options
  • academy-it-microsoft-office-vendor-training
    $4,100.00

    About this course

    This five-day instructor-led course provides students who manage SQL Server and Azure SQL databases with the knowledge and skills needed to administer a SQL server database infrastructure. The material will also be useful to individuals who develop applications that deliver content from SQL Server databases. This material updates and replaces course 20764C.

    55316A is the equivalent of the retired legacy MOC Course 20764A – Administering a SQL Database Infrastructure.

    Course Outline

     

    Select options
  • academy-it-microsoft-office-vendor-training
    $1,640.00

    About this course

    In this 2-day course, students will continue their learning on the foundations of report writing with Microsoft® SQL Server® Report Builder and SSRS. The focus will be on report writing by connecting to a database and manipulating the data for presentation including: creating table and matrix reports, formatting reports, grouping report data, creating simple and complex expressions, displaying aggregated data, sorting and filtering data, charting data, and preparing reports for printing and exporting. Report Builder 3.0 is available for Microsoft® SQL Server® versions 2014, 2012, and 2008 R2.

    Course Outline

     

    Select options