Microsoft SQL Server is a relational database management system developed by Microsoft. As a database server, it is a software product with the primary function of storing and retrieving data as requested by other software applications - which may run either on the same computer or on another computer across a network (including the Internet). Microsoft markets at least a dozen different editions of Microsoft SQL Server, aimed at different audiences and for workloads ranging from small single-machine applications to large Internet-facing applications with many concurrent users.
Zakopane
Dafne, Jagiellońska 30, Zakopane, Poland, 34-500
The training room is located just 350 meters from the railway and bus stations and 700 meters from Krupówki, the main shopping street in Zakopane. There is a fenced parking area on the premises, providing convenience for participants traveling by car and facilitating access to the facility.
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.
Audience Profile
The primary audience for this course is people who are moving into a database role, or whose role has expanded to include database technologies.
At Course Completion
After completing this course, students will be able to:
• Describe key database concepts in the context of SQL Server 2016
• Describe database languages used in SQL Server 2016
• Describe data modelling techniques
• Describe normalization and denormalization techniques
• Describe relationship types and effects in database design
• Describe the effects of database design on performance
• Describe commonly used database objects
About This Course
This course will discuss the various methods and best practices that are in line with business and technical requirements for modeling, visualizing, and analyzing data with Power BI. The course will also show how to access and process data from a range of data sources including both relational and non-relational data. This course will also explore how to implement proper security standards and policies across the Power BI spectrum including datasets and groups. The course will also discuss how to manage and deploy reports and dashboards for sharing and content distribution.
Audience Profile
The audience for this course are data professionals and business intelligence professionals who want to learn how to accurately perform data analysis using Power BI. This course is also targeted toward those individuals who develop reports that visualize data from the data platform technologies that exist on both in the cloud and on-premises.
Skills gained
This three-day instructor-led course provides students moving from earlier releases of SQL Server with an introduction to the new features in SQL Server 2016.
Skills gained
Describekey capabilities and components of SQL Server 2016
Describe new and enhanced features in SQL Server performance
Describes new and enhanced features in SQL Server security
Describe what’s new inSQL Server Availability and Scalability
Describe new and enhanced features in reporting and PowerBIin SQL Server 2016
Describe new and enhanced data access features
Describe new and enhanced features in SQL Server OLAP
This five-day instructor-led course provides students with the knowledge and skills to maintain a Microsoft SQL Server 2014 database. The course focuses on teaching individuals how to use SQL Server 2014 product features and tools related to maintaining a database.
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.
This five-day instructor-led course provides students who administer and maintain SQL Server databases with the knowledge and skills to administer an SQL server database infrastructure. Additionally, it will be of use to individuals who develop applications that deliver content from SQL Server databases.
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.
Skills gained
Describe key database concepts in the context of SQL Server 2016
Describe database languages used in SQL Server 2016
Describe data modelling techniques
Describe normalization and denormalization techniques
Describe relationship types and effects in database design
Describe the effects of database design on performance
Describe commonly used database objects
Read more...
Last Updated:
Testimonials (1)
Best practices for building a data model and best practices for visual elements in a report not covered in official materials. Many examples from projects.
Abc Xyz
Course - Microsoft Power BI Data Analyst (szkolenie autoryzowane PL-300)
Online Authorized SQL Server training in Zakopane, Authorized SQL Server training courses in Zakopane, Weekend Authorized SQL Server courses in Zakopane, Evening Authorized SQL Server training in Zakopane, Authorized SQL Server instructor-led in Zakopane, Authorized SQL Server on-site in Zakopane, Weekend Authorized SQL Server training in Zakopane, Authorized SQL Server boot camp in Zakopane, Authorized SQL Server one on one training in Zakopane, Authorized SQL Server classes in Zakopane, Authorized SQL Server instructor-led in Zakopane, Authorized SQL Server instructor in Zakopane, Online Authorized SQL Server training in Zakopane, Evening Authorized SQL Server courses in Zakopane, Authorized SQL Server trainer in Zakopane, Authorized SQL Server coaching in Zakopane, Authorized SQL Server private courses in Zakopane
