Make it your year ✨ View schedule →

Convince Your Boss

Request Callback

Register Your Interest

Course *
Name *
First Last
Phone *
Email *
- I agree to the Terms & Conditions and Privacy Policy.

CODE

Database Development Course

mysuccess

The course is part of the MySuccess Website Developer Career Path

Delve into the core technologies of the web and create powerful, dynamic web applications.

Read More

Awaiting product image

€50.00

Description

Description

About this Course

What is SQL? Where is SQL used and what can it do..?

The spread of dynamic websites on the World Wide Web today is largely due to the possibility for their content to be handled through databases. Database management is a complicated process, which has been considerably rationalized by the SQL programming language. SQL is responsible for querying and editing information stored in a certain database management system.

With this new course, you will be taught by experienced professionals the key skills which will enable you to build a solid foundation of the SQL programming language. This class is intended for analysts, developers, designers, administrators, managers and students new to the SQL programming language. Extensive hands on exercises are used throughout the course to reinforce learning and develop real competency. A real world scenario implementation of the syllabus covered during the course will be demonstrated during the last lesson together with extra features such as reporting techniques.

Course Outline

Databases Overview

Introduction to Databases
Introduction to DBMS
Introduction to SQL

Data Definition Language (DDL)

Create/Alter/Drop Databases
Create/Alter/Drop Tables

Working with Queries – Retrieving Data

The SELECT Statement
The WHERE Statement
The ORDER BY Statement
The GROUP BY Statement

Modifying data in a Table

The INSERT Statement
The UPDATE Statement
The DELETE Statement

Using SQL Functions in Queries

Aggregate Functions
Mathematical Functions
String Functions
Date Functions

Working with Multi-Table Queries (JOINS)

Inner Join Statements
Left Join Statements
Right Join Statements

Implementing Data Integrity

Understanding the fundamentals of Data Integrity
Relationships
Table Constraints
Field Constraints

Using Databases for Software Applications

Connecting a Database with Your Application
Designing Reports from your Database

Course Details

MODE OF STUDY

PARTTIME

DELIVERY METHOD

Lectures & Hands-On Practice

ENTRY REQUIREMENTS

Good Knowledge of English

DURATION

15 hours (5 Lessons of 3 Hours)

DAY(S)

TBA

TIME

TBA

WHAT'S INCLUDED

Training by a Certified Educator
Detailed Educator Courseware

Price: € 295

Pre-enrol to make sure you don't miss out on the next course! Read More

About this Course

What is SQL? Where is SQL used and what can it do..?

The spread of dynamic websites on the World Wide Web today is largely due to the possibility for their content to be handled through databases. Database management is a complicated process, which has been considerably rationalized by the SQL programming language. SQL is responsible for querying and editing information stored in a certain database management system.

With this new course, you will be taught by experienced professionals the key skills which will enable you to build a solid foundation of the SQL programming language. This class is intended for analysts, developers, designers, administrators, managers and students new to the SQL programming language. Extensive hands on exercises are used throughout the course to reinforce learning and develop real competency. A real world scenario implementation of the syllabus covered during the course will be demonstrated during the last lesson together with extra features such as reporting techniques.

Databases Overview

Introduction to Databases
Introduction to DBMS
Introduction to SQL

Data Definition Language (DDL)

Create/Alter/Drop Databases
Create/Alter/Drop Tables

Working with Queries – Retrieving Data

The SELECT Statement
The WHERE Statement
The ORDER BY Statement
The GROUP BY Statement

Modifying data in a Table

The INSERT Statement
The UPDATE Statement
The DELETE Statement

Using SQL Functions in Queries

Aggregate Functions
Mathematical Functions
String Functions
Date Functions

Working with Multi-Table Queries (JOINS)

Inner Join Statements
Left Join Statements
Right Join Statements

Implementing Data Integrity

Understanding the fundamentals of Data Integrity
Relationships
Table Constraints
Field Constraints

Using Databases for Software Applications

Connecting a Database with Your Application
Designing Reports from your Database

MODE OF STUDY

PARTTIME

DELIVERY METHOD

Lectures & Hands-On Practice

ENTRY REQUIREMENTS

Good Knowledge of English

DURATION

15 hours (5 Lessons of 3 Hours)

DAY(S)

TBA

TIME

TBA

WHAT'S INCLUDED

Training by a Certified Educator
Detailed Educator Courseware

Price: € 295

Pre-enrol to make sure you don't miss out on the next course! Read More

The tutor is exceptional. She presented the lectures with clarity & precision. With her expertise, she transformed complex concepts into digestible insights, making the learning experience both enriching & enjoyable.

Glenn, Professional Diploma in UX Design, April 2024
The project-based learning experience helped me to better visualize & implement the skills attained in web applications. The provided material gives you a solid platform on which to build on.

Ryan, MySuccess Website Developer, March 2024
The educator had a lot of examples to provide from the experience he had working with local companies. He was always well prepared, & made the lesson fun & easy to understand - even for someone that never had any experience in digital marketing.

Shanon, Professional Diploma in Digital Marketing, January 2024
The educator is really knowledgeable & his explanations are extremely clear. He was always ready with detailed explanations for any question. Also, the fact that the educator is super friendly made the whole learning vibe awesome.

Etienne, Python Foundations, January 2024
As someone who struggled a lot in school, I absolutely loved learning with ICE Malta. The educator is super nice & makes the material really interesting. His captivating delivery keeps you focused & the lesson fun.

Jamie, Python Foundations, January 2024
The course met my expectations, content was up-to-date, & the educator was well-informed & knew how to explain or answer any queries that cropped up. It had the ideal blend of theory & practice too. Would highly recommend the course.

Luca, Graphic Designer Associate, January 2024

Q: I’d like to enrol. What’s my next step?

Super choice! We're eager to welcome you to ICE Malta (very) soon. Please navigate to the course page you're interested in, scroll to the bottom of the page, click on "Book Now", fill in your personal details, read through and formally sign the Student Agreement and proceed with the checkout process. Our team will then reach out via email or phone, usually within 24 hours, to confirm your seat.

If you'd like to discuss a personalised monthly payment plan, please reach out to our Admissions Team on chat or on WhatsApp.

Q: Why is ICE Malta the school for me?

'Excellence in Education' - that's how thousands of students describe the unique ICE Malta ISO 9001:2015 study experience. ICE Malta is trusted by the world's leading companies and brands, and continues to celebrate student success stories - semester after semester. Discover ICE Malta's acclaimed study experience here, it's all yours.

Q: Do you accept international students?

Yes, we accept international students. However, some courses are license-restricted to residents of the Maltese Islands. Most of our courses are delivered online live, but if you wish to enroll in an on-campus course, you are responsible for obtaining a Student Visa. Compliance with visa requirements to reside in Malta and attend lectures is solely the student's responsibility. For more information on visa requirements, visit Identity Malta’s VISA requirement page.

Q: Do you really believe that online live learning is for everyone? I’m not sure.

We honestly do and the numbers prove that we are right. The fact that you can select your learning location, join class without the need to commute or struggle to find parking, still enjoy a practical lesson delivered by an industry expert topped off with a brand new 7-day playback feature that allows you to re-watch your lesson again makes online live learning a brilliant option. Plus the support you’ll get at any point of your learning journey and beyond will really make you feel on top of the world - discover more.

Still not sure? Let’s talk some more on chat or on WhatsApp.

Q: My training will be sponsored, how can I enrol?

That's great news! Please navigate to the course page you're interested in, scroll to the bottom of the page, click on "Book Now", fill in your personal details, read through and formally sign the Student Agreement and select "Purchase Order" as your payment method so as you're not charged at checkout. Our team will then reach out via email or phone, usually within 24 hours, so that you can put us in touch with your team to finalise your enrollment.

If you need any additional support, please reach out to our Admissions Team on chat or on WhatsApp now.

Q: In which countries will my certification be recognised?

The collection of MySuccess study programmes together with Google, Adobe, Cisco, Microsoft, LPI, Autodesk, IAPP & Digital Marketing Institute certifications are worldwide recognised certifications.

Q: What equipment do I need?

In the ideal scenario students should have a computer setup with two screens, one where you can follow the lesson from (which can even be your mobile) and your main screen which you will use for practical learning. This will guarantee that your learning experience is really powerful.

Q: I’d love to become an ICE Malta student but budgets are limited.

ICE Malta was the island's first ICT Academy to give students the chance to schedule 4 interest-free payments which gives them the freedom and flexibility to invest in their studies and still do the things they love. Students also have the chance to get 70% of their course fees back thanks to the Get Qualified Scheme. Learn more.

MENU