SQL Programming Complete Bundle هذه الدورة تدرس باللغة الإنجليزية

تفاصيل الدورة

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 SQL Programming Complete Bundle 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 SQL Programming Complete Bundle 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.

Course Curriculum

Introduction

• Introduction
• Course Curriculum Overview
• Overview of Databases

SQL Environment Setup

• MySQL Installation
• MySQL Workbench Installation
• Connecting to MySQL using Console

SQL Statement Basics

• Overview of Challenges
• SQL Statement Basic
• SELECT Statement
• SELECT DISTINCT
• Column AS Statement
• COUNT built-in Method usage
• SELECT WHERE Clause – Part One
• SELECT WHERE Clause – Part Two
• SQL Statement Basic
• SQL Limit Clause Statement
• SQL Using BETWEEN with Same Column Data
• How to Apply IN Operator
• Wildcard Characters with LIKE and ILIKE

GROUP BY Statements

• Overview of GROUP BY
• Aggregation function SUM()
• Aggregation MIN() and MAX()
• GROUP BY – One
• GROUP BY – Two
• HAVING Clause

JOINS

• Overview of JOINS
• Introduction to JOINS
• AS Statement table
• INNER Joins
• FULL Outer Join
• LEFT Outer JOIN
• RIGHT JOIN
• Union

Advanced SQL Commands / Statements

• Timestamps
• EXTRACT from timestamp
• Mathematical Functions
• String Functions
• SUBQUERY

Creating Database and Tables
Databases and Tables
Assignment

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. تحديث بتاريخ 10 January, 2024