Dbms/SQL

Course Description

Database's are used by almost all the languages like Java, Android, Php, ASP.NET and is required by almost all IT firms. Understanding and implementing Database are not as easy as it looks and one should have the proper knowledge of creating and maintaining the databases. In this course, we will begin with basics of database like Db, DB Softwares, Tables, Columns, Datatypes, Keys. then we will focus on the basic queries Create, Update, Delete, Select. Then we focus on implementing Nested Queries and Joins . At the end we will work with PL/SQL basics like Procedures, Triggers, Index, Cursors.

Certification

We provide 6 weeks industrial training in DBMS/SQL and provide the ISO certificate at the end of the course. At NCC, we also provide the complete guidance in building college level professional projects.

Learning Outcomes

• Over 30 Lectures and 5 tests
• Testing Training Included.
• Learn SQL queries and creating Databases from a professional trainer.
• Information packed practical training starting from basics to advanced testing techniques.
• Best suitable for beginners to advanced level users and who learn faster when demonstrated.
• Course content designed by considering current job market.
• Practical assignments at the end of every session.
• Practical learning experience with live project work and examples.

SQL and PL/SQL Programming Chapters in Glance

• Lecture 1 Introduction to SQL and Database
• Lecture 2 Table Basics
• Lecture 3 Column Datatypes and Keys
• Lecture 4 Creating Database and Tables
• Lecture 5 Selecting data(Select, where, having, order by, group by)
• Lecture 6 Updating table
• Lecture 7 Deleting Tables
• Lecture 8 Advanced Queries
• Lecture 9 Nested Queries and Joins
• Lecture 10 SQL Operators(In, Or) and Wild Cards
• Lecture 11 SQL Functions
• Lecture 12 Introduction to PL/SQL
• Lecture 13 Programming in PL/SQL
• Lecture 14 Cursors, Triggers, Index
• Assignments and Project