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?
- COMMIT, ROLLBACK and SAVEPOINT
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:
- PHP + MYSQL Job Interview Questions & Answers
- Data Sciences Job Interview Questions and Answers
- Machine Learning Job Interview Questions
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
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)
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
MySQL Database (for Beginners)
Excel Training Course (for Beginners)
Python Programming (for Beginner)