تفاصيل الدورة
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
… + المزيدتفاصيل الدورة
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, 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 CurriculumIntroduction- 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
AssignmentCareer pathHaving 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.
تحديث بتاريخ 24 February, 2025 - أقلالمتطلبات
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.
