SQL Essentials

Track: Associate Enterprise Data Analyst (AEDA)

SQL Essentials helps trainees to speak in Structured Query Language (SQL) fluently and gives them the capability to participate in database application development teams. The database job market is promising for prospective experts.

Duration: 1 day
Fee: Request
Start Date: Request

SELECT sql_module
FROM theCADS
WHERE you_are=”beginner”
AND data_enthusiast=TRUE

SQL Essentials is a one-day module that covers the basics of SQL and the relational databases. By the end of this module, attendees will have learned and used the basic SQL statements, some advanced SQL syntax and join statements. This intensive module opens the doors of advanced database design and implementation to data enthusiasts.

Learning outcome:

Upon completion, participants should be able to demonstrate each of the following;

Understand the definition of a database and explain what a database management systems (DBMS) does
Familiar with SQL Statements
Ability to JOIN tables

Who should attend:

Business professionals who work with databases

1 day of in depth learning

Face to face with experienced Data Scientist.

Course Methodology

This course will utilize a combination of Lectures and Technical Practice..

CADS Certification

Earn certification upon completion.

Pre-requisite:
N/A

Minimum Qualification:
Undergraduate Degree

Training Track

Associate Enterprise Data Analyst (AEDA)

SQL Essentials is one of the modules under our Associate Enterprise Data Analyst (AEDA) programme. AEDA is a 15- day training program that provides analysts with the tools required for efficient Data Analysis.

Details of Subject

Introduction to Data and Database – Learning the fundamental concepts will lay the foundation to database best practices later on in this module. Participants with a strong foundation can use DBMS to enhance efficiency of data management in their organizations for reduced costs.
Use Case Examples – Participants are introduced to a real-life example of how a DBMS is being used. Participants who go through use cases of DBMS/SQL will be able to improve on known competitive strategies in data and best practices.
Introduction to DBMS and RDBMS – This section nurtures participants with the skill of defining clear structures and rules to the database. Participants with these skills can generate business insights through analytic thinking and query-based research.
Fundamental SQL (Hands-on/Practical) – By learning the fundamental queries used in SQL, participants are able to manipulate the data from a table with various conditions and limitations. Participants that know SQL are able to generate relevant reports based on organizational data assets.
Get the most out of Joined Tables (Hands-on/Practical) – This section dives deeper into learning how to query numerous tables at the same time. Interconnected relations generate comprehensive reports for business insights through drill-down analysis.

Lead Instructor

Mohammad Mehdi Lotfinejad

Mehdi is an experienced computer scientist who is technically proficient in software development and database management. His expertise includes data mining, web development, data engineering and he is very knowledgeable in project management as well. In addition, he has been very active in academia in the past where he worked as a lecturer at the Payame Noor University and published papers for many conferences and journals as well as authoring technical text books on computer science subjects.

CADS Certification

AEDA CADS Certified SQL Essentials

SQL is just that; essential for working with relational databases. This certification covers written SQL statements/queries and Join statements. Put your SQL chops to the test and get your skills certified. Seize the opportunity and get CADS certified today! Fill up the form below to register for this exam.

Hear from Our Alumni

The training has benefited me a lot with the skills required to be a data analyst and has upskilled me in data analysis. What I like about the program is where real life problems in the office is used as the materials during the trainings which provides more understanding of the topics. Eventually, it has broaden up my market in the career development.

The program started by setting an expectation on Day 1, that it is not a Read-And-Pass syllabus. The beauty of this program is that it requires the trainees to get their hands dirty and do the actual work throughout the course. It is indeed very different from a lot of programs in the market which just produces a certificate in the end without the trainee actually able to do some real stuff. The course is definitely benefiting anyone who really want to do Machine Learning and Data Science, by creating talents who are able to connect human thought with the machine algorithm, being the bridge within the corporate, into the digital worlds.

The training was beneficial as it trains myself to think from another perspective - one that may not be new, but wasn't practiced as often as I'd like. It was fun and interactive thanks to the facilitator, Jay, too. He was very helpful to answer any questions the attendees have. Believe that this training gives the attendees an extra edge by giving them the knowledge and perspective on how to better utilize data to what they want/need to do - for the organization, the business, and even for personal use, of which I believe will bring myself further in my career.

The training has been an eye opener for me. As someone who is not of programming background, it introduces me to the possibilities of what data can do. It has also helped me bridge the difference in thinking between the Business Team and the Data Science Team. Had a great time learning!

This training enhance on my skill of analyzing of using another tools of programming instead of excel and how to model and visualized our data in a better way instead of our traditional way. Especially when involve with a large scale of data. If using excel, there will a lot of time consuming there instead of R. For me, in market nowadays of big data, this course will brings more value and create another point of view on how to visualize our data especially in making any decision. And of course will enhance our career development.

Register Interest for Group or Organisation Enrolment

SQL Essentials

SQL Essentials

SELECT sql_module
FROM theCADS
WHERE you_are=”beginner”
AND data_enthusiast=TRUE

Learning outcome: