Introduction to Databases and SQL Querying

 A STEP BY STEP INTRODUCTION TO THE CONCEPT OF DATABASES AND INTRODUCTION TO SQL QUERYING.


Course content:

Section 1: Introduction and Setup
Section 2: Introduction to Querying
Section 3: Deep Dive into Querying
Section 4: SQL Joins
Section 5: Dates/ Aggregation and String Functions

Description:

This is an introductory course on Databases and SQL Querying. There are no pre-requisities for this course. If you are looking to get acquainted with the concept of Databases and Queries for maybe your next interview as an analyst, this is the right course for you. All you need is a windows machine and we will walk through step by step, right from setting up your environment to creating your first table to writing your first query. This course is structured in a way that you can follow along with me. At the end of this course, you should be comfortable writing simple queries including queries related to Dates, String manipulation, Aggregation etc.

This course is for:

  • This course is for beginners with absolutely no experience is database. The course will make you familiar with SQL Syntax and introduce you to the concept of databases. No Prior Programming experience is required. This course is probably not for you if you're looking to learn more advanced and complex queries

Requirements:

  • There is absolutely no pre-requisites for the course. We will walk through very basic installation to setting up your environment to creating your first table and writing queries against it. All videos are recorded in Windows OS. You can however follow this course on MAC/Linux, if you have a Win VM setup.

Comments

Post a Comment

Popular posts from this blog

Anti-Money Laundering Concepts: AML, KYC and Compliance

Anti-Money Laundering Concepts: AML, KYC and Compliance     Description: Welcome to the course on  Anti-Money Laundering (AML) , where you will learn about the key issues faced by financial institutions today:  Money Laundering and Terrorist Financing . This course will educate you on  Money Laundering and Terrorist Financing laws, Know Your Customer, Customer Due Diligence, Economic Sanctions and Politically Exposed Persons . This is a comprehensive course that captures all relevant concepts required for training employees of an organization. We will start the course by understanding the term Money Laundering and will then cover the process & impact of the same. Post which, we will learn about terrorist financing and then cover the differences and similarities between money laundering & terrorist financing. In the next lectures, we will cover the Anti-Money Laundering policies along with KYC procedures, Economic Sanctions & Politically exposed perso...
Read more

Microsoft Excel Masterclass for Business Managers

Microsoft Excel Masterclass for Business Managers      Description: 7 Reasons why you should choose this Excel course Carefully designed curriculum teaching you only the most used functionalities of Microsoft Excel in business environment Concise – you can complete this Microsoft Excel course within one weekend Business related examples, data analysis and case studies solved using Advanced Excel. You will learn various data analysis techniques using MS Excel Ample practice exercises on data analysis, MS excel (basic & advanced), because Excel requires practice Downloadable resources comprising important MS Excel techniques and functionalities Your queries will be responded by the Instructor himself Start using Excel to its full potential to become proficient at your Excel tasks today! Either you’re new to Microsoft Excel, or you’ve played around with Excel since long but want to get more comfortable with MS Excel’s advanced features, or maybe you want to enhance your ...
Read more

Artificial Intelligence (AI) in the Classroom

UNDERSTAND ARTIFICIAL INTELLIGENCE AND TEACH IT TO YOUR STUDENTS! Description: Artificial Intelligence is finally here and most of us are already actively using it in our day-to-day life (even without knowing it). To prepare our future generation in order to harness these technologies, people need to understand how they can use AI first of all! Only then can they use it to facilitate learning and solve real-world problems.  The course is aimed at all those people, irrespective of their profession, who would like to learn how to make active use of AI. No prior knowledge is assumed, no expertise in any related area is required because we will start by introducing the very basic concepts. It is our firm belief that we have to democratize AI, bring it to the people and help them navigate through this maze of new amazing technologies. We will also illustrate a number of fun exercises, to help you understand these concepts and urge you to try them with others. The scope of this course is...
Read more