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
- 7 hours, 50 minutes 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
Frequently Bought Together
Big Data Analytics with PySpark Tableau Desktop and MongoDB
4.7
(1 student)4.7 course rating - 9 reviews
£12.99
£419
This course includes:
-
Duration:7 hours, 50 minutes
-
Access:1 year access
-
Units:53
-
Level:
-
CPD Points:10
-
Certificate:Yes
