INSTRUCTOR LED ONLINE LIVE SESSIONS

MySQL

Course Brief

The aim of this course to make you proficient in designing a database, administrating MySQL database and querying the database for extracting the needed information. During this course you will learn to query the database, schema refinement and database design, and creating triggers, cursors, stored procedures. The course covers the following: RDBMS concepts, MySQL Commands, Integrity Constraints, User management, Normalization, Transaction Management, Triggers, Cursors, Functions, Procedures and Exception Handling.

    Introduction to DBMS, What is a Database, What is Management System, Different views of data, Advantages and disadvantages of RDBMS,Introduction to SQL,Sub language of SQL (DDL, DML, DQL/DRL, TCL & DCL).

    Learning Outcomes:

    • Understand the RDBMS concepts and to get an understanding of SQL at high level

    What is a database table?, How do we create tables?, How do we insert Data?, How to retrieve/select data?, How do we delete data?, How do we update data?

    Learning Outcomes:

    • Basic SQL related to creating, inserting, deleting and updating data

    Logical operators, Between operators, In operator, Pattern matching operators.

    Learning Outcomes:

    • Different SQL operators and their usage

    Detailed coverage of DDL (Data definition language):CREATE, ALTER, DROP, TRUNCATE, RENAME.

    Learning Outcomes:

    • Understand the different DDL statements

    MySql Functions, Aggregate functions,Scalar functions (String functions, date related, numeric related, conversion function, null related functions.),Group by, order by, having clause.

    Learning Outcomes:

    • Understand the aggregate functions and group by/order by and having clause as part of SQL

    Inner Join, Left Join, Right join and full join.

    Learning Outcomes:

    • Understanding Joins in SQL

    Triggers, Procedures, Functions, Views and ACID properties.

    Learning Outcomes:

    • Understand how to create stored procedures, triggers, functions, views and ACID properties

    Normalization (1NF, 2NF, 3NF & BCNF).

    Learning Outcomes:

    • Role of Normalization for good RDBMS design

Ms. Jyothi SanjeevaMani
MySQL

Ms. Jyothi SanjeevaMani has over 15 years of satisfying teaching and technical training experience. She is a Research Scholar of Big Data Analytics from a reputed university. As a technical trainer she trained many students in industry oriented subjects like C, C++, Java, MySQL, Oracle (SQL, PL/SQL), Python, Linux, Openstack, BigData - Hadoop(MapReduce, Pig, Hive, Sqoop, Flume), Data Science with both Python and R.

She is an Asst.Professor with the Department of IT at The Keshav Memorial Institute of Technology (KMIT).

She is a dedicated, resourceful and a result oriented instructor, who strives to help students change marginal grades into good grades.

  • Are there any pre requisites for this course?

    No. There are no prerequisites for this course.

  • How long does it take to complete this Course?

    Most learners are able to complete the course in about 3 weeks.

  • What will I be able to do upon completing this specialization?

    Upon completion of the MySQL course you will be a skilled professional ready to face interviews and land a deserving job.

  • Can I attend a demo session?

    We have limited number of participants in a live session to maintain the Quality Standards, hence, participation in a live class without enrollment is not possible. However, we can create a demo login for one demo session.

  • What are the payment options?

    You can pay by Credit Card, Debit Card or Net Banking from all the leading banks. We use a Payment Gateway. 

  • What is the typical batch size of a course?

    We expect around 50 students to be part of the course

Login to your Teleuniv account!

Don't have an account? Sign up

Sign up and start learning!

Show

By signing up, you agree to our Terms of Use and Privacy Policy.

Already have an account? Login

Forgot Password?

Lost your password? Please enter your email address. You will receive a link to create a new password.

Error message here!

or Back to login