beginner level
Piti Champeethong
Founder and instructor of TANC. He has more than 20 years of teaching experience in university, government and private institutions including domestic and international. Furthermore, as a business consultant for both domestic and international.
BE THE BEST
BEGINERS.
Together with an increase interest and investment in AI, new tools for collecting and analyzing data and new enterprise roles and responsibilities will emerge presenting IT professionals and individuals planning to pursue a career in Big Data and Data Analytics with tremendous career opportunities. This can never be a better time to acquire the necessary skills and gain proficiency in Big Data.
What you get:
Module 1
Module 1 : What is Microsoft SQL Server?
- Overview of Microsoft SQL Server
- Big data vs. its predecessors
- What is the tools of Microsoft SQL Server Management Studio?
Module 2
Module2 : What is Microsoft Azure?
- Overview of Microsoft Azure.
- How to register for Azure.
- Free service for Azure.
- What is Azure SQL Server / database?
- The Step for using Azure SQL database.
Module 3
What is Database?
- Overview of Database.
- What is Database Normalization?
- How to design Database (Database Normalization).
- 1NF (First Normal Form)
- 2NF (Second Normal Form)
- 3NF (Third Normal Form)
Module 4
Database Management
- Database design by using Microsoft SQL Server Management Studio(SSMS).
- Importing data from Excel or CSV into a SQL Server database.
- SQL statement to edit data.
- INSERT Statement
- UPDATE Statement
- DELETE Statement
- คำสั่ง SQL สำหรับเรียกดูข้อมูล
- SELECT Statement
- WHERE Statement
- JOIN Statement
- INNER JOIN
- LEFT JOIN
- RIGHT JOIN
- INNER JOIN
- UNION Statement
- ORDER BY
- Statement
- HAVING Statement
- GROUP BY Statement
Module 5
การเรียกดูข้อมูลโดยใช้คำสั่ง Built-in function
- Using statement related to manage date and time.
- GETDATE
- FORMAT
- Using statement to create the new key by using NEW_ID statement.
- Using statement to convert the data by using CONVERT, CAST statement.
- Using statement to check the data is NULL or not by using ISNULL statement.
Module 6
Using Azure SQL Database
- Creating an Azure Resource Group to create an environment for using the database.
- การเปิดบริการ Azure SQL server สำหรับเป็นจัดเก็บกลุ่มของ Azure SQL database.
- Creating an Azure SQL database to create tables to store data.
- Using SSMS to connect Azure SQL database on Microsoft Azure.
- Using Query Edition to manage Azure SQL database data on website.
Module 7
Data Sync and Database Backup
- Setting up Data Sync between On-premise and Azure databases to exchange data between On-premises and Azure for both databases have the same current information.
- How to backup database to back up data in case of need for data recovery both on-premises and Azure.
- Restore database to remove the backed up database installed on On-premise and Azure.
What you get:
Module 1 : What is Microsoft SQL Server?
- Overview of Microsoft SQL Server
- Big data vs. its predecessors
- What is the tools of Microsoft SQL Server Management Studio?
Module2 : What is Microsoft Azure?
- Overview of Microsoft Azure.
- How to register for Azure.
- Free service for Azure.
- What is Azure SQL Server / database?
- The Step for using Azure SQL database.
Module3 : What is Database?
- Overview of Database.
- What is Database Normalization?
- How to design Database (Database Normalization).
- 1NF (First Normal Form)
- 2NF (Second Normal Form)
- 3NF (Third Normal Form)
Module4 : Database Management
- Database design by using Microsoft SQL Server Management Studio(SSMS).
- Importing data from Excel or CSV into a SQL Server database.
- SQL statement to edit data.
- INSERT Statement
- UPDATE Statement
- DELETE Statement
- คำสั่ง SQL สำหรับเรียกดูข้อมูล
- SELECT Statement
- WHERE Statement
- JOIN Statement
- INNER JOIN
- LEFT JOIN
- RIGHT JOIN
- INNER JOIN
- UNION Statement
- ORDER BY
- Statement
- HAVING Statement
- GROUP BY Statement
Module5 : การเรียกดูข้อมูลโดยใช้คำสั่ง Built-in function
- Using statement related to manage date and time.
- GETDATE
- FORMAT
- Using statement to create the new key by using NEW_ID statement.
- Using statement to convert the data by using CONVERT, CAST statement.
- Using statement to check the data is NULL or not by using ISNULL statement.
Module6 : Using Azure SQL Database
- Creating an Azure Resource Group to create an environment for using the database.
- การเปิดบริการ Azure SQL server สำหรับเป็นจัดเก็บกลุ่มของ Azure SQL database.
- Creating an Azure SQL database to create tables to store data.
- Using SSMS to connect Azure SQL database on Microsoft Azure.
- Using Query Edition to manage Azure SQL database data on website.
Module7 : Data Sync and Database Backup
- Setting up Data Sync between On-premise and Azure databases to exchange data between On-premises and Azure for both databases have the same current information.
- How to backup database to back up data in case of need for data recovery both on-premises and Azure.
- Restore database to remove the backed up database installed on On-premise and Azure.
Get to know
the author
Piti Champeethong
Founder and instructor of TANC. He has more than 20 years of teaching experience in university, government and private institutions including domestic and international. Furthermore, as a business consultant for both domestic and international.