Skip to content

Bundle Combo - SQL Programming (with Microsoft SQL Server and MySQL)

Self-paced videos, Lifetime access, Study material, Certification prep, Technical support, Course Completion Certificate


Uplatz

Summary

Price
£26 inc VAT
Study method
Online
Course format What's this?
Video
Duration
63 hours · Self-paced
Access to content
Lifetime access
Qualification
No formal qualification
Certificates
  • Uplatz Certificate of Completion - Free

Add to basket or enquire

Overview

Uplatz offers this comprehensive bundle course on SQL Programming with Microsoft SQL Server and MySQL.It is a self-paced course with video lectures. You will be awarded Course Completion Certificate at the end of the course.

Master in-demand SQL skills

This course will equip you with the expertise to design, build, and manage relational databases using two of the most popular database management systems (DBMS) in the world: Microsoft SQL Server and MySQL.

Why take this course?

  • Gain proficiency in SQL, a critical skill for data analysis, reporting, and application development.
  • Learn to create, manipulate, and query data in both Microsoft SQL Server and MySQL.
  • Understand the core functionalities and explore the differences between these two industry-standard platforms.
  • Write efficient SQL queries to retrieve and analyze data for various purposes.

What you'll learn:

  • Foundational SQL concepts like tables, columns, data types, and relationships.
  • Writing essential SQL statements like SELECT, INSERT, UPDATE, and DELETE.
  • Working with advanced queries like JOINs, WHERE clauses, and functions.
  • Managing database objects like users, roles, and permissions (focus on security best practices).
  • Exploring specific features of both Microsoft SQL Server (T-SQL) and MySQL.

Certificates

Uplatz Certificate of Completion

Digital certificate - Included

Course Completion Certificate by Uplatz

Course media

Description

SQL Programming with MS SQL Server - Course Syllabus

  1. Introduction to Microsoft SQL Server

  2. Select and Where

  3. SQL Sub Languages - Order By Clauses

  4. Any - All - Select Into - Insert Into - Case

  5. Delete - Top - Aggregate Functions - Wild Cards

  6. Insert - Update - Is Null Commands

  7. In - Between - Table Alias

  8. SQL Comments - SQL Operators

  9. Joins

  10. Union All - Union - Group By - Having - Exists - Not Exists

  11. Null Functions - Transact SQL

  12. Examples - If - Conditional Statements

  13. Goto Statement - Looping Construct

  14. Sub Programs - Stored Procedures

  15. Stored Procedure Examples

  16. Modifying and Dropping a Stored Procedure

  17. Dynamic Queries - Procedure Returning Values - Functions

  18. Break - Continue - Exception Handling

  19. Structured Exception Handling

  20. Multiple and Nested Try Catch Blocks

  21. Using Anonymous Block - Table Valued Functions

  22. Backup DB - Differential Example - DDL Statements

  23. User Defined DB - Creating DB with GUI - Query - Commands

  24. Database Constraints and Domain Integrity Constraints

  25. Primary Key and Composite Key

  26. Creating 1-to-1 Relationship - Indexes

  27. Views and Types of Views

  28. Auto Increment - SQL Date Operations

  29. Hosting

SQL Programming with MySQL - Course Syllabus

1. Basics of Databases

  • Data Models and basic terminologies

  • Advantages and disadvantages of DBMS

2. SQL Basic Understanding

  • What is SQL?

  • What SQL Can do?

  • SQL Process

  • ACID Properties

  • What is ER Model?

  • Best Practices

  • Database Normalization

3. Introduction to SQL

  • SQL Commands

  • SQL Constraints

  • Types of Keys

  • MySQL Hands-on

4. SQL Basic Commands with demonstration

5. Basics and Aggregation Functions

6. Regular Expression Functions

7. SQL Comparison Clauses

  • exists

  • not exists

  • create table like

  • case when

  • NULL Functions

8. SQL String Functions

9. SQL Numerical Function

10. Introduction to Date Functions

11. SQL Joins – Introduction and demonstration

12. Introduction MySQL Workbench

13. Stored Procedures and Views

Who is this course for?

Everyone

Requirements

Passion & determination to achieve big goals in life!

Career path

  • Data Engineer
  • Data Analyst
  • Data Scientist
  • Database Developer
  • Application Developer
  • Software Engineer
  • Database Administrator (DBA)
  • SQL Programmer
  • Business Intelligence (BI) Developer
  • Software Developer
  • Systems Analyst
  • IT Consultant
  • Data Consultant
  • Cloud Engineer

Questions and answers

Currently there are no Q&As for this course. Be the first to ask a question.

Reviews

Currently there are no reviews for this course. Be the first to leave a review.

FAQs

Study method describes the format in which the course will be delivered. At Reed Courses, courses are delivered in a number of ways, including online courses, where the course content can be accessed online remotely, and classroom courses, where courses are delivered in person at a classroom venue.

CPD stands for Continuing Professional Development. If you work in certain professions or for certain companies, your employer may require you to complete a number of CPD hours or points, per year. You can find a range of CPD courses on Reed Courses, many of which can be completed online.

A regulated qualification is delivered by a learning institution which is regulated by a government body. In England, the government body which regulates courses is Ofqual. Ofqual regulated qualifications sit on the Regulated Qualifications Framework (RQF), which can help students understand how different qualifications in different fields compare to each other. The framework also helps students to understand what qualifications they need to progress towards a higher learning goal, such as a university degree or equivalent higher education award.

An endorsed course is a skills based course which has been checked over and approved by an independent awarding body. Endorsed courses are not regulated so do not result in a qualification - however, the student can usually purchase a certificate showing the awarding body's logo if they wish. Certain awarding bodies - such as Quality Licence Scheme and TQUK - have developed endorsement schemes as a way to help students select the best skills based courses for them.