
Explore vendor neutral data concepts across data mining, governance, quality, and analysis, with hands-on practice in databases and visualization to prepare for the CompTIA Data+ exam.
Hello from the instructor.
This exam will retire soon so check on the Microsoft website however, it's a very important foundation for the Data+ so please to follow it first.
Explore relational database concepts, including tables, rows, columns, data types, constraints, and how primary and foreign keys establish table relationships, using sql server management studio and query analyzer.
Learn how data manipulation language (DML) manipulates data with insert, update, delete, and select, while DDL defines the database, and how transactions roll back or commit to preserve integrity.
Grasp data definition language basics for creating tables, views, and constraints using scripts and the SQL Server Management Studio interface.
Learn how data types in SQL Server determine storage and precision, compare exact and approximate numerics, date and time types, and character and binary strings.
Learn how to choose fixed and variable length data types such as char, varchar, unicode, and binary, and master conversions, collation, and precision in SQL Server.
Discover how views are virtual tables that draw from one or more tables, enabling security, simplicity, and analysis with totals, created via graphical designer or t sequel.
Create stored procedures and functions in SQL Server, using input parameters to perform select, insert, update, or delete operations, and learn basics of SQL injection prevention.
Explore advanced data querying with union, intersect, and except, and master inner and outer joins (left, right, full), cross and self joins, plus primary and foreign keys.
Learn to insert and update data in a SQL Server database using insert into and update statements, including identity properties, where clauses, and GUI and manual updates.
Lessons 1 and 2 from the exam syllabus are combined for this video. Next lesson will be called lesson 3 in the video.
Learn data acquisition concepts, including data integration and ETL versus DLT, data cleansing and profiling, and diverse data collection methods such as web scraping, APIs, surveys, and observation.
These are lessons 2 and 3 from the exam syllabus so next lesson is lesson 4.
We've combined points 1 and 2 from the exam syllabus here so next lesson is lesson 3.
Learn to determine the appropriate analysis type—trend, performance, exploratory data, and link analysis—by framing business questions, collecting primary or secondary data, and using gap analysis.
Explore common data analytics tools and programming software such as SQL, Python, Excel, R, RapidMiner, SPSS, Tableau, and Power BI, and learn their functions for analysis, visualization, and reporting.
Hello there, my name is Paul Browning. My team and I have put together a video training course for the brand new CompTIA Data+ (DA0-001).
I started teaching Cisco CCNA courses after leaving Cisco systems in 2004. Since then, we have trained many hundreds of thousands of students for their CompTIA A+, Network+, PenTest+, Security+, Linux+, Cisco CCNA and CCNP, Wireshark, Python, Ethical Hacking, and many more exams. I’ve also written many best-selling IT books, including Cisco CCNA Simplified, Cisco CCNA in 60 Days, IP Subnetting – Zero to Guru, and the entire 101 Labs series for A+, Network+ and many more exams.
I’ve worked my way up from the helpdesk to network support, network consulting, and beyond, so I know exactly what it’s like to start from the bottom, and I know how valuable certifications are to your career. You simply won’t get called for job interviews without being certified.
Unlike many companies, HowToNetwork NEVER uses IT trainers for its courses. We ALWAYS hire IT experts who are working on-the-job and ask them to share their real-world experience with you so you can hit the ground running from your first day.
This is one exam certification course. To qualify, you need to be successful in the below exam:
CompTIA Data+ (DA0-001)
CompTIA presumes around 18-24 months experience in data analytics before you take this exam, but if you are just starting out, then don’t worry because we have you covered. This is actually three courses in one:
Course 1 – Microsoft Database Essentials
Learn to create databases from scratch
Configure databases for storage
Administer a SQL database
Follow along with hands-on labs
Configure database security
Course 2 – CompTIA Data+
Learn data mining
Understand data types and structures
Learn statistical methods
Common data analytics tools used by experts
Learn data governance and compliance
Course 3 – Learn Excel From Scratch
Create worksheets and workbooks
Format spreadsheets
Insert data in cells and ranges
Summarize data with functions
Create charts and views
Follow along with three real-world case studies
WHAT SOME OF OUR STUDENTS ARE SAYING:
5 Stars “It was an excellent course for IPv6 beginners. A lot of clarity on IPv6 fundamentals and hope to improve the same further.” - Suresh Y.
5 Stars “Fantastic and fully comprehensive. I needed to learn how to migrate my IPv4 network of routers to IPv6, and this course covered almost all the bases. The authors were also responsive to my questions. I highly recommend this course to my friends who wish to learn IPv6.” - Wilson C.
5 Stars “Great content, and the labs are awesome! For someone with absolutely zero prior knowledge of TCP/IP, I feel I have learned a lot in last one week.”’ - Pankaj M.
WHY SHOULD YOU TAKE THIS COURSE?
There is currently a huge shortfall of candidates with data analysis skills and a wide variation in available job titles and responsibilities. The shortfall is around 625,000 job postings to be filled. There is a lack of consistency in educational program offerings and credentials (until now) and a way to standardize around a set of skills.
Consider this course if you are interested in learning how to confidently interpret data insights and communicate them in a way that drives the business forward. The job description would be any role that analyzes business-specific data. Individuals likely report data analytics to management on a regular basis on business functions, i.e., they analyze and monitor dashboards, results, and trends.
Suppose you have or want to develop strong logical and critical thinking skills if you consider it important to think through things. If you find yourself often asking ‘why?’ then you should consider this course. It’s particularly suitable for tenacious problem solvers who want data-driven solutions to problems.
WHAT DOES A DATA ANALYST DO?
The data analyst is responsible for collecting, analyzing, and reporting on data that can drive business priorities and lead to intelligent decision-making. CompTIA Data+ validates certified professionals have the skills required to facilitate data-driven business decisions, including:
Mining data
Manipulating data
Applying basic statistical methods
Analyzing complex datasets while adhering to governance and quality standards throughout the entire data life cycle
Typical job roles include:
Data Analyst
Reporting Analyst
Marketing Analyst
Business Intelligence Analyst
WHAT’S INCLUDED?
This course is fantastic value for money:
23 hours of video
Practice exams for lessons and modules
Follow-along labs where you configure your own database
Case studies for Excel you can use in the real world
Access to instructors
30-day money-back guarantee
Lifetime access
Certificate of completion
EXAM INFO
Exam Code: DA0-001
Max. 90 questions (multiple-choice, drag-and-drop, and performance-based)
Length of exam: 90 minutes
Passing score: 675 (on a scale of 100-900)
Recommended experience: 18-24 months’ hands-on experience in a lab or in the field