SQL

This course is designed for everyone who want to learn the basics and advanced level of SQL programming. Students will learn up to advanced level of SQL and gain hands-on experience creating simple database applications.

SQL is a primary and set of commands which are used to work in the relational database management databases. With SQL, we can query the data that we need and do so efficiently, playing into the strengths of the database engine.

We will be able to rapidly work on any relational databases by understanding SQL. SQL is worth learning because it’s not only simple to learn, but it also continues to be a highly in-demand skill.

Most of the professionals who wish to work as Data Analyst, Data Engineer, Data Scientist, Database Developer, ETL Developer (BI Developer), Report Developer, Test Engineer, Performance Engineer and/or Business Analyst, they should learn and get some extent of experience in SQL to continue day to day work.

Make most of the ample job opportunities in this field by learning hands-on and functional SQL, PL/SQL, T-SQL and client tools and techniques.

Content:

• Module 1 :Introduction of SQL, RDBS,Software’s and Tools
• History of SQL
• What is the Transact SQL and PL/SQL?
• Understand the difference in MS SQL Server database and Oracle database!
• SQL Server Versions and Editions
• SQL Server Management Studio Tool
• SQL Developer Tool
• DBeaver Tool
• DB Visualizer Tool
• Toad Tool
• Module 2: DB Objects and SQL Commands
• Different Types of Objects in RDBMS databases
• What is the purpose of Table object?
• Understand Different terminologies like Columns, Rows, Data & Attributes
• SQL Commands
• Different data types in SQL
• DDL – Data Definition Language (CREATE, ALTER & DROP)
• DML – Data Manipulation Language (INSERT, UPDATE & DELETE)
• TCL – Transaction Control Language (BEGIN TRAN, COMMIT, ROLLBACK & SAVEPOINT)
• DCL – Data Control Language (GRANT & REVOKE)
• DRL – Data Retrieval Language (SELECT)
• Module 3: Different Types of Operators
• Different Types of Operators in RDBMS databases
• Understand the query logical processing in SQL
• Comparison Operators (<, >, <=, >=, =, !=, <>)
• Logical Operators (NOT, AND, OR)
• Wildcard Search Operators (%, _, ^, [] )
• Combine Data Set Operators (UNION ALL, UNION, INTERSECT, EXCEPT & MINUS)
• Module 4: Normalization Forms, Keys and Relationships
• Different Types of Normal Forms
• Normal Form 1 Rules
• Normal Form 2 Rules
• Normal Form 3 Rules
• Understand the concept of Key in a Dataset
• Different types of Keys
• Super Keys, Candidate Keys & Primary Key in a Table
• Understand the Parent and Child table’s
• Different types of Relationships
• One to One Relationship
• One to Many Relationship
• Many to Many Relationship
• Module 5: Different Types of Constraints
• Different types of constraints
• Understand business rules in a dataset
• NULL & NOT NULL constraints
• Default constraints
• Check constraints
• Primary key constraints
• Foreign key constraints
• Unique key constraints
• Module 6: Joins
• Different types of joins
• Rules and recommendations to join datasets
• Inner join
• Outer Joins – Left Join / Left Outer Join
• Outer Joins – Right Join / Right Outer Join
• Outer Joins – Full Join / Full Outer Join
• Cross join & Cartesian product
• Self join
• Equi join
• Update & delete the data from a table by using joins
• SQL Training in vizag
• Module 7: Built-in Functions
• Different types of functions
• Variables in SQL
• And more.