Hi people, I am D. Jeffrey B ec, a graduated Bachelors of Economics with over 10 Data Science certificates. I have given professional services to over 50 SME's and Governmental Organisations in Business Administrations and Data Science.

In this course you will see more then 90% of all the codes that SQLspecialists use. We will take you through the functions CREATE, ALTER, DROP, INDEX, AND, OR, NOT, TRUNCATE, ORDER BY, BETWEEN, SELECT, WHERE, MERGE, AVG, COUNT, MAX, MIN, WHERE, IF, GRANT, COMMIT, ROLLBACK. We will do this by giving live examples via the SSMS environment. Via live videos we will take you step by step through the different sections of the coding in DDL, DML, DCL, TCL.

You can install SSMS by searching 'Install SQLServer' via your browser and after installing SQLServer, select 'Install SSMS'. Remember that this will take very much harddisk space. But once you handled the coding, you can use SQLfor many purposes, we will give examples in the Accounting environment.

As SQLSpecialist, your skills are very much in demand. What you need to know depends on the job you want. Metadata management is a common issue nowadays; it deals with organizing information about data, i.e. data about the data, if you will. As databases get larger, data engineers need to find ways to store and access dataset descriptions.

We will teach you how to put in action the above stated codes with giving examples from actual business cases.

We hope you enjoy this course!