Online
Apex Learning SQL Programming Complete Bundle Apex Learning
  • Duration / Course length: Upto 8 Hours Start now
  • Accredited by: IAOCPD Group
  • Certificates:
  • Course delivery: This course is delivered in video format

Course details

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, at an additional 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. Updated on 10 January, 2024

Eligibility / 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.

About Apex Learning

Apex Learning aims to be an online education that provides the necessary support to the learners and facilitates educators' work and contributes to professional development. We offer innovative pedagogical resources and training in a planned, updated, and oriented way.

At Apex Learning we share the goal of millions of people to make the world better and we are aware that, as a company, our actions have a great influence on society. For this reason, at Apex Learning we actively evolve to bring knowledge to everyone, through technology, based on efficiency, quality, credibility, and innovation.

Our mission is to offer innovative and quality education through distance education, allowing everyone easy access through technology and the development of a sustainable society.

Our vision to be an educational portal of reference in distance education, innovative in its proposals and practices and in the formation of critical, conscious, and entrepreneurial learners.

171 students have enrolled with Apex Learning through Laimoon
See all Apex Learning courses
90% Off for Laimoon Users! Get This Deal
USD 24
USD 240
Money Back Guarantee