SQL Tutorials for Beginners

Pubblicato il: 17 dicembre 2017
sul canale di: creativecommIT

4,469

A step by step introduction to the concept of Databases using MSSQL (#SQL) . This SQL Tutorial for beginners is a free and fast way to Learn SQL.

This is an introductory course on Databases and SQL Querying using SQL Server. There are no pre-requisities for this course and you can learn SQL quickly. If you are looking to get acquainted with the concept of Databases and Queries for maybe your next interview as a Data analyst , Reporting Analyst or Business Analyst, this is the right course for you. All you need is a windows machine and I will walk you 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.

-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 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

-Query a database, Create Tables and Databases and be proficient with basic SQL querying

Introduction and setup
Lecture 1 : Introduction to Databases (0:00)
Lecture 2: Installing / Setting up Environment / SQL Management Studio (10:51)

Introduction to Querying
Lecture 3: Creating your First SQL Table (21:55)
Lecture 4: Installing Sample Database (Adventure Works) and Querying (34:08)

Deep Dive into Querying
Lecture 5: Lets Start Writing some SQL code (39:23)
Lecture 6: Deep Dive into SQL Querying (57:04)

SQL Joins
Lecture 7: SQL joins (1/2) (1:10:49)
Lecture 8: SQL Joins (2/2) (1:24:24)
Dates / Aggregation and String Functions
Lecture 9 : TSQL Date function (1:47:21)
Lecture 10: TSQL Aggregation and String Functions (1:58:12)

Conclusion
Lecture 11: Conclusion (2:13:09)

Links:

My analytics courses on Udemy: https://www.udemy.com/user/54a6020bb2...

My Youtube Channel: / creativecommit

My Website: http://www.rakeshgopal.com

Quora : https://www.quora.com/profile/Rakesh-...

In questa pagina del sito puoi guardare il video online SQL Tutorials for Beginners della durata di ore minuti seconda in buona qualità , che l'utente ha caricato creativecommIT 17 dicembre 2017, condividi il link con amici e conoscenti, su youtube questo video è già stato visto 4,469 volte e gli è piaciuto 51 spettatori. Buona visione!