Introduction to Databases and SQL Querying
- Query a database, Create Tables and Databases and be proficient with basic SQL querying
- 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
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 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
We conclude our series of lectures on Introduction to Databases and Querying.
Introduction to Databases and Querying
(Database concepts, Table concepts , Basic Queries, SELECT , CRUD, JOINS, AGGREGATIONS, Dates Etc.)
-Stored Procedures, Customer Functions, Triggers, Views, Temporary Tables
-Database Tuning, Query Tuning, Indexing, CLR, Profiler, Loading Very large datasets
SSIS - Transferring data between systems and cleaning it up (beginners, Intermediate, Advanced)
Big Data Analytics
Hadoop for beginners, Intermediate and Advanced