INSTRUCTOR LED ONLINE LIVE SESSIONS

Course Brief

    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.

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