SkillShare – The Ultimate SQL & Tableau Course: From Zero to Hero 2024-11

Published on: 2024-12-01 02:31:49

Categories: 24

Descriptions

The Ultimate SQL & Tableau Course: From Zero to Hero, Having SQL Skills and learn one of employer’s most requested skills of 2023! Learning SQL is one of the fastest ways to improve your career prospects. This is the most comprehensive, yet straight-forward, course for the SQL language on Skillshare. In this course, I transferred my experience from over a decade of real-world Big Data projects to one Skillshare course. I designed this course to take you from Zero to Hero of SQL, so if you are a beginner, don’t worry, I will explain everything from scratch step by step. You are not too old or too young, and SQL is super easy to learn. Each SQL Topic in this course will be explained in 3 steps: The concept (Theory) Learn SQL Syntax using simple Tasks. Learn How SQL Processes the Query behind the scene. SQL is one of the most in demand skills for business analysts, data scientists, and anyone who finds themselves working with data! Upgrade your skill set quickly and add SQL to your resume by joining today. You will have exercises during the videos where I present a task and we solve it together. By the end of each section, you will have as well tons of exercises and solutions.

What you’ll learn

This is the only course on Udemy that breaks down the complex concepts of Tableau into animated visuals. In this course you will be presented with over 250x animated visuals.
What special about this course it is taught by me, I’m not just another online instructor, i am working in big companies in Germany like Mercedes Benz where I’m leading BI & Big Data projects. That means you are getting real life skills out of this course.
You will master over 63 Tableau Charts, equipping you to visualize any data and meet various requirements. You’ll gain the expertise to choose the right chart for specific requirements and understand when to utilize each type of chart effectively.
We’ll deep dive into 60x Tableau Functions that will help you to manipulate your data for visualization. You will first understand the concept and how tableau works then we will learn the functions using very simple examples.

Specificatoin of The Ultimate SQL & Tableau Course: From Zero to Hero

Publisher : SkillShare
Teacher : Baraa Khatib Salkini
Language : English
Level : All Levels
Number of Course : 258
Duration : 33 hours and 19 minutes

Content of The Ultimate SQL & Tableau Course: From Zero to Hero

1. SQL _ Course Introduction
2. SQL _ Course Curriculum Overview
3. SQL _ Introduction
4. SQL _ Why Learn SQL_
5. SQL _ The Database Concepts
6. SQL _ Table Concepts
7. SQL _ Main SQL Commands
8. SQL _ The Elements of SQL Statements
9. SQL _ Download & Install MySQL
10. SQL _ Tour in the Interface of MySQL Workbench
11. SQL _ Install the Course Database
12. SQL _ Guide to SQL Coding Style
13. SQL _ SELECT Statement
14. SQL _ DISTINCT
15. SQL _ ORDER BY
16. SQL _ WHERE
17. SQL _ Comparison Operators_ =, #, #, #=, #=, !=
18. SQL _ Logical Operators_ AND, OR, NOT
19. SQL _ BETWEEN
20. SQL _ IN
21. SQL _ LIKE
22. SQL _ JOINS Concept
23. SQL _ AS Statement – Aliases
24. SQL _ INNER JOIN
25. SQL _ LEFT JOIN
26. SQL _ RIGHT JOIN
27. SQL _ FULL JOIN
28. SQL _ UNION
29. SQL _ Aggregate Functions
30. SQL _ String Functions
31. SQL _ GROUP BY
32. SQL _ HAVING
33. SQL _ SubQuery_ EXISTS vs IN
34. SQL _ INSERT
35. SQL _ UPDATE
36. SQL _ DELETE & TRUNCATE
37. SQL _ CREATE Table
38. SQL _ ALTER Table
39. SQL _ DROP Table
40. Tableau _ Course Introduction
41. Tableau _ Course Curriculum Overview
42. Tableau _ Section_ Tableau Basics
43. Tableau _ Big Data Buzzwords
44. Tableau _ What is Business Intelligence (BI)
45. Tableau _ The Power of Data Visualization
46. Tableau _ Tableau vs Excel
47. Tableau _ Best 3 BI Tools
48. Tableau _ What is Tableau_
49. Tableau _ Why Tableau is Powerfull_
50. Tableau _ Section_ Tableau Products
51. Tableau _ Development Process
52. Tableau _ Tableau Desktop
53. Tableau _ Tableau Public Desktop
54. Tableau _ Tableau Prep
55. Tableau _ Tableau Desktop vs Prep
56. Tableau _ Sharing Process
57. Tableau _ Hosting Tableau_ On-Prem vs IaaS vs Saas
58. Tableau _ Tableau Server & Cloud
59. Tableau _ Tableau Public
60. Tableau _ Tableau Reader & Mobile
61. Tableau _ Tableau Server vs Cloud vs Public vs Reader vs Mobile
62. Tableau _ Section_ Tableau Architecture
63. Tableau _ Live vs Extract
64. Tableau _ Tableau File Types
65. Tableau _ Tableau Architecture_ Desktop Components
66. Tableau _ Publish Process
67. Tableau _ Authentication Process
68. Tableau _ Access View Process
69. Tableau _ Tableau Server Architecture
70. Tableau _ Tableau Public Architecture
71. Tableau _ Section_ Prepare Your Pc
72. Tableau _ Download & Install Tableau
73. Tableau _ Create Tableau Public Account
74. Tableau _ Get Training Datasets
75. Tableau _ Publish First Viz
76. Tableau _ Tour of the Interface
77. Tableau _ Section_ Data Modeling
78. Tableau _ Concept of Data Modeling
79. Tableau _ Tableau Data Modeling
80. Tableau _ Joins
81. Tableau _ Union
82. Tableau _ Relationships
83. Tableau _ Data Blending
84. Tableau _ Join vs Union
85. Tableau _ Join vs Data Blending
86. Tableau _ Join vs Relationship
87. Tableau _ Join vs Relationship vs Union vs Blending
88. Tableau _ Build 2x Data Sources
89. Tableau _ Section_ Tableau Metadata
90. Tableau _ Introduction to Metadata
91. Tableau _ Data Types
92. Tableau _ Data Type Roles
93. Tableau _ Dimensions vs Measures
94. Tableau _ Discrete vs Continuous
95. Tableau _ Data Types vs Dimension & Measure vs Discrete & Continuous
96. Tableau _ Section_ Tableau Renaming
97. Tableau _ Naming Conventions
98. Tableau _ Renaming
99. Tableau _ Aliases
100. Tableau _ Section_ Organizing Your Data
101. Tableau _ Hierarchy
102. Tableau _ Groups
103. Tableau _ Cluster Groups
104. Tableau _ Sets
105. Tableau _ Bins & Histograms
106. Tableau _ Section_ Filtering & Sorting Data
107. Tableau _ Types of Filters
108. Tableau _ How to Create Filters
109. Tableau _ Customize Filters
110. Tableau _ 10x Filter Tips & Tricks
111. Tableau _ Sorting Data
112. Tableau _ Section_ Parameters
113. Tableau _ Dynamic Calculations using Parameters
114. Tableau _ Dynamic Reference Lines using Parameters
115. Tableau _ Dynamic Filters using Parameters
116. Tableau _ Swap Measures_Dimensions using Parameters
117. Tableau _ Dynamic Titles using Parameters
118. Tableau _ Dynamic Bins Using Parameters
119. Tableau _ Section_ Actions
120. Tableau _ Action_ Go To URL
121. Tableau _ Action_ Go To Sheet
122. Tableau _ Action Filter & Quick Actions
123. Tableau _ Action Highlight
124. Tableau _ Action Sets
125. Tableau _ Action Parameters
126. Tableau _ Action Triggers
127. Tableau _ Section_ Tableau Calculations
128. Tableau _ Introduction to Calculations
129. Tableau _ Calculation Components
130. Tableau _ Nested Calculations
131. Tableau _ 4 Types of Calculations
132. Tableau _ Number Functions_ CEILING, FLOOR, ROUND
133. Tableau _ Change Cases_ LOWER & UPPPER
134. Tableau _ Remove Spaces_ LTRIM, RTRIM, TRIM
135. Tableau _ Extract Substring_ LEFT, RIGHT, MID
136. Tableau _ Search_ STARTSWITH, ENDSWITH, CONTAIN, FIND, FINDNTH
137. Tableau _ CONCAT & SPLIT
138. Tableau _ REPLACE
139. Tableau _ Extract Dateparts_ DATENAME, DATEPART, DATETRUNC, DAY
140. Tableau _ Add & Subtract Dates_ DATEDIFF, DATEADD
141. Tableau _ TODAY & NOW
142. Tableau _ NULL Functions_ ZN, IFNULL, ISNULL
143. Tableau _ Logical Functions_ IF, ELSE, ELSEIF, IIF, CASEWHEN
144. Tableau _ Logical Operators_ AND, OR, NOT
145. Tableau _ Aggregate Functions_ SUM, AVG_ COUNT, COUNTD, MAX, MIN
146. Tableau _ ATTR Attribute Function
147. Tableau _ Introduction to LOD Expressions
148. Tableau _ FIXED LOD Expression
149. Tableau _ EXCLUDE LOD Expression
150. Tableau _ INCLUDE LOD Expression
151. Tableau _ Table Calculations_ FIRST, LAST, INDEX, RANK
152. Tableau _ Table Calculations_ RUNNING TOTAL
153. Tableau _ Table Calculations_ DIFFERENCES
154. Tableau _ Section_ Tableau Charts
155. Tableau _ Multiple Measures in One View
156. Tableau _ Bar Charts
157. Tableau _ Bar-in-Bar Chart
158. Tableau _ Barcode Chart
159. Tableau _ Line Charts
160. Tableau _ Highlighted Line Charts
161. Tableau _ Bump Chart
162. Tableau _ Sparkline Chart
163. Tableau _ Barbell Chart
164. Tableau _ Rounded Bar Chart
165. Tableau _ Slope Chart
166. Tableau _ Bar & Line Charts
167. Tableau _ Bullet Chart
168. Tableau _ Lollipop Chart
169. Tableau _ Area Charts
170. Tableau _ Scatter Plots
171. Tableau _ Dot Plot
172. Tableau _ Circle Timeline
173. Tableau _ Pie & Donut Charts
174. Tableau _ Heat & Treemap Charts
175. Tableau _ Bubble Charts
176. Tableau _ Maps
177. Tableau _ Histograms
178. Tableau _ Calendar Chart
179. Tableau _ Waterfall Chart
180. Tableau _ Pareto Charts
181. Tableau _ Butterfly (Tornado) Charts
182. Tableau _ Quadrant Chart
183. Tableau _ Box Plot
184. Tableau _ KPI
185. Tableau _ KPI & Bars
186. Tableau _ BANS
187. Tableau _ Funnel Chart
188. Tableau _ Progressbar
189. Tableau _ Choose The Right Chart
190. Tableau _ Section_ Tableau Dashboard
191. Tableau _ Tableau Dashboard Project
192. Tableau _ Section_ Tableau Project
193. Tableau _ Tableau Project Steps
194. Tableau _ _1 Step – Requirements Analysis
195. Tableau _ _2 Step – Building Data Source
196. Tableau _ _3 Step – Building Charts
197. Tableau _ _4 Step – Building Sales Dashboard
198. Tableau _ _5 Step – Building Customer Dashboard
199. HR Project _ Introduction
200. HR Project _ Build Data Source
201. HR Project _ Build Charts – Part1
202. HR Project _ Build Charts – Part2
203. HR Project _ Sketch Mockup of Summary Dashboard
204. HR Project _ Build the Summary Dashboard
205. HR Project _ Fine Tuning The Summary Dashboard#
206. HR Project _ Build the Table
207. HR Project _ Sketch Mockup of Detailed Dashboard
208. HR Project _ Build The Detailed Dashboard#
209. HR Project _ Bonus – Build Background Layers using FIGMA
210. Congratulations & THANK YOU Video
211. Advanced SQL _ Download SQL Server & SSMS
212. Advanced SQL _ Create Databases
213. Advanced SQL _ Tour in the Interface of SSMS
214. Advanced SQL _ What are Window Functions
215. Advanced SQL _ Syntax of Window Functions
216. Advanced SQL _ Window Functions_ PARTITION BY
217. Advanced SQL _ Window Functions_ Order BY
218. 3 5 window frame
219. 3 6 window Rules
220. 3 7 window summary
221. 4 1 win aggr what is
222. 4 2 win aggr count
223. 4 3 win aggr sum
224. 4 4 win aggr avg
225. 4 5 win aggr min max
226. 4 6 win aggr rolling running
227. 4 7 win aggr moving avg
228. 4 8 win aggr summary
229. 5 1 win rank what is
230. 5 2 win rank row number
231. 5 3 win rank rank func
232. 5 4 win rank dense rank func
233. 5 5 win rank compare ranking
234. 5 6 win rank top bottom analysis
235. 5 7 win rank unquie ids
236. 5 8 win rank identify duplicates
237. 5 9 untile
238. 5 10 ntile use case data segementation
239. 5 11 ntile use case data load
240. 5 12 win rank cume dist
241. 5 13 win rank percent rank
242. 5 14 win rank summary
243. 6 1 win value what is
244. 6 2 win value min max
245. 6 3 win value MoM
246. 6 4 win value customer retention
247. 6 5 win value first last
248. 6 6 win value suzmmary
249. 8 1 intro case
250. 8 2 syntax case
251. 8 3 howitworks
252. 8 4 usecase 1
253. 8 5 Rules
254. 8 6 usecase2
255. 8 7 quickform
256. 8 8 usecase3
257. 8 9 usecase4
258. 8 10 summary