SQL Tutorials for Beginners
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-...
Auf dieser Seite können Sie das Online-Video SQL Tutorials for Beginners mit der Dauer stunde minuten sekunde in guter Qualität ansehen, das der Benutzer creativecommIT 17 Dezember 2017 hochgeladen hat, den Link mit Freunden und Bekannten teilen, dieses Video wurde auf Youtube bereits 4,469 Mal angesehen und es wurde von 51 den Zuschauern gefallen. Viel Spaß beim Betrachtenden Zuschauern gefallen!
