*Friday CLOSED

Timings 10.00 am - 08.00 pm

Call : 021-3455-6664, 0312-216-9325 DHA 021-35344-600, 03333808376, ISB 03333808376

Or log in to access your purchased courses
by fatima
Price: 60,000
2 Months
0 Lessons

Introduction to SQL Database

Introduction to SQL Database

In this course you can learn the fundamental basics of data management with SQL . Learn everything that you will need to make queries with the most popular data manipulating programming language – SQL. This course is about SQL commands in the main. You will learn the basics of queries. Let’s take a look at what you are going to learn in this course

Course Key Learnings:

After completing this course, students will be able to:

  • understand the basic concepts of databases
  • get a good grasp of SQL and MySQL queries
  • understand database management systems (DBMSs) and database languages
  • understand table manipulation
  • understand pages
  • understand views
  • understand strored procedures
  • understand the data structures (B trees and B+ trees) behind databases

Course Outline:

Module1 – Installing MySQL server

  • Installing MySQL server on Windows and MacOS

Module 2 – Database Theory

  • what are databases?
  • what are database management systems (DBMSs)?
  • what are database languages?
  • the data structures (B-trees) behind databases
  • procedural and non-procedural programming languages

Module 3 – Creating and Manipulating Tables

  • basic data types (integers, floating point numbers and characters)
  • enums and dates
  • how to create databases?
  • how to insert and remove items?
  • how to update existing items or database tables?

Module 4 – Basic SQL

  • basic SQL and MySQL commands
  • select, where and wildcards
  • logical operators
  • ORDER BY and GROUP BY commands

Module 5 – Multiple Tables

  • joining multiple database tables
  • inner join
  • left and right join

Module 6 – Database Normalization

  • what is database normalisation?
  • first normal form (NF1)
  • second normal form (NF2)
  • third normal form (NF3)

Module 7 – Subqueries:

  • advanced SQL and MySQL
  • what are subqueries?
  • correlated and non-correlated subqueries

Module 8 – Transactions

  • what is database locking?
  • the ACID principles?

Module 9 – Views

  • what are views and why are they crucial?
  • creating views
  • updating views
  • dropping views

Module 10 – Indexes and Constraints

  • what are indexes and why to use them?
  • primary keys and foreign keys revisited
  • what are constraints?

Module 11 – Data Structures Behind Databases

  • what are pages?
  • the basic concept of paging in operating systems
  • external memory and internal memory
  • B tree data structure
  • B+ tree data structure

Module 12 – Stored Procedures

  • what are stored procedures?
  • variables
  • loops
  • conditional statements

Who this course is for:
  • This course is mean for newbies who are not familiar with SQL syntax or just want to refresh the knowledge

International Student Fee:700 USD

Job Interview Questions & Answers:

Job Interview Preparation  (Soft Skills Questions & Answers)

 Your FREE eLEARNING Courses (Click Here)

Internships, Freelance and Full-Time Work opportunities

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

Microsoft SQL Server Database Administration Course

Oracle SQL Database Expert

MySQL Database (for Beginners)

Excel Training Course (for Beginners)

Transact- SQL Quering

Python Programming (for Beginner)



Flexible Classes Schedule

Online Classes for out of city / country students

Unlimited Learning - FREE Workshops

FREE Practice Exam

Internships Available

Free Course Recordings Videos

Register Now


Or log in to access your purchased courses

OMNI ACADEMY & CONSULTING is one of the most prestigious Training & Consulting firm, founded in 2010, under MHSG Consulting Group aim to help our customers in transforming their people and business - be more engage with customers through digital transformation. Helping People to Get Valuable Skills and Get Jobs.

Read More

Contact Us

Get your self enrolled for unlimited learning 1000+ Courses, Corporate Group Training, Instructor led Class-Room and ONLINE learning options. Join Now!
  • Head Office: A-2/3 Westland Trade Centre, Shahra-e-Faisal PECHS Karachi 75350 Pakistan Call 0213-455-6664 WhatsApp 0334-318-2845, 0336-7222-191, +92 312 2169325
  • Gulshan Branch: A-242, Sardar Ali Sabri Rd. Block-2, Gulshan-e-Iqbal, Karachi-75300, Call/WhatsApp 0213-498-6664, 0331-3929-217, 0334-1757-521, 0312-2169325
  • ONLINE INQUIRY: Call/WhatsApp +92 312 2169325, 0334-318-2845, Lahore 0333-3808376, Islamabad 0331-3929217, Saudi Arabia 050 2283468
  • DHA Branch: 14-C, Saher Commercial Area, Phase VII, Defence Housing Authority, Karachi-75500 Pakistan. 0213-5344600, 0337-7222-191, 0333-3808-376
  • info@omni-academy.com
  • FREE Support | WhatsApp/Chat/Call : +92 312 2169325

  • Monday10.00am - 7.00pm
  • Tuesday10.00am - 7.00pm
  • Wednesday10.00am - 7.00pm
  • Thursday10.00am - 7.00pm
  • FridayClosed
  • Saturday10.00am - 7.00pm
  • Sunday10.00am - 7.00pm
WhatsApp Us