About this course
Learn to become a fee-earning SQL developer in just seven weeks.
This fast, easy and effective course will take you from zero sql writing skills to being able to make money as a SQL developer.
This one-stop-shot-style course will teach you everything you need to know, from learning various database concepts to writing SQL to interact with the database.
Throughout the course I will be using the below methodology to make you think and help in forming the SQL statement.
Business Need:
Manager asks you to give you a report containing total sales volume for January month by day and city
Questions in your mind to build your query
Question | Answer |
---|---|
Give? | SELECT |
What columns? | DAY, CITY |
Summary? | SUM(VOLUME) |
Preposition? | FROM |
Which table contains sales orders data? | SALES |
Filter? | WHERE SALES_DATE BETWEEN 01-JAN-2015 and 31-JAN-2015 |
Grouping? | GROUP BY DAY, CITY |
Combine the above answers to form the below SQL
SELECT day, city, SUM(volume)
FROM sales
WHERE sales_date BETWEEN 01-JAN-2015 AND 31-JAN-2015
GROUP BY day, city;
In this course participants will learn
- Relational databases Concepts
- Retreiving Data from Database
- Filtering Data based on business requirements
- Creating Tables and modifying its structure
- Joining Data from various Tables
- Grouping Data and calculating summaries
- Enforcing Constraints on Tables
- Improving performance using Index
- and many more interesting things..
Softwares used
- Oracle Database 11g
- SQL Developer
What are the requirements?
- Any Student with computer operation knowledge is good enough to understand this course
What am I going to get from this course?
- Over 111 lectures and 5.5 hours of content!
- Understand Database terminology
- Read data from the database
- Create data in the database
- Enforce restrictions on what type of data can be stored
- Improve performance using Index
What is the target audience?
- This SQL course is meant for newbies who are not familiar with SQL syntax and/or students looking for a quick refresher on SQL and some important Database concepts. No programming knowledge is needed.