MySQL a-z in Telugu

person icon Vijay Kumar Parvatha Reddy

Buy Now

MySQL a-z in Telugu

Name: MySQL a-z in Telugu
Price: 30 USD
Author: Vijay Kumar Parvatha Reddy

Data Base Management Step by Step through MySQL

updated on icon Updated on Sep, 2023

language icon Language - English

person icon Vijay Kumar Parvatha Reddy

architecture icon Development,MySQL,Database Design & Development

Add to Cart Buy Now

30-days Money-Back Guarantee

Training 5 or more people ?

Get your team access to 19,000+ top Tutorialspoint courses anytime, anywhere.

Course Description

This course will take you from beginner in SQL and MySQL to an advanced level. Whether you're a complete beginner with only basic computer knowledge, or a professional who already uses MySQL but wants to understand advanced features like transactions, user permissions, triggers and stored procedures etc.. this course can help you.

Database skills are highly in demand in the I.T. industry; everything from websites to multiplayer games are likely to make use of some kind of database.

MySQL is a free, industrial-strength relational database, very widely used all over the world. In fact, the MySQL Community Server (which this course covers to an advanced level) is the world's most popular open-source database, used by millions of websites.

Goals

What will you learn in this course:

Create, query and update databases
Understand transactions and database isolation levels.
How to use triggers, views and stored procedures etc. objects.
Understand database users and security.
By the end of the course you will be able to use MySQL to an advanced level.

Prerequisites

What are the prerequisites for this course?

You will need to download and install the free MySQL Server Community Edition and the free MySQL Workbench or phpMyadmin. We explained in this course.
No prior knowledge is required, other than basic knowledge of your computer.

Curriculum

Check out the detailed breakdown of what’s inside the course

Database Fundamentals
6 Lectures

Introduction to Database 06:35 06:35
DBMS Models & HDBMS 04:53 04:53
DBMS Models & NDBMS 03:33 03:33
DBMS Models & RDBMS 07:14 07:14
DBMS Models & ORDBMS & OODBMS 08:25 08:25
Database Architecture 1 tier, 2 tier & 3 tier 11:00 11:00

Starting MySQL
5 Lectures

Basics of MySQL
4 Lectures

SQL commands in MySQL
9 Lectures

Operators & Data Integrity Constraints in MySQL
7 Lectures

Indexes & Partitioning in MySQL
3 Lectures

Built-in Functions in MySQL
8 Lectures

Joins & Sub queries in MySQL
4 Lectures

TCL & DCL Commands in MySQL
3 Lectures

MySQL & GUI ( phpMyAdmin)
3 Lectures

Stored Routines ( Sub Programs) & Cursors in MySQL
5 Lectures

How to use Triggers,Events & views in MySQL
3 Lectures

Instructor Details

Vijay Kumar Parvatha Reddy

Course Certificate

User your certification to make a career change or to advance in your current career. Salaries are among the highest in the world.