Home
Course
The Complete MySQL Server from Scratch: Bootcamp

The Complete MySQL Server from Scratch: Bootcamp

0( 0 REVIEWS )

1 STUDENTS

Learning Outcome

Develop your data science BI career with real-world data science exercises
Understand the fundamental principles of database design
Learn how to create basic and advanced SQL queries
Familiarise with some beginner and more complex commands of SQL
Know how to simplify reports like spreadsheets and prepare data structures
Find out how to protect your data through backup and restore best practices
Get step-by-step guidance on how to filter data rows in an SQL database

Description

The Complete SQL Server from Scratch: Bootcamp is the perfect stepping stone to a career in data science. Not only does it cover the basic and more advanced commands and SQL queries, but you will gain up-to-date industry knowledge that will equip you with the fundamental skills to develop an MSSQL database using SQL language.

Through instructor-guided training, this course will walk you through procedures such as simplifying reports, preparing data structures, and interacting with the database. You will also learn best practices for protecting, backing up and restoring your data. What’s more, you’ll gain a working knowledge of SQL programming, with learning material designed for absolute beginners.

We’ve taken this comprehensive professional diploma in SQL programming and broken it down into several manageable modules which we believe will assist you to easily grasp each concept – from the fundamentals to the most advanced aspects of the course. Get a head start in your career and learn the fundamentals of SQL with this best-selling training program!

Who is this course for?

This sql server masterclass is for anyone looking to gain a formal qualification to kickstart a career in this field. It is also the perfect refresher training course for those who want to update their existing skills and knowledge. There are no specific entry requirements for this course, which is open to both part-time and full-time learners.

Career path

On successful completion, learners with have a range of skills required to work in the field of data science, with the opportunity to explore professions such as:

- Sql database developer
- Sql server
- Data analyst
- Data scientist
- System analyst

Course Curriculum

Course Introduction
	Introduction	00:04:00
	Course Curriculum Overview	00:05:00
	Overview of Databases	00:10:00
SQL Environment Setup
	MySQL Installation	00:16:00
	MySQL Workbench Installation	00:09:00
	Connecting to MySQL using Console	00:09:00
SQL Statement Basics
	Overview of Challenges	00:04:00
	SQL Statement Basic	00:16:00
	SELECT Statement	00:09:00
	SELECT DISTINCT	00:05:00
	Column AS Statement	00:12:00
	COUNT built-in Method usage	00:11:00
	SELECT WHERE Clause – Part One	00:05:00
	SELECT WHERE Clause – Part Two	00:11:00
	SQL Statement Basic	00:16:00
	SQL Limit Clause Statement	00:09:00
	SQL Using BETWEEN with Same Column Data	00:11:00
	How to Apply IN Operator	00:11:00
	Wildcard Characters with LIKE and ILIKE	00:11:00
GROUP BY Statements
	Overview of GROUP BY	00:06:00
	Aggregation function SUM()	00:09:00
	Aggregation MIN() and MAX()	00:05:00
	GROUP BY – One	00:09:00
	GROUP BY – Two	00:12:00
	HAVING Clause	00:05:00
JOINS
	Overview of JOINS	00:04:00
	Introduction to JOINS	00:04:00
	AS Statement table	00:03:00
	INNER Joins	00:14:00
	FULL Outer Join	00:11:00
	LEFT Outer JOIN	00:08:00
	RIGHT JOIN	00:08:00
	Union	00:07:00
Advanced SQL Commands / Statements
	Timestamps	00:12:00
	EXTRACT from timestamp	00:10:00
	Mathematical Functions	00:12:00
	String Functions	00:22:00
	SUBQUERY	00:13:00
Creating Database and Tables
	Basic of Database and Tables	00:06:00
	DataTypes	00:10:00
	Primarykey and Foreignkey	00:06:00
	Create Table in SQL Script	00:13:00
	Insert	00:11:00
	Update	00:07:00
	Delete	00:04:00
	Alter Table	00:09:00
	Drop Table	00:05:00
	NOT NULL Constraint	00:08:00
	UNIQUE Constraint	00:09:00
Databases and Tables
	Creating a Database backup	00:12:00
	10a Overview of Databases and Tables	00:05:00
	10c Restoring a Database	00:07:00
Mock Exam
	Mock Exam – The Complete MySQL Server from Scratch: Bootcamp	00:20:00
Final Exam
	Final Exam – The Complete MySQL Server from Scratch: Bootcamp	00:20:00