RDBMS-SQL course
SQL, MySQL
Lectures -143
Duration -13 hours
30-days Money-Back Guarantee
Get your team access to 10000+ top Tutorials Point courses anytime, anywhere.
Course Description
Database development with MySQL is one of the most fundamental skills that a technology professional needs to thrive in today's workplace. This course gives you that skill. You'll start with the absolute basics of installing and creating databases to resolving the complex queries.
In this course you can learn the fundamental basics of RDBMS and Data Management with SQL. Learn everything that you will need to construct queries with the most popular data manipulating programming language - SQL. The course is a self-paced and you can work through it at your own pace. The course is a right blend of concepts and hands-on to take a step towards making you a pro in SQL.
10+ hours of on demand videos
Clarifications through community
Right blend of concepts and hands-on
Built in Assessment to test your knowledge
In this course, you will:
The difference between Data and Information
Why do we need Data?
Learn the ins and outs of SQL syntax
What is RDBMS and its History?
Database Objects and Database Design
Learning about the Keys and Constraints
Explaining the Normalization and its types
Understanding the Transactions and its types
How to write SQL queries to Manipulate data
How to write SQL queries to insert, update and delete data into database
Analyze data using Aggregate Functions
Run complex queries using MySQL logical operators
How to handle the NULL values in the SQL
Write all the common SQL joins
Querying the data using Set Operators
Executing the complex queries with String Functions
And more!!!!
Who this course is for:
- Beginners who want to learn RDBMS and SQL
- Database developers and database administrators.
- Students who wish to learn a new skill to develop their career.
- Professional who wish to learn a new skill to develop their career.
Goals
What will you learn in this course:
Understand the basic and Intermediate concepts of databases and MySQL
How to write SQL queries to manipulate data.
Learn how to create database tables using SQL commands.
Learn how to perform different types of join operations.
Learn SQL operators to write complex SQL queries.
Learn how to perform different types of Set Operators.
Learn about different SQL functions and constrains including NULL values.
How to write SQL queries to insert, update and delete data into database.
Prerequisites
What are the prerequisites for this course?
Passion and curiosity to learn something new technology
No technical knowledge required.
A computer with internet connection.
Curriculum
Check out the detailed breakdown of what’s inside the course
Welcome to course
2 Lectures
- Introduction to RDBMS 02:08 02:08
- RDBMS SQL(youtube) 02:01 02:01
Installation Video
3 Lectures
RDBMS
49 Lectures
SQL
89 Lectures
Instructor Details
Blismos Academy
eCourse Certificate
Use your certificate to make a career change or to advance in your current career.
Our students work
with the Best
Related Video Courses
View MoreAnnual Membership
Become a valued member of Tutorials Point and enjoy unlimited access to our vast library of top-rated Video Courses
Subscribe nowOnline Certifications
Master prominent technologies at full length and become a valued certified professional.
Explore Now