What you will learn
SQL is one of the most in demand tech skills today, and learning SQL would surely be one of the fastest and most efficient way to improve ones career prospectus. After the completion of course, one will be able to read, write and comprehend simple to most complex queries of SQL, using which they could work upon any SQL database such as Oracle, Amazon Redshift and others.
Description
Learn SQL in a simplified manner is one of the best SQL course on Udemy crafted in a way that it would serve both the beginner and software professionals who want to learn or refresh their knowledge on one of the most in demand skill of tech world – SQL. The course is designed in a way that one could complete it in less than 4 weeks with 0 prior experience to programming.
Who is the course for?
This course is designed for the learners who are:
- beginners in this field
- want to prepare for University examinations
- want to prepare for placement interviews
- software professionals who want to quick start there carrier as SQL expert
in a short time span.
What topics will this course cover?
- Create Tables in SQL
- Perform Basic Operations of database like Insert, Update, Delete and Retrieve with SQL
- Integrity Constraints
- Alteration in existing table structure
- Learn to Join one and more Tables in the database
- Learn Grouping of Data
What will you achieve?
By the end of the course, you’ll be able to…
- Design tables to store data
- Demonstrate the use of Insert, Update, Delete and Retrieve operations on database
- Apply integrity constraints during creation of tables
- Perform alteration in structure of existing table
- Access data from multiple tables with the use of Join operations
- Perform grouping of data on one or more columns
- Perform selection of groups
- Explore the use of database in modern world
Learn and Explore the world of Database !
HAPPY LEARNING !!!!
English
language
Content
Introduction to SQL
Introduction to SQL
Performing Basic Operations with SQL
Introduction to SQL
Creation of Tables with Constraints
Need of Constraints
Not Null, Unique and Primary Key Constraint
CHECK constraint
FOREIGN KEY Constraint
Demonstration of Foreign Key constraint
DEFAULT Constraint and Accessing Constraint information
Creation of Table with constraints
Table Alteration
Alter Table Add Option
Alter Table: Modify and Drop Option
Joining of Tables
Joining of tables and Its Types
OUTER JOIN
SELF JOIN
Table Alteration and SQL joins
Grouping of Data
GROUP BY Clause
GROUPING on more than one column
HAVING Clause
Inbuilt Functions of SQL
Grouping of Data