top of page

SQL სილაბუსი 
Module 1: Introduction to Basic Database Concepts
In this module we learn about Basic concepts and advantages of DBMS and limitations of file management system ,and also about 3 data base modelsWhat is Data, Field, Record and database?Limitations of File Management System.Basic Concepts of Advantages of DBMS.❖ Exploring Relational DBMSUnderstanding Client and Server

Module 2: E-R Modeling and Diagram
In this module we learn about entity, attributes and relationship , identify the entities and attributes How to draw a E-R diagram and translating the E-R diagram in relation schema.Analyzing the RequirementIdentify Entities and their RelationshipsDrawing E-R DiagramConversion of E.R. Diagrams into Tables
Module 3: Normalization In this module

we learn about what is normalization,types of normalization, data before and after normalization, benefits of normalization.First Normal FormSecond Normal FormThird Normal Form Practically Normalizing Tables
Module 4: Introduction to SQL Server
In this module we learn about SQL Server,history of sql server ,types of system databases,communication between frontend and backend and sql server editions.What is SQL Server Version history and different editionsBasic Features Components and ToolsStarting and Stopping SQL Server Instances / ServicesIntroduction to Management StudioTypes of System Databases in SQL.

Module 5: Introduction to SQL

In this module we learn about types of sql statements,databases in sql server, how to create a database, datatypes in sql server,and about DDL Statements.Basics of SQL Types of SQL StatementsDDL, DML, DQL, DCL and TCLCreate Database using Management StudioDatatypes in SQL ServerExploring DDL Statements on Table using Management Studio

Module 6: Aggregate Functions
In this module we learn about how to use aggregate functions like sum,mean,max,avg what is difference between having and where clause, group by clause rollup and cube operator.Using functions in Queries❖ Count, Sum, Min, Max, Avg Group By and Having ClauseUsing Group By with Rollup and Cube

Module 7: Joins and Set Operations
In this module we will know about joins and types of joins how to join the tables and aboutSub queries ,types of operators like union ,intersect and except and how to add the tables and relationship between them.Introduction to Joins Cross JoinsInner JoinOuter JoinSelf JoinCo-related Sub QueriesSet Operations using Unions, Intersect and Except.

Module 8: Implementation of Data integrity
In this module , we will learn correctness of data and types of integrity and types of constraints.Entity integrityDomain integrityReferential integrityTypes of constraints

Module 9:Working with Constraints
In this module, we will learn about how to create a constraint,types of constraints,and difference between unique, not null and primary key constraints.UniqueNot NULLPrimary KeyDefault Check Foreign Key

TABLEAU სილაბუსი

Introduction to TableauWhat is TableauArchitecture of TableauFeatures of TableauInstallation of Tableau Desktop/PublicInterface of Tableau (Layout, Toolbars, Data pane, Analytics pane etc)How to start with TableauTop Chart in TableauIntroduction to the various file typeQuick Introduction to the user interface in tableauHow to create data visualization using Tableau feature “show me”Reorder and Remove Visualization FieldsHow to create calculated fieldHow to perform operation using cross tabWorking with workbook data and Worksheet.

 

 

Basic Data Visualization/Graph

Pivot table and Heat Map

Highlight Table

Bar Chart

Line Chart

Area Chart

 

Building View Advance Map Option

  • Explain latitude and longitude
  • Default location/Edit locations
  • Symbol map & Filled Map
  • Map Layer
  • Image in map
  • Map option

 

 

Data Preparation

  • Connecting to different Data Source
  • Excel
  • CSV
  • SQL Server
  • Live vs Extract Connection
  • Creating Extract
  • Refreshing Extract
  • Increment Extract
  • Refreshing Live
  • Data Source Editor
  • Pivoting and splitting
  • Data Interpreter: Clean Dirty Data
  • TWB vs TWBX
  • How to create a packaged workbook
  • Difference between .tde and .hyper file


    Advanced Data Preparation
    JoinsInnerLeftRightOuterComplex JoinReferential IntegrityUnionData Blending and when requiredCross DB Join


 

Data Visualization Principles

  • Why visualization came into the picture?
  • Importance of visualizing data
  • Poor visualization vs Perfect visualization
  • Principal of visualization
  • Goal of Data visualization


    Advance Calculation
  • Table Calculation
  • Running total
  • Percent
  • Percent total
  • Year over Year Growth
  • LOD
  • Include
  • Exclude
  • Fixed

 

Grouping Data/Dynamic Representation

  • Groups
  • Sets
  • In/Out Sets
  • Combined Sets
  • Top and Bottom in Single view Parameters
  • Dynamic Measure
  • Dynamic Dimension
  • Hierarchies
  • Bins
  • Combined Field
     

 

Sharing Your Dashboard

  • Publishing to PDF
  • Exporting to Pivot Table and Images
  • Exporting Packaged workbooks
  • Tableau Reader
  • Tableau Online
  • Tableau Server
  • Tableau Public
  • Version Control
  • Publishing to Tableau Server

 

 

Projects

  • Financial Analysis Dashboard
  • HR Analysis Dashboard
  • Market Analysis Dashboard
  • Tourism Analysis Dashboard
  • New Business Analysis Dashboard
  • Banking Sector Analysis
  • Issue & Bug reporting Analysis
  • Population Trend Analysis

 

 

 

SQL + Tableau BI კურსი

SKU: 006
1 800,00GEL Regular Price
1 620,00GELSale Price

    Related Products