• Home
  • About Us
    • About Us
    • Mission & Vision
    • Core values
    • Trainers
    • Feedback
    • Founder
  • Courses
    • Schedule
    • HCM - Fundamental Business Analysis 3.0
    • HCM - Advanced Business Analysis 3.0
    • HCM - Approach for IIBA(ECBA, CCBA, CBAP) Certificates 3.0
    • Hanoi - Fundamental Business Analysis 3.0
    • Hanoi - Advanced Business Analysis 3.0
    • Hanoi - Approach for IIBA(ECBA, CCBA, CBAP) Certificates 3.0
    • Danang - Fundamental Business Analysis 3.0
    • Can Tho - Fundamental Business Analysis 3.0
    • BA for Banking
    • BA for Insurance
    • Agile Application Expert
    • Software Estimation
    • Business Process Management
    • BA & PM collaboration, lead to success
    • Analyzing And Visualizing Data With Tableau
    • Internal BSC-KPI Experts
    • ERP Stratergic Planning, Consultancy and implementation
    • Essentials of Information Security
    • Fundamentals of UI/UX Design
    • Product Design
    • Analyzing And Visualizing Data With Power BI
    • BPMN in Practice
    • PMI-PBA Certification Exam Preparation
    • Scrum Master in Project - Prepare for PSMI Examination
    • Scrum Framework in Practice
    • Applied Data Science & Machine Learning
    • Content Marketing
    • Digital Marketing
    • Facebook Ads
    • Google Ads
    • Google Data Studio
    • Marketing Automation
    • Social Media Marketing
    • Data analysis with SQL and Google Data Studio
    • Photography
    • Video Editor
    • Practical Project Management
    • Agile Analysis Certification
    • Certification in Business Data Analytics
    • Basic Competency Framework
    • Advanced Competency Framework
    • Direct Sales
    • OKRs - P&L
    • Fundamental Testing
    • Manual Testing
    • Automation Testing
    • ISTQB - Foundation Level Certification
    • Mobile & Web Security
    • Digital Sales Leader
    • Digital Sales – Platform
    • Digital Sales – Business: Google & Facebook
    • Digital Sales – Real Estate
    • Data Analysis with Python
    • Training to work efficiently in the legal industry
    • How to make money on Youtube
    • R programming language
    • Business - Investment Legal Consulting Skills
    • IT Essentials for BAs
    • DAX - Data Analytics Expressions
    • Product Owner & Scrum Master in Practice
    • Slide Design and Effective Presentations With PowerPoint
    • Awakening the power of words
    • Pro Salesman
    • Microsoft Power BI ONLINE
    • Structured Query Language - SQL ONLINE
    • Feng Shui & Applied Anthropology in Human Resources Management
    • Digital Transformation
    • [ONLINE] Business Analysis and Product Design
    • Agile Application Expert as Product Owner & Scrum Master (POSM)
    • English for Information Technology
    • Microsoft Power BI Data Analyst
    • Complete EXCEL POWER QUERY and VBA
    • Apply AI for Digital Sales & Marketing
  • E-learning
    • PLATFORM
    • B2C E-LEARNING
    • Video Elearning Maker
  • Consultancy
    • Solutions
    • Training
  • Service
    • Recruitment
    • Room retal
  • BACBook
  • Document
  • News
    • Press
    • Events
    • Recruitment
  • Partners
  • Policy
    • General Policy
    • Private Policy
    • Payment Terms
    • Tuition Refund Policy
    • Certification & Reservation
  • FAQs
  • Contact Us
Blog

Video

Course

Subscribe Us!

 

Feedback

  • Nguyen Thi Mai Binh

    Business Analyst
    For an outsider like me, the topics on "techniques" of BA are very important. Examples include using diagrams to model the requirement, write User Story / Use case, etc.
     
    At the course of Fundamental Business Analysis, I met Mr. Loc, a very enthusiastic and caring person. In addition to sharing practical experiences in class, he also takes the time to advise, support, and comment on my CV. Besides, the Center and Phung also support sending CVs, connecting students to the network of quality partner companies, which helps students like themselves find the most suitable job. Thanks, BAC.
    View detail +
  • Pham Que

    Business Analyst

    The BAC Product Design course has provided me with a lot of useful knowledge and background. The lecturers are very enthusiastic, infusing us with a flame of passion and enthusiasm in the industry. At the same time, share the necessary knowledge and skills in lectures in a more understandable way. The number of students is not too much, so the quality of teaching is excellent. Instructors correct the exercises 1-1, so the lesson will be more in-depth.

    View detail +
  • Nguyen Van Long

    Specialist in accounting mode & Professional solution of Finance and Accounting in IT application - Vietnam Electricity (EVN)

    I participated in Fundamental Business Analysis at BAC. At this place, the training material provides a lot of useful content and is easy to understand. The lecturers are very enthusiastic additionally the content of the curriculum, they also share many practical experiences, questions of the students are answered right in the classroom, and with illustrations from real projects. After all, Thanks to BAC and Teacher Thai Son.

    View detail +
BAC TRAINING & CONSULTANCY VN BAC TRAINING & CONSULTANCY VN BAC TRAINING & CONSULTANCY VN
Ngôn ngữ  
Hotline0909 310 768
Facebook Youtube Linkedin
Banner

Structured Query Language - SQL ONLINE

GENERAL CONTENT TUITION FEE TRAINERS PHOTOS

Overview

We now live in a data-driven world: people navigate through data to find trends and movements to inform strategy, marketing, operations, and many other purposes. Databases are the foundation for technologies used by most people every day, even every hour. These facts make understanding of SQL become one of the great skills that is most sought ever, not only for data scientists but for almost everyone.

If you crave to learn how to communicate and handle databases but are worried about where to begin, then this course will definitely suitable for you. The “Structured Query Language - SQL ONLINE" course at BAC will teach you everything necessary to start working with databases. Let's learn how to use SQL quickly and efficiently by enrolling in our course at once!

Who are entirely suitable for the training course?

  • Those who have basic knowledge of Excel;
  • Business owners, sales staff, marketers need to handle, analyze business problems and generate reports using data;
  • Those who want to have an opportunity to work as a SQL Developer, Database Administrator, Business Analyst (BA), Business Intelligence (BI), etc.
  • Students or working people who want to deeply understand how the database works to support study/ work;
  • Anyone who is interested in developing a career in data analytics, data science.

tham-gia-khoa-hoc-ba

 

Why should I take the course?

Course aims:

Individuals and businesses can effectively and proficiently apply SQL to analyze actual data in their business operations.

Why should you study SQL?
  • In the upcoming years, data will grow in terms of importance and scale. And SQL is a powerful programming language used to communicate and extract different data types from the database.
  • Whether you work in sales or marketing or run your own company, proficiency in SQL is crucial to answering all complex business questions and problems using information insights from data.
  • Consistently ranked as one of the most in-demand technology skills in the job description of many recruiters recently, learning SQL is a great plan to increase income and promote professional growth, improve your career prospects as well.
Why should you join the "Structured Query Language - SQL ONLINE" course at BAC?
  • The “Structured Query Language - SQL ONLINE” course at BAC will give you a solid foundation in databases. After the course, you will be proficient in using and effectively exploiting SQL for your work.
  • Providing comprehensive knowledge from basic to advanced, after the course, you are qualified enough to participate in the certification exam in the field of data science.
  • The prominence of this course is hands-on in real-world learning. You will be able to apply what you have learned to real-world challenges, working with real databases and real data science tools. Through business cases, you can practice building and running SQL queries, getting the chance to detect common mistakes, and experience solving problems from seasoned mentors.
  • BAC provides a certification that confirms your level of knowledge and skills in the field at the end of the course.
What will you attain after the course?
  • Use SQL to perform data analysis;
  • Understand the fundamentals of Databases and Structured Query Language (SQL);
  • Can interact and query any SQL database;
  • Can easily generate Reports, insights, and forecasts for the most efficient decision-making processes using data and SQL integration;
  • Use SQL commands to filter, sort, and summarize data;
  • Evaluate and create datasets to solve your business questions and problems using SQL;
  • Be able to analyze and design SQL databases;
  • Satisfy the requirements when participating in and developing real projects;
  • Model real-world data.
  • Create, Design, and Operate with SQL Database;
  • Become an expert in SQL, work confidently with constraints and related data tables;
  • Add data analysis tools to your skillset;
  • Develop business intuition while working with big data;
  • Save time for data analysis while ensuring accuracy and efficiency.

 

How are courses designed?

The "Structured Query Language - SQL ONLINE" course is compiled by BAC in conjunction with leading experts in the field with a duration of 1.5 hours according to 2 principles:

  • The lessons are designed scientifically, making it easy for students to understand and remember deeply; and
  • Focus on practice and share real experiences.

Class Information

  • Place: 6th Floor, Thien Phuoc 01 Building, 244 Cong Quynh Street, Pham Ngu Lao Ward, District 1, HCM.
  • Teaching Language: Vietnamese
  • Materials: English

Student Requirements

  • Join the course at the right place, on time and right schedule.
  • Comply with class rules.
  • Spirit of cooperation, working in group with members of the class and trainers.

Contact detail

Điện thoại tư vấn If you have any question, please feel free to contact us via:
Phone: (84) 909 310 768 | (84) 903 746 294
Email: info@bacs.vn | bac.trainingba@gmail.com

Schedule Register Now

Course's content:

1. Introduction to T-SQL

2. Query table

3. JOINs

4. SET operators

5. Function and Aggregating Data

6. Subqueries

7. Table expression

8. Functions & Stored procedures

9. Modifying data

Schedule Register Now
 

 

FULL TUITION FEE: 3,100,000 VND

  • The tuition fee includes materials and certification.
  • Materials are included notebook or/and pen. 
  • Tuition fee IS EXEMPT from value added tax (VAT).

DISCOUNT POLICY

  • 10% discount on tuition fee if the students register for the course and payment is received ten days in advance.

PAYMENT

Students can choose 1 of the following payment methods:

Payment in cash

BAC TRAINING AND CONSULTANCY JOINT STOCK COMPANY

  • Headquarter: 6th Floor, 244 Cong Quynh Street, Pham Ngu Lao Ward, District 1, HCMC.
  • Branch: 11th Floor, 39B Truong Son Street, Ward 4, Tan Binh District, HCMC.
  • Email: info@bacs.vn or bac.trainingba@gmail.com
  • Hotline: (84) 909 310 768 | (84) 903 746 294

Payment by cards

BAC accepts new payment method: Convenient payment using mPOS device:

  • Payment by swiping ATM and international cards directly at the BAC office.
  • Payment by Internet Banking / Mobile Banking / Electronic Wallet (E-Wallet) / QR-code.
  • Easy payments from anywhere with the payment link.
  • Payment by credit card, installment with 0% interest.

Fee: card fees MUST BE PAID by the customer when paying by card. The consultant will estimate the card fee according to the fee schedule given by mPOS and provide a concrete estimate for the student to consider before paying. For additional details on how to incorporate the mPOS payment solution, please visit this link.

Payment by Transfer

  • Account 1: Tien Phong Bank
    • Account number: 01236879001
    • Account name: CTY CO PHAN DAO TAO VA TU VAN BAC
    • Tân Bình Branch

NOTES:

  • Students shall complete the payment in advance, and not later than the opening session. BAC does not accept any payment after the opening day.
  • Exceptions: In cases of faulty payment process or students have committed to pay tuition fee after the opening day, BAC will accept as exceptions.

OTHER PROVISIONS

Reserve registered courses

After register and pay the tuition fee for the course, if students can not join the course, they should have an official notification to BAC before the opening session. In this case, students will be reserved tuition and join the next course or switch to another BAC course in suitable requirements.

Opening Schedule Changes

  • In case of course could not start on schedule, BAC will send an email to inform the student of the expected opening day.
  • If the new opening schedule is suitable for students' needs, BAC will reserve tuition fee. Students will continue to participate in the course.
  • If the new opening schedule does not meet students' needs, BAC will refund the tuition fee. 

Refund Policy

  • Tuition fee ARE NOT REFUNDED.
  • In case of our student cannot join the new class schedule due to a change from BAC in terms of changing the course opening schedule, that student will be refunded the tuition by BAC according to the following process:
    • Students can receive a refund by transfer or in cash.
    • After the two sides have officially confirmed the cancellation of the course, the entire tuition will be refunded to students by BAC within a maximum of 3 working days.
    • Students must return the receipt of tuition to BAC to complete the refund procedure.

Any information or support related to payment - PLEASE CONTACT US VIA:

Hotline: 0903 746 294 or Email: phungtran@bacs.vn.

Schedule Register Now
 

 

Phan Nguyen Minh Truong

Data Architect
Mr. Phan Nguyen Minh Truong is currently a software engineer at NashTech. He has over 15 years of experience in various data platforms such as relational DB, NoSQL, Graph DB, distributed DB to cloud data platform (Azure, AWS, etc.)
 

Schedule Register Now

 

 

Hình ảnh khóa học Phân tích nghiệp vụ của BAC

Class Assignment

Hình ảnh khóa học Phân tích nghiệp vụ của BAC

Group Discussion

Hình ảnh khóa học Phân tích nghiệp vụ của BAC

Students' Memory

Hình ảnh khóa học Phân tích nghiệp vụ của BAC

Mr.Nhat and Ms.Thuy are sharing how to be a good Business Analyst.

Hình ảnh khóa học Phân tích nghiệp vụ của BAC

Trainees change positions to start an interesting conversation.

Hình ảnh khóa học Phân tích nghiệp vụ của BAC

Congratulation! You have graduated.

Hình ảnh khóa học Phân tích nghiệp vụ của BAC

Memorable graduation day. Your life could be changed from now.

Schedule Register Now

 

BAC TRAINING & CONSULTANCY JOINT STOCK COMPANY

License: 0312713743 issued on 28/03/2014 by Department of Planning and Investment of HCM city.
Headquarter: 6th Floor, Thien Phuoc 01 Building, 244 Cong Quynh Street, Pham Ngu Lao Ward, District 1, HCM City.
Branch: 11th Floor, 39B Truong Son St., Ward 4, Tan Binh Dist., HCM city.
Email: info@bacs.vn - Web: www.bacs.vn - Phone: (84) 909 310 768

Đã thông báo bộ công thương
DMCA.com Protection Status

Copyright © 2014 BAC JSC.
All Rights Reserved.

BAC - Business Analyst Training Center