Querying a Database | CompTIA IT Fundamentals+ (FC0-U61) | Part 28 of 38

  Рет қаралды 14,023

ITPro

ITPro

Күн бұрын

In this episode, Don Pezet and Ronnie Wong answer the question: how do we talk to a database? They explore programmatic access, user interface, report builders, and then go into various database commands. This episode is part of ITProTV's engaging online IT training course for the CompTIA IT Fundamentals+ certification. IT Fundamentals+ is an entry level certification designed to introduce users to basic computer principles. ITF+ helps professionals decide whether a career in IT is right for them, and helps to develop a broader understanding of IT concepts.
----
CompTIA IT Fundamentals+ exam objectives PDF: go.itpro.tv/it-fundamentals-e...
----
Did you know that ITProTV is CompTIA's Official Video Training Provider? Get more advanced online IT training today. Start learning free at ITProTV: go.itpro.tv/start-learning-now
----
Subscribe to get the latest videos: go.itpro.tv/subscribe
----
Connect with ITProTV:
Facebook: / itprotv
Twitter: / itprotv
Instagram: / itpro.tv
LinkedIn: / itprotv
Reddit: / itprotv
#CompTIA #ITFundamentals #ExamPrep
IT skills & certification training that’s effective & engaging. Binge-worthy learning for IT teams & individuals with 4000+ hours of on-demand video courses led by top-rated trainers. New content added daily. Start free on www.itpro.tv

Пікірлер: 22
@ShawnaRoxanneX
@ShawnaRoxanneX 2 жыл бұрын
I just finished passing my itf exAm and it was database HEAVY thank you so so much I couldn’t have done it without you both!!!
@0x004
@0x004 2 жыл бұрын
Just wanted to tell you both thanks so much for all the content on the itf+! Been studying and watching your videos and love how you both explain things so well! Passed my itf+ exam today!
@UncleHoCM
@UncleHoCM 4 жыл бұрын
Thanks. Love how Don explains things.
@ITProTv
@ITProTv 4 жыл бұрын
He does have a way of making things easy to understand, doesn't he?
@nicholaspratt1786
@nicholaspratt1786 3 жыл бұрын
Yeah best help with ift+
@dg5609
@dg5609 4 жыл бұрын
thanks for all the help!
@nezmustafa4271
@nezmustafa4271 3 жыл бұрын
Sheesh that was great, love how when Don explains concepts he talks as if he's reading he's reading a fantasy novel. I'm taking the test at the end of the week, hope all goes well.
@ITProTv
@ITProTv 3 жыл бұрын
No doubt, Don has quite a way with words... even when they're boring IT words. Best of luck to you on the exam! Side note: Make sure to review the "Programming Concepts" videos, as we've had a few people comment saying that the exam had a good portion of programming questions that they stumbled on.
@sscoconut1265
@sscoconut1265 3 жыл бұрын
did you pass brah?
@nezmustafa4271
@nezmustafa4271 3 жыл бұрын
@@sscoconut1265 Yep, doing the A+ now.
@ITProTv
@ITProTv 3 жыл бұрын
Congratulations! Good luck on your A+ studying!
@nezmustafa4271
@nezmustafa4271 3 жыл бұрын
@@ITProTv thanks!
@remuspierre8965
@remuspierre8965 3 жыл бұрын
Incredible
@ITProTv
@ITProTv 3 жыл бұрын
Much appreciated!
@joshwalther8838
@joshwalther8838 2 жыл бұрын
So are you using a mixture of DDL and DML when you are adding NY and when you are then querying it later on? Or is DDL strictly just creating tables?
@ITProTv
@ITProTv 2 жыл бұрын
So, DDL is normally NOT used in adding data to table but defining the table itself. You though, can use DML to add data to a table. So this is strictly using DML.
@prabhjotsingh5801
@prabhjotsingh5801 3 жыл бұрын
Can you explain 1-tier, 2-tier, 3-tier, and n-tier, for me? Thanks for the amazing video, once again!
@ITProTv
@ITProTv 3 жыл бұрын
You're very welcome! N-Tier is an umbrella term like 1-tier, 2-tier or 3-tier, where N stands for the number of tiers. It is a layered software model approach for developing software. Software that is human usable requires a user interface, a logical layer (interprets input to software commands) and then data layer--data is stored and accessible. Software can be built into a single unit that runs all on a single machine, like a productivity application like Microsoft PowerPoint. Software can be built into what is called a client-server model. Where the user interface runs on the user's end but but the data is stored and commands are executed on the server side. Lastly, there is 3-tier, Presentation tier, Business Logic tier and database tier in the same manner. This type of layered approach helps with scalability, data integrity, improved security and availability. Hope this helps answer your question!
@prabhjotsingh5801
@prabhjotsingh5801 3 жыл бұрын
@@ITProTv Thank you! It helps a lot!
@ITProTv
@ITProTv 3 жыл бұрын
Awesome! You're very welcome.
@cloudsvengeance672
@cloudsvengeance672 4 жыл бұрын
I want to take this course but I am torn between getting the elearning or getting the certmaster labs. I am a hands on type of person so I wanna get the lab. But I dont know if I will learn as much from the labs as I probably would from the elearning....any recommendations?
@ITProTv
@ITProTv 4 жыл бұрын
Hey there, the ITF+ course in our portal has labs which you can access as a premium member: www.itpro.tv/courses/comptia/comptiafundamentals-exam-fc0u61/
Wait for the last one! 👀
00:28
Josh Horton
Рет қаралды 133 МЛН
ОДИН ДЕНЬ ИЗ ДЕТСТВА❤️ #shorts
00:59
BATEK_OFFICIAL
Рет қаралды 8 МЛН
Heartwarming: Stranger Saves Puppy from Hot Car #shorts
00:22
Fabiosa Best Lifehacks
Рет қаралды 18 МЛН
1 or 2?🐄
00:12
Kan Andrey
Рет қаралды 39 МЛН
you need to learn SQL RIGHT NOW!! (SQL Tutorial for Beginners)
24:25
NetworkChuck
Рет қаралды 1,4 МЛН
Office Hours in Cabo San Lucas
13:04
Brent Ozar Unlimited
Рет қаралды 1,2 М.
Microservices with Databases can be challenging...
20:52
Software Developer Diaries
Рет қаралды 18 М.
The Tragedy of systemd
47:18
linux.conf.au
Рет қаралды 1,1 МЛН
Wait for the last one! 👀
00:28
Josh Horton
Рет қаралды 133 МЛН