Course Information
Registration period
Year-round Recruitment
Course Level
Study Mode
Duration
1 Hour(s) 58 Minute(s)
Language
English
Taught by
Umang Shah
Rating
Course Overview
Understand what is SQL , Start writing Simple and Complex SQL Queries using MySQL. Very useful for Data Analysis.
Master SQL in less than 3 Hours :
- Do You Want to Become a professional Software / Web Application Developer and increase your income Exponentially ?
- Are you a Marketing Professional Who wants to use SQL for making Better Marketing Decisions ?
- Are you a University Student Working Towards a Computer Science or Information Technology Degree ?
Then look no further as you have come to the right place. I have been working with SQL for more than 7 Years now and am currently working as an Application developer. This in-depth course on SQL taught by me covers everything from the very basic definitions to very complex concepts of RELATIONAL DATABASES , FOREIGN KEYS and JOINS so that by the time this course ends, You will have an excellent understanding of all the important concepts of SQL to get things rolling for you.
SQL can be used in almost all fields in today's technology driven world whether you are into your own business or into marketing or into development of Web / Mobile applications. You can use SQL to Analyze tons and tons of data within milliseconds and use the results of analysis to make better fact and data based decision thereby increasing the chances of arriving at a correct decision.
I can assure you that you will enjoy this course and hope that you would make the most of the knowledge you would have gained by the end of this course. Thanks and hope to see you in Lectures.
Course Content
- 7 section(s)
- 45 lecture(s)
- Section 1 Introduction
- Section 2 Inserts , Selects and Updates
- Section 3 MySQL Datatypes and Constraints
- Section 4 JOINS and UNIONS
- Section 5 GROUPS and MySQL Functions
- Section 6 VIEWS
- Section 7 DELETEs , DROPs and TRUNCATEs
What You’ll Learn
- Create SQL/MySQL based applications for companies of all shapes and sizes, Understand all concepts of SQL and databases, Analyze tons of data in few seconds, Make better fact based decisions, Spot trends and patterns easily in pile of data
Skills covered in this course
Reviews
-
SSamrat Kuldip
I started from zero and now i am comfortable. It was crisp,easy to understand and short.It would be great, if you could add topics related to different types of keys and normalization,and we could get more assesments.It would be a complete package then.Overall it was nice and good for noobs.
-
RRotem Amir
The course helped me as expected, I think i found a mistake in one of the solutions of this course. question number 23 in the first download page of section 7 will present also employees who sold cheese
-
SSerena Gyi
Excellent short course. Very good quizzes. Very good exercises. I used this to cram before a job interview. I was comfortably prepared. I didn't know everything of course, but I was surprised by how much I learned in just this 3-hour course that they asked me about in the interview. Highly recommend.
-
DDarren Jones
This is a good quick and to the point intro to what MySQL is and how to create databases and some basics on how to manipulate them. Good place to get started. After the course you will be able to create Databases and tables and insert info into them and compare them etc. Worth the $10 I spent.
