SQL for Data Practitioners Online Training

Focused View

Jonathan Barrios

8:14:58

143 View

1. Introduction.mp4

05:16

2. SQL, Databases, and Tables -.mp4

10:10

3. Jupyter Notebook (optional).mp4

15:04

4 Jupyter Notebook (optional).mp4

09:07

5. Code Challenge.mp4

05:38

6. Introduction.mp4

04:11

7. SELECT.mp4

08:55

8. SELECT DISTINCT.mp4

08:35

9. COUNT.mp4

14:35

10. Code Challenge.mp4

08:21

11. Introduction.mp4

04:37

12. Filtering with Operators.mp4

12:22

13. SELECT WHERE.mp4

17:12

14. BETWEEN.mp4

17:23

15. Code Challenge.mp4

07:45

16. Introduction.mp4

02:33

17. WHERE IN.mp4

10:39

18. NULL and IS NULL.mp4

07:20

19. LIKE and NOT LIKE.mp4

10:04

20. Code Challenge.mp4

11:38

21. Introduction.mp4

03:50

22. Aggregate Functions.mp4

12:34

23. ORDER BY.mp4

12:29

24. LIMIT.mp4

09:48

25. Code Challenge.mp4

08:19

26. Introduction.mp4

03:10

27. GROUP BY (part I).mp4

14:24

28. GROUP BY (part II).mp4

17:13

29. HAVING.mp4

07:28

30. Code Challenge.mp4

08:30

31. Introduction.mp4

04:23

32. Joins.mp4

10:31

33. AS.mp4

14:05

34. INNER JOIN.mp4

20:44

35. Code Challenge.mp4

09:20

36. Introduction.mp4

03:11

37. Full Outer Joins.mp4

13:24

38. Left Outer Joins.mp4

10:01

39. Right Outer Joins.mp4

04:16

40. UNION.mp4

04:52

41. Code Challenge.mp4

08:31

42. Introduction.mp4

05:53

43. Data Types.mp4

11:02

44. Primary and Foreign Keys.mp4

07:16

45. Constraints.mp4

05:13

46. CREATE Database and Tables Part I.mp4

08:26

47. CREATE Database and Tables Part II.mp4

13:56

48. Introduction.mp4

02:19

49. INSERT.mp4

10:27

50. UPDATE.mp4

12:49

51. DELETE.mp4

04:32

52. ALTER.mp4

10:31

53. DROP.mp4

02:41

54. CHECK.mp4

07:25

Description

This entry-level SQL for Data Practitioners training prepares data practitioners to use SQL to perform advanced queries, build stable databases, and optimize your data lakes and warehouses.

When data is stored away inside massive data warehouses or inside databases just waiting to be put to use, getting it out and into the places where you can use it requires speaking the right language. That language is SQL – Structured Query Language – and when you know how to write it, databases work better, search queries are more useful and data is responsive.

More details

No matter what you use the data for, knowing how to write and understand SQL is a foundational step in using it better

Once you're done with this SQL skills training, you'll know how to use SQL to perform advanced queries, build stable databases, and optimize your data lakes and warehouses.

For supervisors, this SQL training can be used to onboard new data practitioners, curated into individual or team training plans, or as a SQL reference resource.

SQL for Data Practitioners: What You Need to Know

This SQL for Data Practitioners training covers SQL topics including:

Querying and manipulating relational databases
Defining connections between data fields and determining how they can be expressed
Working with data directly through SQL commands and queries
Creating, modifying and repairing databases, data lakes and data warehouses
Telling stories and visualizing data

Who Should Take SQL for Data Practitioners Training?

This SQL for Data Practitioners training is considered foundational-level training SQL which means it was designed for data practitioners. This SQL skills course is valuable for new IT professionals with at least a year of experience with relational database management and experienced data practitioners looking to validate their data skills.

New or aspiring data practitioners. Learning SQL early in your career is like learning to change your oil as soon as you get your driverâ€™s license. You might prefer to have your programs and interfaces handle your data pulls and queries automatically, but this SQL for data practitioners course shows you how to do it yourself. That way you can open up the hood and do it perfectly according to your unique needs.

Experienced data practitioners.If youâ€™ve been working as a data professional for several years already, youâ€™ll want to learn SQL so that you donâ€™t accidentally silo yourself professionally. Your teams and co-workers may not trust you with the big projects if you donâ€™t know how to get your hands dirty with hand-written SQL queries, fix that with this SQL course.

User Reviews

Rating

average 0

Total votes0

Focused display

Data Science

Data Analysis

Jonathan Barrios

Instructor's Courses

"Helping aspiring data professionals learn about data and seeing them succeed is one of my greatest passions as a trainer. I love to learn, share my knowledge, and help others succeed—this is why I am passionate about being a trainer at CBT Nuggets."

Jonathan started his career as a full-stack developer and quickly became interested in combining his online education experience with his data science and machine learning knowledge. Jonathan has been a programmer, data analytics instructor, and curriculum writer for several leading online education platforms is excited to share his skills and education experience with aspiring data practitioners at CBT Nuggets.

Certifications: None

Areas of expertise: Full-stack software development, data analytics, data science, machine learning, and cloud technologies such as AWS and Google Cloud. HTML, CSS, JavaScript, PHP, Python, SQL, NoSQL, and frameworks/libraries such as Laravel, Vue, Tailwind, React, Gatsby, Django, NumPy, pandas, Matplotlilb, Scrappy, BeautifulSoup, SciPy, Seaborn, Plotly, Scikit-learn, Tensorflow, and PySpark.

CBT Nuggets

View courses CBT Nuggets

CBT Nuggets is renowned for providing innovative training that's informative, meaningful, and engaging. We provide a variety of training, primarily in IT, project management, and office productivity topics. Our comprehensive library contains thousands of training videos ranging from Cisco networking to Microsoft Word. Whether you want to pass a certification exam, increase your skills, or simply learn new things, we've got you covered! All of our training is delivered through high-quality online streaming video. Subscribers can train 24 hours a day, seven days a week, from the convenience of a computer or mobile device. CBT Nuggets trainers are the rock stars of training, renowned for their expertise, industry-wide credibility, and engaging personalities. They enable CBT Nuggets to deliver accurate, up-to-date training, using a laid-back whiteboard presentation style. There are no scripts, EVER. Our trainers love to teach, and it shows! CEO and founder Dan Charbonneau was a Microsoft trainer when he began recording CBT Nuggets' very first training videos back in the 1990s. He wanted to help provide large organizations, small teams and individuals with comprehensive and budget-conscious training, and he realized it couldn't be done in a classroom. From the CBT Nuggets World Headquarters in Eugene, Oregon, Dan and his team promise each video will be informative, comprehensive, accurate, and fun to watch.