-
Cart
Registering for this site is easy. Just fill in the fields below, and we'll get a new account set up for you in no time.
Sign in to your One Education account
The Complete MySQL Server from Scratch: Bootcamp
The Complete MySQL Server from Scratch: Bootcamp
£29 ex Vat
Take This Course OR
1 Year Access 
Intermediate
5 Students -
8 hours, 22 minutes
get Access To All 3500+ One Education Courses For Just £49/Year!
Claim Offer
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 ORDER BY Statement | 00:08: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 | ||
Related Courses
Intermediate
COPYRIGHT © 2022 One Education
0
0
Your Cart
Your cart is emptyBrowse Courses
Upgrade to get UNLIMITED ACCESS to ALL COURSES for only £49/year
Claim Offer & UpgradeMembership renews after 12 months. You can cancel anytime from your account.
Other Students Also Buy
-
Get Lifetime Access To Your Course£9.99 Add to basket+Add