MySQL in Telugu
0.0 (0 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
0 students enrolled
Wishlisted Wishlist

Please confirm that you want to add MySQL in Telugu to your Wishlist.

Add to Wishlist

MySQL in Telugu

MySQL DataBase Development Step by Step in Telugu
0.0 (0 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
0 students enrolled
Created by Vijay Kumar
Last updated 6/2017
Telugu
Price: $35
30-Day Money-Back Guarantee
Includes:
  • 10 hours on-demand video
  • 56 Supplemental Resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I Learn?
  • Create, query and update databases
  • Understand transactions and database isolation levels.
  • Use triggers, views and stored procedures
  • Understand database users and security.
View Curriculum
Requirements
  • You will need to download and install the free MySQL Server Community Edition and the free MySQL Workbench or phpMyadmin
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, 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.

Who is the target audience?
  • This course teaches you MySQL from the very beginning.
  • No prior knowledge is required, other than basic knowledge of your computer.
  • By the end of the course you will be able to use MySQL to an advanced level.
Students Who Viewed This Course Also Viewed
Curriculum For This Course
60 Lectures
10:01:31
+
Database Fundamentals
6 Lectures 41:40

DBMS Models & HDBMS
04:53

DBMS Models & NDBMS
03:33

DBMS Models & RDBMS
07:14

DBMS Models & ORDBMS & OODBMS
08:25

Database Architecture 1 tier, 2 tier & 3 tier
11:00
+
Starting MySQL
5 Lectures 54:29
MySQL Introduction
10:50



Login to MySQL Users
11:20

Creating New Users in MySQL
11:15
+
Basics of MySQL
4 Lectures 31:05
Principles of entering commands in MySQL
07:41

Naming Rules in MySQL
05:26

User defined variables & Comments in MySQL
04:14

Datatypes in MySQL
13:44
+
SQL commands in MySQL
9 Lectures 01:28:59
SQL introduction
10:10

Creating & Managing DataBases in MySQL
10:55

Creating Tables in MySQL
11:28

Insert data into tables in MySQL
08:06

Retrive data from tables using Select statement in MySQL
16:02

Create table & Insert statements using Select statement in MySQL
05:10

UPDATE,DELETE & TRUNCATE Statements in MySQL
10:18

ALTER TABLE & DROP TABLE commands in MySQL
08:53

SELECT INTO & LOAD statements to Export & Import data in MySQL
07:57
+
Operators & Data Integrity Constraints in MySQL
7 Lectures 01:12:01
Operators in MySQL
20:32

Introduction to Data Integrity Constraints in MySQL
06:48

Data Integrity Constraints & NOT NULL in MySQL
06:30

Data Integrity Constraints & UNIQUE in MySQL
06:27

Data Integrity Constraints & PRIMARY KEY in MySQL
05:03

Data Integrity Constraints & DEFAULT, AUTOINCREMENT & CHECK in MySQL
10:09

Data Integrity Constraints & FOREIGN KEY or Referential Integrity in MySQL
16:32
+
Indexes & Partitioning in MySQL
3 Lectures 33:00
Indexes in MySQL
06:31

MySQL Partitioning - RANGE Partitioning
15:23

MySQL Partitioning - LIST,COLUMNS,HASH,KEY & SUB Partitionnings
11:06
+
Built-in Functions in MySQL
8 Lectures 01:25:43
Mathematical functions in MySQL
10:07

String functions in MySQL
22:34

Date & Time functions in MySQL
16:02

Control Flow functions in MySQL
06:54

Encryption & Compression function in MySQL
10:18

Information functions in MySQL
09:24

Aggregate or Group functions in MySQL
03:03

Other functions in MySQL
07:21
+
Joins & Sub queries in MySQL
4 Lectures 54:11
Joins in MySQL
11:32

Union Operator in MySQL
06:03

Sub-Queries in MySQL
26:40

Common Queries & Sub queries examples in MySQL
09:56
+
TCL & DCL Commands in MySQL
3 Lectures 39:19
Transaction & Locking commands (TCL)-COMMIT,ROLLBACK,SAVEPOINT & LOCK
18:41

Data Control Language commands (DCL)-GRANT & REVOKE in MySQL
13:05

RENAME,REPLACE & HANDLER commands in MySQL
07:33
+
MySQL & GUI ( phpMyAdmin)
3 Lectures 23:03
PhpMyAdmin - How to start & MySQL with GUI
07:27

How to manage Databases & Tables using PhpMyAdmin in MySQL
07:52

How to Build query,Export & Import Databases using PhpMyAdmin in MySQL
07:44
2 More Sections
About the Instructor
Vijay Kumar
4.0 Average rating
1 Review
3 Students
19 Courses
Passionate teacher

Vijay Kumar is a passionate teacher with a strong focus on pragmatism and simplicity. He started teaching programming 25 years ago when the first set of general use computers were just reaching the shores of India. He is known for his teaching style with strong emphasis on bringing clarity to the learners right from basics till advanced features.