Course Database Analyst I - Key Skills
The Database Analyst I competence course is intended for all interested participants who want to find employment on the...
The Database Analyst I competence course is intended for all interested participants who want to find employment on the labor market and learn to work with database functions. The package consists of the Power BI - 1 course and SQL SERVER Working with a Database 1. Only the course start is shown in the date; we will inform you about the other dates.
Minimum input knowledge
Computer skills at the level of a regular user and mastery of Excel at least at a slightly advanced level are required.
Course dates Database Analyst I - Key Skills
Daily courses (5 days): 09:00 - 15:00
Course price: 637.40 / 784.00 EUR
without VAT / incl. VAT
This course can be completed free of charge within the support program for ZoZ employed applicants.
If you are interested in attending the course free of charge, you can find more information at the following link:
Training syllabus Database Analyst I - Key Skills
Power BI 1.
- Application description
Getting Data from Various Sources
- from Excel from text files from the web from a database
Editing Data in the Power Query Editor
Creating a Data Model
- multiple tables in the data model Relationships between tables Date table Hierarchy Selected DAX functions - row, table Weights
Data Visualization
- different visuals - table, matrix charts visual formatting show / hide details
Filters
- at visual level at page level at report level
Create Your Own Tooltip
Creating a Detail Page
Report Reversal Options
SQL SERVER Working with a Database 1.
- overview and familiarization with the Microsoft SQL Server environment installation and basic database setup - creating and editing databases, explanation and division by types tables - creating and editing tables, setting data types keys and relational relationships between tables creating database diagrams working with data, creating and editing views, benefits of their use, working with data in tables ensuring data integrity working with data, filtering, working with multiple tables, joins, views, stored procedures, Triggers, transactions, lock types and their use SQL language syntax T-SQL commands SELECT, INSERT, UPDATE, DELETE, CREATE TABLE, ALTER TABLE Nested functions and SELECTS. Working with text (LTRIM, RTRIM, UPPER, LOWER, LEN). Data cleaning (LEFT, RIGHT, SUBSTRING, REPLACE, CONCAT, CHARINDEX, REPLICATE, STUFF). Conversion between individual data formats (CONVERT, CAST, TRY_CAST, TRY_CONVERT). Joining tables (UNION, UNION ALL, INTERSECT, EXCEPT, SELF JOIN). Temporary tables (Common Table Expression, TEMP Table). Searching data using Windows Function (Aggregate Function, Ranking Function, Value Function). Query Tuning.
Output knowledge
The course participant will gain basic skills in working with a database using SQL language commands and functions in the Microsoft SQL Serv...
The course participant will gain basic skills in working with a database using SQL language commands and functions in the Microsoft SQL Server environment and will learn the basics of data processing and visualization using the modern and powerful Power BI application.
Recommended courses after completing Database Analyst I - Key Skills
Show all courses from category SQL, Oracle, Access courses
Contact us
If you need a custom date, group training, or help choosing the right course, contact Macrosoft directly. We will help you with the next step.
Need more details?
Open the contact page for a full enquiry flow, company billing details, and directions to the training centre.
Course Reviews Database Analyst I - Key Skills
This course has no published reviews yet.
You can add a review after completing the course.