Course Features
Price
Study Method
Online | Self-paced
Course Format
Reading Material - PDF, article
Duration
15 hours, 45 minutes
Qualification
No formal qualification
Certificate
At completion
Additional info
Coming soon
- Share
Overview
Who is this course for?
Requirements
Career path
-
- Introduction 00:10:00
- Course Requirements 00:10:00
- Getting Started on Windows, Linux, or Mac 00:10:00
- How to Ask Great Questions 00:10:00
- FAQs 00:10:00
- Source Code Files 00:10:00
-
- Module Introduction 00:10:00
- MySQL Server Installation 00:10:00
- Connecting to MySQL Server Instance 00:10:00
- MySQL Workbench Overview 00:10:00
- Downloading and Restoring Sample Database 00:10:00
- Module Introduction 00:10:00
- Overview of Databases & Creating Database 00:10:00
- Creating Data Base 00:10:00
- SQL Data Types 00:10:00
- Column Data Types in Workbench 00:10:00
- Creating Tables 00:10:00
- Overview of Primary and Foreign Keys 00:10:00
- Primary Key 00:10:00
- Foreign Key 00:10:00
- Creating Temporary Tables 00:10:00
- Enhanced Entity Relationship Diagrams (EER) 00:10:00
- Module Introduction 00:10:00
- Create Table Statement 00:10:00
- Drop Statement 00:10:00
- Alter Statement 00:10:00
- Truncate Statement 00:10:00
- Comments in Queries 00:10:00
- Rename Table 00:10:00
- Module Introduction 00:10:00
- Basic SQL Statements 00:10:00
- Select Statement 00:10:00
- Select Distinct 00:10:00
- Select with Column Headings 00:10:00
- Using Column Aliases 00:10:00
- Dashboard Analytics 00:10:00
- SUM() Function 00:10:00
- MIN() and MAX() Functions 00:10:00
- Module Introduction 00:10:00
- Group By – Theory 00:10:00
- Data Analytics with Group By 00:10:00
- Having Statement 00:10:00
- Module Introduction 00:10:00
- Check Constraint 00:10:00
- Not Null Constraint 00:10:00
- Unique Constraint 00:10:00
- Module Introduction 00:10:00
- Timestamp Functions 00:10:00
- Extracting Data from Timestamp 00:10:00
- Mathematical Scalar Functions 00:10:00
- String Functions 00:10:00
- Advanced Functions 00:10:00
- Subqueries 00:10:00
- Select with Calculations 00:10:00
- Module Introduction 00:10:00
- Importing CSV Files 00:10:00
- Exporting Data to CSV Files 00:10:00
- Exam of Learn MySQL from Scratch: Essential Skills for Data Science and Analytics 00:50:00
Is this certificate recognized?
Yes, our premium certificate and transcript are widely recognized and accepted by embassies worldwide, particularly by the UK embassy. This adds credibility to your qualification and enhances its value for professional and academic purposes.
I am a beginner. Is this course suitable for me?
Yes, this course is designed for learners of all levels, including beginners. The content is structured to provide step-by-step guidance, ensuring that even those with no prior experience can follow along and gain valuable knowledge.
I am a professional. Is this course suitable for me?
Yes, professionals will also benefit from this course. It covers advanced concepts, practical applications, and industry insights that can help enhance existing skills and knowledge. Whether you are looking to refine your expertise or expand your qualifications, this course provides valuable learning.
Does this course have an expiry date?
No, you have lifetime access to the course. Once enrolled, you can revisit the materials at any time as long as the course remains available. Additionally, we regularly update our content to ensure it stays relevant and up to date.
How do I claim my free certificate?
I trust you’re in good health. Your free certificate can be located in the Achievement section. The option to purchase a CPD certificate is available but entirely optional, and you may choose to skip it. Please be aware that it’s crucial to click the “Complete” button to ensure the certificate is generated, as this process is entirely automated.
Does this course have assessments and assignments?
Yes, the course includes both assessments and assignments. Your final marks will be determined by a combination of 20% from assignments and 80% from assessments. These evaluations are designed to test your understanding and ensure you have grasped the key concepts effectively.
Is this course accredited?
We are a recognized course provider with CPD, UKRLP, and AOHT membership. The logos of these accreditation bodies will be featured on your premium certificate and transcript, ensuring credibility and professional recognition.
Will I receive a certificate upon completion?
Yes, you will receive a free digital certificate automatically once you complete the course. If you would like a premium CPD-accredited certificate, either in digital or physical format, you can upgrade for a small fee.
Course Features
Price
Study Method
Online | Self-paced
Course Format
Reading Material - PDF, article
Duration
15 hours, 45 minutes
Qualification
No formal qualification
Certificate
At completion
Additional info
Coming soon
- Share
Child Sexual Abuse Awareness & Trauma-Informed Support (Professional Certificate)
Kazi Shofi Uddin Bablu237Original price was: ¥4,610.87.¥141.05Current price is: ¥141.05.Artificial Intelligence: Reinforcement Learning in Python with Real Projects
Course Line238Original price was: ¥4,610.87.¥141.05Current price is: ¥141.05.
