Course List

  • Home -
  • Course List

Data Analyst Part2

Data Analyst 2 бол SQL болон Python-ы гайхалтай хослол юм.

course

Data Analyst 2 бол SQL болон Python-ы гайхалтай хослол юм.
Structured Query Language (SQL)-ы ашиглаж сурснаар та өгөгдлийн санд хадгалагдсан өгөгдлийг задлах, дүн шинжилгээ хийх, хүснэгтүүдийг нэгтгэх ажлыг сурч илүү боловсронгуй болгох боломжтой болно. Мөн та дэд каталогиуд болон зарим функцуудыг ашиглан илүү цогц шинжилгээ хийх өргөн боломжтой болно.

Python нь танд код бичих болон SQL query-нүүдийг ашиглан илүү нарийн тооцоо болон датабазыг задлах боломжыг өгөх бөгөөд Matplotlib болон Pandas library-г дүрсэлж харуулах боломжтой.

Эцэст нь та Datа Analyst 2 сургалтаар үр ашигтай SQL query-нүүд бичих, ахисан түвшний Python код ашиглан өргөн цар хүрээ бүхий дата дээр анализ хийх чадвартай дата мастер болох боломжтой.

1. What is software integration?
     1.1 Properties and Definitions: Data, Servers, Clients, Requests and Responses
     1.2 Properties and Definitions: Data Connectivity, APIs, and Endpoints
     1.3 Further Details on APIs
     1.4 Text Files as Means of Communication
     1.5 Definitions and Applications
2. Setting up the working environment
     2.1 Setting Up the Environment
     2.2 Why Python and why Jupyter?
     2.3 Installing Anaconda
     2.4 The Jupyter Dashboard
     2.5 Installing sklearn
     2.6 Installing Packages - Exercise and Solution
3. Preprocessing
     3.1 What to Expect from the Next Couple of Sections
     3.2 Data Sets in Python
     3.3 Data at a Glance
     3.4 Removing Irrelevant Data (EXERCISE and SOLUTION)
     3.5 Splitting a Column into Multiple Dummies (EXERCISE and SOLUTION)
     3.6 Grouping - Transforming Dummy Variables into Categorical Variables
     3.7 Concatenating Columns in Python (EXERCISE and SOLUTION)
     3.8 Changing Column Order in Pandas DataFrame (EXERCISE and SOLUTION)
     3.9 Implementing Checkpoints in Coding (EXERCISE and SOLUTION)
     3.10 Exploring the Initial “Date” Column (EXERCISE and SOLUTION)
     3.11 Machine Learning and Problems
     3.12 Final EXERCISE and SOLUTION


4. Installing MySQL
    4.1 Setting Up a Connection
    4.2 Introduction to the MySQL Interface
5. Connecting Python and SQL
    5.1 Creating a Database in MySQL
    5.2 Importing and Installing python packages
    5.3 Creating a Connection and Cursors
    5.4 Creating the tables in MySQL
    5.5 Running an SQL SELECT Statement from Python
    5.6 Transferring Data from Jupyter
6. SQL query
    6.1 What is SQL and The SQL Tutorial for Data Analysis
    6.2 SQL SELECT
    6.3 SQL LIMIT
    6.4 SQL WHERE
    6.5 SQL Comparison Operator
    6.6 SQL Logical Operators
    6.7 SQL LIKE
    6.8 SQL IN
    6.9 SQL BETWEEN
    6.10 SQL IS NULL
    6.11 SQL AND
    6.12 SQL OR
    6.13 SQL NOT
    6.14 SQL ORDER BY


7. Analyzing data in Tableau
    7.1 Age vs Probability analyze
    7.2 Reasons vs Probability analyze
    7.3 Reasons vs Probability analyze
    7.4 Transportation Expense vs Probability analyze
 

Our training center has foreigner and local instructors. We are offering qualified Oracle Expert instructor who is Mr. Sukhbaatar.

Our instructor’s certificate list:

-Oracle Certified Expert, Oracle Database 12c: RAC and GRID Infrastructure Administration

-Oracle Exadata Database Machine and Cloud Service 2017 Implementation Essentials

-Oracle Certified Professional, 12c Oracle Database

-Oracle Database 11g Administrator Certified Associate