Learn SQL and GIT Quickly
5.0 (1 rating)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
21 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Learn SQL and GIT Quickly to your Wishlist.

Add to Wishlist

Learn SQL and GIT Quickly

Best place to learn SQL and GIT together
5.0 (1 rating)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
21 students enrolled
Created by S D Academy
Last updated 4/2017
English
Curiosity Sale
Current price: $10 Original price: $30 Discount: 67% off
30-Day Money-Back Guarantee
Includes:
  • 3 hours on-demand video
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I Learn?
  • Learn basics of SQL queries and GIT basics
  • Able to work with GIT with great confidence
View Curriculum
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 is the target audience?
  • 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
Students Who Viewed This Course Also Viewed
Curriculum For This Course
56 Lectures
03:04:35
+
GIT and SQL introduction and Basic tutorial
1 Lecture 02:33
+
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: SQL and Database Introduction
1 Lecture 01:20
What is Relation Database
01:20
+
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
About the Instructor
S D Academy
4.0 Average rating
7 Reviews
132 Students
2 Courses
Founder

S D Academy is best place to start  learning about testing and development where academician with enriched experience from industry try to teach with practical scenario.

More information:

As founder, I always try to bring best learning to students and for the same i am working to bring more simplicity what ever we are teaching in our classroom or in our online course with good blend of practical and indsutry honed examples. I have more than 5+ years of experience in IT Industry.I have a very good experience of teaching Selenium WebDriver using Java, Python, SOAPUI, Groovy, Geb,  and now these days grooming my self for XML, XSLT since whole world is talking about Reporting and becoming more and more result oriented. 

As an IT person have worked with many CMM level organisation with good understanding of product life cycle.