SQL Training – Oracle SQL/MySQL/MSSQ
SQL is the world’s most popular open source database. Whether you’re a beginner or an experienced user, a MySQL database administrator, MySQL developer, or a MySQL security administrator, digital training helps you develop deeper knowledge of relational databases so you can manage your MySQL applications more efficiently.
SQL (Structured Query Language) is a standard language used to interact with relational databases. It allows users to retrieve, manipulate, and manage data stored in databases. Oracle, MySQL, and MSSQL are three popular relational database management systems (RDBMS) that support SQL.
Course Key Learnings:
-
Learn Data Modeling
-
Understand Relational database Terminology
-
Install and Use MS SQL Server and MySQL
Course Content:
Module1 -Basics
- Selection of all columns/fields
- Selection of certain columns/fields
- Use of distinct/unique
- Selection of certain rows/records
- Selection of values in a range
- Selection of values matching a pattern mask
- Selection of values within a list
- Treatment of null values
- How to sort and order data
- Selection of calculated and derived values
- How to control column headings in query results
- How to send query results to external files
Module2-Joining Tables
- Principles of joining tables:
- Use of cartesian join
- Use of inner join
- Use of non-equi join
- Use of outer join
Module3-Joining Queries
- Union operator
- Intersect operator
- Except operator
Module-4 Simple Functions
- Conversion functions
- Date functions
- Number functions
- Text functions
- Group/summary/aggregate functions
Module5-Sub-Queries
- Principles of sub-queries
- How to filter rows from main query
- Use of nested sub-query
- Use of multi-column sub-query
- Use of correlated sub-query
- Use of sub-query as an inline view and common table expression
- Use of sub-query as a column in main query
Module6- Case Statements
- Principles of case statements
- Use of case statement to derive column values
- Use of nested case statements
- Use of case statements to produce pivot tables
- Use of case statement with sub-queries
Module7-Data Manipulation
- How to insert values into a table
- How to copy values between tables
- How to update values
- How to delete records
- How to change data via views
- Use of transactions
- How to lock rows and tables
Module-8Data Definition
- Principles of a relational database and data normalisation
- Use of primary key and foreign key relationships and constraints
- How to create tables
- How to alter tables
- How to create views
- Use of synonyms
- How to remove tables and views
Who this course is for:
- Those who need to learn SQL and relational databases from scratch in MySQL and MS SQL Server
International Student FEE : USD 200 |
Job Interview Preparation (Soft Skills Questions & Answers)
- Tough Open-Ended Job Interview Questions
- What to Wear for Best Job Interview Attire
- Job Interview Question- What are You Passionate About?
- How to Prepare for a Job Promotion Interview
Stay connected even when you’re apart
👬🏻Join our WhatsApp Channel – Get discount offers
🧮 500+ Free Certification Exam Practice Question and Answers
Internships, Freelance and Full-Time Work opportunities
👫🏻 Join Internships and Referral Program (click for details)
👫🏻 Work as Freelancer or Full-Time Employee (click for details)
Flexible Class Options
- Week End Classes For Professionals SAT | SUN
- Corporate Group Trainings Available
- Online Classes – Live Virtual Class (L.V.C), Online Training
Related Courses
MySQL Database Administration (Beginner)
SQL Server Performance Tuning and Optimization
Administering a SQL Database Infrastructure
MySQL Course – Learn SQL Step-By-Step With Examples