As I started developing android apps I felt the necessity of storing data. But I had no prior knowledge about Databases. So started learning about My SQL from Sololearn. They have a nice interface and a very friendly interactive learning platform. It usually follows the videos of newboston but at the same time has quizzes to test the knowledge instantly. I've been at it for the last 2 weeks and managed to finish it .
Certificate Link: http://www.sololearn.com/Certificate/1060-1489426/pdf/
Some of the concepts I have learned about SQL from the course are mentioned below:
*Introduction to Databases
*SQL Statements: Select
*SQL Syntax Rules
*Selecting Multiple Columns
*Distinct and Limits
*Storing Results
*WHERE Statements
*Filtering with AND,OR
*IN,NOT IN Statements
*Custom Columns
*Functions
*Sub queries
*LIKE and MIN
*Joining Tables
*Types of Join
*UNION
*The INSERT Statement
*UPDATE and DELETE Statements
*Creating a Table
*NOT NULL and AUTO_INCREMENT
*Alter,Drop,Rename a Table
*Views
Extras:
*Quizzes from each of the topics
* Quizzes from a group of topics
*Challenges on all the overall topics
Certificate Link: http://www.sololearn.com/Certificate/1060-1489426/pdf/
Some of the concepts I have learned about SQL from the course are mentioned below:
*Introduction to Databases
*SQL Statements: Select
*SQL Syntax Rules
*Selecting Multiple Columns
*Distinct and Limits
*Storing Results
*WHERE Statements
*Filtering with AND,OR
*IN,NOT IN Statements
*Custom Columns
*Functions
*Sub queries
*LIKE and MIN
*Joining Tables
*Types of Join
*UNION
*The INSERT Statement
*UPDATE and DELETE Statements
*Creating a Table
*NOT NULL and AUTO_INCREMENT
*Alter,Drop,Rename a Table
*Views
Extras:
*Quizzes from each of the topics
* Quizzes from a group of topics
*Challenges on all the overall topics
No comments:
Post a Comment