Course Database Analyst I. - Comprehensive Skills
The Database Analyst I competency course is intended for all applicants who want to find employment in the labor market...
The Database Analyst I competency course is intended for all applicants who want to find employment in the labor market and learn to work with database functions. The package consists of the courses: MS Excel Database Functions: in the scope of 2 days SQL SERVER Working with a Database I.: in the scope of 2 days Power BI - 1: in the scope of 3 days
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. - Comprehensive Skills
Daily courses (7 days): 09:00 - 15:00
Course price: 999.92 / 1 229.90 EUR
without VAT / incl. VAT
This course can be completed free of charge within the support program for UoZ job seekers.
If you are interested in attending the course free of charge, you can find more information at the following link:
The manual is included in the training price.
Training syllabus Database Analyst I. - Comprehensive Skills
Principles When Creating a Database Table
- limitations of Excel and their possible solutions data validation in a database table
Logical Functions
- IF, nested IF AND, OR
Lookup Functions
- INDIRECT LOOKUP, VLOOKUP HLOOKUP, CHOOSE MATCH, INDEX
Database Functions
- DSUM, DAVERAGE DMIN, DMAX DCOUNT, DSTDEV etc.
Formula Debugging
- watch window mode and formula checking panel arrows, Evaluate Formula tools error checking
Working with Automatic and Advanced Filter
- limitations of automatic filter entering complicated filtering conditions use of wildcards in text criteria use of a macro over a table creating simple and nested subtotals tool for consolidating multiple ranges
Working with PivotTables
- working with row, column, page and data area fields setting properties of a table field and also properties of the whole table multiple consolidation ranges calculated field, grouping
Printing Large Tables
- selecting print area page setup discussion conclusion
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 Classification by Table Types
- - creating and editing tables, setting data types, keys and relational relationships between tables
creating database diagrams
- working with data, creating and editing views, advantages 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, Types of Locks 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 Window Functions (Aggregate Function, Ranking Function, Value Function). Query Tuning.
Power BI 1.
- Application description
Getting Data from Different 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 Measures
Data Visualization
- different visuals - table, matrix charts visual formatting show / hide details
Filters
- at visual level at page level at report level
Creating Custom Tooltips
Creating a Details Page
Report Drillthrough Options
Output knowledge
Mastering the basics of data analysis through Power BI and PowerQuery tools. Mastering the basics of the SQL language in the MS SQL Server environment.
Recommended courses after completing Database Analyst I. - Comprehensive 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. - Comprehensive Skills
This course has no published reviews yet.
You can add a review after completing the course.