The Complete MySQL Server from Scratch: Bootcamp

The Complete MySQL Server from Scratch: Bootcamp

Learning Outcome

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
sidemoneyBack

COPYRIGHT © 2022 One Education

Home Search Cart
0
    0
    Your Cart
    Your cart is emptyBrowse Courses

    Upgrade to get UNLIMITED ACCESS to ALL COURSES for only £49/year

    Claim Offer & Upgrade

    Membership renews after 12 months. You can cancel anytime from your account.

    Other Students Also Buy
      Apply Coupon