#databasedevelooment

Advanced SQL tutorial In my last post,I introduced SQL basic and intermediate topics.We walked through the topics with simple explanation based and syntax highlight lessons. It really is a great way to quickly introduce and talk out a concept.But if we are to really appreciate the SQL syntax and it's application in real world projects,we need to put all the topics first into a working environment and test out the code. We are coders right😏😏!!? It really won't make sense to Cruse a topic minus coding. All the advanced SQL topics will be practice based sequence.On finishing,we will build at least 2 web applications based on all SQL topics to create dynamic and data driven applications. Enjoy our first set. #sql #sqlsyntax #sqlunion #databasedevelooment (at Area 23 Lilongwe) https://www.instagram.com/p/B_qYL7Dh7Ox/?utm_medium=tumblr

Creating and using SQL Views Views are one of the what I consider as wizardry magic touch to the back end developer. SQL views are just virtual tables.Tables that are created just from SQL statements.They don't exist in the database. But they have the power to offer you an extra layer of providing added security by simply allowing the API developer access to the columns (fields) you want them and hide the sensitive ones. In this slides set,I will give you the introductory part of how you create Views in SQL data bases using a practical example. In a later post,we will dive deeper by building an even complex application that will query multiple tables and provide us interesting result sets. So, you had better hang around. And enjoy the reading #sql #sqlstatements #databasedevelooment #sqlviews #creatingsqlviews (at Lilongwe, Malawi) https://www.instagram.com/p/CAGfuw7BQ87/?igshid=1nqynrhva6byq

Advanced SQL tutorial In my last post,I introduced SQL basic and intermediate topics.We walked through the topics with simple explanation based and syntax highlight lessons. It really is a great way to quickly introduce and talk out a concept.But if we are to really appreciate the SQL syntax and it's application in real world projects,we need to put all the topics first into a working environment and test out the code. We are coders right😏😏!!? It really won't make sense to Cruse a topic minus coding. All the advanced SQL topics will be practice based sequence.On finishing,we will build at least 2 web applications based on all SQL topics to create dynamic and data driven applications. Enjoy our first set. #sql #sqlsyntax #sqlunion #databasedevelooment (at Area 23 Lilongwe) https://www.instagram.com/p/B_qYL7Dh7Ox/?igshid=qfwyneb54di1