SQL for Beginners: Learn SQL from Zero

Focused View

Rohit Kadian

29:46:04

145 View

1. Database Concepts (Database, DBMS, Data Models, RDBMS and SQL).mp4

33:28

2. Practice SQL without installing any Software.mp4

11:42

3. Select Command.mp4

06:25

4. Distinct keyword.mp4

06:43

5. SQL is not case sensitive.mp4

03:09

6. Semicolon.mp4

08:40

7. Where Clause.mp4

14:00

8. Using Relational Operators in Where Clause Condition.mp4

07:41

9. Using Logical Operators (AND, OR, NOT).mp4

15:10

10. Between Operator.mp4

09:28

11. Order By Clause (ASC, DESC).mp4

11:47

12. Using Between Operator with Text.mp4

11:25

13. In Operator.mp4

07:17

14. Like Operator and Wildcard Characters.mp4

19:20

15. Aliases for Table Column Names AS Keyword.mp4

11:16

16. Limit Keyword.mp4

09:19

17. Breaking the Lengthy SQL Statement into multiple lines.mp4

05:26

18. MySQL Built in Functions.mp4

10:26

19. upper() MySQL String Function.mp4

08:50

20. lower() MySQL String Function.mp4

10:26

21. Length() MySQL String Function.mp4

10:37

22. Instr() MySQL String Function.mp4

12:03

23. Substr() MySQL String Function..mp4

14:13

24. Concat() MySQL String Function.mp4

12:23

25. Trim() MySQL String Function.mp4

16:42

26. Abs() MySQL Numeric Function.mp4

10:52

27. Mod() MySQL Numeric Function.mp4

09:19

28. Greatest() and least() MySQL Numeric Functions.mp4

05:23

29. Truncate() MySQL Numeric Function.mp4

08:44

30. Power() and sqrt() MySQL Numeric Functions.mp4

03:46

31. Current_date(), curdate(), current_time(), curtime(), now() & sysdate()..mp4

11:24

32. Year(),month(),day(),month name(),day name() MySQL Date Time Functions.mp4

08:24

33. Avg(), max(), min(), count() and sum() MySQL Aggregate Functions..mp4

06:37

34. Arithmetic Operators.mp4

05:14

35. Installing MySQL Server and Workbench Client for Practice.mp4

34:45

36. Creating, Deleting, viewing and using Databases.mp4

18:12

37. Creating, Viewing, Describing and Deleting Tables.mp4

19:16

38. Insert Into Statements (For inserting data into Tables).mp4

14:15

39. Data Types.mp4

35:45

40. Null Value, Is Null Operator and Is Not Null Operator..mp4

11:18

41. Delete Statement (For Deleting the Records from Table)..mp4

06:58

42. Update Statement and Set Keyword (For Updating the Table Records.mp4

10:51

43. Rename statement and To Keyword (For Renaming Table Name)..mp4

03:39

44. Alter Statement, Add, Modify Column, Rename Column, and Drop Column..mp4

09:57

45. Set Autocommit.mp4

11:46

46. Commit Statement.mp4

09:09

47. Rollback Statement.mp4

08:22

48. Truncate Statement.mp4

08:45

49. Single Line and Multi Line Comments.mp4

12:46

50. Group By Clause.mp4

10:17

51. Having Clause.mp4

12:42

52. Sequence of using where, group by, having and order by clauses..mp4

08:28

53. Set Operators.mp4

14:15

54. Union Operator.mp4

49:27

55. Union All Operator.mp4

13:28

56. Intersect Operator.mp4

16:18

57. Minus Operator.mp4

13:37

58. Tables and Aliases.mp4

17:25

59. Joins (Inner Join, Left Join, Right Join, Full Join and Self Join).mp4

47:41

60. Sub Query (Single Row Sub Query explained by solving different problems).mp4

18:56

61. In Operator.mp4

08:40

62. Using In Operator with Multi Row Sub Query.mp4

12:22

63. Using Any Operator in Multi Row Sub Query.mp4

13:18

64. Using All Operator in Multi Row Sub Query.mp4

06:42

65. Exists Operator.mp4

06:52

66. Using Sub Queries for retrieving the records from multiple tables..mp4

14:06

67. Using Multiple Sub Queries in a single SQL statement.mp4

10:13

68. Integrity Constraints.mp4

09:26

69. Not Null Integrity Constraint.mp4

08:37

70. Unique Integrity Constraint..mp4

12:44

71. Primary Key Integrity Constraint.mp4

16:46

72. Foreign Key Integrity Constraint.mp4

34:50

73. Check Integrity Constraint.mp4

09:57

74. Default Integrity Constraint.mp4

10:24

75. Auto_increment.mp4

12:36

76. Insert Into.mp4

16:09

77. AS Keyword.mp4

08:14

78. IfNull() function.mp4

07:41

79. Case, When, Then and End Keywords.mp4

22:37

80. Delimiter.mp4

07:26

81. Delimiter usage in Stored Procedures.mp4

15:08

82. Views.mp4

39:47

83. Indexes.mp4

30:03

84. JDBC (MySQL Database connection from Java Programs).mp4

01:02:05

85. ODBC (Object Database Connectivity) using SQL ODBC Query Client Tool.mp4

37:57

86. MySQL Shell Command Line Tool.mp4

12:13

87. MySQL Command Line Client.mp4

08:12

88. Using default Windows Command Prompt for connecting to MySQL Server..mp4

08:22

89. Types of SQL Statements.mp4

05:21

90. Grant and Revoke SQL Statements.mp4

18:56

91. Temporary Tables.mp4

08:17

92. Show Columns,Show Indexes,Show Privileges and Show Grants Statements.mp4

11:31

93. Inserting Null.mp4

05:05

94. Using trim() for trimming the corner characters of the Table Values..mp4

12:19

95. Using wild cards as normal characters.mp4

08:04

96. Database Objects.mp4

08:32

97. Creating Linux Virtual Machine.mp4

29:13

98. Installing MySQL Server in Linux Ubuntu Machine.mp4

21:41

99. Putty for Connecting to a Remote Machine having MySQL Server..mp4

37:38

100. Oracle 11g Software, SQL Plus, SQL Developer and Executing SQL Queries..mp4

44:08

101. Oracle SQL Queries.mp4

59:32

102. Oracle SQL Built in functions.mp4

48:27

103. Oracle SQL Queries (Part 2).mp4

39:30

104. Oracle SQL Queries (Part 3)..mp4

22:08

105. Oracle SQL Queries (Part 4).mp4

37:48

106. Oracle SQL Queries (Part 5).mp4

01:07:35

107. DBeaver Universal DB Client Tool.mp4

16:23

108. XAMPP for Practicing SQL.mp4

17:07

109. Savepoint.mp4

07:25

Description

Become an In-demand SQL Master by creating complex databases and build real-world projects

What You'll Learn?

Write complex SQL queries across multiple tables.
Create your own database or interact with existing databases.
Obtained a knowledge of SQL, and MySQL, allows students to apply for jobs in the IT sector.
Model real-world data and generate reports using SQL.
Learn to perform GROUP BY statements.

Who is this for?

Anyone who wants to learn how to use SQL and MySQL.

Anyone looking to answer complex business problems and generate reports using data.

What You Need to Know?

NO Prior Knowledge Required !!

More details

Description
Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Welcome to "SQL for Beginners: Learn SQL from Zero "
Hi, My name is Rohit and I teach Computer Science and several programming languages. I have worked in top MNC's like Google, IBM, TCS. I have a training institute where I am training students in various programming languages since 7yrs. I train over 800 students per year and trained 9100+ students till now!!

The course contents are mostly interactive video lectures. I as a Good Instructor, will encourage absolute beginners to follow the lectures and will motivate in the right direction. You as a sincere student should start from the very first video and proceed one by one .
The course is for anyone who may or may not have any previous experience with programming language. We will go from the very basic to the advanced topics. Simple program to complex one step by step.
WHAT YOU ARE GETTING IN THE COURSE
109 Full Fledged Crisp and Detailed Lectures
29 Hours+ Video on Demand
Full Course at a very Low Cost
A great trainer with 7 yrs+ experience
The Curriculum is very practical as it guides you from start to finish on the path to become professional in SQL. We'll start by teaching you the basics of SQL and the basics of programming. Then move on to advanced SQL topics.
We will continue to provide really helpful tips and we will provides plenty of other references.
Why Take This SQL for Beginners: Learn SQL from Zero:
Interesting: No boring lectures. It walks you through fun and useful tasks.
Unforgettable: Learn the 'why' behind every action, remember concepts so you can apply them later.
Perfect length. The course is 29 hours long.
Perfectly Paced: Learn the basics of SQL at a beginner's pace. This means you're never left behind and don't waste time on irrelevant filler material.

Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Still Worried !!
Here's the Panacea,Â Â Â Â Â Â Â Â Â Â Â Â Â Â NO QUESTIONS ASKED
Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Udemy's money-back guarantee !!
ENROLL NOW

Who this course is for:
Anyone who wants to learn how to use SQL and MySQL.
Anyone looking to answer complex business problems and generate reports using data.

User Reviews

Rating

average 0

Total votes0

Focused display

Hi, My name is Rohit and I teach Computer Science and several programming languages. I have worked in top MNC's like Google, IBM, TCS. I have a training institute where I am training students in various programming languages since 7yrs. I train over 800 students per year and trained 9100+ students till now!!So don't worry you will be in great hands after purchasing the course.

Udemy

View courses Udemy

Students take courses primarily to improve job-related skills.Some courses generate credit toward technical certification. Udemy has made a special effort to attract corporate trainers seeking to create coursework for employees of their company.