Learn SQL and GIT Quickly
3.9 (8 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
47 students enrolled

Learn SQL and GIT Quickly

Best place to learn SQL and GIT together
3.9 (8 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
47 students enrolled
Created by S D Academy
Last updated 4/2017
English
English [Auto-generated]
Current price: $34.99 Original price: $49.99 Discount: 30% off
5 hours left at this price!
30-Day Money-Back Guarantee
This course includes
  • 3 hours on-demand video
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
Training 5 or more people?

Get your team access to 4,000+ top Udemy courses anytime, anywhere.

Try Udemy for Business
What you'll learn
  • Learn basics of SQL queries and GIT basics
  • Able to work with GIT with great confidence
Course content
Expand all 56 lectures 03:04:35
+ GIT Tutorial : GIT Introduction and Installation
3 lectures 11:13
What is GIT
03:07
Installation of GIT on Windows Machine
03:18
Configuration of git for the first time user...
04:48
+ GIT Tutorial : Essential GIT Commands
11 lectures 36:16
Creating Git Project from Existing Project or Folder(GIT INIT )
03:28
Dot GIT folder: Where all changes are registered
03:09
GIT HELP
01:17
GIT COMMIT
06:05
GIT STATUS
07:16
GIT LOG
04:08
Reverting Changes : GIT Checkout
02:17
Reverting Changes : Un-Staging Stage File
01:12
Amending Changes : git commit --amend
03:39
Reverting Commit
01:46
Deleting un-tracked file
01:59
+ GIT Tutorial : Essentials of Branching and Reset
8 lectures 27:00
Creating new Branch in GIT
03:29
Creating and switching to newly created branches
01:55
Switching to branches
04:26
Merging changes of branches
03:50
Renaming and Deleting branch
02:47
GIT Reset : Soft Reset
04:35
GIT Reset: Mixed Reset
01:43
GIT Reset : Hard Reset
04:15
+ GIT Tutorial: Stashing in GIT
3 lectures 09:41
Why Stashing
03:34
GIT Stash Apply and POP commands
03:46
Deleting Stashing
02:21
+ SQL Tutorial : Essential Commands of SQL
12 lectures 35:43
Fetching list of databases and tables
03:14
Creating Table
04:50
Update Command in SQL
01:25
Deleting table data
02:38
Dropping table
01:42
Like Operator for pattern matching in SQL
04:43
Between operator in SQL
01:04
In Operator in SQL
01:30
Order By in SQL
05:30
+ SQL Tutorial : Aggregate Functions|Group By | Having Clause
6 lectures 10:05
Max() function in SQL
01:11
Min function in SQL
00:46
Avg in SQL
00:52
Sum() Function inSQL
00:51
Count() function in SQL
00:43
Group By and Having Clause in SQL
05:42
+ SQL Tutorial : Joins in SQL
3 lectures 08:16
What is join
03:07
Inner Join
03:23
Left and Right Join
01:46
+ GIT Tutorial: GIT Remote Repository
8 lectures 42:28
Introduction to remote repository and how it remain in sync with local repositor
08:35
Creating account on Bitbucket
05:18
Adding remote repository
03:06
Pushing your changes to remote repository first time.
07:08
Cloning git project on our local machine
04:53
Creating branch on remote
03:50
Pushing changes in remote branch
03:22
GIT Fetch and Git Merge
06:16
Requirements
  • Only basic computer knowledge.
Description

This course has been design for everyone who want to start learning GIT and SQL. 

This course is going to give you following benefits

1- Once after going through this course, you would be able to write most of the sql query those are needed for you day to day office work

2- You would be able to setup GIT on your local machine mainly on windows machine

3- You will learn the basics of GIT and its versioning benefits.

4- GIT part is going to cover following stuff

  • Installation
  • Creating git repository
  • Pushing first changes
  • Creating branches
  • merging branches
  • Stashing changes while pulling changes
  • Merging changes and resolving issues.
  • Later it will show case how to work with remote repositor like Github and Bitbucket

5- While SQL part is going to cover following topics and these tutorial would gradually increase with its lecture count

  • Relational database introduction
  • Data retrieval using Select Statement
  • Creation of database, data table, insertion of data
  • Difference between delete, drop and truncate
  • Concept of Join
  • Constraints implementation in sql
  • Setting sql_mode in mysql for better result of Constraints in mysql



Who this course is for:
  • Any one who wants to learn SQL Queries for Testing purposes
  • Any one who wants to learn GIT, For this course there is no need of previous knowledge of GIT
  • This course is meant for all the people who wants to maintain version and want to have control on versioning of content