Read more
2 Months/20 Hour Price35,000
30,000
SQL Training-Oracle SQL/MYSQL/MSSQL
SQL Training-Oracle SQL/MYSQL/MSSQLThis course is designed to provide a comprehensive introduction to the SQL programming language, which is the standard language for relational database management systems. Whether you’re a beginner with no prior experience in SQL or database management, or a professional looking to refresh your skills, this course is perfect for you.
Key leranings:
By the end of this course, learners will be able to:
Design and create databases using SQL
Analyze data using SQL
Troubleshoot common SQL errors and issues
Apply best practices for writing effective SQL queries
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
Module4-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
Module-7Data 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
Prerequisites
None
International student Fess: USD300$
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
Your FREE eLEARNING Courses (Click Here)
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)
Hire an Intern
Flexible Class Options
Week End Classes For Professionals SAT | SUN
Corporate Group Trainings Available
Online Classes – Live Virtual Class (L.V.C), Online Training
SQL Courses
MySQL Course – Learn SQL Step-By-Step With Examples
MySQL Boot camp – SQL Beginner to Expert
Introduction to SQL Database
MySQL Database (for Beginners)
Java Programming for Beginners
PHP Programming (for Beginner)
Computer Networking (for Beginners)
0 Reviews