MICROSOFT SQL

learning-partner
PostgreSQL

Course Information

This three-day instructor-led course is aimed toward people looking to maneuver 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 that are getting into a database role, or whose role has expanded to incorporate database technologies.

Skills gained
  • Describe key database concepts within the context of SQL Server 2016
  • Describe database languages utilized in SQL Server 2016
  • Describe data modelling techniques
  • Describe normalization and denormalization techniques
  • Describe relationship types and effects in database design
  • Describe the consequences of database design on performance
  • Describe commonly used database objects
Prerequisites

This is a foundation level course and thus only requires general computer literacy.

This four-day instructor-led course provides students who manage and maintain SQL Server databases with the knowledge and skills to performance tune and optimize their databases.

Audience profile

The primary audience for this course is individuals who administer and maintain SQL Server databases and are liable for optimal performance of SQL Server instances that they manage. These individuals also write queries against data and wish to make sure optimal execution performance of the workloads.

Skills gained
  • Describe the high level architectural overview of SQL Server and its various components.
  • Describe the SQL Server execution model, waits and queues.
  • Describe core I/O concepts, cargo area Networks and performance testing.
  • Describe architectural concepts and best practices associated with data files for user databases and TempDB.
  • Describe architectural concepts and best practices associated with Concurrency, Transactions, Isolation Levels and Locking.
  • Describe architectural concepts of the Optimizer and the way to spot and fix query plan issues.
  • Describe architectural concepts, troubleshooting scenarios and best practices associated with Plan Cache.
  • Describe architectural concepts, troubleshooting strategy and usage scenarios for Extended Events.
  • Explain data collection strategy and techniques to research collected data.
  • Understand techniques to spot and diagnose bottlenecks to enhance overall performance.
Prerequisites

In addition to their professional experience, students who attend this training should have already got the subsequent technical knowledge:

  • Basic knowledge of the Microsoft Windows OS and its core functionality.
    Working knowledge of database administration and maintenance.
    Working knowledge of Transact-SQL.

This course is meant to introduce students to Transact-SQL. it's designed in such how that the primary three days are often taught as a course to students requiring the knowledge for other courses within the SQL Server curriculum. Days 4 & 5 teach the remaining skills required to require exam 70-761.

Audience profile

The main purpose of the course is to offer students an honest understanding of the Transact-SQL language which is employed by all SQL Server-related disciplines; namely, Database Administration, Database Development and Business Intelligence. As such, the first audience for this course is: Database Administrators, Database Developers and BI professionals.

Skills gained
  • Describe key capabilities and components of SQL Server.
  • Describe T-SQL, sets, and predicate logic.
  • Write one table SELECT statement.
  • Write a multi-table SELECT statement.
  • Write SELECT statements with filtering and sorting.
  • Describe how SQL Server uses data types.
  • Write DML statements.
  • Write queries that use built-in functions.
  • Write queries that aggregate data.
  • Write subqueries.
  • Create and implement views and table-valued functions.
  • Use set operators to mix query results.
  • Write queries that use window ranking, offset, and aggregate functions.
  • Transform data by implementing pivot, unpivot, rollup and cube.
  • Create and implement stored procedures.
  • Add programming constructs like variables, conditions, and loops to T-SQL code.

Prerequisites

  • Basic knowledge of the Microsoft Windows OS and its core functionality.
  • Working knowledge of relational databases.

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'll be of use to individuals who develop applications that deliver content from SQL Server databases.

Audience profile

The primary audience for this course is individuals who administer and maintain SQL Server databases. These individuals perform database administration and maintenance as their primary area of responsibility, or add environments where databases play a key role in their primary job.

The secondary audiences for this course are individuals who develop applications that deliver content from SQL Server databases.

Skills gained
  • Authenticate and authorize users
  • Assign server and database roles
  • Authorize users to access resources
  • Protect data with encryption and auditing
  • Describe recovery models and backup strategies
  • Backup SQL Server databases
  • Restore SQL Server databases
  • Automate management
  • Configure security for the SQL Server agent
  • Manage alerts and notifications
  • Managing SQL Server using PowerShell
  • Trace access to SQL Server
  • Monitor a SQL Server infrastructure
  • Troubleshoot a SQL Server infrastructure
  • Import and export data
Prerequisites

In addition to their professional experience, students who attend this training should have already got the subsequent technical knowledge:

  • Basic knowledge of the Microsoft Windows OS and its core functionality.
  • Working knowledge of Transact-SQL.
  • Working knowledge of relational databases.
  • Some experience with database design.

This five-day instructor-led course provides students with the knowledge and skills to provision a Microsoft SQL Server database. The course covers SQL Server provision both on-premise and in Azure, and covers installing from new and migrating from an existing install.

Audience profile

The primary audience for this course are database professionals who got to fulfil a Business Intelligence Developer role. they're going to got to specialise in hands-on work creating BI solutions including Data Warehouse implementation, ETL, and data cleansing.

Skills gained
  • Describe the key elements of a knowledge warehousing solution
  • Describe the most hardware considerations for building a knowledge warehouse
  • Implement a logical design for a knowledge warehouse
  • Implement a physical design for a knowledge warehouse
  • Create columnstore indexes
  • Implementing an Azure SQL Data Warehouse
  • Describe the key features of SSIS
  • Implement a knowledge flow by using SSIS
  • Implement control flow by using tasks and precedence constraints
  • Create dynamic packages that include variables and parameters
  • Debug SSIS packages
  • Describe the considerations for implement an ETL solution
  • Implement Data Quality Services
  • Implement a Master Data Services model
  • Describe how you'll use custom components to increase SSIS
  • Deploy SSIS projects
  • Describe BI and customary BI scenarios
Prerequisites

In addition to their professional experience, students who attend this training should have already got the subsequent technical knowledge:

  • Basic knowledge of the Microsoft Windows OS and its core functionality.
  • Working knowledge of relational databases.
  • Some experience with database design.

The focus of this 3-day instructor-led course is on creating managed enterprise BI solutions. It describes the way to implement both multidimensional and tabular data models and the way to make cubes, dimensions, measures, and measure groups. This course helps you steel oneself against the Exam 70-768.

Audience profile

The primary audience for this course are database professionals who got to fulfil BI Developer role to make enterprise BI solutions. Primary responsibilities will include:

  • Implementing multidimensional databases by using SQL Server Analysis Services
  • Creating tabular semantic data models for analysis by using SQL Server Analysis Services
Skills gained
  • Describe the components, architecture, and nature of a BI solution
  • Create a multidimensional database with Analysis Services
  • Implement dimensions during a cube
  • Implement measures and measure groups during a cube
  • Use MDX syntax
  • Customize a cube
  • Implement a tabular database
  • Use DAX to question a tabular model
  • Use data processing for predictive analysis
Prerequisites

Before attending this course, students must have:

Experience of querying data using Transact-SQL

This Four-day instructor-led course provides students with the knowledge and skills to research data with Power BI.

Audience profile

The primary audience for this course is BI professionals who got to analyze data utilizing Power BI. The secondary audiences for this course are technically proficient business users.

Skills gained
  • Describe self-service BI.
  • Describe the facility BI suite of products.
  • Connect to data sources and optimize data models.
  • Shape and mix data from different sources.
  • Model data.
  • Create reports and manage solutions.
  • Describe the facility BI developer API.
  • Describe the facility BI mobile app.

Contact us for Analyzing Data with Power BI Training in Dubai UAE.

Prerequisites

In addition to their professional experience, students who attend this training should have already got the subsequent technical knowledge:

  • Basic knowledge of the Microsoft Windows OS and its core functionality.
  • Basic knowledge of knowledge warehouse schema topology (including star and snowflake schemas).
  • Some exposure to basic programming concepts (such as looping and branching).
  • An awareness of key business priorities like revenue, profitability, and financial accounting is desirable.
  • Familiarity with Microsoft Office applications – particularly Excel.

The main purpose of the course is to offer students the power to feature BI techniques to Excel data analysis. The course goes beyond the capabilities of tables and charts and uses Pivot Charts, the Excel Data Model, and Power BI.

Audience profile

This course is meant for college kids who are experienced with analyzing data with Excel and who wish to feature BI techniques.

The course will likely be attended by SQL Server report creators who have an interest in alternative methods of presenting data.

Skills gained
  • Explore and extend a classic Excel dashboard.
  • Explore and extend an Excel data model.
  • Pre-format and import a .CSV file.
  • Import data from a SQL Server database
  • Import data from a report.
  • Create measures using advanced DAX functions.
  • Create data visualizations in Excel.
  • Create an influence BI dashboard with Excel.
Prerequisites

Before attending this course, students must have:

  • Basic knowledge of the Microsoft Windows OS and its core functionality.
    Working knowledge of relational databases.
    Extensive knowledge of Excel spreadsheets including formulas, charts, filtering, sorting, and sub-totals.
    Basic knowledge of knowledge analytics like having attended course 10994.

This three-day instructor-led course is meant for database administrators and Windows engineers to familiarize them with the concepts in SQL AlwaysOn and High Availability. The course utilizes SQL 2016, but explains the differences from SQL 2012- SQL 2014.

Audience profile

Experienced DBAs, Windows Server pros, team leads. this is often a lab intense course! We designed this course supported our experience of getting taught many classes to literally thousands of scholars . We tried very hard to form the labs, of which there are over 30, very oriented to one concept like Adding a reproduction or Transferring Logons. 

Skills gained
  • Understand Always On High Availability
  • Employ Server 2016 Failover Clustering
  • Deploy SQL Failover Clusters
  • Work with Availability Groups
  • Perform maintenance
  • Monitor and Troubleshoot Availability Groups
Prerequisites

Before attending this course, students must have:

  • Experience as SQL DBA
  • Experience as Windows IT PRO

This four-day instructor-led course provides students who manage and maintain SQL Server databases with the knowledge and skills to performance tune and optimize their databases.

Audience profile

The primary audience for this course is individuals who administer and maintain SQL Server databases and are liable for optimal performance of SQL Server instances that they manage. These individuals also write queries against data and wish to make sure optimal execution performance of the workloads.

The secondary audiences for this course are individuals who develop applications that deliver content from SQL Server databases.

Skills gained
  • Describe the high level architectural overview of SQL Server and its various components.
  • Describe the SQL Server execution model, waits and queues.
  • Describe core I/O concepts, cargo area Networks and performance testing.
  • Describe architectural concepts and best practices associated with data files for user databases and TempDB.
  • Describe architectural concepts and best practices associated with Concurrency, Transactions, Isolation Levels and Locking.
  • Describe architectural concepts of the Optimizer and the way to spot and fix query plan issues.
  • Describe architectural concepts, troubleshooting scenarios and best practices associated with Plan Cache.
  • Describe architectural concepts, troubleshooting strategy and usage scenarios for Extended Events.
  • Explain data collection strategy and techniques to research collected data.
  • Understand techniques to spot and diagnose bottlenecks to enhance overall performance.
Prerequisites

In addition to their professional experience, students who attend this training should have already got the subsequent technical knowledge:

  • Basic knowledge of the Microsoft Windows OS and its core functionality.
  • Working knowledge of database administration and maintenance.
  • Working knowledge of Transact-SQL.

This five-day instructor-led course teaches students the way to implement a SQL Server 2016 Reporting Services solution for data analysis in a corporation . The course discusses the way to use the Reporting Services development tools to make and manage reports and implement self-service BI solutions.

Audience profile

The primary audience for this course is database professionals who got to fulfil a BI developer role to make reports. Primary responsibilities will include implementing reports and mobile reports.

The secondary audiences for this course are power information workers.

Skills gained
  • Describe reporting services and it’s components
  • Describe reporting services data sources
  • Implement paginated reports
  • Work with reporting services data
  • Visualize data with reporting services
  • Aggregate report data
  • Share reporting services reports
  • Administer reporting services
  • Expand and integrate reporting services
  • Describe mobile reports
  • Develop mobile reports.
Prerequisites

Before attending this course, students must have:

  • Basic knowledge of the Microsoft Windows OS and its core functionality.
  • Working knowledge of Transact-SQL, like that taught in 20761C.

This course is meant to introduce the participant to SQL Business Intelligence Semantic Model (BISM) Tabular mode, data modeling, and DAX.

Audience profile

The course is targeted towards business analysts, business intelligence developers, and SQL Professionals.

Skills gained
  • Understand Analysis Services Installation and Architecture: One Product, Two Models.
  • Understand version changes: SQL Server Analysis Services.
  • Understand important terms.
  • Understand and utilize SQL Server Data Tools for Tabular.
  • Understand and utilize projects.
  • Understand and utilize importing.
  • Understand and utilize loading data.
  • Understand and utilize examining views.
  • Understand and utilize deployment.
  • Understand and utilize data sources.
  • Understand and utilize data credentials.
  • Understand and utilize SQL as a source.
  • Understand and utilize Excel as a source.
  • Understand and utilize Flat Files as a source.
  • Understand and utilize Azure as a source.
  • Understand and utilize SharePoint as a source.
  • Understand and utilize sorting during load.
  • Understand querying with MDX.
  • Understand and utilize DAX syntax.
  • Understand and utilize DAX data types and operator overloading.
  • Understand and utilize DAX operators.
  • Understand and utilize DAX values.
  • Understand and utilize measures.
  • Understand and utilize calculated columns.
  • Understand evaluation contexts.
  • Understand and utilize date calculations.
  • Understand and utilize importing related tables.
  • Understand and utilize creating relationships.
  • Understand and utilize hierarchies.
  • Understand Direct Query.
  • Understand and utilize KPIs.
  • Understand drillthrough.
  • Understand perspectives.
  • Understand and utilize PowerPivot.
  • Understand and utilize Pivot Tables.
  • Understand and utilize Power View.
Prerequisites

A working knowledge of SQL Server

Who can take up Microsoft SQL Course?

  • IT professionals
  • Database developers
  • Power information workers
  • Business intelligence professionals
  • Data scientists
  • SQL Server database administrators
  • Developers

The Trainer’s extensive background is excellently complimented by hands-on experience in Microsoft SQL right from inception to completion. 

The Trainer provides complete freedom to the candidates to explore the subject and learn based on real-time examples. The trainer helps the candidates in completing their projects and prepares them for interview questions and answers. Candidates are free to ask any questions at any time.

  • More than 7+ Yearsof Experience.
  • Trained more than 1000+students in a year.
  • Strong Theoretical & Practical Knowledge.
  • Certified Professionals with High Grade.
  • Expert level Subject Knowledge and fully up-to-date on real-world industry applications.
  • Trainer has experienced on multiple real-time projects in their Industries.

Inquire about this Course

Whatsapp link for Counseltrain Microsoft SQL Course

Contact Us

    Corporate Training Options

    Online Instructor Led


    Connect Online from Anywhere

    Onsite Training

    Deliver at your Work Location

    Classroom Training

    Customized to your Team’s needs

    Our Corporate Clients

    TRA
    KAUST
    SIEMENS
    Highnoon
    SIDF
    Etisiat
    Saudi Ceramics
    Borouge
    Moro
    Al Jazeera

    Not sure,
    which course to choose?