- Duration / Course length: Upto 8 Hours Start now
- Accredited by: IAOCPD Group
- Certificates:
- Course delivery: This course is delivered in video format
Course details
OverviewAcquire 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
- MySQL Installation
- MySQL Workbench Installation
- Connecting to MySQL using Console
- 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
- Overview of JOINS
- Introduction to JOINS
- AS Statement table
- INNER Joins
- FULL Outer Join
- LEFT Outer JOIN
- RIGHT JOIN
- Union
- Timestamps
- EXTRACT from timestamp
- Mathematical Functions
- String Functions
- SUBQUERY
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.
Job roles this course is suitable for:
Mysql Developer , Senior PL/SQL Developer , SQL Coordinator , Microsoft SQL Server AdministratorAbout 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.
