3975826_136

SQL Programming with MySQL Database

18,00 

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

MySQL is the most popular Open Source Relational SQL Database Management System. MySQL is one of the best RDBMS being used for developing various web-based software applications. MySQL is developed, marketed and supported by MySQL AB, which is a Swedish company.

SQL is used to communicate with a database. According to ANSI (American National Standards Institute), it is the standard language for relational database management systems. SQL statements perform tasks such as update data on a database, or retrieve data from a database.

Description

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 and determination to achieve your goals!

Additional information

Hours · Self-Paced

8

Language

English

Related Products