Description

Overview

Acquire the language of databases with this SQL Programming Complete Bundle course. In this data-driven world, data is used to make strategies, find solutions and do a thousand other tasks. Businesses across the world are using big and related data, which makes a basic knowledge of SQL a remarkable skill not only for data scientists but for everyone. This SQL Programming Complete Bundle course will teach you the language of databases, SQL, and help you gain proficiency in SQL tools.

How will I get my certificate?

At the end of the course there will be a written assignment test which you can take either during or after the course. After successfully completing the test you will be able to order your certificate, these are included in the price.

Who is this course for?

There is no experience or previous qualifications required for enrolment on this SQL Programming Complete Bundle. It is available to all students, of all academic backgrounds.

Requirements

Our SQL Programming Complete Bundle is fully compatible with PC's, Mac's, Laptop, Tablet and Smartphone devices. This course has been designed to be fully compatible on tablets and smartphones so you can access your course on wifi, 3G or 4G. There is no time limit for completing this course, it can be studied in your own time at your own pace.

Career path

Having these various qualifications will increase the value in your CV and open you up to multiple sectors such as Business & Management , Admin, Accountancy & Finance, Secretarial & PA, Teaching & Mentoring etc.

Course Curriculum

9 sections • 53 lectures • 07:50:00 total length

•Introduction: 00:04:00

•Course Curriculum Overview: 00:05:00

•Overview of Databases: 00:10:00

•MySQL Installation: 00:16:00

•MySQL Workbench Installation: 00:09:00

•Connecting to MySQL using Console: 00:09:00

•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

•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

•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

•Timestamps: 00:12:00

•EXTRACT from timestamp: 00:10:00

•Mathematical Functions: 00:12:00

•String Functions: 00:22:00

•SUBQUERY: 00:13:00

•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

•Creating a Database backup: 00:12:00

•10a Overview of Databases and Tables: 00:05:00

•10c Restoring a Database: 00:07:00

•Assignment - SQL Programming Complete Bundle: 00:00:00

Course Images

SQL Programming Complete Bundle

By Apex Learning

Booking options

Highlights

Description

Overview

How will I get my certificate?

Who is this course for?

Requirements

Career path

Course Curriculum

About The Provider

Tags

Reviews