Industry Certifications for IT & Management:
Updating Your Skills To SQL Server 2017 M10998
500 Learners
Foundation
This SQL workshop is for beginners interested in learning Microsoft SQL Server Database 2017. Microsoft SQL Server developers earn a higher salary in the IT industry, but it's not about writing queries. It's about understanding and applying the right question at the right time. This course will let you easily understand the SQL Server concepts.
Updating Your Skills To SQL Server 2017 M10998
Accreditation With
Updating Your Skills To SQL Server 2017 Course Overview
SQL Server 2017 updated Microsoft's enterprise relational database platform with new features, including support for running on Linux and Docker containers, Python programming support (on top of R introduced in the previous version), graph data support, adaptive query processing, and helpful improvements to almost every area of the platform, including T-SQL, SSRS, and SSIS. SQL Server 2019 brought more updates, introducing Big Data Clusters for SQL Server and adding support for deployment of databases as Docker containers using Kubernetes. In addition added many new features to the database engine, Analysis Services, Machine Learning Services, and more.
What You Will Learn?
  • Start from scratch by installing Microsoft SQL Server 2017 and create a practice environment for yourself.
  • You will be familiarized with some of the core concepts of RDBMS / SQL Server.
  • You will learn the ins and outs of SQL Server Management studio.
  • You will learn how to create and connect SQL server cloud database using Amazon AWS and Microsoft Azure.
  • You will learn how to create, alter and drop databases.
  • You will learn how to create, alter and drop tables.
  • You will learn how to insert, update and delete records from tables.
  • You will start constructing your SELECT statement to retrieve data from SQL Server.
  • You will know how to filter out unwanted data by using the WHERE clause as well as; you will know how to order your result set by using the ORDER BY clause.
  • You will also see how to use UNION / UNION ALL operators
  • You will see how to group and summarize your data by using, the GROUP BY clause, HAVING clause and Aggregate functions.
  • You will learn Joins in SQL Server. Inner Join, Left Outer Join, Right Outer Join, Full Outer Join, Cross Join and Self Join.
  • You will also know about some string functions, date functions, and system functions.
  • You will learn how to create your function.
  • You will learn how to create, alter and drop Stored Procedures and the advantages of stored procedures.
  • You will learn how to create, alter and drop Triggers and its advantage.
  • You will learn how to create, alter and drop View and its advantage.
  • You will learn about temp tables and its advantage.
  • You will learn how to Handel exceptions in SQL Server.
  • You will learn how to import data from excel files, flat files, another SQL server database and MySQL.
  • You will learn how to export data to an excel file, flat file and another SQL server database.
  • You will learn about Bulk Insert.
  • You will learn about Cursors.
Course Key Features
  • With exam preparation guidance, course materials, pre & post course support
  • Fully accredited as a Microsoft Learning Partner
  • All-inclusive training delivered over two days by an expert trainer
Training Options
In-Class
Starts from
No price
  • 2-days in-class training 
  • Official Curriculum
  • Pre-course consultation
  • Highly experienced instructor(s)
  • Post-course follow-up
  • All related Averest's quality control tools
  • Required stationary
  • 5 or 4 stars training venue
  • 24x7 learner assistance and support
Online Instructor-Led
Starts from
No price
  • 2-days instructor-led training 
  • Official Curriculum
  • Pre-course consultation
  • Highly experienced instructor(s)
  • Post-course follow-up
  • All related Averest's quality control tools
  • Required stationary
  • 5 or 4 stars training venue
  • 24x7 learner assistance and support
Self-Paced
$ 1,500
  • Official Curriculum
  • Case studies
  • Exercise Files
  • Immediate Access for 90 days
  • Train in the comfort of your home
  • 24x7 learner assistance and support
Updating Your Skills To SQL Server Training Schedules
You can get this course with 3 training options and 1 venues
Filter:
Corporate Team Training Enquiry
Bring this or any training to your organization
Corporate Team Training Enquiry
Updating Your Skills To SQL Server Training Curriculum
Eligibility
Job roles that can benefit from Microsoft SQL Server courses include: IT Administrators Architects Application Developers Software Developers BI Developers Directors Cloud Administrators Implementers Web Programmers Business Analysts
Pre-requisites
Before attending this course, you should have experience with: Building and managing databases, data warehouses and business intelligence (BI) solutions with SQL Server 2016 Windows Server 2016 operating systems and networking Microsoft Office 2016
Course Content
Section 01 - Module 1: Introduction to SQL Server 2017
Lessons:
Overview of SQL Server 2017
Functionality across versions
After completing this module, you'll be able to:
Describe the edition scale limits
Explain the consistent functionality across versions
Section 02 - Module 2: What's new in SQL Server Performance, Scalability, and Availability
This module introduces the performance enhancements provided by Adaptive Query Processing and Automatic Tuning, as well as the scalability and availability enhancements provided by new Availability Group architectures, including Read-Scale Availability Groups and Availability Groups with SQL Server on Linux
Lessons:
Adaptive query processing
Automatic tuning
Availability Scalability
Lab: Performance and availability - adaptive query processing
Interleaved execution
Batch mode memory grants feedback
Batch mode adaptive joins
After completing this module, you'll be able to:
Describe adaptive query processing
Describe automatic plan correction
Describe availability group architectures
Describe always-on availability groups for Linux
Describe load-balancing of readable secondary replicas
Describe petabyte-scale data warehousing
Section 03 - Module 3: What's New in SQL Server Data Access
SQL Server 2017 introduces SQL Graph which enables you to define the relationships between your data items in a table rather than calculating them during a query, reducing the query cost and simplifying your data structure.
Lessons:
SQL Graph
Lab: SQL Graph
Create a Graph database
Query a Graph database
After completing this module, you'll be able to:
Describe SQL Graph
Section 04 - Module 4: What's new in SQL Server Reporting and BI
This module describes what’s new in SQL Server reporting and BI.
Lessons:
Power BI report Server
Reporting Services update
Lab: Reporting and BI
Deploy Power BI report server
Add commenting to a report
After completing this module, you'll be able to:
Explain what Power BI report server is
Use Power BI report server
Create a Power BI report foe Power BI report server
Section 05 - Module 5: New and Enhanced Features in SQL Server Analysis Services
This module introduces new and enhanced features in SQL Server Analysis Services, with particular emphasis on the tabular data model.
Lessons:
Tabular model updates
Lab: Ragged hierarchies
View existing reports
Hide blank members
After completing this module, you'll be able to:
Describe the new features of tabular data models
Section 06 - Module 6: New and Enhanced data Analytics Features
This module introduces new and enhanced data analytics features.
Lessons:
New and enhanced data analytics features
Lab: Data analytics with Python
Enable external script execution
Run Python scripts
After completing this module, you'll be able to:
Describe the new and enhanced data analytics features.
Section 07 - Module 7: What's new in SQL Server in the Cloud
Organisations want the best value from a mixture of cloud services and their existing investment in on-premises hardware and software. This module covers a comparison between the features of Microsoft Azure SQL Database and Microsoft SQL Server 2017, as well as new features that make it easier for you to migrate databases from on-premises SQL Server instances to Azure SQL Database.
Lessons:
Azure SQL database features
Managed Instances
Lab: Managed Instances
After completing this module, you'll be able to:
Explain the different features available in Azure SQL database and SQL Server 2017
Describe Azure managed instances
Section 08 - Module 8: SQL Server on Linux
This module covers the features of SQL Server on Linux, as well as the process for deploying SQL Server on Linux and using Docker.
Lessons:
SQL Server on Linux
Deploying SQL Server on Linux
Lab: SQL Server in Docker containers
Deploy a SQL Server Docker image
Run a SQL Server instance inside a Docker container
Connect to a SQL Server Instance running in a Docker container
After completing this module, you'll be able to:
Describe the features of SQL Server on Linux
Describe SQL Server on Linux deployment
Deploy SQL server in a Docker container.
Updating Your Skills To SQL Server 2017 Exam & Certification
On successful completion of this training course, an AVEREST Certificate will be awarded to the delegates
Updating Your Skills To SQL Server 2017 Exam & Certification
You Maybe Interested
Let Us Help You!
Please fill the contact form and we'll get back to you soon.