ACE IT | Training & Development | Full Stack Development | Online Training | website design | website design company in odisha|coding classes near me |data science course| Software Development | PHP Training | College Projects College Projects| mtech projects | btech projects | mca projects| bca projects | .NET Training | C Programing | Java Training | SqlServer Training | Android Training | Berhampur Training | Orissa Training Institute | Corporate Training | Python Training | Tally Training | Autocad Training | Matlab near me, Best Java Trainign in Berhampur | software development in berhampur,Software Development, sms service, purchase transactional sms, Web site designing ,c,C programming in Berhampur, c++, java, .net, python training, Matlab,Matlab college Project, net, php, college project, free projects, dca, pgdca, web designing, web development,dtp, .net projects, java projects, php project, c#,vb, asp.net, tally, free books, computer learning, compute education, computer education in berhampur, ACEIT, online python training, online java training, online matalab training, online javascript training, online php training, online training, online computer education

Contact

Place:Berhampur-760001
Working hours:9:AM - 8PM
Phone:+91 801 803 3055
Email:info@aceit.in

aceit,
Gandhi Nagar 1st Lane , Near SAI Complex , Berhampur, Odisha, Ganjam-760001

25 %off

mysql

_₹ 4500

(608 ratings)

MySQL is a relational database management system based on the Structured Query Language, which is the popular language for accessing and managing the records in the database. MySQL is open-source and free software under the GNU license.

Course Price

~~₹6000~~

Offer Price

₹4500

Course Duration

35H

Bye Now Added

Syllabus Content Course Details Other Details

RDBMS Introduction

Normalization in RDBMS

Create database objects i.e. Create Table

Delete database objects i. e. Delete Database

Alter database objects i.e. Change Column Name

Create, alter and delete constraints

Relation Database Management System (RDBMS)

Normalization

Create Database objects

Data Types in SQL

Alter Table Statements

Drop Table Statements

Various Constraints

Creating Views

Hands-on/Demo/Use-case:

Create Table With Predefine Columns

Add New Column to Existing Table

Check the constraints on a table

Add Primary Key and Foreign Key on Table

Remove Unique Constraint

Insert record/data in tables

Modify/Update the existing data

Retrieve the data from database from single table

Use of operators for data retrieval

Delete the data from tables

Insert Statements

Insert As- Select Statement

Update Statements

Delete Statements

Truncate Statements

Select Statement

Sorting and Filtering

SQL wildcard

CASE Expression

Self-Join

Inner Join

Left Join

Right Join

Cross Join

Conversion Function

Logical Functions

Math Function

Aggregate Functions

String Functions

Date Functions

Trigger

Procedure

SQL Maintenance

Contact

mysql

Course Price

Offer Price

Course Duration

`Certificate` : Yes

`Study Material` : Yes

`Project` : Self

`Strength` : Max 10

`Duration` : 35H

`Language` : English, Telegu, Hindi, Oriya

`Class` : Online / Offline

Contact

mysql

Course Price

Offer Price

Course Duration

Certificate : Yes

Study Material : Yes

Project : Self

Strength : Max 10

Duration : 35H

Language : English, Telegu, Hindi, Oriya

Class : Online / Offline

`Certificate` : Yes

`Study Material` : Yes

`Project` : Self

`Strength` : Max 10

`Duration` : 35H

`Language` : English, Telegu, Hindi, Oriya

`Class` : Online / Offline